Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Too Many Child Processes

Too Many Child Processes

Too Many Child Processes

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

RE: Too Many Child Processes

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 www.phpbuilder.com, persistent connections don't really do much to streamline things anyway.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close