LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   max user connection mysql (https://www.linuxquestions.org/questions/linux-server-73/max-user-connection-mysql-851626/)

tribbiyani 12-21-2010 12:53 PM
max user connection mysql
 
hi
I've hosting server running fedora.lately I'm getting this error
"MAX_User_Connection".any ideas?

ilvista 12-21-2010 12:56 PM
you have to increase the value of MAX_USER_CONNECTION in the my.cnf

Code:
vi /etc/my.cnf

tribbiyani 12-21-2010 01:00 PM
thx for the quick reply

but there is two variables

Code:
set-variable=max_connections=50
set-variable=max_user_connections=50
witch one?

tribbiyani 12-21-2010 01:10 PM
max_connections represent all the sql connections.
and max_user_connection represent the connections per user.(shared hosting)

in my case i had to increase both of them.

tribbiyani 12-21-2010 01:28 PM
thx anyway,I got rid of it

ilvista 12-21-2010 01:32 PM
I remember also when i changed max_user_connection,i got my cpu overloaded.
you can monitor you server performance using ATOP.

tribbiyani 12-21-2010 01:35 PM
yeah I'll give it a shot. although my server looks just fine.
thx again


All times are GMT -5. The time now is 01:21 AM.