为什么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屋！