RE: MySQL process increasing problem..

2003-11-06 Thread Jobs PHP Workshop
uot; -Original Message- From: Matt W [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 7:22 AM To: Jobs PHP Workshop; [EMAIL PROTECTED] Subject: Re: MySQL process increasing problem.. Hi, Yes, in top, those are threads not processes, as Gerald already said. Not that it reall

Re: MySQL process increasing problem..

2003-11-05 Thread Matt W
Hi, Yes, in top, those are threads not processes, as Gerald already said. Not that it really matters. :-) Your connections in PROCESSLIST are sleeping (e.g. idle). What are the clients? It looks like you may be using persistent connections with a Web app. If you want to get rid of the sleeping t

Re: MySQL process increasing problem..

2003-11-05 Thread Jeremy Zawodny
On Wed, Nov 05, 2003 at 10:38:05PM +0530, Jobs PHP Workshop wrote: > Hi, > > Problem is, Mysql server in our production machine keeps spawning child > processes and it reaches to a level where mysql hangs and the only > solution is to restart our mysql server. That sucks. > I have checked all the

Re: MySQL process increasing problem..

2003-11-05 Thread gerald_clark
Those are threads, not processes. Each connection gets a thread. Many connections waiting for disk space will give you this problem. Jobs PHP Workshop wrote: Hi, Problem is, Mysql server in our production machine keeps spawning child processes and it reaches to a level where mysql hangs and the on