Level 18
The "Too many connections" error in MySQL can occur due to a variety of reasons, such as a high traffic website, long-running queries, or a misconfigured MySQL server.
Please check this reply for more information on investigating further
Jan 23, 2024
6
Level 8
DB issue too many connection
Why I'm getting this error on production.
PDOException /artisan Error SQLSTATE[08004] [1040] Too many connections
I'm using laravel version 8.8.* https://jmp.sh/wJiP5Moo
Level 8
@Braunson Its not a high traffic website only 5-10 people visit
Level 18
@amitsolanki24_ Regardless I would suggest checking into your MySQL config, something is eating up connections or the max connection rate is low. Work your way from the MySQL config (checking max connections) to how Laravel is using connections. Check the MySQL processes running when it's maxing out, see what queries are being run, etc.
Level 8
@Braunson thanks, but how can i check how many nom of processes are running on server.
Level 8
@Braunson I have a doubt suppose if it would be the social networking site so what is the max connection I can set?
Level 29
@amitsolanki24_ if you use MySQL you can check current connections with this query, run this in your DB client
SHOW PROCESSLIST;
Please or to participate in this conversation.