mysql key reads 参数,为什么MySQL状态key_reads，key_reads_request的值为零？

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 |

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.

解决方案

Perhaps you're using InnoDB tables ?

Those Key_XXX server status values are for MyISAM tables.