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
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
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
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