Here, I gave the list of variables to be tune for MySQL optimization. And give the value for each variable belongs to your system configuration.
The MySQL server
#mysqld
max_connections
max_user_connections
key_buffer_size
myisam_sort_buffer_size
bulk_insert_buffer_size
join_buffer_size
read_buffer_size
sort_buffer_size
table_cache
table_open_cache
thread_cache_size
max_heap_table_size
tmp_table_size
interactive_timeout
wait_timeout
connect_timeout
max_allowed_packet
max_connect_errors
query_cache_limit
query_cache_size
query_cache_type
log_slow_queries
long_query_time
#InnoDB tables
innodb_log_buffer_size
innodb_buffer_pool_size
innodb_additional_mem_pool_size
#mysqldump
max_allowed_packet
#myisamchk
key_buffer_size
sort_buffer_size
read_buffer_size
No comments:
Post a Comment