MySQLSHOWSTATUS命令介绍
SHOW STATUS提供MySQL服务的状态信息，执行这个语句只需要连接到MySQL数据库的权限。
这些服务状态信息来源于以下:
① 性能用户的表。
② INFORMATION_SCHEMA用户下的GLOBAL_STATUS和SESSION_STATUS表。
MariaDB [test]> desc information_schema.global_status;
+----------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+-------+
| VARIABLE_NAME | varchar(64) | NO | | | |
| VARIABLE_VALUE | varchar(2048) | NO | | | |
+----------------+---------------+------+-----+---------+-------+
2 rows in set (0.12 sec)
MariaDB [test]> select * from information_schema.global_status where variable_name like 'Com_insert%';
+-------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+-------------------+----------------+
| COM_INSERT | 106 |
| COM_INSERT_SELECT | 10 |
+-------------------+----------------+
2 rows in set (0.00 sec)
MariaDB [test]> desc information_schema.session_status;
+----------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+-------+
| VARIABLE_NAME | varchar(64) | NO | | | |
| VARIABLE_VALUE | varchar(2048) | NO | | | |
+----------------+---------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
MariaDB [test]> select * from information_schema.session_status where variable_name like 'Com_insert%';
+-------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+-------------------+----------------+
| COM_INSERT | 19 |
| COM_INSERT_SELECT | 0 |
+-------------------+----------------+
2 rows in set (0.00 sec)
③ mysqladmin的extended-status命令
[root@localhost 20160630]# /maria/bin/mysqladmin -uroot -p extended-status|grep Com|more
Enter password:
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_db_upgrade | 0 |
| Com_alter_event | 0 |
| Com_alter_function | 0 |
| Com_alter_procedure | 0 |
| Com_alter_server | 0 |
| Com_alter_table | 40 |
| Com_alter_tablespace | 0 |
| Com_analyze | 3 |
| Com_assign_to_keycache | 0 |
| Com_begin | 0 |
| Com_binlog | 0 |
| Com_call_procedure | 3 |
| Com_change_db | 43 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_compound_sql | 0 |
| Com_create_db | 1 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 4 |
| Com_create_procedure | 4 |
SHOW STATUS接受GLOBAL或SESSION参数，分别显示全局或当前连接会话信息，如果不带参数则显示的是当前会话的信息。
每次调用SHOW STATUS语句会使用一个临时表，并会增加Created_tmp_tables全局参数的值。
MariaDB [test]> show global status like 'Created_tmp_tables';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| Created_tmp_tables | 894 |
+--------------------+-------+
1 row in set (0.00 sec)
MariaDB [test]> show global status like 'Created_tmp_tables';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| Created_tmp_tables | 895 |
+--------------------+-------+
1 row in set (0.00 sec)
--常用的统计参数
Com_select 执行SELECT操作的次数
Com_insert 执行INSERT操作的次数
Com_update 执行UPDATE操作的次数
Com_delete 执行DELETE操作的次数
Innodb_rows_read InnoDB存储引擎SELECT查询返回的行数
Innodb_rows_inserted InnoDB存储引擎执行INSERT操作插入的行数
Innodb_rows_updated InnoDB存储引擎执行UPDATE操作更新的行数
Innodb_rows_deleted InnoDB存储引擎执行DELETE操作删除的行数
Connections 连接数
Uptime 服务器工作时间
Slow_queries 慢查询的次数
MariaDB [test]> show global status like 'Innodb_rows%';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Innodb_rows_deleted | 512 |
| Innodb_rows_inserted | 1662 |
| Innodb_rows_read | 4557 |
| Innodb_rows_updated | 4 |
+----------------------+-------+
4 rows in set (0.00 sec)
MariaDB [test]> show global status like 'Connection%';
+-----------------------------------+-------+
| Variable_name | Value |
+-----------------------------------+-------+
| Connection_errors_accept | 0 |
| Connection_errors_internal | 0 |
| Connection_errors_max_connections | 0 |
| Connection_errors_peer_address | 0 |
| Connection_errors_select | 0 |
| Connection_errors_tcpwrap | 0 |
| Connections | 15 |
+-----------------------------------+-------+
7 rows in set (0.00 sec)
MariaDB [test]> show global status like 'Uptime%';
+---------------------------+---------+
| Variable_name | Value |
+---------------------------+---------+
| Uptime | 1285789 |
| Uptime_since_flush_status | 1285789 |
+---------------------------+---------+
2 rows in set (0.00 sec)
MariaDB [test]> show global status like 'Slow_queries%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Slow_queries | 0 |
+---------------+-------+
1 row in set (0.00 sec)
这些服务状态信息来源于以下:
① 性能用户的表。
② INFORMATION_SCHEMA用户下的GLOBAL_STATUS和SESSION_STATUS表。
MariaDB [test]> desc information_schema.global_status;
+----------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+-------+
| VARIABLE_NAME | varchar(64) | NO | | | |
| VARIABLE_VALUE | varchar(2048) | NO | | | |
+----------------+---------------+------+-----+---------+-------+
2 rows in set (0.12 sec)
MariaDB [test]> select * from information_schema.global_status where variable_name like 'Com_insert%';
+-------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+-------------------+----------------+
| COM_INSERT | 106 |
| COM_INSERT_SELECT | 10 |
+-------------------+----------------+
2 rows in set (0.00 sec)
MariaDB [test]> desc information_schema.session_status;
+----------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+-------+
| VARIABLE_NAME | varchar(64) | NO | | | |
| VARIABLE_VALUE | varchar(2048) | NO | | | |
+----------------+---------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
MariaDB [test]> select * from information_schema.session_status where variable_name like 'Com_insert%';
+-------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+-------------------+----------------+
| COM_INSERT | 19 |
| COM_INSERT_SELECT | 0 |
+-------------------+----------------+
2 rows in set (0.00 sec)
③ mysqladmin的extended-status命令
[root@localhost 20160630]# /maria/bin/mysqladmin -uroot -p extended-status|grep Com|more
Enter password:
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_db_upgrade | 0 |
| Com_alter_event | 0 |
| Com_alter_function | 0 |
| Com_alter_procedure | 0 |
| Com_alter_server | 0 |
| Com_alter_table | 40 |
| Com_alter_tablespace | 0 |
| Com_analyze | 3 |
| Com_assign_to_keycache | 0 |
| Com_begin | 0 |
| Com_binlog | 0 |
| Com_call_procedure | 3 |
| Com_change_db | 43 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_compound_sql | 0 |
| Com_create_db | 1 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 4 |
| Com_create_procedure | 4 |
SHOW STATUS接受GLOBAL或SESSION参数，分别显示全局或当前连接会话信息，如果不带参数则显示的是当前会话的信息。
每次调用SHOW STATUS语句会使用一个临时表，并会增加Created_tmp_tables全局参数的值。
MariaDB [test]> show global status like 'Created_tmp_tables';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| Created_tmp_tables | 894 |
+--------------------+-------+
1 row in set (0.00 sec)
MariaDB [test]> show global status like 'Created_tmp_tables';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| Created_tmp_tables | 895 |
+--------------------+-------+
1 row in set (0.00 sec)
--常用的统计参数
Com_select 执行SELECT操作的次数
Com_insert 执行INSERT操作的次数
Com_update 执行UPDATE操作的次数
Com_delete 执行DELETE操作的次数
Innodb_rows_read InnoDB存储引擎SELECT查询返回的行数
Innodb_rows_inserted InnoDB存储引擎执行INSERT操作插入的行数
Innodb_rows_updated InnoDB存储引擎执行UPDATE操作更新的行数
Innodb_rows_deleted InnoDB存储引擎执行DELETE操作删除的行数
Connections 连接数
Uptime 服务器工作时间
Slow_queries 慢查询的次数
MariaDB [test]> show global status like 'Innodb_rows%';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Innodb_rows_deleted | 512 |
| Innodb_rows_inserted | 1662 |
| Innodb_rows_read | 4557 |
| Innodb_rows_updated | 4 |
+----------------------+-------+
4 rows in set (0.00 sec)
MariaDB [test]> show global status like 'Connection%';
+-----------------------------------+-------+
| Variable_name | Value |
+-----------------------------------+-------+
| Connection_errors_accept | 0 |
| Connection_errors_internal | 0 |
| Connection_errors_max_connections | 0 |
| Connection_errors_peer_address | 0 |
| Connection_errors_select | 0 |
| Connection_errors_tcpwrap | 0 |
| Connections | 15 |
+-----------------------------------+-------+
7 rows in set (0.00 sec)
MariaDB [test]> show global status like 'Uptime%';
+---------------------------+---------+
| Variable_name | Value |
+---------------------------+---------+
| Uptime | 1285789 |
| Uptime_since_flush_status | 1285789 |
+---------------------------+---------+
2 rows in set (0.00 sec)
MariaDB [test]> show global status like 'Slow_queries%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Slow_queries | 0 |
+---------------+-------+
1 row in set (0.00 sec)
分享题目：MySQLSHOWSTATUS命令介绍
标题网址：https://www.cdcxhl.com/article0/gcjgio.html
成都网站建设公司_创新互联，为您提供、企业网站制作、移动网站建设、品牌网站建设、全网营销推广、ChatGPT
声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联
- 网站建设中开发使用静态网站和动态网站哪个制作比较好？ 2020-12-06
- 为什么seo都建议大家做静态页面? 2013-07-27
- 企业官网设计之制作静态页面 2015-07-26
- 网站优化不一定需要静态化 2016-06-23
- 网站建设中Apache服务器上如何使用伪静态 2016-08-12
- 谈谈静态网页和动态网页的制作区别 2016-11-09
- 网站建设基础知识之静态和动态网站（一） 2016-09-16
- 网站建设中的静态网站与动态网站 2016-10-26
- 静态页面-企业网站是使用动态还是静态好？ 2016-11-10
- 老生常谈，动态网站和静态网站的优劣势 2014-09-04
- 成都网站建设静态页面最大的优势 2016-11-02
- 为什么说网站伪静态更有利于优化? 2015-05-16