Control Database query

romanepo

• September 15, 2014 06:39

I want to control mysql database query. Queries per second avg: 2896.162, its increase mysql and server load. Server process manager show [php] , /usr/bin/php /home/------/public_html/index.php and /usr/local/apache/bin/httpd -k start -DSSL lots of process. I want to control server query.

• 

  cPanelMichael

  • September 16, 2014 12:59

  Hello :) I have moved this thread to our "Optimization" forum. You should receive more user-feedback here. Note the following thread is a good place to start when attempting to tune your MySQL configuration: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0
• 

  romanepo

  • September 21, 2014 13:13

  Hi, I installed and configure my.cnf as hardware resource. My main issue mysql query.Please see--- mysqladmin proc stat result Uptime: 83433 Threads: 11 Questions: 467997235 Slow queries: 36744 Opens: 26386 Flush tables: 1 Open tables: 24220 Queries per second avg: 5609.258 Most of query auto coming from wordpress script. Please suggest me how to control mysql server query. [quote="cPanelMichael, post: 1730552">Hello :) I have moved this thread to our "Optimization" forum. You should receive more user-feedback here. Note the following thread is a good place to start when attempting to tune your MySQL configuration: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.
  

  0

Please sign in to leave a comment.