mysql myisam optimization Settings

myisam_max_ extra _sort_file_size is big enough

delay_key_write reduces io and improves write performance

bulk_insert_buffer_size

concurrent_insert is set to 2

read_rnd_buffer_size random scan

read_buffer_size sequential scan table used

Three ways of key cache

key cache preload

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