MySQL 튜닝

1 목록[ | ]

변수명	기본값	권장값	비고
key_buffer_size	8M→ 8388608	1G^[1]	[1]
table_cache
myisam_sort_buffer_size
join_buffer_size
innodb_buffer_pool_size		2G^[2]^[3]
innodb_additional_mem_pool_size		8M^[3]
innodb_log_file_size		512M^[3]
innodb_log_buffer_size		4M^[3]
innodb_flush_log_at_trx_commit		2
innodb_lock_wait_timeout		50
innodb_flush_method		O_DSYNC
innodb_thread_concurrency		12

↑ 메모리의 25% 정도
↑ 메모리의 50% 정도
↑ ^3.0 ^3.1 ^3.2 ^3.3 http://redkite777.tistory.com/entry/MySQLMySQL-파라메터-튜닝 [All Days 무한도전]