i'm using Johnny Heliohost remote mysql and codeigniter 4 for development. After a few requests from the frontend, I'm seeing this error on mysql that user has more than max_user_connections (code 1203). While connecting db from backend, codeigniter seems to automatically close db connections. Even when I'm checking through workbench show processlist shows only 1 sleeping process. But then, suddenly max_user_connections exceeds the limit for the same request which was working a moment before.
So, my asks are jotted below:
- Can the mysql wait_timeout parameter be redued to 180 secs?
- From mysql documentation it seems the max_user_connections are set to 150 and another for super user, is there any additional limit from heliohost's end?
If there's any better way of dealing with this problem I'm all ears.
I'm quite new to this. I signed up yesterday to Johnny and started to send some data to a MySQL database. That worked quite good but since 3.5 hours the server seems not accessible and in the cpanel I get a message that the server is down.
The MySQL server is currently offline.
Error while connecting to MySQL: (XID 8f868x) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) Error while connecting to MySQL: (XID 8f868x) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1.
Is there something wrong in my application posting the data or is the server really down?
I'm quite confused...