There is a server, do data statistics work, previously ran is still stable, did not have a big problem, but suddenly found from yesterday, Apache process is full, MySQL process is stained with, the entire server changed very card, my first feeling may be the problem of MySQL, random check a SQL to wait twenty or thirty seconds, Write is also very slow, do not know why, the preliminary thought is MySQL execution inefficient caused by the Apache process congestion, one night did not understand, this morning found that the return to normal, may be the morning when the amount of data is small, and now hang, I want to know what will cause the server very card, resulting in MySQL, Low execution efficiency
Reply to discussion (solution)
Optimizing Your programs and SQL commands may make things better
You also need to consider other factors, after all, the server is not specifically for your site services
Check the log to see if you can find a valid message.