Help! Too many connections error

2004-02-08 Thread Mark
I started getting an error:

#1049: Too many connections

Around 10 hours ago, and I don't know what it means. My admin is sort of
a go between with the host provider, so I need to give him as much
information as possible to get the problem fixed.

I haven't made any changes to the site, although I was testing some
optimized SQL statements using LEFT JOIN with phpMyAdmin prior to the
error occurring.

Thanks for any help you might provide.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: [Mysql-discussions] Help! Too many connections error

2004-02-08 Thread Remko Lodder
probably you had over 100 connections to you SQL db, on tcp level.
the default max is 100 connections, perhaps you can increase it a little

--max-connections=200 for example (in your startup config)

hope it helps you.

cheers

--

Kind regards,

Remko Lodder
Elvandar.org/DSINet.org
www.mostly-harmless.nl Dutch community for helping newcomers on the
hackerscene

-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Mark
Verzonden: zondag 8 februari 2004 19:12
Aan: MySQL List
Onderwerp: [Mysql-discussions] Help! Too many connections error


I started getting an error:

#1049: Too many connections

Around 10 hours ago, and I don't know what it means. My admin is sort of
a go between with the host provider, so I need to give him as much
information as possible to get the problem fixed.

I haven't made any changes to the site, although I was testing some
optimized SQL statements using LEFT JOIN with phpMyAdmin prior to the
error occurring.

Thanks for any help you might provide.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

___
Mysql-discussions mailing list
[EMAIL PROTECTED]
http://lists.elvandar.org/mailman/listinfo/mysql-discussions


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]