MySQL MyISAM optimization settings settings _mysql

Myisam_max_[extra]_sort_file_size big enough.

Delay_key_write reduces IO and improves write performance

Bulk_insert_buffer_size

Concurrent_insert set to 2

Read_rnd_buffer_size Random Scan use

Read_buffer_size Sequential Scan Table use

Three ways of key cache

Key Cache pre-loading

SET GLOBAL hot_cache.key_buffer_size=16m

SET Blobal cold_cache.key_buffer_size=16m

CACHE INDEX Example.top_message in Hot_cache

CACHE INDEX example.event in Cold_cache

LOAD INDEX into CACHE example.top_message,example.event IGNORE LEAVES

LOAD INDEX into CACHE example.user IGNORE leavers,expamle.groups

MySQL Optimization Setup Steps