mysql myisam 优化设置

mysql myisam 优化设置设置，需要的朋友可以参考下。
myisam_max_[extra]_sort_file_size足够大

delay_key_write减少io,提高写入性能文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/47372.html

bulk_insert_buffer_size文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/47372.html

concurrent_insert 设置为2文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/47372.html

read_rnd_buffer_size random scan 使用文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/47372.html

read_buffer_size 顺序扫描表使用文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/47372.html

key cache 的三种方式文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/47372.html

key cache 预加载文章源自很文博客https://www.hinven.com很文博客-https://www.hinven.com/47372.html

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