开发者

load myisam table key files to memory

开发者 https://www.devze.com 2023-01-10 17:50 出处:网络
I am using Myisam only Database. I want to load all the indexes into cache as suggested on this page.

I am using Myisam only Database. I want to load all the indexes into cache as suggested on this page.

http://dev.mysql.com/do开发者_运维知识库c/refman/5.0/en/load-index.html

How do I know if the memory allocation is sufficient to hold the key cache files?


MyISAM engine does this by default. There is one default default buffer, you can create additional ones and force loading of them with mentioned command (this may be useful if you want to allocate more than 4GB for key buffering). As for default, you allocate memory for key buffering using key_buffer_size option in config file.

You can monitor usage of key buffering with SHOW STATUS and SHOW VARIABLES. The values interesting for you will be:

key_reads
key_reads_requests
key_blocks_unused
key_cache_block_size
key_buffer_size
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号