使用CMD命令查看MySQL状态（cmd看mysql）
使用CMD命令查看MySQL状态
MySQL是用于管理关系数据库的一种开源软件。在使用MySQL时，有时会遇到连接不上数据库、执行查询缓慢等问题，这时我们需要查看MySQL的状态来定位问题所在。接下来将介绍如何使用CMD命令查看MySQL状态。
1. 打开CMD命令窗口。在Windows操作系统中，可以使用快捷键Win+R打开运行窗口，输入cmd命令打开CMD命令窗口。
2. 输入以下命令，连接MySQL数据库：
mysql -h主机名 -u用户名 -p密码
其中，主机名是MySQL服务器的IP地址或域名；用户名和密码是MySQL的登录账号和密码。连接成功后，CMD命令窗口会显示MySQL的版本信息和欢迎信息。
3. 输入以下命令，查看MySQL运行状态：
show status;
这个命令会输出当前MySQL的所有状态信息，如下所示：
+--------------------------+-------------------+
| Variable_name | Value |+--------------------------+-------------------+
| Aborted_clients | 0 || Aborted_connects | 0 |
| Bytes_received | 1518720822 || Bytes_sent | 4381137799 |
| Com_admin_commands | 95 || Com_assign_to_keycache | 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 | 2 || Com_alter_tablespace | 0 |
| Com_analyze | 0 || Com_begin | 0 |
| Com_binlog | 0 || Com_call_procedure | 0 |
| Com_change_db | 138 || Com_change_master | 0 |
| Com_check | 0 || Com_checksum | 0 |
| Com_commit | 0 || Com_create_db | 0 |
| Com_create_event | 0 || Com_create_function | 0 |
| Com_create_index | 0 || Com_create_procedure | 0 |
| Com_create_server | 0 || Com_create_table | 0 |
| Com_create_trigger | 0 || Com_create_udf | 0 |
| Com_create_user | 0 || Com_create_view | 0 |
| Com_dealloc_sql | 0 || Com_delete | 1 |
| Com_delete_multi | 0 || Com_do | 0 |
| Com_drop_db | 0 || Com_drop_event | 0 |
| Com_drop_function | 0 || Com_drop_index | 0 |
| Com_drop_procedure | 0 || Com_drop_server | 0 |
| Com_drop_table | 0 || Com_drop_trigger | 0 |
| Com_drop_user | 0 || Com_drop_view | 0 |
| Com_empty_query | 0 || Com_execute_sql | 0 |
| Com_flush | 0 || Com_get_diagnostics | 0 |
| Com_grant | 0 || Com_ha_close | 0 |
| Com_ha_open | 0 || Com_ha_read | 0 |
| Com_help | 0 || Com_insert | 2 |
| Com_insert_select | 0 || Com_install_plugin | 0 |
| Com_kill | 0 || Com_load | 0 |
| Com_lock_tables | 0 || Com_optimize | 0 |
| Com_preload_keys | 0 || Com_prepare_sql | 0 |
| Com_purge | 0 || Com_purge_before_date | 0 |
| Com_release_savepoint | 0 || Com_rename_table | 0 |
| Com_rename_user | 0 || Com_repr | 0 |
| Com_replace | 0 || Com_replace_select | 0 |
| Com_reset | 0 || Com_resignal | 0 |
| Com_revoke | 0 || Com_revoke_all | 0 |
| Com_rollback | 0 || Com_rollback_to_savepoint| 0 |
| Com_savepoint | 0 || Com_select | 61 |
| Com_set_option | 502 || Com_signal | 0 |
| Com_show_authors | 0 || Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 || Com_show_charsets | 2 |
| Com_show_collations | 2 || Com_show_contributors | 0 |
| Com_show_create_db | 0 || Com_show_create_event | 0 |
| Com_show_create_func | 0 || Com_show_create_proc | 0 |
| Com_show_create_table | 6 || Com_show_create_trigger | 0 |
| Com_show_databases | 5 || Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 || Com_show_engine_status | 2 |
| Com_show_events | 0 || Com_show_errors | 0 |
| Com_show_fields | 38 || Com_show_function_status | 0 |
| Com_show_grants | 0 || Com_show_index_statistics| 0 |
| Com_show_keys | 8 || Com_show_master_status | 0 |
| Com_show_open_tables | 0 || Com_show_plugins | 0 |
| Com_show_privileges | 0 || Com_show_processlist | 1 |
| Com_show_profile | 0 || Com_show_profiles | 0 |
| Com_show_relaylog_events | 0 || Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 || Com_show_status | 1 |
| Com_show_storage_engines | 0 || Com_show_table_statistics| 0 |
| Com_show_table_status | 0 || Com_show_tables | 18 |
| Com_show_triggers | 0 || Com_show_variables | 14 |
| Com_show_warnings | 0 || Com_slave_start | 0 |
| Com_slave_stop | 0 || Com_stmt_close | 0 |
| Com_stmt_execute | 0 || Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 || Com_stmt_reprepare | 0 |
| Com_stmt_reset | 0 || Com_stmt_send_long_data | 0 |
| Com_truncate | 0 || Com_uninstall_plugin | 0 |
| Com_unlock_tables | 0 || Com_update | 6 |
| Com_update_multi | 0 || Com_xa_commit | 0 |
| Com_xa_end | 0 || Com_xa_prepare | 0 |
| Com_xa_recover | 0 || Com_xa_rollback | 0 |
| Com_xa_start | 0 || Compression | OFF |
| Connections | 4799 || Created_tmp_disk_tables | 0 |
| Created_tmp_files | 10 || Created_tmp_tables | 73769 |
| Delayed_errors | 0 || Delayed_insert_threads | 0 |
| Delayed_writes | 0 || Flush_commands | 1 |
| Handler_commit | 1 || Handler_delete | 0 |
| Handler_discover | 0 || Handler_external_lock | 0 |
| Handler_mrr_init | 0 || Handler_prepare | 0 |
| Handler_read_first | 138119 || Handler_read_key | 408837582 |
| Handler_read_last | 1 || Handler_read_next | 21863537 |
| Handler_read_prev | 327704938 || Handler_read_rnd | 11218 |
| Handler_read_rnd_next | 333813959 || Handler_rollback | 0 |
| Handler_savepoint | 0
