来源：自学PHP网 时间：2015-04-16 10:51 作者： 阅读:次
[导读] [MySQL参数取值] Status取值ERROR 1193 (HY000): Unknown system variable 39;Innodb_buffer_pool_read_requests 39;variables参数值，可以通过 select @@xx取值，如下：[sql] mysql show varia...
|
[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>
|
自学PHP网专注网站建设学习,PHP程序学习,平面设计学习，以及操作系统学习
京ICP备14009008号-1@版权所有www.zixuephp.com
网站声明：本站所有视频，教程都由网友上传，站长收集和分享给大家学习使用，如由牵扯版权问题请联系站长邮箱904561283@qq.com
