[MYSQL]Mysql 数据库 show global status 的所有项目

 

Aborted_clients   5
Aborted_connects   0
Binlog_cache_disk_use   0
Binlog_cache_use   0
Binlog_stmt_cache_disk_use   0
Binlog_stmt_cache_use   0
Bytes_received   9835
Bytes_sent   275095
Com_admin_commands   0
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   0
Com_alter_tablespace   0
Com_analyze   0
Com_begin   0
Com_binlog   0
Com_call_procedure   0
Com_change_db   0
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   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_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_grant   0
Com_ha_close   0
Com_ha_open   0
Com_ha_read   0
Com_help   0
Com_insert   0
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_repair   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   68
Com_set_option   68
Com_signal   0
Com_show_authors   0
Com_show_binlog_events   0
Com_show_binlogs   0
Com_show_charsets   0
Com_show_collations   0
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   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_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_status   0
Com_show_processlist   0
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   100
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_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   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
Compression   OFF
Connections   18
Created_tmp_disk_tables   0
Created_tmp_files   5
Created_tmp_tables   100
Delayed_errors   0
Delayed_insert_threads   0
Delayed_writes   0
Flush_commands   1
Handler_commit   0
Handler_delete   0
Handler_discover   0
Handler_prepare   0
Handler_read_first   3
Handler_read_key   0
Handler_read_last   0
Handler_read_next   0
Handler_read_prev   0
Handler_read_rnd   0
Handler_read_rnd_next   9892
Handler_rollback   0
Handler_savepoint   0
Handler_savepoint_rollback   0
Handler_update   0
Handler_write   9780
Innodb_buffer_pool_pages_data   149
Innodb_buffer_pool_pages_dirty   0
Innodb_buffer_pool_pages_flushed   0
Innodb_buffer_pool_pages_free   6379
Innodb_buffer_pool_pages_misc   0
Innodb_buffer_pool_pages_total   6528
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   482
Innodb_buffer_pool_reads   150
Innodb_buffer_pool_wait_free   0
Innodb_buffer_pool_write_requests   0
Innodb_data_fsyncs   3
Innodb_data_pending_fsyncs   0
Innodb_data_pending_reads   0
Innodb_data_pending_writes   0
Innodb_data_read   4640768
Innodb_data_reads   160
Innodb_data_writes   3
Innodb_data_written   1536
Innodb_dblwr_pages_written   0
Innodb_dblwr_writes   0
Innodb_have_atomic_builtins   ON
Innodb_log_waits   0
Innodb_log_write_requests   0
Innodb_log_writes   1
Innodb_os_log_fsyncs   3
Innodb_os_log_pending_fsyncs   0
Innodb_os_log_pending_writes   0
Innodb_os_log_written   512
Innodb_page_size   16384
Innodb_pages_created   0
Innodb_pages_read   149
Innodb_pages_written   0
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_truncated_status_writes   0
Key_blocks_not_flushed   0
Key_blocks_unused   44216
Key_blocks_used   0
Key_read_requests   0
Key_reads   0
Key_write_requests   0
Key_writes   0
Last_query_cost   0.000000
Max_used_connections   1
Not_flushed_delayed_rows   0
Open_files   0
Open_streams   0
Open_table_definitions   33
Open_tables   0
Opened_files   77
Opened_table_definitions   33
Opened_tables   33
Performance_schema_cond_classes_lost   0
Performance_schema_cond_instances_lost   0
Performance_schema_file_classes_lost   0
Performance_schema_file_handles_lost   0
Performance_schema_file_instances_lost   0
Performance_schema_locker_lost   0
Performance_schema_mutex_classes_lost   0
Performance_schema_mutex_instances_lost   0
Performance_schema_rwlock_classes_lost   0
Performance_schema_rwlock_instances_lost   0
Performance_schema_table_handles_lost   0
Performance_schema_table_instances_lost   0
Performance_schema_thread_classes_lost   0
Performance_schema_thread_instances_lost   0
Prepared_stmt_count   0
Qcache_free_blocks   0
Qcache_free_memory   0
Qcache_hits   0
Qcache_inserts   0
Qcache_lowmem_prunes   0
Qcache_not_cached   0
Qcache_queries_in_cache   0
Qcache_total_blocks   0
Queries   247
Questions   247
Rpl_status   AUTH_MASTER
Select_full_join   0
Select_full_range_join   0
Select_range   0
Select_range_check   0
Select_scan   100
Slave_heartbeat_period   0.000
Slave_open_temp_tables   0
Slave_received_heartbeats   0
Slave_retried_transactions   0
Slave_running   OFF
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   0
Ssl_ctx_verify_mode   0
Ssl_default_timeout   0
Ssl_finished_accepts   0
Ssl_finished_connects   0
Ssl_session_cache_hits   0
Ssl_session_cache_misses   0
Ssl_session_cache_mode   NONE
Ssl_session_cache_overflows   0
Ssl_session_cache_size   0
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   36
Table_locks_waited   0
Tc_log_max_pages_used   0
Tc_log_page_size   0
Tc_log_page_waits   0
Threads_cached   0
Threads_connected   1
Threads_created   1
Threads_running   1
Uptime   26939
Uptime_since_flush_status   26939

 

总格310个项目。

 

=============================================================

可以定义一个数组：

 

#ifndef __MYSQL_GLOBAL_STATUS__
#define __MYSQL_GLOBAL_STATUS__

typedef struct mysql_globalstatus {
 int index;
 char *pGlobalStat;
} Mysql_Gstat;

Mysql_Gstat Gstatus[] =
{
 {0, "Aborted_clients"},
 {1, "Aborted_connects"},
 {2, "Binlog_cache_disk_use"},
 {3, "Binlog_cache_use"},
 {4, "Binlog_stmt_cache_disk_use"},
 {5, "Binlog_stmt_cache_use"},
 {6, "Bytes_received"},
 {7, "Bytes_sent"},
 {8, "Com_admin_commands"},
 {9, "Com_assign_to_keycache"},
 {10, "Com_alter_db"},
 {11, "Com_alter_db_upgrade"},
 {12, "Com_alter_event"},
 {13, "Com_alter_function"},
 {14, "Com_alter_procedure"},
 {15, "Com_alter_server"},
 {16, "Com_alter_table"},
 {17, "Com_alter_tablespace"},
 {18, "Com_analyze"},
 {19, "Com_begin"},
 {20, "Com_binlog"},
 {21, "Com_call_procedure"},
 {22, "Com_change_db"},
 {23, "Com_change_master"},
 {24, "Com_check"},
 {25, "Com_checksum"},
 {26, "Com_commit"},
 {27, "Com_create_db"},
 {28, "Com_create_event"},
 {29, "Com_create_function"},
 {30, "Com_create_index"},
 {31, "Com_create_procedure"},
 {32, "Com_create_server"},
 {33, "Com_create_table"},
 {34, "Com_create_trigger"},
 {35, "Com_create_udf"},
 {36, "Com_create_user"},
 {37, "Com_create_view"},
 {38, "Com_dealloc_sql"},
 {39, "Com_delete"},
 {40, "Com_delete_multi"},
 {41, "Com_do"},
 {42, "Com_drop_db"},
 {43, "Com_drop_event"},
 {44, "Com_drop_function"},
 {45, "Com_drop_index"},
 {46, "Com_drop_procedure"},
 {47, "Com_drop_server"},
 {48, "Com_drop_table"},
 {49, "Com_drop_trigger"},
 {50, "Com_drop_user"},
 {51, "Com_drop_view"},
 {52, "Com_empty_query"},
 {53, "Com_execute_sql"},
 {54, "Com_flush"},
 {55, "Com_grant"},
 {56, "Com_ha_close"},
 {57, "Com_ha_open"},
 {58, "Com_ha_read"},
 {59, "Com_help"},
 {60, "Com_insert"},
 {61, "Com_insert_select"},
 {62, "Com_install_plugin"},
 {63, "Com_kill"},
 {64, "Com_load"},
 {65, "Com_lock_tables"},
 {66, "Com_optimize"},
 {67, "Com_preload_keys"},
 {68, "Com_prepare_sql"},
 {69, "Com_purge"},
 {70, "Com_purge_before_date"},
 {71, "Com_release_savepoint"},
 {72, "Com_rename_table"},
 {73, "Com_rename_user"},
 {74, "Com_repair"},
 {75, "Com_replace"},
 {76, "Com_replace_select"},
 {77, "Com_reset"},
 {78, "Com_resignal"},
 {79, "Com_revoke"},
 {80, "Com_revoke_all"},
 {81, "Com_rollback"},
 {82, "Com_rollback_to_savepoint"},
 {83, "Com_savepoint"},
 {84, "Com_select"},
 {85, "Com_set_option"},
 {86, "Com_signal"},
 {87, "Com_show_authors"},
 {88, "Com_show_binlog_events"},
 {89, "Com_show_binlogs"},
 {90, "Com_show_charsets"},
 {91, "Com_show_collations"},
 {92, "Com_show_contributors"},
 {93, "Com_show_create_db"},
 {94, "Com_show_create_event"},
 {95, "Com_show_create_func"},
 {96, "Com_show_create_proc"},
 {97, "Com_show_create_table"},
 {98, "Com_show_create_trigger"},
 {99, "Com_show_databases"},
 {100, "Com_show_engine_logs"},
 {101, "Com_show_engine_mutex"},
 {102, "Com_show_engine_status"},
 {103, "Com_show_events"},
 {104, "Com_show_errors"},
 {105, "Com_show_fields"},
 {106, "Com_show_function_status"},
 {107, "Com_show_grants"},
 {108, "Com_show_keys"},
 {109, "Com_show_master_status"},
 {110, "Com_show_open_tables"},
 {111, "Com_show_plugins"},
 {112, "Com_show_privileges"},
 {113, "Com_show_procedure_status"},
 {114, "Com_show_processlist"},
 {115, "Com_show_profile"},
 {116, "Com_show_profiles"},
 {117, "Com_show_relaylog_events"},
 {118, "Com_show_slave_hosts"},
 {119, "Com_show_slave_status"},
 {120, "Com_show_status"},
 {121, "Com_show_storage_engines"},
 {122, "Com_show_table_status"},
 {123, "Com_show_tables"},
 {124, "Com_show_triggers"},
 {125, "Com_show_variables"},
 {126, "Com_show_warnings"},
 {127, "Com_slave_start"},
 {128, "Com_slave_stop"},
 {129, "Com_stmt_close"},
 {130, "Com_stmt_execute"},
 {131, "Com_stmt_fetch"},
 {132, "Com_stmt_prepare"},
 {133, "Com_stmt_reprepare"},
 {134, "Com_stmt_reset"},
 {135, "Com_stmt_send_long_data"},
 {136, "Com_truncate"},
 {137, "Com_uninstall_plugin"},
 {138, "Com_unlock_tables"},
 {139, "Com_update"},
 {140, "Com_update_multi"},
 {141, "Com_xa_commit"},
 {142, "Com_xa_end"},
 {143, "Com_xa_prepare"},
 {144, "Com_xa_recover"},
 {145, "Com_xa_rollback"},
 {146, "Com_xa_start"},
 {147, "Compression"},
 {148, "Connections"},
 {149, "Created_tmp_disk_tables"},
 {150, "Created_tmp_files"},
 {151, "Created_tmp_tables"},
 {152, "Delayed_errors"},
 {153, "Delayed_insert_threads"},
 {154, "Delayed_writes"},
 {155, "Flush_commands"},
 {156, "Handler_commit"},
 {157, "Handler_delete"},
 {158, "Handler_discover"},
 {159, "Handler_prepare"},
 {160, "Handler_read_first"},
 {161, "Handler_read_key"},
 {162, "Handler_read_last"},
 {163, "Handler_read_next"},
 {164, "Handler_read_prev"},
 {165, "Handler_read_rnd"},
 {166, "Handler_read_rnd_next"},
 {167, "Handler_rollback"},
 {168, "Handler_savepoint"},
 {169, "Handler_savepoint_rollback"},
 {170, "Handler_update"},
 {171, "Handler_write"},
 {172, "Innodb_buffer_pool_pages_data"},
 {173, "Innodb_buffer_pool_pages_dirty"},
 {174, "Innodb_buffer_pool_pages_flushed"},
 {175, "Innodb_buffer_pool_pages_free"},
 {176, "Innodb_buffer_pool_pages_misc"},
 {177, "Innodb_buffer_pool_pages_total"},
 {178, "Innodb_buffer_pool_read_ahead_rnd"},
 {179, "Innodb_buffer_pool_read_ahead"},
 {180, "Innodb_buffer_pool_read_ahead_evicted"},
 {181, "Innodb_buffer_pool_read_requests"},
 {182, "Innodb_buffer_pool_reads"},
 {183, "Innodb_buffer_pool_wait_free"},
 {184, "Innodb_buffer_pool_write_requests"},
 {185, "Innodb_data_fsyncs"},
 {186, "Innodb_data_pending_fsyncs"},
 {187, "Innodb_data_pending_reads"},
 {188, "Innodb_data_pending_writes"},
 {189, "Innodb_data_read"},
 {190, "Innodb_data_reads"},
 {191, "Innodb_data_writes"},
 {192, "Innodb_data_written"},
 {193, "Innodb_dblwr_pages_written"},
 {194, "Innodb_dblwr_writes"},
 {195, "Innodb_have_atomic_builtins"},
 {196, "Innodb_log_waits"},
 {197, "Innodb_log_write_requests"},
 {198, "Innodb_log_writes"},
 {199, "Innodb_os_log_fsyncs"},
 {200, "Innodb_os_log_pending_fsyncs"},
 {201, "Innodb_os_log_pending_writes"},
 {202, "Innodb_os_log_written"},
 {203, "Innodb_page_size"},
 {204, "Innodb_pages_created"},
 {205, "Innodb_pages_read"},
 {206, "Innodb_pages_written"},
 {207, "Innodb_row_lock_current_waits"},
 {208, "Innodb_row_lock_time"},
 {209, "Innodb_row_lock_time_avg"},
 {210, "Innodb_row_lock_time_max"},
 {211, "Innodb_row_lock_waits"},
 {212, "Innodb_rows_deleted"},
 {213, "Innodb_rows_inserted"},
 {214, "Innodb_rows_read"},
 {215, "Innodb_rows_updated"},
 {216, "Innodb_truncated_status_writes"},
 {217, "Key_blocks_not_flushed"},
 {218, "Key_blocks_unused"},
 {219, "Key_blocks_used"},
 {220, "Key_read_requests"},
 {221, "Key_reads"},
 {222, "Key_write_requests"},
 {223, "Key_writes"},
 {224, "Last_query_cost"},
 {225, "Max_used_connections"},
 {226, "Not_flushed_delayed_rows"},
 {227, "Open_files"},
 {228, "Open_streams"},
 {229, "Open_table_definitions"},
 {230, "Open_tables"},
 {231, "Opened_files"},
 {232, "Opened_table_definitions"},
 {233, "Opened_tables"},
 {234, "Performance_schema_cond_classes_lost"},
 {235, "Performance_schema_cond_instances_lost"},
 {236, "Performance_schema_file_classes_lost"},
 {237, "Performance_schema_file_handles_lost"},
 {238, "Performance_schema_file_instances_lost"},
 {239, "Performance_schema_locker_lost"},
 {240, "Performance_schema_mutex_classes_lost"},
 {241, "Performance_schema_mutex_instances_lost"},
 {242, "Performance_schema_rwlock_classes_lost"},
 {243, "Performance_schema_rwlock_instances_lost"},
 {244, "Performance_schema_table_handles_lost"},
 {245, "Performance_schema_table_instances_lost"},
 {246, "Performance_schema_thread_classes_lost"},
 {247, "Performance_schema_thread_instances_lost"},
 {248, "Prepared_stmt_count"},
 {249, "Qcache_free_blocks"},
 {250, "Qcache_free_memory"},
 {251, "Qcache_hits"},
 {252, "Qcache_inserts"},
 {253, "Qcache_lowmem_prunes"},
 {254, "Qcache_not_cached"},
 {255, "Qcache_queries_in_cache"},
 {256, "Qcache_total_blocks"},
 {257, "Queries"},
 {258, "Questions"},
 {259, "Rpl_status"},
 {260, "Select_full_join"},
 {261, "Select_full_range_join"},
 {262, "Select_range"},
 {263, "Select_range_check"},
 {264, "Select_scan"},
 {265, "Slave_heartbeat_period"},
 {266, "Slave_open_temp_tables"},
 {267, "Slave_received_heartbeats"},
 {268, "Slave_retried_transactions"},
 {269, "Slave_running"},
 {270, "Slow_launch_threads"},
 {271, "Slow_queries"},
 {272, "Sort_merge_passes"},
 {273, "Sort_range"},
 {274, "Sort_rows"},
 {275, "Sort_scan"},
 {276, "Ssl_accept_renegotiates"},
 {277, "Ssl_accepts"},
 {278, "Ssl_callback_cache_hits"},
 {279, "Ssl_cipher"},
 {280, "Ssl_cipher_list"},
 {281, "Ssl_client_connects"},
 {282, "Ssl_connect_renegotiates"},
 {283, "Ssl_ctx_verify_depth"},
 {284, "Ssl_ctx_verify_mode"},
 {285, "Ssl_default_timeout"},
 {286, "Ssl_finished_accepts"},
 {287, "Ssl_finished_connects"},
 {288, "Ssl_session_cache_hits"},
 {289, "Ssl_session_cache_misses"},
 {290, "Ssl_session_cache_mode"},
 {291, "Ssl_session_cache_overflows"},
 {292, "Ssl_session_cache_size"},
 {293, "Ssl_session_cache_timeouts"},
 {294, "Ssl_sessions_reused"},
 {295, "Ssl_used_session_cache_entries"},
 {296, "Ssl_verify_depth"},
 {297, "Ssl_verify_mode"},
 {298, "Ssl_version"},
 {299, "Table_locks_immediate"},
 {300, "Table_locks_waited"},
 {301, "Tc_log_max_pages_used"},
 {302, "Tc_log_page_size"},
 {303, "Tc_log_page_waits"},
 {304, "Threads_cached"},
 {305, "Threads_connected"},
 {306, "Threads_created"},
 {307, "Threads_running"},
 {308, "Uptime"},
 {309, "Uptime_since_flush_status"}
};

#endif// __MYSQL_GLOBAL_STATUS__