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>
--转自
当前位置：
论坛首页 »
自由讨论区 »
MySQL, Oracle及数据库讨论区
»
发起投票
技术讨论
加好友
发消息
2015-1-13 16:23:10 |
赞(
操作
