结合zabbix统计数据库状态的内容

1. mysqladmin status  :获得数据库的基本信息

2. mysqladmin extended-status | less:获取数据库的扩展信息,| less,表示分页显示,不是一下子全部显示

3.vim zabbix_mysql_status.sh

#!/bin/bash 
#mysql for zabbix 
 
Uptime(){ 
        mysqladmin status|awk '{print $2}'    #使用mysqladmin status获取数据库基本信息,用awk打印以空格分割的第二列的内容
} 

Com_delete(){ #获取增删改查中的删除的值
      mysqladmin extended-status| awk '/<Com_delete>/{print $4}' #使用mysqladmin extended-status获取数据库扩展状态信息,用awk搜索单词Com_delete一行,然后打印该行以空格分

                                           #割后第四列的值,其中<限定词首,>限定词尾,用<>限定一个单词

}

$1 #根据传入的参数,调用函数

:wq!  :保存

4.chmod +x zabbix_mysql_status.sh  :赋可执行权限

5.调用: ./zabbix_mysql_status.sh  Uptime

mysqladmin status 和 mysqladmin extended-status 全部数据获取:

Uptime(){
    mysqladmin status|awk '{print $2}'
}

Threads(){ 
        mysqladmin status|awk '{print $4}'   
} 
    

Questions(){ 
        mysqladmin status|awk '{print $6}'   
} 
    

Slow_queries(){ 
        mysqladmin status|awk '{print $9}'   
} 
    

Opens(){ 
        mysqladmin status|awk '{print $11}'   
} 
    

Flush_tables(){ 
        mysqladmin status|awk '{print $14}'   
} 
    

Open_tables(){ 
        mysqladmin status|awk '{print $17}'   
} 
    

Queries_per_second_avg(){ 
        mysqladmin status|awk '{print $22}'   
} 

Com_delete(){
    mysqladmin extended-status| awk '/<Com_delete>/{print $4}' 
}

Aborted_clients(){
mysqladmin extended-status| awk '/<Aborted_clients>/{print $4}'
}


Aborted_connects(){
mysqladmin extended-status| awk '/<Aborted_connects>/{print $4}'
}


Access_denied_errors(){
mysqladmin extended-status| awk '/<Access_denied_errors>/{print $4}'
}


Acl_column_grants(){
mysqladmin extended-status| awk '/<Acl_column_grants>/{print $4}'
}


Acl_database_grants(){
mysqladmin extended-status| awk '/<Acl_database_grants>/{print $4}'
}


Acl_function_grants(){
mysqladmin extended-status| awk '/<Acl_function_grants>/{print $4}'
}


Acl_procedure_grants(){
mysqladmin extended-status| awk '/<Acl_procedure_grants>/{print $4}'
}


Acl_proxy_users(){
mysqladmin extended-status| awk '/<Acl_proxy_users>/{print $4}'
}


Acl_role_grants(){
mysqladmin extended-status| awk '/<Acl_role_grants>/{print $4}'
}


Acl_roles(){
mysqladmin extended-status| awk '/<Acl_roles>/{print $4}'
}


Acl_table_grants(){
mysqladmin extended-status| awk '/<Acl_table_grants>/{print $4}'
}


Acl_users(){
mysqladmin extended-status| awk '/<Acl_users>/{print $4}'
}


Aria_pagecache_blocks_not_flushed(){
mysqladmin extended-status| awk '/<Aria_pagecache_blocks_not_flushed>/{print $4}'
}


Aria_pagecache_blocks_unused(){
mysqladmin extended-status| awk '/<Aria_pagecache_blocks_unused>/{print $4}'
}


Aria_pagecache_blocks_used(){
mysqladmin extended-status| awk '/<Aria_pagecache_blocks_used>/{print $4}'
}


Aria_pagecache_read_requests(){
mysqladmin extended-status| awk '/<Aria_pagecache_read_requests>/{print $4}'
}


Aria_pagecache_reads(){
mysqladmin extended-status| awk '/<Aria_pagecache_reads>/{print $4}'
}


Aria_pagecache_write_requests(){
mysqladmin extended-status| awk '/<Aria_pagecache_write_requests>/{print $4}'
}


Aria_pagecache_writes(){
mysqladmin extended-status| awk '/<Aria_pagecache_writes>/{print $4}'
}


Aria_transaction_log_syncs(){
mysqladmin extended-status| awk '/<Aria_transaction_log_syncs>/{print $4}'
}


Binlog_commits(){
mysqladmin extended-status| awk '/<Binlog_commits>/{print $4}'
}


Binlog_group_commits(){
mysqladmin extended-status| awk '/<Binlog_group_commits>/{print $4}'
}


Binlog_group_commit_trigger_count(){
mysqladmin extended-status| awk '/<Binlog_group_commit_trigger_count>/{print $4}'
}


Binlog_group_commit_trigger_lock_wait(){
mysqladmin extended-status| awk '/<Binlog_group_commit_trigger_lock_wait>/{print $4}'
}


Binlog_group_commit_trigger_timeout(){
mysqladmin extended-status| awk '/<Binlog_group_commit_trigger_timeout>/{print $4}'
}


Binlog_snapshot_file(){
mysqladmin extended-status| awk '/<Binlog_snapshot_file>/{print $4}'
}


Binlog_snapshot_position(){
mysqladmin extended-status| awk '/<Binlog_snapshot_position>/{print $4}'
}


Binlog_bytes_written(){
mysqladmin extended-status| awk '/<Binlog_bytes_written>/{print $4}'
}


Binlog_cache_disk_use(){
mysqladmin extended-status| awk '/<Binlog_cache_disk_use>/{print $4}'
}


Binlog_cache_use(){
mysqladmin extended-status| awk '/<Binlog_cache_use>/{print $4}'
}


Binlog_stmt_cache_disk_use(){
mysqladmin extended-status| awk '/<Binlog_stmt_cache_disk_use>/{print $4}'
}


Binlog_stmt_cache_use(){
mysqladmin extended-status| awk '/<Binlog_stmt_cache_use>/{print $4}'
}


Busy_time(){
mysqladmin extended-status| awk '/<Busy_time>/{print $4}'
}


Bytes_received(){
mysqladmin extended-status| awk '/<Bytes_received>/{print $4}'
}


Bytes_sent(){
mysqladmin extended-status| awk '/<Bytes_sent>/{print $4}'
}


Com_admin_commands(){
mysqladmin extended-status| awk '/<Com_admin_commands>/{print $4}'
}


Com_alter_db(){
mysqladmin extended-status| awk '/<Com_alter_db>/{print $4}'
}


Com_alter_db_upgrade(){
mysqladmin extended-status| awk '/<Com_alter_db_upgrade>/{print $4}'
}


Com_alter_event(){
mysqladmin extended-status| awk '/<Com_alter_event>/{print $4}'
}


Com_alter_function(){
mysqladmin extended-status| awk '/<Com_alter_function>/{print $4}'
}


Com_alter_procedure(){
mysqladmin extended-status| awk '/<Com_alter_procedure>/{print $4}'
}


Com_alter_server(){
mysqladmin extended-status| awk '/<Com_alter_server>/{print $4}'
}


Com_alter_table(){
mysqladmin extended-status| awk '/<Com_alter_table>/{print $4}'
}


Com_alter_tablespace(){
mysqladmin extended-status| awk '/<Com_alter_tablespace>/{print $4}'
}


Com_analyze(){
mysqladmin extended-status| awk '/<Com_analyze>/{print $4}'
}


Com_assign_to_keycache(){
mysqladmin extended-status| awk '/<Com_assign_to_keycache>/{print $4}'
}


Com_begin(){
mysqladmin extended-status| awk '/<Com_begin>/{print $4}'
}


Com_binlog(){
mysqladmin extended-status| awk '/<Com_binlog>/{print $4}'
}


Com_call_procedure(){
mysqladmin extended-status| awk '/<Com_call_procedure>/{print $4}'
}


Com_change_db(){
mysqladmin extended-status| awk '/<Com_change_db>/{print $4}'
}


Com_change_master(){
mysqladmin extended-status| awk '/<Com_change_master>/{print $4}'
}


Com_check(){
mysqladmin extended-status| awk '/<Com_check>/{print $4}'
}


Com_checksum(){
mysqladmin extended-status| awk '/<Com_checksum>/{print $4}'
}


Com_commit(){
mysqladmin extended-status| awk '/<Com_commit>/{print $4}'
}


Com_compound_sql(){
mysqladmin extended-status| awk '/<Com_compound_sql>/{print $4}'
}


Com_create_db(){
mysqladmin extended-status| awk '/<Com_create_db>/{print $4}'
}


Com_create_event(){
mysqladmin extended-status| awk '/<Com_create_event>/{print $4}'
}


Com_create_function(){
mysqladmin extended-status| awk '/<Com_create_function>/{print $4}'
}


Com_create_index(){
mysqladmin extended-status| awk '/<Com_create_index>/{print $4}'
}


Com_create_procedure(){
mysqladmin extended-status| awk '/<Com_create_procedure>/{print $4}'
}


Com_create_role(){
mysqladmin extended-status| awk '/<Com_create_role>/{print $4}'
}


Com_create_server(){
mysqladmin extended-status| awk '/<Com_create_server>/{print $4}'
}


Com_create_table(){
mysqladmin extended-status| awk '/<Com_create_table>/{print $4}'
}


Com_create_temporary_table(){
mysqladmin extended-status| awk '/<Com_create_temporary_table>/{print $4}'
}


Com_create_trigger(){
mysqladmin extended-status| awk '/<Com_create_trigger>/{print $4}'
}


Com_create_udf(){
mysqladmin extended-status| awk '/<Com_create_udf>/{print $4}'
}


Com_create_user(){
mysqladmin extended-status| awk '/<Com_create_user>/{print $4}'
}


Com_create_view(){
mysqladmin extended-status| awk '/<Com_create_view>/{print $4}'
}


Com_dealloc_sql(){
mysqladmin extended-status| awk '/<Com_dealloc_sql>/{print $4}'
}


Com_delete(){
mysqladmin extended-status| awk '/<Com_delete>/{print $4}'
}


Com_delete_multi(){
mysqladmin extended-status| awk '/<Com_delete_multi>/{print $4}'
}


Com_do(){
mysqladmin extended-status| awk '/<Com_do>/{print $4}'
}


Com_drop_db(){
mysqladmin extended-status| awk '/<Com_drop_db>/{print $4}'
}


Com_drop_event(){
mysqladmin extended-status| awk '/<Com_drop_event>/{print $4}'
}


Com_drop_function(){
mysqladmin extended-status| awk '/<Com_drop_function>/{print $4}'
}


Com_drop_index(){
mysqladmin extended-status| awk '/<Com_drop_index>/{print $4}'
}


Com_drop_procedure(){
mysqladmin extended-status| awk '/<Com_drop_procedure>/{print $4}'
}


Com_drop_role(){
mysqladmin extended-status| awk '/<Com_drop_role>/{print $4}'
}


Com_drop_server(){
mysqladmin extended-status| awk '/<Com_drop_server>/{print $4}'
}


Com_drop_table(){
mysqladmin extended-status| awk '/<Com_drop_table>/{print $4}'
}


Com_drop_temporary_table(){
mysqladmin extended-status| awk '/<Com_drop_temporary_table>/{print $4}'
}


Com_drop_trigger(){
mysqladmin extended-status| awk '/<Com_drop_trigger>/{print $4}'
}


Com_drop_user(){
mysqladmin extended-status| awk '/<Com_drop_user>/{print $4}'
}


Com_drop_view(){
mysqladmin extended-status| awk '/<Com_drop_view>/{print $4}'
}


Com_empty_query(){
mysqladmin extended-status| awk '/<Com_empty_query>/{print $4}'
}


Com_execute_sql(){
mysqladmin extended-status| awk '/<Com_execute_sql>/{print $4}'
}


Com_flush(){
mysqladmin extended-status| awk '/<Com_flush>/{print $4}'
}


Com_get_diagnostics(){
mysqladmin extended-status| awk '/<Com_get_diagnostics>/{print $4}'
}


Com_grant(){
mysqladmin extended-status| awk '/<Com_grant>/{print $4}'
}


Com_grant_role(){
mysqladmin extended-status| awk '/<Com_grant_role>/{print $4}'
}


Com_ha_close(){
mysqladmin extended-status| awk '/<Com_ha_close>/{print $4}'
}


Com_ha_open(){
mysqladmin extended-status| awk '/<Com_ha_open>/{print $4}'
}


Com_ha_read(){
mysqladmin extended-status| awk '/<Com_ha_read>/{print $4}'
}


Com_help(){
mysqladmin extended-status| awk '/<Com_help>/{print $4}'
}


Com_insert(){
mysqladmin extended-status| awk '/<Com_insert>/{print $4}'
}


Com_insert_select(){
mysqladmin extended-status| awk '/<Com_insert_select>/{print $4}'
}


Com_install_plugin(){
mysqladmin extended-status| awk '/<Com_install_plugin>/{print $4}'
}


Com_kill(){
mysqladmin extended-status| awk '/<Com_kill>/{print $4}'
}


Com_load(){
mysqladmin extended-status| awk '/<Com_load>/{print $4}'
}


Com_lock_tables(){
mysqladmin extended-status| awk '/<Com_lock_tables>/{print $4}'
}


Com_optimize(){
mysqladmin extended-status| awk '/<Com_optimize>/{print $4}'
}


Com_preload_keys(){
mysqladmin extended-status| awk '/<Com_preload_keys>/{print $4}'
}


Com_prepare_sql(){
mysqladmin extended-status| awk '/<Com_prepare_sql>/{print $4}'
}


Com_purge(){
mysqladmin extended-status| awk '/<Com_purge>/{print $4}'
}


Com_purge_before_date(){
mysqladmin extended-status| awk '/<Com_purge_before_date>/{print $4}'
}


Com_release_savepoint(){
mysqladmin extended-status| awk '/<Com_release_savepoint>/{print $4}'
}


Com_rename_table(){
mysqladmin extended-status| awk '/<Com_rename_table>/{print $4}'
}


Com_rename_user(){
mysqladmin extended-status| awk '/<Com_rename_user>/{print $4}'
}


Com_repair(){
mysqladmin extended-status| awk '/<Com_repair>/{print $4}'
}


Com_replace(){
mysqladmin extended-status| awk '/<Com_replace>/{print $4}'
}


Com_replace_select(){
mysqladmin extended-status| awk '/<Com_replace_select>/{print $4}'
}


Com_reset(){
mysqladmin extended-status| awk '/<Com_reset>/{print $4}'
}


Com_resignal(){
mysqladmin extended-status| awk '/<Com_resignal>/{print $4}'
}


Com_revoke(){
mysqladmin extended-status| awk '/<Com_revoke>/{print $4}'
}


Com_revoke_all(){
mysqladmin extended-status| awk '/<Com_revoke_all>/{print $4}'
}


Com_revoke_role(){
mysqladmin extended-status| awk '/<Com_revoke_role>/{print $4}'
}


Com_rollback(){
mysqladmin extended-status| awk '/<Com_rollback>/{print $4}'
}


Com_rollback_to_savepoint(){
mysqladmin extended-status| awk '/<Com_rollback_to_savepoint>/{print $4}'
}


Com_savepoint(){
mysqladmin extended-status| awk '/<Com_savepoint>/{print $4}'
}


Com_select(){
mysqladmin extended-status| awk '/<Com_select>/{print $4}'
}


Com_set_option(){
mysqladmin extended-status| awk '/<Com_set_option>/{print $4}'
}


Com_show_authors(){
mysqladmin extended-status| awk '/<Com_show_authors>/{print $4}'
}


Com_show_binlog_events(){
mysqladmin extended-status| awk '/<Com_show_binlog_events>/{print $4}'
}


Com_show_binlogs(){
mysqladmin extended-status| awk '/<Com_show_binlogs>/{print $4}'
}


Com_show_charsets(){
mysqladmin extended-status| awk '/<Com_show_charsets>/{print $4}'
}


Com_show_collations(){
mysqladmin extended-status| awk '/<Com_show_collations>/{print $4}'
}


Com_show_contributors(){
mysqladmin extended-status| awk '/<Com_show_contributors>/{print $4}'
}


Com_show_create_db(){
mysqladmin extended-status| awk '/<Com_show_create_db>/{print $4}'
}


Com_show_create_event(){
mysqladmin extended-status| awk '/<Com_show_create_event>/{print $4}'
}


Com_show_create_func(){
mysqladmin extended-status| awk '/<Com_show_create_func>/{print $4}'
}


Com_show_create_proc(){
mysqladmin extended-status| awk '/<Com_show_create_proc>/{print $4}'
}


Com_show_create_table(){
mysqladmin extended-status| awk '/<Com_show_create_table>/{print $4}'
}


Com_show_create_trigger(){
mysqladmin extended-status| awk '/<Com_show_create_trigger>/{print $4}'
}


Com_show_databases(){
mysqladmin extended-status| awk '/<Com_show_databases>/{print $4}'
}


Com_show_engine_logs(){
mysqladmin extended-status| awk '/<Com_show_engine_logs>/{print $4}'
}


Com_show_engine_mutex(){
mysqladmin extended-status| awk '/<Com_show_engine_mutex>/{print $4}'
}


Com_show_engine_status(){
mysqladmin extended-status| awk '/<Com_show_engine_status>/{print $4}'
}


Com_show_errors(){
mysqladmin extended-status| awk '/<Com_show_errors>/{print $4}'
}


Com_show_events(){
mysqladmin extended-status| awk '/<Com_show_events>/{print $4}'
}


Com_show_explain(){
mysqladmin extended-status| awk '/<Com_show_explain>/{print $4}'
}


Com_show_fields(){
mysqladmin extended-status| awk '/<Com_show_fields>/{print $4}'
}


Com_show_function_status(){
mysqladmin extended-status| awk '/<Com_show_function_status>/{print $4}'
}


Com_show_generic(){
mysqladmin extended-status| awk '/<Com_show_generic>/{print $4}'
}


Com_show_grants(){
mysqladmin extended-status| awk '/<Com_show_grants>/{print $4}'
}


Com_show_keys(){
mysqladmin extended-status| awk '/<Com_show_keys>/{print $4}'
}


Com_show_master_status(){
mysqladmin extended-status| awk '/<Com_show_master_status>/{print $4}'
}


Com_show_open_tables(){
mysqladmin extended-status| awk '/<Com_show_open_tables>/{print $4}'
}


Com_show_plugins(){
mysqladmin extended-status| awk '/<Com_show_plugins>/{print $4}'
}


Com_show_privileges(){
mysqladmin extended-status| awk '/<Com_show_privileges>/{print $4}'
}


Com_show_procedure_status(){
mysqladmin extended-status| awk '/<Com_show_procedure_status>/{print $4}'
}


Com_show_processlist(){
mysqladmin extended-status| awk '/<Com_show_processlist>/{print $4}'
}


Com_show_profile(){
mysqladmin extended-status| awk '/<Com_show_profile>/{print $4}'
}


Com_show_profiles(){
mysqladmin extended-status| awk '/<Com_show_profiles>/{print $4}'
}


Com_show_relaylog_events(){
mysqladmin extended-status| awk '/<Com_show_relaylog_events>/{print $4}'
}


Com_show_slave_hosts(){
mysqladmin extended-status| awk '/<Com_show_slave_hosts>/{print $4}'
}


Com_show_slave_status(){
mysqladmin extended-status| awk '/<Com_show_slave_status>/{print $4}'
}


Com_show_status(){
mysqladmin extended-status| awk '/<Com_show_status>/{print $4}'
}


Com_show_storage_engines(){
mysqladmin extended-status| awk '/<Com_show_storage_engines>/{print $4}'
}


Com_show_table_status(){
mysqladmin extended-status| awk '/<Com_show_table_status>/{print $4}'
}


Com_show_tables(){
mysqladmin extended-status| awk '/<Com_show_tables>/{print $4}'
}


Com_show_triggers(){
mysqladmin extended-status| awk '/<Com_show_triggers>/{print $4}'
}


Com_show_variables(){
mysqladmin extended-status| awk '/<Com_show_variables>/{print $4}'
}


Com_show_warnings(){
mysqladmin extended-status| awk '/<Com_show_warnings>/{print $4}'
}


Com_shutdown(){
mysqladmin extended-status| awk '/<Com_shutdown>/{print $4}'
}


Com_signal(){
mysqladmin extended-status| awk '/<Com_signal>/{print $4}'
}


Com_start_all_slaves(){
mysqladmin extended-status| awk '/<Com_start_all_slaves>/{print $4}'
}


Com_start_slave(){
mysqladmin extended-status| awk '/<Com_start_slave>/{print $4}'
}


Com_stmt_close(){
mysqladmin extended-status| awk '/<Com_stmt_close>/{print $4}'
}


Com_stmt_execute(){
mysqladmin extended-status| awk '/<Com_stmt_execute>/{print $4}'
}


Com_stmt_fetch(){
mysqladmin extended-status| awk '/<Com_stmt_fetch>/{print $4}'
}


Com_stmt_prepare(){
mysqladmin extended-status| awk '/<Com_stmt_prepare>/{print $4}'
}


Com_stmt_reprepare(){
mysqladmin extended-status| awk '/<Com_stmt_reprepare>/{print $4}'
}


Com_stmt_reset(){
mysqladmin extended-status| awk '/<Com_stmt_reset>/{print $4}'
}


Com_stmt_send_long_data(){
mysqladmin extended-status| awk '/<Com_stmt_send_long_data>/{print $4}'
}


Com_stop_all_slaves(){
mysqladmin extended-status| awk '/<Com_stop_all_slaves>/{print $4}'
}


Com_stop_slave(){
mysqladmin extended-status| awk '/<Com_stop_slave>/{print $4}'
}


Com_truncate(){
mysqladmin extended-status| awk '/<Com_truncate>/{print $4}'
}


Com_uninstall_plugin(){
mysqladmin extended-status| awk '/<Com_uninstall_plugin>/{print $4}'
}


Com_unlock_tables(){
mysqladmin extended-status| awk '/<Com_unlock_tables>/{print $4}'
}


Com_update(){
mysqladmin extended-status| awk '/<Com_update>/{print $4}'
}


Com_update_multi(){
mysqladmin extended-status| awk '/<Com_update_multi>/{print $4}'
}


Com_xa_commit(){
mysqladmin extended-status| awk '/<Com_xa_commit>/{print $4}'
}


Com_xa_end(){
mysqladmin extended-status| awk '/<Com_xa_end>/{print $4}'
}


Com_xa_prepare(){
mysqladmin extended-status| awk '/<Com_xa_prepare>/{print $4}'
}


Com_xa_recover(){
mysqladmin extended-status| awk '/<Com_xa_recover>/{print $4}'
}


Com_xa_rollback(){
mysqladmin extended-status| awk '/<Com_xa_rollback>/{print $4}'
}


Com_xa_start(){
mysqladmin extended-status| awk '/<Com_xa_start>/{print $4}'
}


Compression(){
mysqladmin extended-status| awk '/<Compression>/{print $4}'
}


Connection_errors_accept(){
mysqladmin extended-status| awk '/<Connection_errors_accept>/{print $4}'
}


Connection_errors_internal(){
mysqladmin extended-status| awk '/<Connection_errors_internal>/{print $4}'
}


Connection_errors_max_connections(){
mysqladmin extended-status| awk '/<Connection_errors_max_connections>/{print $4}'
}


Connection_errors_peer_address(){
mysqladmin extended-status| awk '/<Connection_errors_peer_address>/{print $4}'
}


Connection_errors_select(){
mysqladmin extended-status| awk '/<Connection_errors_select>/{print $4}'
}


Connection_errors_tcpwrap(){
mysqladmin extended-status| awk '/<Connection_errors_tcpwrap>/{print $4}'
}


Connections(){
mysqladmin extended-status| awk '/<Connections>/{print $4}'
}


Cpu_time(){
mysqladmin extended-status| awk '/<Cpu_time>/{print $4}'
}


Created_tmp_disk_tables(){
mysqladmin extended-status| awk '/<Created_tmp_disk_tables>/{print $4}'
}


Created_tmp_files(){
mysqladmin extended-status| awk '/<Created_tmp_files>/{print $4}'
}


Created_tmp_tables(){
mysqladmin extended-status| awk '/<Created_tmp_tables>/{print $4}'
}


Delayed_errors(){
mysqladmin extended-status| awk '/<Delayed_errors>/{print $4}'
}


Delayed_insert_threads(){
mysqladmin extended-status| awk '/<Delayed_insert_threads>/{print $4}'
}


Delayed_writes(){
mysqladmin extended-status| awk '/<Delayed_writes>/{print $4}'
}


Delete_scan(){
mysqladmin extended-status| awk '/<Delete_scan>/{print $4}'
}


Empty_queries(){
mysqladmin extended-status| awk '/<Empty_queries>/{print $4}'
}


Executed_events(){
mysqladmin extended-status| awk '/<Executed_events>/{print $4}'
}


Executed_triggers(){
mysqladmin extended-status| awk '/<Executed_triggers>/{print $4}'
}


Feature_delay_key_write(){
mysqladmin extended-status| awk '/<Feature_delay_key_write>/{print $4}'
}


Feature_dynamic_columns(){
mysqladmin extended-status| awk '/<Feature_dynamic_columns>/{print $4}'
}


Feature_fulltext(){
mysqladmin extended-status| awk '/<Feature_fulltext>/{print $4}'
}


Feature_gis(){
mysqladmin extended-status| awk '/<Feature_gis>/{print $4}'
}


Feature_locale(){
mysqladmin extended-status| awk '/<Feature_locale>/{print $4}'
}


Feature_subquery(){
mysqladmin extended-status| awk '/<Feature_subquery>/{print $4}'
}


Feature_timezone(){
mysqladmin extended-status| awk '/<Feature_timezone>/{print $4}'
}


Feature_trigger(){
mysqladmin extended-status| awk '/<Feature_trigger>/{print $4}'
}


Feature_xml(){
mysqladmin extended-status| awk '/<Feature_xml>/{print $4}'
}


Flush_commands(){
mysqladmin extended-status| awk '/<Flush_commands>/{print $4}'
}


Handler_commit(){
mysqladmin extended-status| awk '/<Handler_commit>/{print $4}'
}


Handler_delete(){
mysqladmin extended-status| awk '/<Handler_delete>/{print $4}'
}


Handler_discover(){
mysqladmin extended-status| awk '/<Handler_discover>/{print $4}'
}


Handler_external_lock(){
mysqladmin extended-status| awk '/<Handler_external_lock>/{print $4}'
}


Handler_icp_attempts(){
mysqladmin extended-status| awk '/<Handler_icp_attempts>/{print $4}'
}


Handler_icp_match(){
mysqladmin extended-status| awk '/<Handler_icp_match>/{print $4}'
}


Handler_mrr_init(){
mysqladmin extended-status| awk '/<Handler_mrr_init>/{print $4}'
}


Handler_mrr_key_refills(){
mysqladmin extended-status| awk '/<Handler_mrr_key_refills>/{print $4}'
}


Handler_mrr_rowid_refills(){
mysqladmin extended-status| awk '/<Handler_mrr_rowid_refills>/{print $4}'
}


Handler_prepare(){
mysqladmin extended-status| awk '/<Handler_prepare>/{print $4}'
}


Handler_read_first(){
mysqladmin extended-status| awk '/<Handler_read_first>/{print $4}'
}


Handler_read_key(){
mysqladmin extended-status| awk '/<Handler_read_key>/{print $4}'
}


Handler_read_last(){
mysqladmin extended-status| awk '/<Handler_read_last>/{print $4}'
}


Handler_read_next(){
mysqladmin extended-status| awk '/<Handler_read_next>/{print $4}'
}


Handler_read_prev(){
mysqladmin extended-status| awk '/<Handler_read_prev>/{print $4}'
}


Handler_read_retry(){
mysqladmin extended-status| awk '/<Handler_read_retry>/{print $4}'
}


Handler_read_rnd(){
mysqladmin extended-status| awk '/<Handler_read_rnd>/{print $4}'
}


Handler_read_rnd_deleted(){
mysqladmin extended-status| awk '/<Handler_read_rnd_deleted>/{print $4}'
}


Handler_read_rnd_next(){
mysqladmin extended-status| awk '/<Handler_read_rnd_next>/{print $4}'
}


Handler_rollback(){
mysqladmin extended-status| awk '/<Handler_rollback>/{print $4}'
}


Handler_savepoint(){
mysqladmin extended-status| awk '/<Handler_savepoint>/{print $4}'
}


Handler_savepoint_rollback(){
mysqladmin extended-status| awk '/<Handler_savepoint_rollback>/{print $4}'
}


Handler_tmp_update(){
mysqladmin extended-status| awk '/<Handler_tmp_update>/{print $4}'
}


Handler_tmp_write(){
mysqladmin extended-status| awk '/<Handler_tmp_write>/{print $4}'
}


Handler_update(){
mysqladmin extended-status| awk '/<Handler_update>/{print $4}'
}


Handler_write(){
mysqladmin extended-status| awk '/<Handler_write>/{print $4}'
}


Innodb_available_undo_logs(){
mysqladmin extended-status| awk '/<Innodb_available_undo_logs>/{print $4}'
}


Innodb_background_log_sync(){
mysqladmin extended-status| awk '/<Innodb_background_log_sync>/{print $4}'
}


Innodb_buffer_pool_bytes_data(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_bytes_data>/{print $4}'
}


Innodb_buffer_pool_bytes_dirty(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_bytes_dirty>/{print $4}'
}


Innodb_buffer_pool_dump_status(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_dump_status>/{print $4}'
}


Innodb_buffer_pool_load_status(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_load_status>/{print $4}'
}


Innodb_buffer_pool_pages_data(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_data>/{print $4}'
}


Innodb_buffer_pool_pages_dirty(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_dirty>/{print $4}'
}


Innodb_buffer_pool_pages_flushed(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_flushed>/{print $4}'
}


Innodb_buffer_pool_pages_free(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_free>/{print $4}'
}


Innodb_buffer_pool_pages_lru_flushed(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_lru_flushed>/{print $4}'
}


Innodb_buffer_pool_pages_made_not_young(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_made_not_young>/{print $4}'
}


Innodb_buffer_pool_pages_made_young(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_made_young>/{print $4}'
}


Innodb_buffer_pool_pages_misc(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_misc>/{print $4}'
}


Innodb_buffer_pool_pages_old(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_old>/{print $4}'
}


Innodb_buffer_pool_pages_total(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_pages_total>/{print $4}'
}


Innodb_buffer_pool_read_ahead(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_read_ahead>/{print $4}'
}


Innodb_buffer_pool_read_ahead_evicted(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_read_ahead_evicted>/{print $4}'
}


Innodb_buffer_pool_read_ahead_rnd(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_read_ahead_rnd>/{print $4}'
}


Innodb_buffer_pool_read_requests(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_read_requests>/{print $4}'
}


Innodb_buffer_pool_reads(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_reads>/{print $4}'
}


Innodb_buffer_pool_wait_free(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_wait_free>/{print $4}'
}


Innodb_buffer_pool_write_requests(){
mysqladmin extended-status| awk '/<Innodb_buffer_pool_write_requests>/{print $4}'
}


Innodb_checkpoint_age(){
mysqladmin extended-status| awk '/<Innodb_checkpoint_age>/{print $4}'
}


Innodb_checkpoint_max_age(){
mysqladmin extended-status| awk '/<Innodb_checkpoint_max_age>/{print $4}'
}


Innodb_data_fsyncs(){
mysqladmin extended-status| awk '/<Innodb_data_fsyncs>/{print $4}'
}


Innodb_data_pending_fsyncs(){
mysqladmin extended-status| awk '/<Innodb_data_pending_fsyncs>/{print $4}'
}


Innodb_data_pending_reads(){
mysqladmin extended-status| awk '/<Innodb_data_pending_reads>/{print $4}'
}


Innodb_data_pending_writes(){
mysqladmin extended-status| awk '/<Innodb_data_pending_writes>/{print $4}'
}


Innodb_data_read(){
mysqladmin extended-status| awk '/<Innodb_data_read>/{print $4}'
}


Innodb_data_reads(){
mysqladmin extended-status| awk '/<Innodb_data_reads>/{print $4}'
}


Innodb_data_writes(){
mysqladmin extended-status| awk '/<Innodb_data_writes>/{print $4}'
}


Innodb_data_written(){
mysqladmin extended-status| awk '/<Innodb_data_written>/{print $4}'
}


Innodb_dblwr_pages_written(){
mysqladmin extended-status| awk '/<Innodb_dblwr_pages_written>/{print $4}'
}


Innodb_dblwr_writes(){
mysqladmin extended-status| awk '/<Innodb_dblwr_writes>/{print $4}'
}


Innodb_deadlocks(){
mysqladmin extended-status| awk '/<Innodb_deadlocks>/{print $4}'
}


Innodb_have_atomic_builtins(){
mysqladmin extended-status| awk '/<Innodb_have_atomic_builtins>/{print $4}'
}


Innodb_history_list_length(){
mysqladmin extended-status| awk '/<Innodb_history_list_length>/{print $4}'
}


Innodb_ibuf_discarded_delete_marks(){
mysqladmin extended-status| awk '/<Innodb_ibuf_discarded_delete_marks>/{print $4}'
}


Innodb_ibuf_discarded_deletes(){
mysqladmin extended-status| awk '/<Innodb_ibuf_discarded_deletes>/{print $4}'
}


Innodb_ibuf_discarded_inserts(){
mysqladmin extended-status| awk '/<Innodb_ibuf_discarded_inserts>/{print $4}'
}


Innodb_ibuf_free_list(){
mysqladmin extended-status| awk '/<Innodb_ibuf_free_list>/{print $4}'
}


Innodb_ibuf_merged_delete_marks(){
mysqladmin extended-status| awk '/<Innodb_ibuf_merged_delete_marks>/{print $4}'
}


Innodb_ibuf_merged_deletes(){
mysqladmin extended-status| awk '/<Innodb_ibuf_merged_deletes>/{print $4}'
}


Innodb_ibuf_merged_inserts(){
mysqladmin extended-status| awk '/<Innodb_ibuf_merged_inserts>/{print $4}'
}


Innodb_ibuf_merges(){
mysqladmin extended-status| awk '/<Innodb_ibuf_merges>/{print $4}'
}


Innodb_ibuf_segment_size(){
mysqladmin extended-status| awk '/<Innodb_ibuf_segment_size>/{print $4}'
}


Innodb_ibuf_size(){
mysqladmin extended-status| awk '/<Innodb_ibuf_size>/{print $4}'
}


Innodb_log_waits(){
mysqladmin extended-status| awk '/<Innodb_log_waits>/{print $4}'
}


Innodb_log_write_requests(){
mysqladmin extended-status| awk '/<Innodb_log_write_requests>/{print $4}'
}


Innodb_log_writes(){
mysqladmin extended-status| awk '/<Innodb_log_writes>/{print $4}'
}


Innodb_lsn_current(){
mysqladmin extended-status| awk '/<Innodb_lsn_current>/{print $4}'
}


Innodb_lsn_flushed(){
mysqladmin extended-status| awk '/<Innodb_lsn_flushed>/{print $4}'
}


Innodb_lsn_last_checkpoint(){
mysqladmin extended-status| awk '/<Innodb_lsn_last_checkpoint>/{print $4}'
}


Innodb_master_thread_active_loops(){
mysqladmin extended-status| awk '/<Innodb_master_thread_active_loops>/{print $4}'
}


Innodb_master_thread_idle_loops(){
mysqladmin extended-status| awk '/<Innodb_master_thread_idle_loops>/{print $4}'
}


Innodb_max_trx_id(){
mysqladmin extended-status| awk '/<Innodb_max_trx_id>/{print $4}'
}


Innodb_mem_adaptive_hash(){
mysqladmin extended-status| awk '/<Innodb_mem_adaptive_hash>/{print $4}'
}


Innodb_mem_dictionary(){
mysqladmin extended-status| awk '/<Innodb_mem_dictionary>/{print $4}'
}


Innodb_mem_total(){
mysqladmin extended-status| awk '/<Innodb_mem_total>/{print $4}'
}


Innodb_mutex_os_waits(){
mysqladmin extended-status| awk '/<Innodb_mutex_os_waits>/{print $4}'
}


Innodb_mutex_spin_rounds(){
mysqladmin extended-status| awk '/<Innodb_mutex_spin_rounds>/{print $4}'
}


Innodb_mutex_spin_waits(){
mysqladmin extended-status| awk '/<Innodb_mutex_spin_waits>/{print $4}'
}


Innodb_oldest_view_low_limit_trx_id(){
mysqladmin extended-status| awk '/<Innodb_oldest_view_low_limit_trx_id>/{print $4}'
}


Innodb_os_log_fsyncs(){
mysqladmin extended-status| awk '/<Innodb_os_log_fsyncs>/{print $4}'
}


Innodb_os_log_pending_fsyncs(){
mysqladmin extended-status| awk '/<Innodb_os_log_pending_fsyncs>/{print $4}'
}


Innodb_os_log_pending_writes(){
mysqladmin extended-status| awk '/<Innodb_os_log_pending_writes>/{print $4}'
}


Innodb_os_log_written(){
mysqladmin extended-status| awk '/<Innodb_os_log_written>/{print $4}'
}


Innodb_page_size(){
mysqladmin extended-status| awk '/<Innodb_page_size>/{print $4}'
}


Innodb_pages_created(){
mysqladmin extended-status| awk '/<Innodb_pages_created>/{print $4}'
}


Innodb_pages_read(){
mysqladmin extended-status| awk '/<Innodb_pages_read>/{print $4}'
}


Innodb_pages0_read(){
mysqladmin extended-status| awk '/<Innodb_pages0_read>/{print $4}'
}


Innodb_pages_written(){
mysqladmin extended-status| awk '/<Innodb_pages_written>/{print $4}'
}


Innodb_purge_trx_id(){
mysqladmin extended-status| awk '/<Innodb_purge_trx_id>/{print $4}'
}


Innodb_purge_undo_no(){
mysqladmin extended-status| awk '/<Innodb_purge_undo_no>/{print $4}'
}


Innodb_read_views_memory(){
mysqladmin extended-status| awk '/<Innodb_read_views_memory>/{print $4}'
}


Innodb_row_lock_current_waits(){
mysqladmin extended-status| awk '/<Innodb_row_lock_current_waits>/{print $4}'
}


Innodb_row_lock_time(){
mysqladmin extended-status| awk '/<Innodb_row_lock_time>/{print $4}'
}


Innodb_row_lock_time_avg(){
mysqladmin extended-status| awk '/<Innodb_row_lock_time_avg>/{print $4}'
}


Innodb_row_lock_time_max(){
mysqladmin extended-status| awk '/<Innodb_row_lock_time_max>/{print $4}'
}


Innodb_row_lock_waits(){
mysqladmin extended-status| awk '/<Innodb_row_lock_waits>/{print $4}'
}


Innodb_rows_deleted(){
mysqladmin extended-status| awk '/<Innodb_rows_deleted>/{print $4}'
}


Innodb_rows_inserted(){
mysqladmin extended-status| awk '/<Innodb_rows_inserted>/{print $4}'
}


Innodb_rows_read(){
mysqladmin extended-status| awk '/<Innodb_rows_read>/{print $4}'
}


Innodb_rows_updated(){
mysqladmin extended-status| awk '/<Innodb_rows_updated>/{print $4}'
}


Innodb_system_rows_deleted(){
mysqladmin extended-status| awk '/<Innodb_system_rows_deleted>/{print $4}'
}


Innodb_system_rows_inserted(){
mysqladmin extended-status| awk '/<Innodb_system_rows_inserted>/{print $4}'
}


Innodb_system_rows_read(){
mysqladmin extended-status| awk '/<Innodb_system_rows_read>/{print $4}'
}


Innodb_system_rows_updated(){
mysqladmin extended-status| awk '/<Innodb_system_rows_updated>/{print $4}'
}


Innodb_s_lock_os_waits(){
mysqladmin extended-status| awk '/<Innodb_s_lock_os_waits>/{print $4}'
}


Innodb_s_lock_spin_rounds(){
mysqladmin extended-status| awk '/<Innodb_s_lock_spin_rounds>/{print $4}'
}


Innodb_s_lock_spin_waits(){
mysqladmin extended-status| awk '/<Innodb_s_lock_spin_waits>/{print $4}'
}


Innodb_truncated_status_writes(){
mysqladmin extended-status| awk '/<Innodb_truncated_status_writes>/{print $4}'
}


Innodb_x_lock_os_waits(){
mysqladmin extended-status| awk '/<Innodb_x_lock_os_waits>/{print $4}'
}


Innodb_x_lock_spin_rounds(){
mysqladmin extended-status| awk '/<Innodb_x_lock_spin_rounds>/{print $4}'
}


Innodb_x_lock_spin_waits(){
mysqladmin extended-status| awk '/<Innodb_x_lock_spin_waits>/{print $4}'
}


Innodb_page_compression_saved(){
mysqladmin extended-status| awk '/<Innodb_page_compression_saved>/{print $4}'
}


Innodb_page_compression_trim_sect512(){
mysqladmin extended-status| awk '/<Innodb_page_compression_trim_sect512>/{print $4}'
}


Innodb_page_compression_trim_sect1024(){
mysqladmin extended-status| awk '/<Innodb_page_compression_trim_sect1024>/{print $4}'
}


Innodb_page_compression_trim_sect2048(){
mysqladmin extended-status| awk '/<Innodb_page_compression_trim_sect2048>/{print $4}'
}


Innodb_page_compression_trim_sect4096(){
mysqladmin extended-status| awk '/<Innodb_page_compression_trim_sect4096>/{print $4}'
}


Innodb_page_compression_trim_sect8192(){
mysqladmin extended-status| awk '/<Innodb_page_compression_trim_sect8192>/{print $4}'
}


Innodb_page_compression_trim_sect16384(){
mysqladmin extended-status| awk '/<Innodb_page_compression_trim_sect16384>/{print $4}'
}


Innodb_page_compression_trim_sect32768(){
mysqladmin extended-status| awk '/<Innodb_page_compression_trim_sect32768>/{print $4}'
}


Innodb_num_index_pages_written(){
mysqladmin extended-status| awk '/<Innodb_num_index_pages_written>/{print $4}'
}


Innodb_num_non_index_pages_written(){
mysqladmin extended-status| awk '/<Innodb_num_non_index_pages_written>/{print $4}'
}


Innodb_num_pages_page_compressed(){
mysqladmin extended-status| awk '/<Innodb_num_pages_page_compressed>/{print $4}'
}


Innodb_num_page_compressed_trim_op(){
mysqladmin extended-status| awk '/<Innodb_num_page_compressed_trim_op>/{print $4}'
}


Innodb_num_page_compressed_trim_op_saved(){
mysqladmin extended-status| awk '/<Innodb_num_page_compressed_trim_op_saved>/{print $4}'
}


Innodb_num_pages_page_decompressed(){
mysqladmin extended-status| awk '/<Innodb_num_pages_page_decompressed>/{print $4}'
}


Innodb_num_pages_page_compression_error(){
mysqladmin extended-status| awk '/<Innodb_num_pages_page_compression_error>/{print $4}'
}


Innodb_num_pages_encrypted(){
mysqladmin extended-status| awk '/<Innodb_num_pages_encrypted>/{print $4}'
}


Innodb_num_pages_decrypted(){
mysqladmin extended-status| awk '/<Innodb_num_pages_decrypted>/{print $4}'
}


Innodb_have_lz4(){
mysqladmin extended-status| awk '/<Innodb_have_lz4>/{print $4}'
}


Innodb_have_lzo(){
mysqladmin extended-status| awk '/<Innodb_have_lzo>/{print $4}'
}


Innodb_have_lzma(){
mysqladmin extended-status| awk '/<Innodb_have_lzma>/{print $4}'
}


Innodb_have_bzip2(){
mysqladmin extended-status| awk '/<Innodb_have_bzip2>/{print $4}'
}


Innodb_have_snappy(){
mysqladmin extended-status| awk '/<Innodb_have_snappy>/{print $4}'
}


Innodb_defragment_compression_failures(){
mysqladmin extended-status| awk '/<Innodb_defragment_compression_failures>/{print $4}'
}


Innodb_defragment_failures(){
mysqladmin extended-status| awk '/<Innodb_defragment_failures>/{print $4}'
}


Innodb_defragment_count(){
mysqladmin extended-status| awk '/<Innodb_defragment_count>/{print $4}'
}


Innodb_onlineddl_rowlog_rows(){
mysqladmin extended-status| awk '/<Innodb_onlineddl_rowlog_rows>/{print $4}'
}


Innodb_onlineddl_rowlog_pct_used(){
mysqladmin extended-status| awk '/<Innodb_onlineddl_rowlog_pct_used>/{print $4}'
}


Innodb_onlineddl_pct_progress(){
mysqladmin extended-status| awk '/<Innodb_onlineddl_pct_progress>/{print $4}'
}


Innodb_secondary_index_triggered_cluster_reads(){
mysqladmin extended-status| awk '/<Innodb_secondary_index_triggered_cluster_reads>/{print $4}'
}


Innodb_secondary_index_triggered_cluster_reads_avoided(){
mysqladmin extended-status| awk '/<Innodb_secondary_index_triggered_cluster_reads_avoided>/{print $4}'
}


Innodb_encryption_rotation_pages_read_from_cache(){
mysqladmin extended-status| awk '/<Innodb_encryption_rotation_pages_read_from_cache>/{print $4}'
}


Innodb_encryption_rotation_pages_read_from_disk(){
mysqladmin extended-status| awk '/<Innodb_encryption_rotation_pages_read_from_disk>/{print $4}'
}


Innodb_encryption_rotation_pages_modified(){
mysqladmin extended-status| awk '/<Innodb_encryption_rotation_pages_modified>/{print $4}'
}


Innodb_encryption_rotation_pages_flushed(){
mysqladmin extended-status| awk '/<Innodb_encryption_rotation_pages_flushed>/{print $4}'
}


Innodb_encryption_rotation_estimated_iops(){
mysqladmin extended-status| awk '/<Innodb_encryption_rotation_estimated_iops>/{print $4}'
}


Innodb_scrub_background_page_reorganizations(){
mysqladmin extended-status| awk '/<Innodb_scrub_background_page_reorganizations>/{print $4}'
}


Innodb_scrub_background_page_splits(){
mysqladmin extended-status| awk '/<Innodb_scrub_background_page_splits>/{print $4}'
}


Innodb_scrub_background_page_split_failures_underflow(){
mysqladmin extended-status| awk '/<Innodb_scrub_background_page_split_failures_underflow>/{print $4}'
}


Innodb_scrub_background_page_split_failures_out_of_filespace(){
mysqladmin extended-status| awk '/<Innodb_scrub_background_page_split_failures_out_of_filespace>/{print $4}'
}


Innodb_scrub_background_page_split_failures_missing_index(){
mysqladmin extended-status| awk '/<Innodb_scrub_background_page_split_failures_missing_index>/{print $4}'
}


Innodb_scrub_background_page_split_failures_unknown(){
mysqladmin extended-status| awk '/<Innodb_scrub_background_page_split_failures_unknown>/{print $4}'
}


Key_blocks_not_flushed(){
mysqladmin extended-status| awk '/<Key_blocks_not_flushed>/{print $4}'
}


Key_blocks_unused(){
mysqladmin extended-status| awk '/<Key_blocks_unused>/{print $4}'
}


Key_blocks_used(){
mysqladmin extended-status| awk '/<Key_blocks_used>/{print $4}'
}


Key_blocks_warm(){
mysqladmin extended-status| awk '/<Key_blocks_warm>/{print $4}'
}


Key_read_requests(){
mysqladmin extended-status| awk '/<Key_read_requests>/{print $4}'
}


Key_reads(){
mysqladmin extended-status| awk '/<Key_reads>/{print $4}'
}


Key_write_requests(){
mysqladmin extended-status| awk '/<Key_write_requests>/{print $4}'
}


Key_writes(){
mysqladmin extended-status| awk '/<Key_writes>/{print $4}'
}


Last_query_cost(){
mysqladmin extended-status| awk '/<Last_query_cost>/{print $4}'
}


Master_gtid_wait_count(){
mysqladmin extended-status| awk '/<Master_gtid_wait_count>/{print $4}'
}


Master_gtid_wait_time(){
mysqladmin extended-status| awk '/<Master_gtid_wait_time>/{print $4}'
}


Master_gtid_wait_timeouts(){
mysqladmin extended-status| awk '/<Master_gtid_wait_timeouts>/{print $4}'
}


Max_statement_time_exceeded(){
mysqladmin extended-status| awk '/<Max_statement_time_exceeded>/{print $4}'
}


Max_used_connections(){
mysqladmin extended-status| awk '/<Max_used_connections>/{print $4}'
}


Memory_used(){
mysqladmin extended-status| awk '/<Memory_used>/{print $4}'
}


Not_flushed_delayed_rows(){
mysqladmin extended-status| awk '/<Not_flushed_delayed_rows>/{print $4}'
}


Open_files(){
mysqladmin extended-status| awk '/<Open_files>/{print $4}'
}


Open_streams(){
mysqladmin extended-status| awk '/<Open_streams>/{print $4}'
}


Open_table_definitions(){
mysqladmin extended-status| awk '/<Open_table_definitions>/{print $4}'
}


Open_tables(){
mysqladmin extended-status| awk '/<Open_tables>/{print $4}'
}


Opened_files(){
mysqladmin extended-status| awk '/<Opened_files>/{print $4}'
}


Opened_plugin_libraries(){
mysqladmin extended-status| awk '/<Opened_plugin_libraries>/{print $4}'
}


Opened_table_definitions(){
mysqladmin extended-status| awk '/<Opened_table_definitions>/{print $4}'
}


Opened_tables(){
mysqladmin extended-status| awk '/<Opened_tables>/{print $4}'
}


Opened_views(){
mysqladmin extended-status| awk '/<Opened_views>/{print $4}'
}


Performance_schema_accounts_lost(){
mysqladmin extended-status| awk '/<Performance_schema_accounts_lost>/{print $4}'
}


Performance_schema_cond_classes_lost(){
mysqladmin extended-status| awk '/<Performance_schema_cond_classes_lost>/{print $4}'
}


Performance_schema_cond_instances_lost(){
mysqladmin extended-status| awk '/<Performance_schema_cond_instances_lost>/{print $4}'
}


Performance_schema_digest_lost(){
mysqladmin extended-status| awk '/<Performance_schema_digest_lost>/{print $4}'
}


Performance_schema_file_classes_lost(){
mysqladmin extended-status| awk '/<Performance_schema_file_classes_lost>/{print $4}'
}


Performance_schema_file_handles_lost(){
mysqladmin extended-status| awk '/<Performance_schema_file_handles_lost>/{print $4}'
}


Performance_schema_file_instances_lost(){
mysqladmin extended-status| awk '/<Performance_schema_file_instances_lost>/{print $4}'
}


Performance_schema_hosts_lost(){
mysqladmin extended-status| awk '/<Performance_schema_hosts_lost>/{print $4}'
}


Performance_schema_locker_lost(){
mysqladmin extended-status| awk '/<Performance_schema_locker_lost>/{print $4}'
}


Performance_schema_mutex_classes_lost(){
mysqladmin extended-status| awk '/<Performance_schema_mutex_classes_lost>/{print $4}'
}


Performance_schema_mutex_instances_lost(){
mysqladmin extended-status| awk '/<Performance_schema_mutex_instances_lost>/{print $4}'
}


Performance_schema_rwlock_classes_lost(){
mysqladmin extended-status| awk '/<Performance_schema_rwlock_classes_lost>/{print $4}'
}


Performance_schema_rwlock_instances_lost(){
mysqladmin extended-status| awk '/<Performance_schema_rwlock_instances_lost>/{print $4}'
}


Performance_schema_session_connect_attrs_lost(){
mysqladmin extended-status| awk '/<Performance_schema_session_connect_attrs_lost>/{print $4}'
}


Performance_schema_socket_classes_lost(){
mysqladmin extended-status| awk '/<Performance_schema_socket_classes_lost>/{print $4}'
}


Performance_schema_socket_instances_lost(){
mysqladmin extended-status| awk '/<Performance_schema_socket_instances_lost>/{print $4}'
}


Performance_schema_stage_classes_lost(){
mysqladmin extended-status| awk '/<Performance_schema_stage_classes_lost>/{print $4}'
}


Performance_schema_statement_classes_lost(){
mysqladmin extended-status| awk '/<Performance_schema_statement_classes_lost>/{print $4}'
}


Performance_schema_table_handles_lost(){
mysqladmin extended-status| awk '/<Performance_schema_table_handles_lost>/{print $4}'
}


Performance_schema_table_instances_lost(){
mysqladmin extended-status| awk '/<Performance_schema_table_instances_lost>/{print $4}'
}


Performance_schema_thread_classes_lost(){
mysqladmin extended-status| awk '/<Performance_schema_thread_classes_lost>/{print $4}'
}


Performance_schema_thread_instances_lost(){
mysqladmin extended-status| awk '/<Performance_schema_thread_instances_lost>/{print $4}'
}


Performance_schema_users_lost(){
mysqladmin extended-status| awk '/<Performance_schema_users_lost>/{print $4}'
}


Prepared_stmt_count(){
mysqladmin extended-status| awk '/<Prepared_stmt_count>/{print $4}'
}


Qcache_free_blocks(){
mysqladmin extended-status| awk '/<Qcache_free_blocks>/{print $4}'
}


Qcache_free_memory(){
mysqladmin extended-status| awk '/<Qcache_free_memory>/{print $4}'
}


Qcache_hits(){
mysqladmin extended-status| awk '/<Qcache_hits>/{print $4}'
}


Qcache_inserts(){
mysqladmin extended-status| awk '/<Qcache_inserts>/{print $4}'
}


Qcache_lowmem_prunes(){
mysqladmin extended-status| awk '/<Qcache_lowmem_prunes>/{print $4}'
}


Qcache_not_cached(){
mysqladmin extended-status| awk '/<Qcache_not_cached>/{print $4}'
}


Qcache_queries_in_cache(){
mysqladmin extended-status| awk '/<Qcache_queries_in_cache>/{print $4}'
}


Qcache_total_blocks(){
mysqladmin extended-status| awk '/<Qcache_total_blocks>/{print $4}'
}


Queries(){
mysqladmin extended-status| awk '/<Queries>/{print $4}'
}


Questions(){
mysqladmin extended-status| awk '/<Questions>/{print $4}'
}


Rows_read(){
mysqladmin extended-status| awk '/<Rows_read>/{print $4}'
}


Rows_sent(){
mysqladmin extended-status| awk '/<Rows_sent>/{print $4}'
}


Rows_tmp_read(){
mysqladmin extended-status| awk '/<Rows_tmp_read>/{print $4}'
}


Rpl_status(){
mysqladmin extended-status| awk '/<Rpl_status>/{print $4}'
}


Select_full_join(){
mysqladmin extended-status| awk '/<Select_full_join>/{print $4}'
}


Select_full_range_join(){
mysqladmin extended-status| awk '/<Select_full_range_join>/{print $4}'
}


Select_range(){
mysqladmin extended-status| awk '/<Select_range>/{print $4}'
}


Select_range_check(){
mysqladmin extended-status| awk '/<Select_range_check>/{print $4}'
}


Select_scan(){
mysqladmin extended-status| awk '/<Select_scan>/{print $4}'
}


Slave_connections(){
mysqladmin extended-status| awk '/<Slave_connections>/{print $4}'
}


Slave_heartbeat_period(){
mysqladmin extended-status| awk '/<Slave_heartbeat_period>/{print $4}'
}


Slave_open_temp_tables(){
mysqladmin extended-status| awk '/<Slave_open_temp_tables>/{print $4}'
}


Slave_received_heartbeats(){
mysqladmin extended-status| awk '/<Slave_received_heartbeats>/{print $4}'
}


Slave_retried_transactions(){
mysqladmin extended-status| awk '/<Slave_retried_transactions>/{print $4}'
}


Slave_running(){
mysqladmin extended-status| awk '/<Slave_running>/{print $4}'
}


Slave_skipped_errors(){
mysqladmin extended-status| awk '/<Slave_skipped_errors>/{print $4}'
}


Slaves_connected(){
mysqladmin extended-status| awk '/<Slaves_connected>/{print $4}'
}


Slaves_running(){
mysqladmin extended-status| awk '/<Slaves_running>/{print $4}'
}


Slow_launch_threads(){
mysqladmin extended-status| awk '/<Slow_launch_threads>/{print $4}'
}


Slow_queries(){
mysqladmin extended-status| awk '/<Slow_queries>/{print $4}'
}


Sort_merge_passes(){
mysqladmin extended-status| awk '/<Sort_merge_passes>/{print $4}'
}


Sort_priority_queue_sorts(){
mysqladmin extended-status| awk '/<Sort_priority_queue_sorts>/{print $4}'
}


Sort_range(){
mysqladmin extended-status| awk '/<Sort_range>/{print $4}'
}


Sort_rows(){
mysqladmin extended-status| awk '/<Sort_rows>/{print $4}'
}


Sort_scan(){
mysqladmin extended-status| awk '/<Sort_scan>/{print $4}'
}


Ssl_accept_renegotiates(){
mysqladmin extended-status| awk '/<Ssl_accept_renegotiates>/{print $4}'
}


Ssl_accepts(){
mysqladmin extended-status| awk '/<Ssl_accepts>/{print $4}'
}


Ssl_callback_cache_hits(){
mysqladmin extended-status| awk '/<Ssl_callback_cache_hits>/{print $4}'
}


Ssl_cipher(){
mysqladmin extended-status| awk '/<Ssl_cipher>/{print $4}'
}


Ssl_cipher_list(){
mysqladmin extended-status| awk '/<Ssl_cipher_list>/{print $4}'
}


Ssl_client_connects(){
mysqladmin extended-status| awk '/<Ssl_client_connects>/{print $4}'
}


Ssl_connect_renegotiates(){
mysqladmin extended-status| awk '/<Ssl_connect_renegotiates>/{print $4}'
}


Ssl_ctx_verify_depth(){
mysqladmin extended-status| awk '/<Ssl_ctx_verify_depth>/{print $4}'
}


Ssl_ctx_verify_mode(){
mysqladmin extended-status| awk '/<Ssl_ctx_verify_mode>/{print $4}'
}


Ssl_default_timeout(){
mysqladmin extended-status| awk '/<Ssl_default_timeout>/{print $4}'
}


Ssl_finished_accepts(){
mysqladmin extended-status| awk '/<Ssl_finished_accepts>/{print $4}'
}


Ssl_finished_connects(){
mysqladmin extended-status| awk '/<Ssl_finished_connects>/{print $4}'
}


Ssl_server_not_after(){
mysqladmin extended-status| awk '/<Ssl_server_not_after>/{print $4}'
}


Ssl_server_not_before(){
mysqladmin extended-status| awk '/<Ssl_server_not_before>/{print $4}'
}


Ssl_session_cache_hits(){
mysqladmin extended-status| awk '/<Ssl_session_cache_hits>/{print $4}'
}


Ssl_session_cache_misses(){
mysqladmin extended-status| awk '/<Ssl_session_cache_misses>/{print $4}'
}


Ssl_session_cache_mode(){
mysqladmin extended-status| awk '/<Ssl_session_cache_mode>/{print $4}'
}


Ssl_session_cache_overflows(){
mysqladmin extended-status| awk '/<Ssl_session_cache_overflows>/{print $4}'
}


Ssl_session_cache_size(){
mysqladmin extended-status| awk '/<Ssl_session_cache_size>/{print $4}'
}


Ssl_session_cache_timeouts(){
mysqladmin extended-status| awk '/<Ssl_session_cache_timeouts>/{print $4}'
}


Ssl_sessions_reused(){
mysqladmin extended-status| awk '/<Ssl_sessions_reused>/{print $4}'
}


Ssl_used_session_cache_entries(){
mysqladmin extended-status| awk '/<Ssl_used_session_cache_entries>/{print $4}'
}


Ssl_verify_depth(){
mysqladmin extended-status| awk '/<Ssl_verify_depth>/{print $4}'
}


Ssl_verify_mode(){
mysqladmin extended-status| awk '/<Ssl_verify_mode>/{print $4}'
}


Ssl_version(){
mysqladmin extended-status| awk '/<Ssl_version>/{print $4}'
}


Subquery_cache_hit(){
mysqladmin extended-status| awk '/<Subquery_cache_hit>/{print $4}'
}


Subquery_cache_miss(){
mysqladmin extended-status| awk '/<Subquery_cache_miss>/{print $4}'
}


Syncs(){
mysqladmin extended-status| awk '/<Syncs>/{print $4}'
}


Table_locks_immediate(){
mysqladmin extended-status| awk '/<Table_locks_immediate>/{print $4}'
}


Table_locks_waited(){
mysqladmin extended-status| awk '/<Table_locks_waited>/{print $4}'
}


Tc_log_max_pages_used(){
mysqladmin extended-status| awk '/<Tc_log_max_pages_used>/{print $4}'
}


Tc_log_page_size(){
mysqladmin extended-status| awk '/<Tc_log_page_size>/{print $4}'
}


Tc_log_page_waits(){
mysqladmin extended-status| awk '/<Tc_log_page_waits>/{print $4}'
}


Threadpool_idle_threads(){
mysqladmin extended-status| awk '/<Threadpool_idle_threads>/{print $4}'
}


Threadpool_threads(){
mysqladmin extended-status| awk '/<Threadpool_threads>/{print $4}'
}


Threads_cached(){
mysqladmin extended-status| awk '/<Threads_cached>/{print $4}'
}


Threads_connected(){
mysqladmin extended-status| awk '/<Threads_connected>/{print $4}'
}


Threads_created(){
mysqladmin extended-status| awk '/<Threads_created>/{print $4}'
}


Threads_running(){
mysqladmin extended-status| awk '/<Threads_running>/{print $4}'
}


Update_scan(){
mysqladmin extended-status| awk '/<Update_scan>/{print $4}'
}


Uptime(){
mysqladmin extended-status| awk '/<Uptime>/{print $4}'
}


Uptime_since_flush_status(){
mysqladmin extended-status| awk '/<Uptime_since_flush_status>/{print $4}'
}


wsrep_cluster_conf_id(){
mysqladmin extended-status| awk '/<wsrep_cluster_conf_id>/{print $4}'
}


wsrep_cluster_size(){
mysqladmin extended-status| awk '/<wsrep_cluster_size>/{print $4}'
}


wsrep_cluster_state_uuid(){
mysqladmin extended-status| awk '/<wsrep_cluster_state_uuid>/{print $4}'
}


wsrep_cluster_status(){
mysqladmin extended-status| awk '/<wsrep_cluster_status>/{print $4}'
}


wsrep_connected(){
mysqladmin extended-status| awk '/<wsrep_connected>/{print $4}'
}


wsrep_local_bf_aborts(){
mysqladmin extended-status| awk '/<wsrep_local_bf_aborts>/{print $4}'
}


wsrep_local_index(){
mysqladmin extended-status| awk '/<wsrep_local_index>/{print $4}'
}


wsrep_provider_name(){
mysqladmin extended-status| awk '/<wsrep_provider_name>/{print $4}'
}


wsrep_provider_vendor(){
mysqladmin extended-status| awk '/<wsrep_provider_vendor>/{print $4}'
}


wsrep_provider_version(){
mysqladmin extended-status| awk '/<wsrep_provider_version>/{print $4}'
}


wsrep_ready(){
mysqladmin extended-status| awk '/<wsrep_ready>/{print $4}'
}


wsrep_thread_count(){
mysqladmin extended-status| awk '/<wsrep_thread_count>/{print $4}'
}

$1

原文地址:https://www.cnblogs.com/jingzaixin/p/12552628.html