2012-04-06, 17:30
Where'd you get those settings from? They seem pretty off to me. A setting being in the file will override the default. My personal opinion (others here may disagree with me:
Remove the following form the file and let MySQL manage them based on defaults:
Adjust the following:
See if that helps with performance
Remove the following form the file and let MySQL manage them based on defaults:
Code:
net_buffer_length = 16384
performance_schema_max_cond_classes = 80
performance_schema_max_cond_instances = 1000
performance_schema_max_rwlock_instances = 1000
performance_schema_events_waits_history_long_size = 10000
performance_schema_max_table_instances = 50000
performance_schema_max_rwlock_classes = 20
performance_schema_max_mutex_classes = 200
performance_schema_max_mutex_instances = 1000
performance_schema_max_table_handles = 100000
performance_schema_events_waits_history_size = 10
performance_schema_max_thread_classes = 50
performance_schema_max_file_handles = 32768
performance_schema_max_file_instances = 10000
performance_schema_max_file_classes = 50
performance_schema_max_thread_instances = 1000
Adjust the following:
Code:
query_cache_limit=2M
query_cache_size=128M
query_cache_min_res_unit = 1024
key_buffer_size = 24M
max_allowed_packet = 1M
table_open_cache = 24576
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
innodb_buffer_pool_size = 128M
join_buffer_size = 2M
max_connections = 10
max_join_size = 4294967295
# Keep the 2 below the same:
tmp_table_size = 16M
max_heap_table_size = 16M
See if that helps with performance