mysql - 为 InnoDB 配置 MySQL

Question

我正在将很多表从 MyISAM 转换为 InnoDB(你已经说服了我)，我想知道你们对我的 MySQL 配置有什么建议......

我运行的是 16GB RAM 和 4 个四核 3.0 GHz 处理器。

#
# * Fine Tuning
#
key_buffer              = 1024M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
max_connections        = 1500
table_cache            = 128
thread_concurrency     = 4
#
# * Query Cache Configuration
#
query_cache_limit       = 2M
query_cache_size        = 32M
query_cache_type        = 1
#
# * Custom Configuration
#    
tmp_table_size          = 512M
max_heap_table_size     = 128M
join_buffer_size        = 128M
myisam_sort_buffer_size = 512M

Answer 1

http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/