SQL Error:
user ........._example already has more than max_user_connections
my server max. concurrent connections is 118
somtimes this error appear and disapear
usrfrm is your mysql user.
This is a host issue, ask them to increase your max_user_connections limit.
i change max. concurrent connectionson 145 but this error appear again:
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1203 - User ..........._example already has more than 'max_user_connections' active connections
plz give me a perfect solution, how much max_user_connections limit should be increased?
this error depends on what?
my website have only 16,000 Pageviews per day.
We can't tell you how big or small that value should be, you need to monitor your mysql connections and increase the value as needed to accomodate for more users. You can use SHOW PROCESSLIST in phpmyadmin to see the connections and see why it is so high.
http://dev.mysql.com/doc/refman/5.5/en/t...tions.html
hello again
i watch PROCESSLIST in max_user_connection error...
i change max_user_connection to 250 and problem not solved.
send request to server management and they tell us that max user connection error depend on CMS programing (plugin)
some opinion is Separate table ( i don't know how to do it)
--------------------------
table information that i see in process list:
mybb_users 59,868 rows 28.7 MiB
mybb_sessions 5,647 rows MEMORY (cuz make error in MyISAM i change it to MEMORY)
mybb_users_profiledesigns 1,521,711 rows 105.2 MiB
mybb_posts 290,437 rows 792.9 MiB
-------------------------
dedicated server
intel core 2 Quad - Q8200 - 2GB Memory ram - mysql 5.1
query_cache_limit=12M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=250
max_connections=6000
interactive_timeout=10
wait_timeout=6
connect_timeout=10
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=12M
max_connect_errors=20
max_allowed_packet=128M
table_cache=1024
record_buffer=12M
sort_buffer_size=12M ## 1MB for every 1GB of RAM
read_buffer_size=12M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=12M ## 1MB for every 1GB of RAM
thread_concurrency=8 # Number of CPUs x 2
myisam_sort_buffer_size=64M
problem solved
we added 2GB more Memory ram and our server have 4GB ram now.
max user connection is on 100 and our CMS not shown error till today.