Hello,
persistence off in php.ini
KeepAlive Off in httpd
my.cnf has following
query_cache_limit= 1M
query_cache_size = 32M
query_cache_type = 1
table_cache=512
thread_cache=32
old-password=1
wait_timeout=30
interactive_timeout=20
However, we find there are still sleeping processes with sleep time in excess of the session and global timeout limits.
+------+------------------+-----------+------------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------------------+-----------+------------------+---------+------+-------+------------------+
| 9342 | indept_indept | localhost | indept_News | Sleep | 1019 | | |
| 9618 | indept_indept | localhost | indept_News | Sleep | 239 | | |
| 9734 | business_Chukwud | localhost | business_Newsday | Sleep | 1 | | |
| 9735 | root | localhost | | Query | 0 | | show processlist |
+------+------------------+-----------+------------------+---------+------+-------+------------------+
Is this anything related to following:
http://bugs.mysql.com/bug.php?id=11897
Find Mysql eating up lot of CPU cycles. Query/Sec averages around 20.00
Clueless except to try an upgrade to 4.1.20
Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================
persistence off in php.ini
KeepAlive Off in httpd
my.cnf has following
query_cache_limit= 1M
query_cache_size = 32M
query_cache_type = 1
table_cache=512
thread_cache=32
old-password=1
wait_timeout=30
interactive_timeout=20
However, we find there are still sleeping processes with sleep time in excess of the session and global timeout limits.
+------+------------------+-----------+------------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------------------+-----------+------------------+---------+------+-------+------------------+
| 9342 | indept_indept | localhost | indept_News | Sleep | 1019 | | |
| 9618 | indept_indept | localhost | indept_News | Sleep | 239 | | |
| 9734 | business_Chukwud | localhost | business_Newsday | Sleep | 1 | | |
| 9735 | root | localhost | | Query | 0 | | show processlist |
+------+------------------+-----------+------------------+---------+------+-------+------------------+
Is this anything related to following:
http://bugs.mysql.com/bug.php?id=11897
Find Mysql eating up lot of CPU cycles. Query/Sec averages around 20.00
Clueless except to try an upgrade to 4.1.20
Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================