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
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· Linux系列:如何用heaptrack跟踪.NET程序的非托管内存泄露
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· 阿里巴巴 QwQ-32B真的超越了 DeepSeek R-1吗?
· 【译】Visual Studio 中新的强大生产力特性
· 10年+ .NET Coder 心语 ── 封装的思维:从隐藏、稳定开始理解其本质意义
· 【设计模式】告别冗长if-else语句:使用策略模式优化代码结构