时间:2021-07-01 10:21:17 帮助过:12人阅读
[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>