为什么MySQL状态key_reads,key_reads_request的值为零? [英] Why mysql status key_reads,key_reads_request's values are zero?
问题描述
我对自己的mysql状态有些困惑. mysql>显示类似'%key%'的状态; </p>
I have some confusion about my mysql status. mysql> show status like '%key%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| Com_assign_to_keycache | 0 |
| Com_preload_keys | 0 |
| Com_show_keys | 0 |
| Handler_read_key | 2 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 13396 |
| Key_blocks_used | 0 |
| Key_read_requests | 0 |
| Key_reads | 0 |
| Key_write_requests | 0 |
| Key_writes | 0 |
但是,服务器上有大量(每天超过10亿个)插入,更新和查询,但是为什么状态值为0.服务器已运行近3天.(正常运行时间:2天18小时54分钟19秒).我没有刷新服务器的状态. 一些数据库配置引擎= innodb,key_buffer = 16M,innodb_buffer_pool_size = 2147483648. 感谢您提供任何信息.
but,there have large (more then 1 billion each day) insert,update and query on the server,but why the status's value is 0.The server has run nearly 3 days.(Uptime:2 days 18 hours 54 min 19 sec).I did not flush the server's status. Some db config engine = innodb,key_buffer = 16M, innodb_buffer_pool_size = 2147483648. Thanks for any information.
推荐答案
也许您正在使用InnoDB表?
Perhaps you're using InnoDB tables ?
这些Key_XXX服务器状态值用于MyISAM表.
Those Key_XXX server status values are for MyISAM tables.
这篇关于为什么MySQL状态key_reads,key_reads_request的值为零?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!