[MySQL][8.0.26] Global Status 설명

• flush status;   -- 상태정보 초기화 쿼리

Variable Name	Value(Example)	Description
Aborted_clients	0	≫ 클라이언트 프로그램이 비 정상적으로 종료된 수 ≫ max_allowed_packet을 초과하는 쿼리는 비정상 적으로 중단된다. (default 4194304 byte) ≫ MySQL 연결을 닫지 않은 상태에서 Wait_timeout 설정에 의해 클라이언트와의 연결을 강제 종료한 경우 증가 ≫
Aborted_connects	0	≫ MySQL 서버에 접속이 실패된 수 ≫ 값이 지속적으로 증가하면 해킹 시도를 의심해야 함 ≫ 실패 사유 : 계정정보 오류, 유효하지 않은 DB명 입력, 컨넥션 부족 ≫ 서버 재시작 시 초기화됨
Acl_cache_items_count	0
Binlog_cache_disk_use	0
Binlog_cache_use	0
Binlog_stmt_cache_disk_use	0
Binlog_stmt_cache_use	0
Bytes_received	65418
Bytes_sent	1177448
Caching_sha2_password_rsa_public_key	"-----BEGIN PUBLIC KEY----- -----END PUBLIC KEY-----"
Com_admin_commands	11	≫ Com:서버가 실행된 후 각 명령어가 실행된 횟수 ≫ show status 명령어 실행시 마다 3~4씩 증가
Com_assign_to_keycache	0
Com_alter_db	0	≫ alter db명령어가 실행된 횟수
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	2
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	1	≫ create database 실행 횟수 ≫ 서버 재시작 시 초기화됨
Com_create_event	0	≫ create event 실행 횟수
Com_create_function	0
Com_create_index	0
Com_create_procedure	0
Com_create_role	0
Com_create_server	0
Com_create_table	34	≫ create table 실행 횟수 ≫ 서버 재시작 시 초기화됨
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	1	≫ flush status; 등의 명령을 수행한 횟수
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	89
Com_set_option	385
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	22
Com_show_create_proc	26
Com_show_create_table	79
Com_show_create_trigger	2
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	2
Com_show_storage_engines	0
Com_show_table_status	0
Com_show_tables	0
Com_show_triggers	0
Com_show_variables	2
Com_show_warnings	413
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
Connection_errors_accept	0	≫ 수신 포트에서 수락 호출 중에 발생한 오류 수입니다. ≫ 서버 재시작 시 초기화됨
Connection_errors_internal	0	≫ 새 스레드를 시작하지 못했거나 메모리 부족 상태와 같은 서버 내부 오류로 인해 거부된 연결 수입니다. ≫ 서버 재시작 시 초기화됨
Connection_errors_max_connections	0	≫ 서버 max_connections 제한에 도달했기 때문에 거부된 연결 수입니다. ≫ 서버 재시작 시 초기화됨
Connection_errors_peer_address	0	≫ 클라이언트 IP 주소를 연결하는 동안 발생한 오류 수입니다. ≫ 서버 재시작 시 초기화됨
Connection_errors_select	0	≫ 수신 포트에서 select() 또는 pool()를 호출하는 동안 발생한 오류 수입니다. ≫ 이 작업이 실패했다고 해서 클라이언트 연결이 반드시 거부된 것은 아닙니다.
Connection_errors_tcpwrap	0	≫ libwrap 라이브러리에서 거부된 연결 수입니다.
Connections	9	≫ 서버 가동 후 연결 시도된 횟수 ≫ 실제 접속이 되지 않고 시도만 해도 값 증가 ≫ Access denied 이 되어도 수치 증가
Created_tmp_disk_tables	4	≫ 임시테이블을 디스크에 생성한 횟수 ≫ 이 수치가 높으면 쿼리 처리를 위해 디스크를 많이 사용하고 있다는 뜻(성능 하락)
Created_tmp_files	4	≫ 임시파일 생성 횟수
Created_tmp_tables	81	≫ 임시 테이블 생성 횟수
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,TLSv1.1,TLSv1.2,TLSv1.3
Delayed_errors	0
Delayed_insert_threads	0	≫ 사용중인 insert handler threads가 지연되고 있는 수
Delayed_writes	0	≫ INSERT DELAYED로 쓰여진 rows수
Error_log_buffered_bytes	147912	≫ performance_schema.error_log 의 Byte수 ≫ MySQL 8.0.22에서 추가
Error_log_buffered_events	1032	≫ performance_schema.error_log 의 Row 수
Error_log_expired_events	0
Error_log_latest_write	1675386451298063	≫ performance_schema.error_log 테이블에 마지막으로 기록한 시간
Flush_commands	3
Handler_commit	2369
Handler_delete	0
Handler_discover	0
Handler_external_lock	15409
Handler_mrr_init	0
Handler_prepare	0
Handler_read_first	114
Handler_read_key	11478
Handler_read_last	0
Handler_read_next	17529
Handler_read_prev	0
Handler_read_rnd	3991
Handler_read_rnd_next	9840
Handler_rollback	0
Handler_savepoint	0
Handler_savepoint_rollback	0
Handler_update	318
Handler_write	6208
Innodb_buffer_pool_dump_status	Dumping of buffer pool not started
Innodb_buffer_pool_load_status	Buffer pool(s) load completed at 230203 10:07:31
Innodb_buffer_pool_resize_status	""
Innodb_buffer_pool_pages_data	2267
Innodb_buffer_pool_bytes_data	37142528
Innodb_buffer_pool_pages_dirty	0
Innodb_buffer_pool_bytes_dirty	0
Innodb_buffer_pool_pages_flushed	217
Innodb_buffer_pool_pages_free	259829
Innodb_buffer_pool_pages_misc	48
Innodb_buffer_pool_pages_total	262144
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	63821
Innodb_buffer_pool_reads	2123
Innodb_buffer_pool_wait_free	0
Innodb_buffer_pool_write_requests	1958
Innodb_data_fsyncs	125
Innodb_data_pending_fsyncs	0
Innodb_data_pending_reads	0
Innodb_data_pending_writes	0
Innodb_data_read	34853888
Innodb_data_reads	2149
Innodb_data_writes	372
Innodb_data_written	3638272
Innodb_dblwr_pages_written	72
Innodb_dblwr_writes	29
Innodb_log_waits	0
Innodb_log_write_requests	812
Innodb_log_writes	77
Innodb_os_log_fsyncs	59
Innodb_os_log_pending_fsyncs	0
Innodb_os_log_pending_writes	0
Innodb_os_log_written	64000
Innodb_page_size	16384
Innodb_pages_created	146
Innodb_pages_read	2122
Innodb_pages_written	217
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	0
Innodb_system_rows_inserted	38
Innodb_system_rows_read	22621
Innodb_system_rows_updated	318
Innodb_sampled_pages_read	0
Innodb_sampled_pages_skipped	0
Innodb_num_open_files	19
Innodb_truncated_status_writes	0
Innodb_undo_tablespaces_total	2
Innodb_undo_tablespaces_implicit	2
Innodb_undo_tablespaces_explicit	0
Innodb_undo_tablespaces_active	2
Key_blocks_not_flushed	0
Key_blocks_unused	6698
Key_blocks_used	0
Key_read_requests	0
Key_reads	0
Key_write_requests	0
Key_writes	0
Locked_connects	0
Max_execution_time_exceeded	0
Max_execution_time_set	0
Max_execution_time_set_failed	0
Max_used_connections	1	최대로 동시에 접속한 수
Max_used_connections_time	2023-02-03 13:58:30	최대로 동시에 접속한 시각
Mysqlx_aborted_clients	0
Mysqlx_address	::
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	UNDEFINED
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	Sep 25 01:18:46 2031 GMT
Mysqlx_ssl_server_not_before	Sep 27 01:18:46 2021 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	3
Open_streams	0
Open_table_definitions	209
Open_tables	164
Opened_files	3
Opened_table_definitions	246
Opened_tables	299
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	131
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	1030
Questions	1018
Replica_open_temp_tables	0
Rsa_public_key	"-----BEGIN PUBLIC KEY----- -----END PUBLIC KEY-----"
Secondary_engine_execution_count	0
Select_full_join	18
Select_full_range_join	0
Select_range	0
Select_range_check	0
Select_scan	84
Slave_open_temp_tables	0
Slow_launch_threads	0
Slow_queries	0
Sort_merge_passes	0
Sort_range	0
Sort_rows	4003
Sort_scan	24
Ssl_accept_renegotiates	0
Ssl_accepts	2
Ssl_callback_cache_hits	0
Ssl_cipher	TLS_AES_256_GCM_SHA384
Ssl_cipher_list	TLS_AES_256_GCM_SHA384
Ssl_client_connects	0
Ssl_connect_renegotiates	0
Ssl_ctx_verify_depth	4294967295
Ssl_ctx_verify_mode	5
Ssl_default_timeout	7200
Ssl_finished_accepts	2
Ssl_finished_connects	0
Ssl_server_not_after	Sep 25 01:18:46 2031 GMT
Ssl_server_not_before	Sep 27 01:18:46 2021 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_timeouts	0
Ssl_sessions_reused	0
Ssl_used_session_cache_entries	0
Ssl_verify_depth	4294967295
Ssl_verify_mode	5
Ssl_version	TLSv1.3
Table_locks_immediate	4	즉식 획득한 테이블 락 횟수
Table_locks_waited	0	테이블 락을 즉시 획득하지 못하고 대기한 횟수
Table_open_cache_hits	7686
Table_open_cache_misses	299
Table_open_cache_overflows	54
Tc_log_max_pages_used	0
Tc_log_page_size	0
Tc_log_page_waits	0
Threads_cached	0	Thread Cache의 Thread 수
Threads_connected	1	현재 연결된 Thread 수
Threads_created	1	접속을 위해 생성된 Thread 수
Threads_running	2	Sleeping 되어 있지 않은 Thread 수
Uptime	13895	MySQL이 가동중인 시간
Uptime_since_flush_status	13895