Mariadb Too many connections

qba82

Verified User
Joined
Jun 26, 2018
Messages
65
Hi, today I had some kind of error in mariadb, all websites using db had "error 1040 Too many connections".
I'm quite sure there was not too many connections, all websites using db wasn't working and after I restarted mariadb all starts to work just fine. After this I have made this:
nano /etc/my.cnf
[mysqld]
max_connections=500
service mariadb restart

Everything seems to work fine now, but I don't want to repeat this error in future.

Anybody else had such a problem?
 
Use:
mysqladmin processlist
or
mysql> SHOW FULL PROCESSLIST\G
also add to my.cnf:
max_user_connections=30
 
Back
Top