Too Many Child Processes

[bpasc95]

Here's the issue. Over the course of about 24 hours, I have noticed that MYSQL will have 50-90 child processes that are "sleeping". Obviously, this is takeing quite a bit of memory. How, far from killing the processes manually or restarting MySQL, would I prevent these idle processes from taking up all the memory? The routines that connect to the db are in PHP using the mysq_pconnect command.

Any suggestions would be greatly appreciated

 

[rycamor]

Well...you're using persistent connections, so of course you're going to have SLEEP processes. The whole point of persistent connections is to keep connections open in case more requests come in.

In that sense, these processes are not really using up extra memory, because that memory is just sitting there waiting to do a task.

If there is some reason you don't want this (ie - you have other non-MySQL tasks that you want to give more memory), then don't use persistent connections, just use 'mysql_connect'. As I recall from an article at

http://www.phpbuilder.com,

persistent connections don't really do much to streamline things anyway.