Re: Database error : too many connectons

[Rick James]

* Increase max_connections. Watch out; that takes RAM. I would hesitate to go past 1000, even on a relatively big machine.

* Decrease wait_timeout. That will pull the plug on idle connections. This setting is tricky to set.

SHOW VARIABLES LIKE 'max_connections';
SHOW GLOBAL VARIABLES LIKE '%timeout';
SHOW GLOBAL STATUS LIKE '%conn%';
SHOW GLOBAL STATUS LIKE 'Abort%';
SHOW GLOBAL STATUS LIKE 'Uptime';
How much RAM do you have?

Do your visitors connect directly to the database? Or do they go through some API?