On Ensim 3.1 (Mysql 3.2.3) I had to add -O wait_timeout=60 to the /etc/init.d/mysqld line with safe_mysqld on it else I'd have boatloads of sleeping mysql. Well on Directadmin I'm having the same problem.
(here's the processlist for one server):
35 sleeping mysqld processes
Well so far everything I've tried to get the "wait_timeout" set hasn't worked. I'm surely not the only person with customers who have badly coded php/mysql because I can see at least 4 servers of about 12 DA servers sitting here right now with too many mysqld processes. If anyone knows how I can set the sleep timeout I'd be grateful
(here's the processlist for one server):
Code:
mysql> show processlist;
+-------+-----------+-----------+----------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-----------+-----------+----------+---------+------+-------+------------------+
| 63186 | rskit_usr | localhost | rskit_db | Sleep | 1064 | | NULL |
| 63189 | rskit_usr | localhost | rskit_db | Sleep | 2476 | | NULL |
| 63191 | rskit_usr | localhost | rskit_db | Sleep | 1572 | | NULL |
| 63193 | mconn_usr | localhost | mconn_db | Sleep | 1826 | | NULL |
| 63195 | mconn_usr | localhost | mconn_db | Sleep | 2123 | | NULL |
| 63197 | rskit_usr | localhost | rskit_db | Sleep | 1091 | | NULL |
| 63199 | mconn_usr | localhost | mconn_db | Sleep | 1880 | | NULL |
| 63202 | rskit_usr | localhost | rskit_db | Sleep | 2515 | | NULL |
| 63209 | rskit_usr | localhost | rskit_db | Sleep | 1056 | | NULL |
| 63211 | mconn_usr | localhost | mconn_db | Sleep | 2217 | | NULL |
| 63214 | mconn_usr | localhost | mconn_db | Sleep | 2293 | | NULL |
| 63216 | mconn_usr | localhost | mconn_db | Sleep | 1943 | | NULL |
| 63232 | mconn_usr | localhost | mconn_db | Sleep | 2897 | | NULL |
| 63237 | rskit_usr | localhost | rskit_db | Sleep | 326 | | NULL |
| 63262 | mconn_usr | localhost | mconn_db | Sleep | 2300 | | NULL |
| 63264 | rskit_usr | localhost | rskit_db | Sleep | 323 | | NULL |
| 63276 | mconn_usr | localhost | mconn_db | Sleep | 2065 | | NULL |
| 63296 | mconn_usr | localhost | mconn_db | Sleep | 1818 | | NULL |
| 63302 | rskit_usr | localhost | rskit_db | Sleep | 890 | | NULL |
| 63307 | mconn_usr | localhost | mconn_db | Sleep | 1965 | | NULL |
| 63323 | assmt_usr | localhost | assmt_db | Sleep | 848 | | NULL |
| 63332 | mconn_usr | localhost | mconn_db | Sleep | 2357 | | NULL |
| 63334 | mconn_usr | localhost | mconn_db | Sleep | 1955 | | NULL |
| 63344 | mconn_usr | localhost | mconn_db | Sleep | 1663 | | NULL |
| 63348 | mconn_usr | localhost | mconn_db | Sleep | 2422 | | NULL |
| 63364 | mconn_usr | localhost | mconn_db | Sleep | 3146 | | NULL |
| 63376 | mconn_usr | localhost | mconn_db | Sleep | 2074 | | NULL |
| 63511 | rskit_usr | localhost | rskit_db | Sleep | 2304 | | NULL |
| 63513 | rskit_usr | localhost | rskit_db | Sleep | 1693 | | NULL |
| 63515 | rskit_usr | localhost | rskit_db | Sleep | 1070 | | NULL |
| 63521 | rskit_usr | localhost | rskit_db | Sleep | 2471 | | NULL |
| 63525 | rskit_usr | localhost | rskit_db | Sleep | 906 | | NULL |
| 63574 | rskit_usr | localhost | rskit_db | Sleep | 320 | | NULL |
| 63588 | rskit_usr | localhost | rskit_db | Sleep | 1129 | | NULL |
| 63605 | rskit_usr | localhost | rskit_db | Sleep | 318 | | NULL |
| 63651 | da_admin | localhost | NULL | Query | 0 | NULL | show processlist |
+-------+-----------+-----------+----------+---------+------+-------+------------------+
36 rows in set (0.01 sec)
35 sleeping mysqld processes
Well so far everything I've tried to get the "wait_timeout" set hasn't worked. I'm surely not the only person with customers who have badly coded php/mysql because I can see at least 4 servers of about 12 DA servers sitting here right now with too many mysqld processes. If anyone knows how I can set the sleep timeout I'd be grateful