Mysql database issue

[david510]

Hello,

One of the server is actaully eating load due to mysql connection. I have a database that is actually taking lot of connections . What all measures we could do to rectify this? memory space increase or any measures like that? Please help.

Regards,
David

[weaver]

Hi -

If the connection is being made via a php script then make sure you have this in your php.ini file:

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent=Off

This will force non-persistent connections and help keep the load down!

[webignition]

Making sure the MySQL query cache is set for your needs is always a good idea.

There's a good article about it at http://www.databasejournal.com/featu...le.php/3110171

There are also links from the article regarding minimising server load due to MySQL through correct MySQL config and correct table indexing, which are always worth a read.

[silversurfer]

You can limit the no. of connections per user in /etc/my.cnf

[david510]

Thak you everyone