[MySQL参数取值] Status取值ERROR 1193 (HY000): Unknown system_MySQL
- WBOYOriginal
- 2016-06-01 13:28:382014browse
bitsCN.com
[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>
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL Index索引的建立、使用说明_MySQLNext article：mysql查询时间戳和日期的转换_MySQL