I have problem with my site: max_user_connections

Avatar
  • Answered
Hello.
I wont optimized my table in database. But after running, I got Error: User xxx already has more than 'max_user_connections' active connections in...
My site is: booksonline.com.ua
How I can decide this problem?
Can You increase max_user_connections?
Avatar
JeffMa
The max user connections can be increased within a VPS or dedicated server environment if you like, however, it does look like you could have a further issue such as your code not closing the MySQL connection or your site running extremely long queries multiple times. I recommend taking a further look at your code for where this may be taking place.