Hello,

If I have dozens of processes like this:

| 436 | linu_data | localhost | linu_data | Sleep | 1864 | | |

Does it (over)load the database? What is Sleep?

Thank you.

Yeah.... in addition to MySQL, I found other processes that Sleep. Why is then CPU loaded to 80% if everything sleeps?

Hi, is there anyone?

This is ps aux:

mysql 2063 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
mysql 2204 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
mysql 2205 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
mysql 2206 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
mysql 2207 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
mysql 2208 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
mysql 2210 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
mysql 2211 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
mysql 2212 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
mysql 2213 0.0 2.0 30540 10696 ? S 20:17 0:00 /usr/sbin/mysqld
root 2230 0.0 1.6 18676 8468 ? S 20:17 0:00 httpd2 -f /etc/ht
root 2233 0.0 0.4 4044 2192 ? S 20:17 0:00 /usr/bin/perl /us
apache 2253 0.0 1.6 18752 8568 ? S 20:17 0:00 httpd2 -f /etc/ht
apache 2254 0.0 1.6 18752 8568 ? S 20:17 0:00 httpd2 -f /etc/ht
apache 2255 0.0 1.6 18752 8568 ? S 20:17 0:00 httpd2 -f /etc/ht
apache 2256 0.0 1.6 18752 8568 ? S 20:17 0:00 httpd2 -f /etc/ht
apache 2257 0.0 1.6 18752 8568 ? S 20:17 0:00 httpd2 -f /etc/ht

Is it OK to leave the Sleeping processes alone? Do they put any load on the server?

are you talking about the "show processlist" command in MySQL?

if so, the sleep means the connection to the database is not processing but not yet freed. You should check your code to see if you are closing the connections correctly. the connections can also be there because you use pooling, so the system can reuse exist connnections.

I don't think sleeping processes will take up CPU, but if a large number of them don't eventually die, your MySQL will run out of avaliable connections.

Phooo.... That's an exhaustive answer! Thanks, if I understood you right, everything is clear now.

well, im not sure i understand.

if i kill mine, more just show up. are you supposed to close the db connection in your php file for these to stop showing up? there's no setting in mysql to automatically close connections after x number of seconds?

You can use "set-variable=wait_timeout=xxx(seconds)" to close the connections.

- Karthik Iyer
The-Bat

I suggest you read this: [removed]