Even though you can tune quite a lot of variables in MySQL Servers only few of them are really important for most common workload. After you get these settings right other changes will most commonly offer only incremental performance improvements.
key_buffer_size
innodb_buffer_pool_size
innodb_additional_mem_pool_size
innodb_log_buffer_size
innodb_flush_log_at_trx_commit
table_cache
thread_cache
query_cache_size
Read more http://blogmee.info/index.php/tuning-mysql-server/
No comments:
Post a Comment