LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 12-21-2010, 12:53 PM   #1
tribbiyani
LQ Newbie
 
Registered: Dec 2010
Posts: 5

Rep: Reputation: 0
max user connection mysql


hi
I've hosting server running fedora.lately I'm getting this error
"MAX_User_Connection".any ideas?
 
Old 12-21-2010, 12:56 PM   #2
ilvista
Member
 
Registered: Nov 2010
Location: Ghazaouet
Distribution: Fedora OpenSuse
Posts: 153

Rep: Reputation: 27
you have to increase the value of MAX_USER_CONNECTION in the my.cnf

Code:
vi /etc/my.cnf
 
Old 12-21-2010, 01:00 PM   #3
tribbiyani
LQ Newbie
 
Registered: Dec 2010
Posts: 5

Original Poster
Rep: Reputation: 0
thx for the quick reply

but there is two variables

Code:
set-variable=max_connections=50
set-variable=max_user_connections=50
witch one?
 
Old 12-21-2010, 01:10 PM   #4
tribbiyani
LQ Newbie
 
Registered: Dec 2010
Posts: 5

Original Poster
Rep: Reputation: 0
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.
 
Old 12-21-2010, 01:28 PM   #5
tribbiyani
LQ Newbie
 
Registered: Dec 2010
Posts: 5

Original Poster
Rep: Reputation: 0
thx anyway,I got rid of it
 
Old 12-21-2010, 01:32 PM   #6
ilvista
Member
 
Registered: Nov 2010
Location: Ghazaouet
Distribution: Fedora OpenSuse
Posts: 153

Rep: Reputation: 27
I remember also when i changed max_user_connection,i got my cpu overloaded.
you can monitor you server performance using ATOP.
 
Old 12-21-2010, 01:35 PM   #7
tribbiyani
LQ Newbie
 
Registered: Dec 2010
Posts: 5

Original Poster
Rep: Reputation: 0
yeah I'll give it a shot. although my server looks just fine.
thx again
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql giving max connection errors, server has no connection limit. Jukas Linux - Server 1 03-26-2008 04:06 AM
[mysql] difference between Mysql Max or Normal BlackCell Programming 2 11-06-2003 05:41 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 02:48 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration