Re: Debian sarge Mysql 4.1 (Too many connections)
On 8/9/06, Jean-Paul Blaquiere <jeanpaul@blaquiere.id.au> wrote:
> On Aug 08, Roberto C. Sanchez illuminated :
> Have you considered switching to PostgreSQL? Seriously, it is more
> robust, more scalable and much more compliant with the SQL language
> specification.
>
*smack*
and not answer the question he is asking?
sheesh!
I have a small number of mysql databasese (less than twenty) and there's
no way I'd switch them to postgresql without extensive testing, even
though I would really like to do so.
in /etc/mysql/my.cnf, try upping the number of connections.
set-variable=max_connections=500
also, get a hold of the mysql administrator tool (available on the mysql
web site) and use the 'server health' page to watch what's happening on
the box. It will show the number of users, memory usage, all nifty stuff.
Thanks for the replies. WOW, move all my sites to progresql? What
about the 150 or so products/systems that are NOT on my server, but
that we have developed? Sorry i dont have a month worth+ of all my
developers time up my sleve for that one!
As above: *smack*, sheesh!
Anyway, I found that "wait_timeout = 28800" (the default setting), so
added "wait_timeout = 300" under the [mysqld_safe] section in the
my.cnf file, and now persistant mysql connections (via PHP) drop off
after 5 mins, rather than 8 hours.
Ive also uppped the max_connections to 1000, our server's load average
is 0.32, so it should be OK :)
Thanks
Simon
Reply to: