2012-11-09, 01:54 AM
After recently moving my forum to a dedicated server I started receiving the following error
SQL Error:
1203 - User neochi_mybb3 already has more than 'max_user_connections' active connections
Then after my host tried to raise this limit I started getting
SQL Error:
1041 - Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
They then revert the max user connection limit but I'm still getting the out of memory alot...
Here's my dedicated servers specs: http://hostgator.com/dedicated (standard plan)
I don't have much members (~3,400) or posts (~150,000) but I do have alot of members usually on at once (200-300).
Here's my MySQL conf:
[mysqld]
slow_query_log=1
slow_query_log_file=/var/log/mysql_slow_queries.log
innodb_file_per_table=1
tmp_table_size = 384M
max_heap_table_size = 384M
query_cache_size=64M # increment by 32M, max of 384M if busy MySQL server
thread_cache_size=64M # can be increased on servers with large numbers of active users
key_buffer_size=32M
max_allowed_packet=16M # don't change unless required for large blobs
table_cache=1024 # can be increased if more Opened tables - SHOW STATUS LIKE 'Opened_tables';
table_definition_cache=8192 # increase by the same factor as table_cache
innodb_buffer_pool_size=128M # check mysql -e "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';" - free vs total
innodb_flush_method=O_DIRECT
open_files_limit=16384
max_connections=125 # Should be between 100-150, increase slowly because it causes MySQL to consume more memory!
max_user_connections=25
wait_timeout=20 # can be increased if using persistent connections
#delayed_insert_timeout=20 # Turn on if max_connections being reached due to delayed inserts
#delayed_queue_size=300 # Turn on if max_connections being reached due to delayed inserts
#query_cache_limit=2M # leave at default unless there is a good reason
#join_buffer=2M # leave at default unless there is a good reason
#sort_buffer_size=2M # leave at default unless there is a good reason
#read_rnd_buffer_size=256K # leave at default unless there is a good reason
#read_buffer_size=2M # leave at default unless there is a good reason
myisam_sort_buffer_size=2M # can be increased per sessions if needed for alter tables (indexes, repair)
thread_concurrency=8 # Number of physical + virtual CPU's, be careful of adding more
#general_log=1
slow_query_log=1
log-output=TABLE # select * from mysql.general_log order by event_time desc limit 10;
long_query_time=20 # select * from mysql.slow_log order by start_time desc limit 10;
Can someone please help me with this?
help!! my server is getting these errors alot...
Please someone help...my users and I are getting these errors alot!
SQL Error:
1203 - User neochi_mybb3 already has more than 'max_user_connections' active connections
Then after my host tried to raise this limit I started getting
SQL Error:
1041 - Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
They then revert the max user connection limit but I'm still getting the out of memory alot...
Here's my dedicated servers specs: http://hostgator.com/dedicated (standard plan)
I don't have much members (~3,400) or posts (~150,000) but I do have alot of members usually on at once (200-300).
Here's my MySQL conf:
[mysqld]
slow_query_log=1
slow_query_log_file=/var/log/mysql_slow_queries.log
innodb_file_per_table=1
tmp_table_size = 384M
max_heap_table_size = 384M
query_cache_size=64M # increment by 32M, max of 384M if busy MySQL server
thread_cache_size=64M # can be increased on servers with large numbers of active users
key_buffer_size=32M
max_allowed_packet=16M # don't change unless required for large blobs
table_cache=1024 # can be increased if more Opened tables - SHOW STATUS LIKE 'Opened_tables';
table_definition_cache=8192 # increase by the same factor as table_cache
innodb_buffer_pool_size=128M # check mysql -e "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';" - free vs total
innodb_flush_method=O_DIRECT
open_files_limit=16384
max_connections=125 # Should be between 100-150, increase slowly because it causes MySQL to consume more memory!
max_user_connections=25
wait_timeout=20 # can be increased if using persistent connections
#delayed_insert_timeout=20 # Turn on if max_connections being reached due to delayed inserts
#delayed_queue_size=300 # Turn on if max_connections being reached due to delayed inserts
#query_cache_limit=2M # leave at default unless there is a good reason
#join_buffer=2M # leave at default unless there is a good reason
#sort_buffer_size=2M # leave at default unless there is a good reason
#read_rnd_buffer_size=256K # leave at default unless there is a good reason
#read_buffer_size=2M # leave at default unless there is a good reason
myisam_sort_buffer_size=2M # can be increased per sessions if needed for alter tables (indexes, repair)
thread_concurrency=8 # Number of physical + virtual CPU's, be careful of adding more
#general_log=1
slow_query_log=1
log-output=TABLE # select * from mysql.general_log order by event_time desc limit 10;
long_query_time=20 # select * from mysql.slow_log order by start_time desc limit 10;
Can someone please help me with this?
help!! my server is getting these errors alot...
Please someone help...my users and I are getting these errors alot!