When you say too many concurrent connections do you mean that mysql is
complaining about the maximum number of connections or because the
system is struggling?

If it's simply mysql complaining then just increase the number of
connections

(default is 100 I think?)

e.g. max_connections=100 to say max_connections=500

http://dev.mysql.com/doc/mysql/en/too-many-connections.html

To add your my.ini file in the [mysqld] section add:

set-variable=max_connections=500

or add --max_connections=500 as an argument to your mysql start up
script.

Are using using persistent web connections? These may eat up your mysql
max_connections.

There is a section on this in Jeremy Zawodny's high performance mysql --
http://highperformancemysql.com/ -- worth a read.

HTH,

S

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Simon
Sent: 12 September 2005 08:14
To: DBMail mailinglist
Subject: Re: [Dbmail] MySQL Connections

Steven Lynn wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> The real question is what version of MySQL are you running? 4.x or
5.x?

4.1.11a-4 on debian sarge



_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


Reply via email to