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

 

posted on 2020-03-23 15:49  大话人生  阅读(362)  评论(0编辑  收藏  举报