[MySQL参数取值] Status取值ERROR 1193 (HY000): Unknown s

页面导航:首页 > 数据库 > Mysql > [MySQL参数取值] Status取值ERROR 1193 (HY000): Unknown s

[MySQL参数取值] Status取值ERROR 1193 (HY000): Unknown s

来源: 作者: 时间:2016-02-03 08:56 【

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

 


Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<