This is the second of a two-part series on MySQL encryption performance testing. In the first article, I exclusively used MySQL’s built-in SSL support to run stress tests, which produced some surprising results. Of course, it was expected that query throughput with SSL would be lower than without SSL, but …
Issue: After installing MySQL, phpMyAdmin cannot log into MySQL and returns error 1130, but logging in via the MySQL command line with `mysql -u root -p` works. Analysis and Solution: A Baidu search reveals that MySQL error 1130 is caused by remote connection users lacking remote access privileges. Solution: Log in locally …
When installing MySQL, most people enable the binlog feature. The benefit of enabling this feature is that it makes data recovery easier in the future, while the downside is that the log files grow rapidly and can quickly fill up disk space. Therefore, we need to periodically or manually delete oversized log files. The methods for deleting log files generally include the following …
Symptom: The website became slower and slower to access, and eventually became completely inaccessible. Upon inspection, the disk was found to be full. A detailed investigation confirmed that the excessive number and large size of MySQL binlog files were consuming the disk space. Analysis process and solution: Typically, when encountering such an issue, you should log into the server to check disk, memory, and process usage. Generally…
1、Stop the MySQL Service# service mysql stop If you get an error like mysql: unrecognized service, first locate mysql.server by using: find / -name "mysql.server" Then use /usr/local/mysql/share/mysql/mysql.server …
A Little Tool to Easily Decompress in Windows! A long time ago, downloading an instance backup looked like this: Now, you can also decompress under Windows. Please click here RDSBackup.rar (967 K) Please download the RDS backup file and this tool to the same directory, then double-click RDS.bat to run the decompression program …
The images on my blog were originally hosted on the www.s135.com server. Due to the server’s instability, I moved all images to the blog.s135.com server and performed a bulk find-and-replace in the MySQL database, changing all instances of the string www.s135.com to blog.s135.com. To make future use more convenient, I …
The NoSQL Concept With the rapid development of Web 2.0, non-relational and distributed data storage has advanced quickly, without guaranteeing the ACID properties of relational data. The NoSQL concept was introduced in 2009. The most common interpretations of NoSQL are “non-relational” and “Not Only SQ …
MySQL Index Table Corruption “The storage engine for the table doesn't support repair”
Check what the table’s storage engine is. Only MyISAM can be repaired directly. If it’s not MyISAM, you need to change the table’s storage engine before you can repair it. First, back up the corrupted table in the database, then dele …
View All Users in MySQL Database
mysql> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
+——————- …
