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;
+——————- …
Shell scripts are files that contain a series of commands which can be executed together. You could also type these commands one by one to run them manually. To use a shell script, you must first write these commands into a text file, and later you can …
I picked up another project today, so I needed to set up a local LAMP environment. To keep things simple, I decided to install everything directly using YUM. After installing MySQL, I needed to set the root password. I’m not sure how everyone else used to set theirs, but I previously used /usr/bin/mysqladmin -u root password ' …
Checking Current Nginx and MySQL Connections
View all current Nginx connections and their statuses:
#netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a]}'
TIME_WAIT 17
ESTABLISHED 3254
LAST_ACK 236
FIN_W …
