8 messages in com.mysql.lists.win32Re: Too many connections (WIN NT, ASP...
FromSent OnAttachments
Mads Vestergaard23 Jul 2000 07:35 
Sinisa Milivojevic24 Jul 2000 05:02 
Mads Vestergaard24 Jul 2000 06:26 
sin...@mysql.com24 Jul 2000 07:43 
Mads Vestergaard24 Jul 2000 09:58 
Sinisa Milivojevic25 Jul 2000 05:41 
Rik Bradt25 Jul 2000 06:40 
Mads Vestergaard25 Jul 2000 09:00 
Subject:Re: Too many connections (WIN NT, ASP, MySQL, MyODBC) problem
From:Sinisa Milivojevic (sin@mysql.com)
Date:07/24/2000 05:02:14 AM
List:com.mysql.lists.win32

On Sun, 23 Jul 2000, Mads Vestergaard wrote:

Hi MySQL experts

We are having a 'too many connections error' problem on our website. I have changed the mysql configuration by reading a lot of comments at the lists at mysql.com, but the problem still exist though I have made a few fixes, which you can see in the mysql variables below.

Now I have scheduled a daily mysqld-nt restart (a timescheduled .batch file) at night so the processes are killed, and that works fine for now, but when we start marketing our website, that won't be enough.

The processes are sleeping like they have not been closes, even though I close each of them exactly as described in the asp manuals. ex. (asp) rs.close set rs = Nothing conn.close set conn = Nothing

Software setup:

Sincerely,

Hi!

Increasing max_connections is not the way to go.

You should diagnose slow queries that force others to queue up, optimise them and optmimize MySQL settings.

That way, number of processes will decrease.

Regards,

Sinisa