16核mysql性能_16核12 GB RAM专用MySql配置

我有一个专用的16核12 GB RAM Mysql服务器,由于我为16 GB服务器配置它,表现非常糟糕,我想这解释了为什么现在这个网站现在需要超过500秒来渲染单个页面.我使用memcached来缓存quires并使用InnoDB作为数据库引擎.

#8 core/16GB config stolen from http://groups.drupal.org/node/28830

back_log = 50

max_connect_errors = 9999999

table_cache = 5000

binlog_cache_size = 1M

max_heap_table_size = 128M

sort_buffer_size = 500K

join_buffer_size = 500K

thread_cache_size = 100

thread_concurrency = 16

query_cache_size = 512M

query_cache_limit = 8M

query_cache_min_res_unit = 2K

thread_stack = 192K

tmp_table_size = 384M

long_query_time = 2

# *** INNODB Specific options ***

innodb_additional_mem_pool_size = 80M

innodb_buffer_pool_size = 12G

innodb_file_io_threads = 4

innodb_thread_concurrency = 16

innodb_log_buffer_size = 20M

innodb_log_file_size = 800M

innodb_log_files_in_group = 3

innodb_max_dirty_pages_pct = 90

innodb_lock_wait_timeout = 120

innodb_file_per_table = 1

任何优化my.cnf配置的帮助,甚至是新的配置都会非常感激.