By wqr786 on

One site we're working on - simply has started giving some strange results - and situation is pretty confusing.

Site is offline - mysql error: too many connections <-- this is what is coming

Before this error, it seemed that site was working okay, and sometimes it was giving extremely slow response, sometimes it seemed server was busy and wasn't responding at all, and then-- too many connections error.

Can anybody suggest what's going on here?

⋅ Categories: Drupal 6.x

Comments

attiks’s picture

attiks commented

Talk to your hosting provider, they are probably limiting the number of connections

Attiks - Print and web design

wqr786’s picture

wqr786 commented

The host support says Indexing and SQL optimization will be required, some table gets locked. Because database is very heavy, there's 1 table of size around 34mb, etc.

Any suggestion for a good mysql tuner, or some tips on how to perform it manually? I hope the database won't get damaged.

Netzarim’s picture

Netzarim commented

If you are on a shared hosing system, you will need to contact the provider.

If it is a dedicated, managed, or owned system:

wget mysqltuner.pl

chmod 755

and run it, you will need your database user and password. It will report back and give areas of the my.cnf that need to be adjusted to optimize performance based on performance history.

This is in addition to following the various recommendations from Drupal on changing table types for specific tables based on how they are used: Mostly write (logging), read/write, mostly read. Each of the table types presented by MySQL are optimized for different types of access. However, another thing to keep in mind is that repair of some table types is not possible. Make sure you are running regular backups on your databases.