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

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

1. mysql> show variables like 'innodb_buffer_pool_size';  
2. +-------------------------+-------------+  
3. | Variable_name           | Value       |  
4. +-------------------------+-------------+  
5. | innodb_buffer_pool_size | 22020096000 |  
6. +-------------------------+-------------+  
7. 1 row in set (0.00 sec)  
8.   
9.   
10. mysql> select @@innodb_buffer_pool_size;  
11. +---------------------------+  
12. | @@innodb_buffer_pool_size |  
13. +---------------------------+  
14. |               22020096000 |  
15. +---------------------------+  
16. 1 row in set (0.00 sec)  
17.   
18.   
19. mysql>  

而status参数就不行，why？

1. mysql> show status like 'Innodb_buffer_pool_read_requests';  
2. +----------------------------------+-------------+  
3. | Variable_name                    | Value       |  
4. +----------------------------------+-------------+  
5. | Innodb_buffer_pool_read_requests | 15551159458 |  
6. +----------------------------------+-------------+  
7. 1 row in set (0.00 sec)  
8.   
9.   
10. mysql> select @@Innodb_buffer_pool_read_requests;  
11. ERROR 1193 (HY000): Unknown system variable 'Innodb_buffer_pool_read_requests'  
12. mysql>