[MySQL参数取值]Status取值ERROR1193(HY000):Unknownsystem_MySQL

[MySQL参数取值] Status取值ERROR 1193 (HY000): Unknown system variable 'Innodb_buffer_pool_read_requests'

variables参数值，可以通过 select @@xx取值，如下：

[sql] mysql> show variables like 'innodb_buffer_pool_size'; +-------------------------+-------------+ | Variable_name | Value | +-------------------------+-------------+ | innodb_buffer_pool_size | 22020096000 | +-------------------------+-------------+ 1 row in set (0.00 sec) mysql> select @@innodb_buffer_pool_size; +---------------------------+ | @@innodb_buffer_pool_size | +---------------------------+ | 22020096000 | +---------------------------+ 1 row in set (0.00 sec) mysql> 

而status参数就不行，why？

[sql] mysql> show status like 'Innodb_buffer_pool_read_requests'; +----------------------------------+-------------+ | Variable_name | Value | +----------------------------------+-------------+ | Innodb_buffer_pool_read_requests | 15551159458 | +----------------------------------+-------------+ 1 row in set (0.00 sec) mysql> select @@Innodb_buffer_pool_read_requests; ERROR 1193 (HY000): Unknown system variable 'Innodb_buffer_pool_read_requests' mysql>