mysql+status+取值_[MySQL参数取值] Status取值ERROR 1193 (HY000): Unknown system variable 'Innodb_buffer_...

[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>