Jocelyn Fournier wrote:
Hi,
A quick fix would be to set the wait_timeout variable in the my.cnf to a
much smaller value than 28800 (default value).
Try to add wait_timeout=60 in the my.cnf for example, the connections should
be automatically closed after 60 secondes if there are not used anymore.
Fournier
www.presence-pc.com
- Original Message -
From: "Jan Kirchhoff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 03, 2004 7:43 PM
Subject: Re: Problem with Mysql 4.0.18 + Debian
> That sounds like a typical
| citidel | localhost | citidel | Sleep | 607 | | NULL
>
> |
> | 95 | citidel | localhost | citidel | Query | 0| NULL | show
> processlist |
> ++-+---+-+-+--+---+---------
>
>
>
>
> Ryan Richardson said:
>>
>> -Original Message-
>> From: [
| Query | 0| NULL | show
processlist |
++-+---+-+-+--+---+-
Ryan Richardson said:
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/2/04 9:16 AM
Subject: Problem with Mysql 4.0.18 + Debian
Hello:
I posted this before but I have not
--
Ryan Richardson said:
>
> -Original Message-
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: 8/2/04 9:16 AM
> Subject: Problem with Mysql 4.0.18 + Debian
>
> Hello:
>
> I posted this before but I have not gotten a response. I have a
>
Ryan,
> Here's the problem. I had the site up several days, with everything
> running perfectly. Ordinarily there would be about 11 mysql processes
> running. However, after a few days of running smoothly, the number of
> mysql processes increases to over 170, and the site crashes. Formerly
>
Victor Pendleton said:
> What does mysql "show processlist" look like?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: 8/2/04 9:16 AM
> Subject: Problem with Mysql 4.0.18 + Debian
>
> Hello:
>
> I posted this
What does mysql "show processlist" look like?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/2/04 9:16 AM
Subject: Problem with Mysql 4.0.18 + Debian
Hello:
I posted this before but I have not gotten a response. I have a
Debian
(woody) server runn
Hello:
I posted this before but I have not gotten a response. I have a Debian
(woody) server running a good sized database (7.2GB of db files), Mysql
4.0.18. I am running Apache 1.3.29 + perl and using mysql as the
backend. In my.cnf, I have max_connections=300.
Here's the problem. I had th