MySQL Limit User Connections set by Host-Provider

Ask the community for help and support.
Post Reply
Philo2005
Posts: 11
Joined: Fri Mar 26, 2021 7:20 am
Has thanked: 6 times
Been thanked: 1 time

MySQL Limit User Connections set by Host-Provider

Post by Philo2005 »

My Host-Provider introduced a new limit for user connections to mysql databases which produced a warning in my error.log.
User 'xxx has exceeded the 'max_user_connections' resource (current value: 25) in /xxx/xxx/xxx/xxx.xx/xxx/shop/includes/functions/database.php on line 16

This caused a die of access the mysql database of my shop when several user accessed the shop at the same time , also this created performance problems of accessing my shop.
I've researched and thought about it that this occurs mostly while I am adding/copying new products to my shop.
Now I set up a new mysql-user, changed the configure.php for the admin section to the new user, and it seems to run better.
Any other ideas are welcome to resolve the max_user_connections issue

Tags:
Post Reply