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

最新推荐文章于 2025-09-04 10:17:52 发布

原创最新推荐文章于 2025-09-04 10:17:52 发布 · 1w 阅读

0 ·

CC 4.0 BY-SA版权

mysql problem 专栏收录该内容

70 篇文章

订阅专栏

博客探讨了variables和status参数取值的问题，指出variables参数值可通过select @@xx取值，而status参数不行，并提出疑问。

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

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？

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>