What and why we need to increase connection pooing?
If your application code is running successfully and no issues from application server side and web server side and you are getting HTTP_500 Internal server error. Then you need to think here to eradicate the issue.
Steps to do it:
Steps to do it:
- Go to MySQL workbench and then in the
- Menu tab go to Servers, then open dashboard
- Execute your code or script
- Check connect/thread connection (max limit would be defined there)
- Open mysql server instance/cluster
- Go to the path cd /etc/mysql
- Open the file my.cnf
- Add new line - max_connections = 512
- Save file and restart mysql instance/cluster