I have recently upgraded my laravel app from 5.1 to 5.4. My server is now on PHP 7 and Maria db 10.1.22. Now I am getting a really weird error. Sometimes, I would just try to refresh my browser and PHPMyAdmin would display #1040 - Too many connections. Other times I would click on a new link on my app and then would get this same error. I did some research on the internet and executed the command below:
show variables like 'max_connections`
The above command gave 100. Which I then increase to 500.
But now I still get the error. This is weird to me because I have oracle mysql 5.6 installed on another server and max_connections is 151 and for over a year and a half I have not experienced this error.
When I run the command show processlist, I get the result below and this keeps increasing. is this normal?
What could be the issue with Mariadb and how can I fix it.