MySQL Process is in Sleep State

The MySQL Process is in Sleep State When

  1. A PHP script connects to MySQL
  2. Some queries are executed
  3. The PHP script does some stuff that takes time : without disconnecting from the DB
  4. Finally, the PHP script ends which means it disconnects from the MySQL server
  5. There are more and more requests coming to Apache which means many pages to generate
  6. Each PHP script, in order to generate a page, connects to the DB and does some queries
  7. These queries take more and more time, as the load on the DB server increases, Which means more processes keep stacking up

Comments are closed.

(adsbygoogle = window.adsbygoogle || []).push({}); //--> Feedjit Flag Counter