8 messages in com.mysql.lists.win32Re: Too many connections (WIN NT, ASP...| From | Sent On | Attachments |
|---|---|---|
| Mads Vestergaard | 23 Jul 2000 07:35 | |
| Sinisa Milivojevic | 24 Jul 2000 05:02 | |
| Mads Vestergaard | 24 Jul 2000 06:26 | |
| sin...@mysql.com | 24 Jul 2000 07:43 | |
| Mads Vestergaard | 24 Jul 2000 09:58 | |
| Sinisa Milivojevic | 25 Jul 2000 05:41 | |
| Rik Bradt | 25 Jul 2000 06:40 | |
| Mads Vestergaard | 25 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,
Mads Vestergaard System Developer inte...@hotmail.com
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
+----------------------------------------------------------------------+ | ____ __ _____ _____ ___ == MySQL AB | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin...@mysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+




