Detection of excessive MySQL load and solutions (detailed explanation of SSH TOP command)

When we use a host or VPS, MYSQL may take up too much resources due to some reasons, causing our host to be suspended. What are the common reasons that cause MYSQL occupancy and load to be too high? The sudden increase in a large number of concurrent tasks, the occupation of the website program scripts we use, man-made DDOS attacks, etc.

As VPS users, we need to first check whether the above-mentioned MYSQL load is too large due to our own problems. Log in to SSH and enter the \\"top\\" command and press Enter.

Let’s look at this line first. Because the VPS host used by Snail to write tutorials is not used to build the website, the data usage seen is small. Currently, only one WP blog is installed in this VPS.

Cpu(s): 0.2%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.2%st

US: represents the percentage of CPU occupied in our space; SY: represents the percentage of CPU occupied in the kernel space; ID: represents the percentage of idle CPU; WA: represents the percentage of CPU occupied waiting for input.

The following two lines of MEM and SWAP represent the usage of physical memory and swap memory. The first field represents the total amount, followed by used and remaining respectively.

Below we will see the amount of CPU occupied by various processes. Because there is currently no content in my VPS, all I see is occupied by ROOT. If there is site data running, other processes should appear, such as mysql, apache, etc.

In response to the problems that arise, we will then deal with those that occupy too much.

Recommended site search: anti-attack IP, filing space, Shaoxing server rental, high defense IP, cloud host, high defense IP rental, icp filing query, cloud server rental, website server rental, free personal website server,