9 o 'clock in the morning, more the load on the server from 0.5 to more than 130, the fixed period of time every day, 10 points from half past eight in the morning to nine this time, the rest of the time also BuKa all day,,
In using mysql show the processlist. Found a large number of Sending data option, a total of more than 90, all this kind of SQL

 
SELECT a. *, c. * FROM cms_archives16 a INNER JOIN cms_archives_3 c ON c.a. id=a.a id WHERE a.c hid=
SELECT a. *, c. * FROM cms_archives16 a INNER JOIN cms_archives_3 c ON c.a. id=a.a id WHERE a.c hid=
SELECT COUNT (*) FROM cms_archives16 a INNER JOIN cms_archives_3 c ON c.a. id=a.a id WHERE a.c hid=

Now lost these SQL execution from that page, how to optimize, 08 CMS in the original program, just changed the template, the underlying SQL did not move,
Cms_archives16 and cms_archives_3 is secondhand the room table

CodePudding user response:

Show full the processlist. See complete SQL

CodePudding user response:

Every day is the time, it'll be the first to wonder if what's the timing task execution during that period.

Secondly, according to timing task execution of SQL analysis what is the need to optimize SQL

CodePudding user response:

Look at the SQL is the query of what ah, and then find the corresponding page optimization under