【MySQL】MySQL 8.0 状态变量(Server Status Variables)列表(show status 的结果例)

发布时间:2024年01月20日


【声明】文章仅供学习交流,观点代表个人,与任何公司无关。
编辑|SQL和数据库技术(ID:SQLplusDB)

MySQL 8.0 OCP (1Z0-908) 考点概要

MySQL 8.0 OCP (1Z0-908) 考点精析-安装与配置考点1:设置系统变量
【MySQL】控制MySQL优化器行为方法之optimizer_switch系统变量
【MySQL】MySQL系统变量(system variables)列表(mysqld --verbose --help的结果例)
【MySQL】MySQL系统变量(system variables)列表(SHOW VARIABLES 的结果例)
MySQL 8.0 OCP (1Z0-908) 考点精析-备份与恢复考点1:MySQL Enterprise Backup概要
MySQL 8.0 OCP (1Z0-908) 考点精析-性能优化考点1:sys.statement_analysis视图
MySQL 8.0 OCP (1Z0-908) 考点精析-性能优化考点2:系统变量的确认
MySQL 8.0 OCP (1Z0-908) 考点精析-性能优化考点3:EXPLAIN ANALYZE
MySQL 8.0 OCP (1Z0-908) 考点精析-性能优化考点4:慢速查询日志(slow query log)
MySQL 8.0 OCP (1Z0-908) 考点精析-性能优化考点5:表连接算法(join algorithm)
MySQL 8.0 OCP (1Z0-908) 考点精析-性能优化考点6:MySQL Enterprise Monitor之Query Analyzer
MySQL 8.0 OCP (1Z0-908) 考点精析-架构考点1:二进制日志文件(Binary log)
MySQL 8.0 OCP (1Z0-908) 考点精析-架构考点5:数据字典(Data Dictionary)
MySQL 8.0 OCP (1Z0-908) 考点精析-架构考点6:InnoDB Tablespaces之系统表空间(System Tablespace)
MySQL 8.0 InnoDB Tablespaces之File-per-table tablespaces(单独表空间)
MySQL 8.0 InnoDB Tablespaces之General Tablespaces(通用表空间/一般表空间)
【MySQL】在数据目录之外创建InnoDB 表(Creating Tables Externally)
MySQL 8.0 InnoDB Tablespaces之Temporary Tablespaces(临时表空间)
MySQL 8.0 InnoDB 架构之 日志缓冲区(Log Buffer)和重做日志(Redo Log)
MySQL 8.0 架构 之错误日志文件(Error Log)(1)

【MySQL】MySQL 8.0 状态变量(Server Status Variables)列表(show status的结果例)

MySQL提供了许多状态变量用于监视数据库相关的动作信息,可以使用SHOW [GLOBAL | SESSION] STATUS语句查看这些变量信息。
下面是MySQL 8.0 状态变量信息(show status的结果例)。

例:

mysql> select version();
+-------------------------+
| version()               |
+-------------------------+
| 8.0.35-0ubuntu0.22.04.1 |
+-------------------------+
1 row in set (0.00 sec)

mysql>
mysql> show status;
+-------------------------------------------------------+-----------------------------------------------+
| Variable_name                                         | Value          |
+-------------------------------------------------------+-----------------------------------------------+
| Aborted_clients                                       | 0              |
| Aborted_connects                                      | 2              |
| Acl_cache_items_count                                 | 0              |
| Binlog_cache_disk_use                                 | 0              |
| Binlog_cache_use                                      | 12             |
| Binlog_stmt_cache_disk_use                            | 0              |
| Binlog_stmt_cache_use                                 | 0              |
| Bytes_received                                        | 295            |
| Bytes_sent                                            | 226            |
| Caching_sha2_password_rsa_public_key                  | -----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtV9pQFfRgnehmEpaus5+
FHb6ZzZW8akQcn3gW8FC4wrpbO7tn/d0Fs9tF4dgHUN6eFJb8YvbD4ApBsttsGQt
fSTGLH1cHGb9DVrzNNssdmVxAAUCSLrOYkqOK1iC1zafKG2wOjkts7CWVEQ5J8ol
e80ET+pc+rRimL2OgOrUhyeB8W5tqpT69RwhZEM0SS1FVoVnJE2iCl32X4nt0Njv
cjXp1XbkSftjRpm8oUlH3wej+9jGGtRV5uBG7+NVUQt20hKvEb8F9NLFv4z9wnTG
oEMUlJOFUn5/yxvmgyMyKcYSaMav13+CqvzC5CzCafVAkNh+V/egylJ3EDDa6Jl6
qQIDAQAB
-----END PUBLIC KEY-----
 |
| Com_admin_commands                                    | 0              |
| Com_assign_to_keycache                                | 0              |
| Com_alter_db                                          | 0              |
| Com_alter_event                                       | 0              |
| Com_alter_function                                    | 0              |
| Com_alter_instance                                    | 0              |
| Com_alter_procedure                                   | 0              |
| Com_alter_resource_group                              | 0              |
| Com_alter_server                                      | 0              |
| Com_alter_table                                       | 0              |
| Com_alter_tablespace                                  | 0              |
| Com_alter_user                                        | 0              |
| Com_alter_user_default_role                           | 0              |
| Com_analyze                                           | 0              |
| Com_begin                                             | 0              |
| Com_binlog                                            | 0              |
| Com_call_procedure                                    | 0              |
| Com_change_db                                         | 0              |
| Com_change_master                                     | 0              |
| Com_change_repl_filter                                | 0              |
| Com_change_replication_source                         | 0              |
| Com_check                                             | 0              |
| Com_checksum                                          | 0              |
| Com_clone                                             | 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_role                                       | 0              |
| Com_create_server                                     | 0              |
| Com_create_table                                      | 0              |
| Com_create_resource_group                             | 0              |
| Com_create_trigger                                    | 0              |
| Com_create_udf                                        | 0              |
| Com_create_user                                       | 0              |
| Com_create_view                                       | 0              |
| Com_create_spatial_reference_system                   | 0              |
| Com_dealloc_sql                                       | 0              |
| Com_delete                                            | 0              |
| 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_resource_group                               | 0              |
| Com_drop_role                                         | 0              |
| Com_drop_server                                       | 0              |
| Com_drop_spatial_reference_system                     | 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_explain_other                                     | 0              |
| Com_flush                                             | 0              |
| Com_get_diagnostics                                   | 0              |
| Com_grant                                             | 0              |
| Com_grant_roles                                       | 0              |
| Com_ha_close                                          | 0              |
| Com_ha_open                                           | 0              |
| Com_ha_read                                           | 0              |
| Com_help                                              | 0              |
| Com_import                                            | 0              |
| Com_insert                                            | 0              |
| Com_insert_select                                     | 0              |
| Com_install_component                                 | 0              |
| Com_install_plugin                                    | 0              |
| Com_kill                                              | 0              |
| Com_load                                              | 0              |
| Com_lock_instance                                     | 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_repair                                            | 0              |
| Com_replace                                           | 0              |
| Com_replace_select                                    | 0              |
| Com_reset                                             | 0              |
| Com_resignal                                          | 0              |
| Com_restart                                           | 0              |
| Com_revoke                                            | 0              |
| Com_revoke_all                                        | 0              |
| Com_revoke_roles                                      | 0              |
| Com_rollback                                          | 0              |
| Com_rollback_to_savepoint                             | 0              |
| Com_savepoint                                         | 0              |
| Com_select                                            | 1              |
| Com_set_option                                        | 0              |
| Com_set_password                                      | 0              |
| Com_set_resource_group                                | 0              |
| Com_set_role                                          | 0              |
| Com_signal                                            | 0              |
| Com_show_binlog_events                                | 0              |
| Com_show_binlogs                                      | 0              |
| Com_show_charsets                                     | 0              |
| Com_show_collations                                   | 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                                 | 0              |
| Com_show_create_trigger                               | 0              |
| Com_show_databases                                    | 0              |
| Com_show_engine_logs                                  | 0              |
| Com_show_engine_mutex                                 | 0              |
| Com_show_engine_status                                | 0              |
| Com_show_events                                       | 0              |
| Com_show_errors                                       | 0              |
| Com_show_fields                                       | 0              |
| Com_show_function_code                                | 0              |
| Com_show_function_status                              | 0              |
| Com_show_grants                                       | 0              |
| Com_show_keys                                         | 0              |
| Com_show_master_status                                | 0              |
| Com_show_open_tables                                  | 0              |
| Com_show_plugins                                      | 0              |
| Com_show_privileges                                   | 0              |
| Com_show_procedure_code                               | 0              |
| Com_show_procedure_status                             | 0              |
| Com_show_processlist                                  | 0              |
| Com_show_profile                                      | 0              |
| Com_show_profiles                                     | 0              |
| Com_show_relaylog_events                              | 0              |
| Com_show_replicas                                     | 0              |
| Com_show_slave_hosts                                  | 0              |
| Com_show_replica_status                               | 0              |
| Com_show_slave_status                                 | 0              |
| Com_show_status                                       | 1              |
| Com_show_storage_engines                              | 0              |
| Com_show_table_status                                 | 0              |
| Com_show_tables                                       | 0              |
| Com_show_triggers                                     | 0              |
| Com_show_variables                                    | 0              |
| Com_show_warnings                                     | 0              |
| Com_show_create_user                                  | 0              |
| Com_shutdown                                          | 0              |
| Com_replica_start                                     | 0              |
| Com_slave_start                                       | 0              |
| Com_replica_stop                                      | 0              |
| Com_slave_stop                                        | 0              |
| Com_group_replication_start                           | 0              |
| Com_group_replication_stop                            | 0              |
| Com_stmt_execute                                      | 0              |
| Com_stmt_close                                        | 0              |
| Com_stmt_fetch                                        | 0              |
| Com_stmt_prepare                                      | 0              |
| Com_stmt_reset                                        | 0              |
| Com_stmt_send_long_data                               | 0              |
| Com_truncate                                          | 0              |
| Com_uninstall_component                               | 0              |
| Com_uninstall_plugin                                  | 0              |
| Com_unlock_instance                                   | 0              |
| Com_unlock_tables                                     | 0              |
| Com_update                                            | 0              |
| 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              |
| Com_stmt_reprepare                                    | 0              |
| Compression                                           | OFF            |
| Compression_algorithm                                 |                |
| Compression_level                                     | 0              |
| 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                                           | 25             |
| Created_tmp_disk_tables                               | 0              |
| Created_tmp_files                                     | 5              |
| Created_tmp_tables                                    | 0              |
| Current_tls_ca                                        | ca.pem         |
| Current_tls_capath                                    |                |
| Current_tls_cert                                      | server-cert.pem|
| Current_tls_cipher                                    |                |
| Current_tls_ciphersuites                              |                |
| Current_tls_crl                                       |                |
| Current_tls_crlpath                                   |                |
| Current_tls_key                                       | server-key.pem |
| Current_tls_version                                   | TLSv1.2,TLSv1.3|
| Delayed_errors                                        | 0              |
| Delayed_insert_threads                                | 0              |
| Delayed_writes                                        | 0              |
| Error_log_buffered_bytes                              | 17144          |
| Error_log_buffered_events                             | 114            |
| Error_log_expired_events                              | 0              |
| Error_log_latest_write                                | 1703926836878871|
| Flush_commands                                        | 3              |
| Global_connection_memory                              | 0              |
| Handler_commit                                        | 0              |
| Handler_delete                                        | 0              |
| Handler_discover                                      | 0              |
| Handler_external_lock                                 | 0              |
| Handler_mrr_init                                      | 0              |
| Handler_prepare                                       | 0              |
| Handler_read_first                                    | 0              |
| Handler_read_key                                      | 0              |
| Handler_read_last                                     | 0              |
| Handler_read_next                                     | 0              |
| Handler_read_prev                                     | 0              |
| Handler_read_rnd                                      | 0              |
| Handler_read_rnd_next                                 | 0              |
| Handler_rollback                                      | 0              |
| Handler_savepoint                                     | 0              |
| Handler_savepoint_rollback                            | 0              |
| Handler_update                                        | 0              |
| Handler_write                                         | 0              |
| Innodb_buffer_pool_dump_status                        | Dumping of buffer pool not started                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| Innodb_buffer_pool_load_status                        | Buffer pool(s) load completed at 231228 11:28:14                                                                                                                                                                                                                                                                                                                                                                                                                    |
| Innodb_buffer_pool_resize_status                      |                |
| Innodb_buffer_pool_resize_status_code                 | 0              |
| Innodb_buffer_pool_resize_status_progress             | 0              |
| Innodb_buffer_pool_pages_data                         | 1430           |
| Innodb_buffer_pool_bytes_data                         | 23429120       |
| Innodb_buffer_pool_pages_dirty                        | 0              |
| Innodb_buffer_pool_bytes_dirty                        | 0              |
| Innodb_buffer_pool_pages_flushed                      | 1295           |
| Innodb_buffer_pool_pages_free                         | 6749           |
| Innodb_buffer_pool_pages_misc                         | 13             |
| Innodb_buffer_pool_pages_total                        | 8192           |
| Innodb_buffer_pool_read_ahead_rnd                     | 0              |
| Innodb_buffer_pool_read_ahead                         | 0              |
| Innodb_buffer_pool_read_ahead_evicted                 | 0              |
| Innodb_buffer_pool_read_requests                      | 65355          |
| Innodb_buffer_pool_reads                              | 1219           |
| Innodb_buffer_pool_wait_free                          | 0              |
| Innodb_buffer_pool_write_requests                     | 6687           |
| Innodb_data_fsyncs                                    | 1520           |
| Innodb_data_pending_fsyncs                            | 0              |
| Innodb_data_pending_reads                             | 0              |
| Innodb_data_pending_writes                            | 0              |
| Innodb_data_read                                      | 20040704       |
| Innodb_data_reads                                     | 1338           |
| Innodb_data_writes                                    | 2595           |
| Innodb_data_written                                   | 24901120       |
| Innodb_dblwr_pages_written                            | 1146           |
| Innodb_dblwr_writes                                   | 314            |
| Innodb_redo_log_read_only                             | OFF            |
| Innodb_redo_log_uuid                                  | 1075899837     |
| Innodb_redo_log_checkpoint_lsn                        | 486673283      |
| Innodb_redo_log_current_lsn                           | 486673283      |
| Innodb_redo_log_flushed_to_disk_lsn                   | 486673283      |
| Innodb_redo_log_logical_size                          | 512            |
| Innodb_redo_log_physical_size                         | 3276800        |
| Innodb_redo_log_capacity_resized                      | 104857600      |
| Innodb_redo_log_resize_status                         | OK             |
| Innodb_log_waits                                      | 0              |
| Innodb_log_write_requests                             | 3703           |
| Innodb_log_writes                                     | 652            |
| Innodb_os_log_fsyncs                                  | 415            |
| Innodb_os_log_pending_fsyncs                          | 0              |
| Innodb_os_log_pending_writes                          | 0              |
| Innodb_os_log_written                                 | 1599488        |
| Innodb_page_size                                      | 16384          |
| Innodb_pages_created                                  | 329            |
| Innodb_pages_read                                     | 1218           |
| Innodb_pages_written                                  | 1406           |
| Innodb_redo_log_enabled                               | ON             |
| Innodb_row_lock_current_waits                         | 0              |
| Innodb_row_lock_time                                  | 0              |
| Innodb_row_lock_time_avg                              | 0              |
| Innodb_row_lock_time_max                              | 0              |
| Innodb_row_lock_waits                                 | 0              |
| Innodb_rows_deleted                                   | 0              |
| Innodb_rows_inserted                                  | 0              |
| Innodb_rows_read                                      | 0              |
| Innodb_rows_updated                                   | 0              |
| Innodb_system_rows_deleted                            | 65             |
| Innodb_system_rows_inserted                           | 152            |
| Innodb_system_rows_read                               | 12883          |
| Innodb_system_rows_updated                            | 459            |
| Innodb_sampled_pages_read                             | 0              |
| Innodb_sampled_pages_skipped                          | 0              |
| Innodb_num_open_files                                 | 69             |
| Innodb_truncated_status_writes                        | 0              |
| Innodb_undo_tablespaces_total                         | 3              |
| Innodb_undo_tablespaces_implicit                      | 2              |
| Innodb_undo_tablespaces_explicit                      | 1              |
| Innodb_undo_tablespaces_active                        | 3              |
| Key_blocks_not_flushed                                | 0              |
| Key_blocks_unused                                     | 13396          |
| Key_blocks_used                                       | 0              |
| Key_read_requests                                     | 0              |
| Key_reads                                             | 0              |
| Key_write_requests                                    | 0              |
| Key_writes                                            | 0              |
| Last_query_cost                                       | 0.000000       |
| Last_query_partial_plans                              | 0              |
| Locked_connects                                       | 0              |
| Max_execution_time_exceeded                           | 0              |
| Max_execution_time_set                                | 0              |
| Max_execution_time_set_failed                         | 0              |
| Max_used_connections                                  | 3              |
| Max_used_connections_time                             | 2023-12-30 00:00:28                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| Mysqlx_aborted_clients                                | 0              |
| Mysqlx_address                                        | 127.0.0.1      |
| Mysqlx_bytes_received                                 | 0              |
| Mysqlx_bytes_received_compressed_payload              | 0              |
| Mysqlx_bytes_received_uncompressed_frame              | 0              |
| Mysqlx_bytes_sent                                     | 0              |
| Mysqlx_bytes_sent_compressed_payload                  | 0              |
| Mysqlx_bytes_sent_uncompressed_frame                  | 0              |
| Mysqlx_compression_algorithm                          |                |
| Mysqlx_compression_level                              |                |
| Mysqlx_connection_accept_errors                       | 0              |
| Mysqlx_connection_errors                              | 0              |
| Mysqlx_connections_accepted                           | 0              |
| Mysqlx_connections_closed                             | 0              |
| Mysqlx_connections_rejected                           | 0              |
| Mysqlx_crud_create_view                               | 0              |
| Mysqlx_crud_delete                                    | 0              |
| Mysqlx_crud_drop_view                                 | 0              |
| Mysqlx_crud_find                                      | 0              |
| Mysqlx_crud_insert                                    | 0              |
| Mysqlx_crud_modify_view                               | 0              |
| Mysqlx_crud_update                                    | 0              |
| Mysqlx_cursor_close                                   | 0              |
| Mysqlx_cursor_fetch                                   | 0              |
| Mysqlx_cursor_open                                    | 0              |
| Mysqlx_errors_sent                                    | 0              |
| Mysqlx_errors_unknown_message_type                    | 0              |
| Mysqlx_expect_close                                   | 0              |
| Mysqlx_expect_open                                    | 0              |
| Mysqlx_init_error                                     | 0              |
| Mysqlx_messages_sent                                  | 0              |
| Mysqlx_notice_global_sent                             | 0              |
| Mysqlx_notice_other_sent                              | 0              |
| Mysqlx_notice_warning_sent                            | 0              |
| Mysqlx_notified_by_group_replication                  | 0              |
| Mysqlx_port                                           | 33060          |
| Mysqlx_prep_deallocate                                | 0              |
| Mysqlx_prep_execute                                   | 0              |
| Mysqlx_prep_prepare                                   | 0              |
| Mysqlx_rows_sent                                      | 0              |
| Mysqlx_sessions                                       | 0              |
| Mysqlx_sessions_accepted                              | 0              |
| Mysqlx_sessions_closed                                | 0              |
| Mysqlx_sessions_fatal_error                           | 0              |
| Mysqlx_sessions_killed                                | 0              |
| Mysqlx_sessions_rejected                              | 0              |
| Mysqlx_socket                                         | /var/run/mysqld/mysqlx.sock                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| Mysqlx_ssl_accepts                                    | 0              |
| Mysqlx_ssl_active                                     |                |
| Mysqlx_ssl_cipher                                     |                |
| Mysqlx_ssl_cipher_list                                |                |
| Mysqlx_ssl_ctx_verify_depth                           | 18446744073709551615                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| Mysqlx_ssl_ctx_verify_mode                            | 5              |
| Mysqlx_ssl_finished_accepts                           | 0              |
| Mysqlx_ssl_server_not_after                           | Mar 23 00:59:48 2033 GMT                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Mysqlx_ssl_server_not_before                          | Mar 26 00:59:48 2023 GMT                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Mysqlx_ssl_verify_depth                               |                |
| Mysqlx_ssl_verify_mode                                |                |
| Mysqlx_ssl_version                                    |                |
| Mysqlx_stmt_create_collection                         | 0              |
| Mysqlx_stmt_create_collection_index                   | 0              |
| Mysqlx_stmt_disable_notices                           | 0              |
| Mysqlx_stmt_drop_collection                           | 0              |
| Mysqlx_stmt_drop_collection_index                     | 0              |
| Mysqlx_stmt_enable_notices                            | 0              |
| Mysqlx_stmt_ensure_collection                         | 0              |
| Mysqlx_stmt_execute_mysqlx                            | 0              |
| Mysqlx_stmt_execute_sql                               | 0              |
| Mysqlx_stmt_execute_xplugin                           | 0              |
| Mysqlx_stmt_get_collection_options                    | 0              |
| Mysqlx_stmt_kill_client                               | 0              |
| Mysqlx_stmt_list_clients                              | 0              |
| Mysqlx_stmt_list_notices                              | 0              |
| Mysqlx_stmt_list_objects                              | 0              |
| Mysqlx_stmt_modify_collection_options                 | 0              |
| Mysqlx_stmt_ping                                      | 0              |
| Mysqlx_worker_threads                                 | 2              |
| Mysqlx_worker_threads_active                          | 0              |
| Not_flushed_delayed_rows                              | 0              |
| Ongoing_anonymous_transaction_count                   | 0              |
| Open_files                                            | 6              |
| Open_streams                                          | 0              |
| Open_table_definitions                                | 176            |
| Open_tables                                           | 325            |
| Opened_files                                          | 6              |
| Opened_table_definitions                              | 0              |
| Opened_tables                                         | 0              |
| Performance_schema_accounts_lost                      | 0              |
| Performance_schema_cond_classes_lost                  | 0              |
| Performance_schema_cond_instances_lost                | 0              |
| Performance_schema_digest_lost                        | 0              |
| Performance_schema_file_classes_lost                  | 0              |
| Performance_schema_file_handles_lost                  | 0              |
| Performance_schema_file_instances_lost                | 0              |
| Performance_schema_hosts_lost                         | 0              |
| Performance_schema_index_stat_lost                    | 0              |
| Performance_schema_locker_lost                        | 0              |
| Performance_schema_memory_classes_lost                | 0              |
| Performance_schema_metadata_lock_lost                 | 0              |
| Performance_schema_mutex_classes_lost                 | 0              |
| Performance_schema_mutex_instances_lost               | 0              |
| Performance_schema_nested_statement_lost              | 0              |
| Performance_schema_prepared_statements_lost           | 0              |
| Performance_schema_program_lost                       | 0              |
| Performance_schema_rwlock_classes_lost                | 0              |
| Performance_schema_rwlock_instances_lost              | 0              |
| Performance_schema_session_connect_attrs_longest_seen | 117            |
| Performance_schema_session_connect_attrs_lost         | 0              |
| Performance_schema_socket_classes_lost                | 0              |
| Performance_schema_socket_instances_lost              | 0              |
| Performance_schema_stage_classes_lost                 | 0              |
| Performance_schema_statement_classes_lost             | 0              |
| Performance_schema_table_handles_lost                 | 0              |
| Performance_schema_table_instances_lost               | 0              |
| Performance_schema_table_lock_stat_lost               | 0              |
| Performance_schema_thread_classes_lost                | 0              |
| Performance_schema_thread_instances_lost              | 0              |
| Performance_schema_users_lost                         | 0              |
| Prepared_stmt_count                                   | 0              |
| Queries                                               | 269            |
| Questions                                             | 2              |
| Replica_open_temp_tables                              | 0              |
| Resource_group_supported                              | ON             |
| Rsa_public_key                                        | -----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtV9pQFfRgnehmEpaus5+
FHb6ZzZW8akQcn3gW8FC4wrpbO7tn/d0Fs9tF4dgHUN6eFJb8YvbD4ApBsttsGQt
fSTGLH1cHGb9DVrzNNssdmVxAAUCSLrOYkqOK1iC1zafKG2wOjkts7CWVEQ5J8ol
e80ET+pc+rRimL2OgOrUhyeB8W5tqpT69RwhZEM0SS1FVoVnJE2iCl32X4nt0Njv
cjXp1XbkSftjRpm8oUlH3wej+9jGGtRV5uBG7+NVUQt20hKvEb8F9NLFv4z9wnTG
oEMUlJOFUn5/yxvmgyMyKcYSaMav13+CqvzC5CzCafVAkNh+V/egylJ3EDDa6Jl6
qQIDAQAB
-----END PUBLIC KEY-----
 |
| Secondary_engine_execution_count                      | 0              |
| Select_full_join                                      | 0              |
| Select_full_range_join                                | 0              |
| Select_range                                          | 0              |
| Select_range_check                                    | 0              |
| Select_scan                                           | 0              |
| Slave_open_temp_tables                                | 0              |
| Slow_launch_threads                                   | 0              |
| Slow_queries                                          | 0              |
| Sort_merge_passes                                     | 0              |
| Sort_range                                            | 0              |
| Sort_rows                                             | 0              |
| Sort_scan                                             | 0              |
| Ssl_accept_renegotiates                               | 0              |
| Ssl_accepts                                           | 0              |
| Ssl_callback_cache_hits                               | 0              |
| Ssl_cipher                                            |                |
| Ssl_cipher_list                                       |                |
| Ssl_client_connects                                   | 0              |
| Ssl_connect_renegotiates                              | 0              |
| Ssl_ctx_verify_depth                                  | 18446744073709551615                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| Ssl_ctx_verify_mode                                   | 5              |
| Ssl_default_timeout                                   | 0              |
| Ssl_finished_accepts                                  | 0              |
| Ssl_finished_connects                                 | 0              |
| Ssl_server_not_after                                  | Mar 23 00:59:48 2033 GMT                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Ssl_server_not_before                                 | Mar 26 00:59:48 2023 GMT                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Ssl_session_cache_hits                                | 0              |
| Ssl_session_cache_misses                              | 0              |
| Ssl_session_cache_mode                                | SERVER         |
| Ssl_session_cache_overflows                           | 0              |
| Ssl_session_cache_size                                | 128            |
| Ssl_session_cache_timeout                             | 300            |
| Ssl_session_cache_timeouts                            | 0              |
| Ssl_sessions_reused                                   | 0              |
| Ssl_used_session_cache_entries                        | 0              |
| Ssl_verify_depth                                      | 0              |
| Ssl_verify_mode                                       | 0              |
| Ssl_version                                           |                |
| Table_locks_immediate                                 | 52             |
| Table_locks_waited                                    | 0              |
| Table_open_cache_hits                                 | 0              |
| Table_open_cache_misses                               | 0              |
| Table_open_cache_overflows                            | 0              |
| Tc_log_max_pages_used                                 | 0              |
| Tc_log_page_size                                      | 0              |
| Tc_log_page_waits                                     | 0              |
| Telemetry_traces_supported                            | ON             |
| Threads_cached                                        | 2              |
| Threads_connected                                     | 1              |
| Threads_created                                       | 3              |
| Threads_running                                       | 2              |
| Tls_library_version                                   | OpenSSL 3.0.2 15 Mar 2022                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| Uptime                                                | 192758         |
| Uptime_since_flush_status                             | 192758         |
+-------------------------------------------------------+-----------------------------------------------+
497 rows in set (0.00 sec)

mysql>

关于各个状态变量的含义可以参考如下官方文档的解释。

5.1.10 Server Status Variables
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html

参考

5.1.10 Server Status Variables
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html

5.1.6 Server Status Variable Reference
https://dev.mysql.com/doc/refman/8.0/en/server-status-variable-reference.html

13.7.7.37 SHOW STATUS Statement
https://dev.mysql.com/doc/refman/8.0/en/show-status.html

文章来源:https://blog.csdn.net/lukeUnique/article/details/135643864
本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。