Server is iis+php528+mysql5.6.13, running two sites, one of which is the source of ecshop, fluency naturally no problem, the problem is another site, as long as an open IIS services, Mysqld.exe CPU immediately soar, if you close the site, CPU usage is basically within 10%, in the MySQL show processlists found that there are almost 30-50 threads in progress, but this site no one access, this is very strange, no one to access, how still connected to the database you? This problem is troubled in the next too long, please master advice, thank you!
Reply to discussion (solution)
A large number of sorting and other unreasonable queries led to the table lock.
First look at the log of slow query?
A large number of sorting and other unreasonable queries led to the table lock.
First look at the log of slow query?
Please elaborate, how to analyze and solve, thank you!
