mysql监控的chk_mysql.sh脚本内容for show status

最新推荐文章于 2024-05-21 01:22:39 发布

huoyuanshen

最新推荐文章于 2024-05-21 01:22:39 发布

阅读量1.3k

点赞数

分类专栏： zabbix

本文链接：https://blog.csdn.net/huoyuanshen/article/details/71656423

版权

zabbix 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

该脚本内容比网上的更全，包括zabbix模板中参数和mysql5.7的show status命令全部参数，部分show variables参数。对于后期追加监控参数，可以避免在该脚本中添加监控项的操作。

#!/bin/sh

# -------------------------------------------------------------------------------
# FileName: check_mysql.sh
# Revision: 1.0
# Date: 2016/04/22
# Author: HuoYuanshen
# Email: 370003015@qq.com
MYSQL_SOCK="/usr/local/mysql/mysql.sock"
MYSQL_HOST='127.0.0.1'
MYSQL_PORT='3306'
ARGS=1
if [ $# -ne "$ARGS" ];then
echo "Please input one arguement:"
fi
case $1 in

Slow_queries)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK status |cut -f5 -d":"|cut -f1 -d"O"`
echo $result
;;
Uptime)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK status|cut -f2 -d":"|cut -f1 -d"T"`
echo $result
;;
Questions)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK status|cut -f4 -d":"|cut -f1 -d"S"`
echo $result
;;

Aborted_clients)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Aborted_clients"|cut -d"|" -f3`
echo $result
;;

Aborted_connects)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Aborted_connects"|cut -d"|" -f3`
echo $result
;;

Binlog_cache_disk_use)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Binlog_cache_disk_use"|cut -d"|" -f3`
echo $result
;;

Binlog_cache_use)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Binlog_cache_use"|cut -d"|" -f3`
echo $result
;;

Binlog_stmt_cache_disk_use)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Binlog_stmt_cache_disk_use"|cut -d"|" -f3`
echo $result
;;

Binlog_stmt_cache_use)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Binlog_stmt_cache_use"|cut -d"|" -f3`
echo $result
;;

Bytes_received)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Bytes_received"|cut -d"|" -f3`
echo $result
;;

Bytes_sent)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Bytes_sent"|cut -d"|" -f3`
echo $result
;;

Com_admin_commands)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_admin_commands"|cut -d"|" -f3`
echo $result
;;

Com_assign_to_keycache)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_assign_to_keycache"|cut -d"|" -f3`
echo $result
;;

Com_alter_db)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_db"|cut -d"|" -f3`
echo $result
;;

Com_alter_db_upgrade)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_db_upgrade"|cut -d"|" -f3`
echo $result
;;

Com_alter_event)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_event"|cut -d"|" -f3`
echo $result
;;

Com_alter_function)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_function"|cut -d"|" -f3`
echo $result
;;

Com_alter_instance)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_instance"|cut -d"|" -f3`
echo $result
;;

Com_alter_procedure)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_procedure"|cut -d"|" -f3`
echo $result
;;

Com_alter_server)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_server"|cut -d"|" -f3`
echo $result
;;

Com_alter_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_table"|cut -d"|" -f3`
echo $result
;;

Com_alter_tablespace)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_tablespace"|cut -d"|" -f3`
echo $result
;;

Com_alter_user)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_alter_user"|cut -d"|" -f3`
echo $result
;;

Com_analyze)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_analyze"|cut -d"|" -f3`
echo $result
;;

Com_begin)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_begin"|cut -d"|" -f3`
echo $result
;;

Com_binlog)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_binlog"|cut -d"|" -f3`
echo $result
;;

Com_call_procedure)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_call_procedure"|cut -d"|" -f3`
echo $result
;;

Com_change_db)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_change_db"|cut -d"|" -f3`
echo $result
;;

Com_change_master)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_change_master"|cut -d"|" -f3`
echo $result
;;

Com_change_repl_filter)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_change_repl_filter"|cut -d"|" -f3`
echo $result
;;

Com_check)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_check"|cut -d"|" -f3`
echo $result
;;

Com_checksum)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_checksum"|cut -d"|" -f3`
echo $result
;;

Com_commit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_commit"|cut -d"|" -f3`
echo $result
;;

Com_create_db)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_db"|cut -d"|" -f3`
echo $result
;;

Com_create_event)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_event"|cut -d"|" -f3`
echo $result
;;

Com_create_function)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_function"|cut -d"|" -f3`
echo $result
;;

Com_create_index)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_index"|cut -d"|" -f3`
echo $result
;;

Com_create_procedure)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_procedure"|cut -d"|" -f3`
echo $result
;;

Com_create_server)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_server"|cut -d"|" -f3`
echo $result
;;

Com_create_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_table"|cut -d"|" -f3`
echo $result
;;

Com_create_trigger)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_trigger"|cut -d"|" -f3`
echo $result
;;

Com_create_udf)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_udf"|cut -d"|" -f3`
echo $result
;;

Com_create_user)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_user"|cut -d"|" -f3`
echo $result
;;

Com_create_view)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_create_view"|cut -d"|" -f3`
echo $result
;;

Com_dealloc_sql)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_dealloc_sql"|cut -d"|" -f3`
echo $result
;;

Com_delete)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_delete"|cut -d"|" -f3`
echo $result
;;

Com_delete_multi)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_delete_multi"|cut -d"|" -f3`
echo $result
;;

Com_do)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_do"|cut -d"|" -f3`
echo $result
;;

Com_drop_db)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_db"|cut -d"|" -f3`
echo $result
;;

Com_drop_event)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_event"|cut -d"|" -f3`
echo $result
;;

Com_drop_function)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_function"|cut -d"|" -f3`
echo $result
;;

Com_drop_index)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_index"|cut -d"|" -f3`
echo $result
;;

Com_drop_procedure)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_procedure"|cut -d"|" -f3`
echo $result
;;

Com_drop_server)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_server"|cut -d"|" -f3`
echo $result
;;

Com_drop_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_table"|cut -d"|" -f3`
echo $result
;;

Com_drop_trigger)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_trigger"|cut -d"|" -f3`
echo $result
;;

Com_drop_user)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_user"|cut -d"|" -f3`
echo $result
;;

Com_drop_view)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_drop_view"|cut -d"|" -f3`
echo $result
;;

Com_empty_query)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_empty_query"|cut -d"|" -f3`
echo $result
;;

Com_execute_sql)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_execute_sql"|cut -d"|" -f3`
echo $result
;;

Com_explain_other)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_explain_other"|cut -d"|" -f3`
echo $result
;;

Com_flush)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_flush"|cut -d"|" -f3`
echo $result
;;

Com_get_diagnostics)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_get_diagnostics"|cut -d"|" -f3`
echo $result
;;

Com_grant)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_grant"|cut -d"|" -f3`
echo $result
;;

Com_ha_close)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_ha_close"|cut -d"|" -f3`
echo $result
;;

Com_ha_open)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_ha_open"|cut -d"|" -f3`
echo $result
;;

Com_ha_read)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_ha_read"|cut -d"|" -f3`
echo $result
;;

Com_help)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_help"|cut -d"|" -f3`
echo $result
;;

Com_insert)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_insert"|cut -d"|" -f3`
echo $result
;;

Com_insert_select)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_insert_select"|cut -d"|" -f3`
echo $result
;;

Com_install_plugin)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_install_plugin"|cut -d"|" -f3`
echo $result
;;

Com_kill)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_kill"|cut -d"|" -f3`
echo $result
;;

Com_load)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_load"|cut -d"|" -f3`
echo $result
;;

Com_lock_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_lock_tables"|cut -d"|" -f3`
echo $result
;;

Com_optimize)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_optimize"|cut -d"|" -f3`
echo $result
;;

Com_preload_keys)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_preload_keys"|cut -d"|" -f3`
echo $result
;;

Com_prepare_sql)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_prepare_sql"|cut -d"|" -f3`
echo $result
;;

Com_purge)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_purge"|cut -d"|" -f3`
echo $result
;;

Com_purge_before_date)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_purge_before_date"|cut -d"|" -f3`
echo $result
;;

Com_release_savepoint)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_release_savepoint"|cut -d"|" -f3`
echo $result
;;

Com_rename_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_rename_table"|cut -d"|" -f3`
echo $result
;;

Com_rename_user)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_rename_user"|cut -d"|" -f3`
echo $result
;;

Com_repair)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_repair"|cut -d"|" -f3`
echo $result
;;

Com_replace)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_replace"|cut -d"|" -f3`
echo $result
;;

Com_replace_select)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_replace_select"|cut -d"|" -f3`
echo $result
;;

Com_reset)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_reset"|cut -d"|" -f3`
echo $result
;;

Com_resignal)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_resignal"|cut -d"|" -f3`
echo $result
;;

Com_revoke)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_revoke"|cut -d"|" -f3`
echo $result
;;

Com_revoke_all)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_revoke_all"|cut -d"|" -f3`
echo $result
;;

Com_rollback)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_rollback"|cut -d"|" -f3`
echo $result
;;

Com_rollback_to_savepoint)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_rollback_to_savepoint"|cut -d"|" -f3`
echo $result
;;

Com_savepoint)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_savepoint"|cut -d"|" -f3`
echo $result
;;

Com_select)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_select"|cut -d"|" -f3`
echo $result
;;

Com_set_option)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_set_option"|cut -d"|" -f3`
echo $result
;;

Com_signal)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_signal"|cut -d"|" -f3`
echo $result
;;

Com_show_binlog_events)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_binlog_events"|cut -d"|" -f3`
echo $result
;;

Com_show_binlogs)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_binlogs"|cut -d"|" -f3`
echo $result
;;

Com_show_charsets)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_charsets"|cut -d"|" -f3`
echo $result
;;

Com_show_collations)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_collations"|cut -d"|" -f3`
echo $result
;;

Com_show_create_db)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_create_db"|cut -d"|" -f3`
echo $result
;;

Com_show_create_event)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_create_event"|cut -d"|" -f3`
echo $result
;;

Com_show_create_func)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_create_func"|cut -d"|" -f3`
echo $result
;;

Com_show_create_proc)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_create_proc"|cut -d"|" -f3`
echo $result
;;

Com_show_create_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_create_table"|cut -d"|" -f3`
echo $result
;;

Com_show_create_trigger)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_create_trigger"|cut -d"|" -f3`
echo $result
;;

Com_show_databases)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_databases"|cut -d"|" -f3`
echo $result
;;

Com_show_engine_logs)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_engine_logs"|cut -d"|" -f3`
echo $result
;;

Com_show_engine_mutex)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_engine_mutex"|cut -d"|" -f3`
echo $result
;;

Com_show_engine_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_engine_status"|cut -d"|" -f3`
echo $result
;;

Com_show_events)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_events"|cut -d"|" -f3`
echo $result
;;

Com_show_errors)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_errors"|cut -d"|" -f3`
echo $result
;;

Com_show_fields)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_fields"|cut -d"|" -f3`
echo $result
;;

Com_show_function_code)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_function_code"|cut -d"|" -f3`
echo $result
;;

Com_show_function_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_function_status"|cut -d"|" -f3`
echo $result
;;

Com_show_grants)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_grants"|cut -d"|" -f3`
echo $result
;;

Com_show_keys)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_keys"|cut -d"|" -f3`
echo $result
;;

Com_show_master_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_master_status"|cut -d"|" -f3`
echo $result
;;

Com_show_open_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_open_tables"|cut -d"|" -f3`
echo $result
;;

Com_show_plugins)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_plugins"|cut -d"|" -f3`
echo $result
;;

Com_show_privileges)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_privileges"|cut -d"|" -f3`
echo $result
;;

Com_show_procedure_code)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_procedure_code"|cut -d"|" -f3`
echo $result
;;

Com_show_procedure_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_procedure_status"|cut -d"|" -f3`
echo $result
;;

Com_show_processlist)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_processlist"|cut -d"|" -f3`
echo $result
;;

Com_show_profile)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_profile"|cut -d"|" -f3`
echo $result
;;

Com_show_profiles)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_profiles"|cut -d"|" -f3`
echo $result
;;

Com_show_relaylog_events)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_relaylog_events"|cut -d"|" -f3`
echo $result
;;

Com_show_slave_hosts)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_slave_hosts"|cut -d"|" -f3`
echo $result
;;

Com_show_slave_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_slave_status"|cut -d"|" -f3`
echo $result
;;

Com_show_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_status"|cut -d"|" -f3`
echo $result
;;

Com_show_storage_engines)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_storage_engines"|cut -d"|" -f3`
echo $result
;;

Com_show_table_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_table_status"|cut -d"|" -f3`
echo $result
;;

Com_show_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_tables"|cut -d"|" -f3`
echo $result
;;

Com_show_triggers)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_triggers"|cut -d"|" -f3`
echo $result
;;

Com_show_variables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_variables"|cut -d"|" -f3`
echo $result
;;

Com_show_warnings)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_warnings"|cut -d"|" -f3`
echo $result
;;

Com_show_create_user)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_show_create_user"|cut -d"|" -f3`
echo $result
;;

Com_shutdown)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_shutdown"|cut -d"|" -f3`
echo $result
;;

Com_slave_start)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_slave_start"|cut -d"|" -f3`
echo $result
;;

Com_slave_stop)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_slave_stop"|cut -d"|" -f3`
echo $result
;;

Com_group_replication_start)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_group_replication_start"|cut -d"|" -f3`
echo $result
;;

Com_group_replication_stop)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_group_replication_stop"|cut -d"|" -f3`
echo $result
;;

Com_stmt_execute)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_stmt_execute"|cut -d"|" -f3`
echo $result
;;

Com_stmt_close)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_stmt_close"|cut -d"|" -f3`
echo $result
;;

Com_stmt_fetch)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_stmt_fetch"|cut -d"|" -f3`
echo $result
;;

Com_stmt_prepare)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_stmt_prepare"|cut -d"|" -f3`
echo $result
;;

Com_stmt_reset)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_stmt_reset"|cut -d"|" -f3`
echo $result
;;

Com_stmt_send_long_data)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_stmt_send_long_data"|cut -d"|" -f3`
echo $result
;;

Com_truncate)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_truncate"|cut -d"|" -f3`
echo $result
;;

Com_uninstall_plugin)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_uninstall_plugin"|cut -d"|" -f3`
echo $result
;;

Com_unlock_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_unlock_tables"|cut -d"|" -f3`
echo $result
;;

Com_update)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_update"|cut -d"|" -f3`
echo $result
;;

Com_update_multi)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_update_multi"|cut -d"|" -f3`
echo $result
;;

Com_xa_commit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_xa_commit"|cut -d"|" -f3`
echo $result
;;

Com_xa_end)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_xa_end"|cut -d"|" -f3`
echo $result
;;

Com_xa_prepare)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_xa_prepare"|cut -d"|" -f3`
echo $result
;;

Com_xa_recover)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_xa_recover"|cut -d"|" -f3`
echo $result
;;

Com_xa_rollback)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_xa_rollback"|cut -d"|" -f3`
echo $result
;;

Com_xa_start)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_xa_start"|cut -d"|" -f3`
echo $result
;;

Com_stmt_reprepare)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Com_stmt_reprepare"|cut -d"|" -f3`
echo $result
;;

Compression)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Compression"|cut -d"|" -f3`
echo $result
;;

Connection_errors_accept)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Connection_errors_accept"|cut -d"|" -f3`
echo $result
;;

Connection_errors_internal)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Connection_errors_internal"|cut -d"|" -f3`
echo $result
;;

Connection_errors_max_connections)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Connection_errors_max_connections"|cut -d"|" -f3`
echo $result
;;

Connection_errors_peer_address)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Connection_errors_peer_address"|cut -d"|" -f3`
echo $result
;;

Connection_errors_select)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Connection_errors_select"|cut -d"|" -f3`
echo $result
;;

Connection_errors_tcpwrap)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Connection_errors_tcpwrap"|cut -d"|" -f3`
echo $result
;;

Connections)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Connections"|cut -d"|" -f3`
echo $result
;;

Created_tmp_disk_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Created_tmp_disk_tables"|cut -d"|" -f3`
echo $result
;;

Created_tmp_files)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Created_tmp_files"|cut -d"|" -f3`
echo $result
;;

Created_tmp_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Created_tmp_tables"|cut -d"|" -f3`
echo $result
;;

Delayed_errors)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Delayed_errors"|cut -d"|" -f3`
echo $result
;;

Delayed_insert_threads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Delayed_insert_threads"|cut -d"|" -f3`
echo $result
;;

Delayed_writes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Delayed_writes"|cut -d"|" -f3`
echo $result
;;

Flush_commands)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Flush_commands"|cut -d"|" -f3`
echo $result
;;

Handler_commit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_commit"|cut -d"|" -f3`
echo $result
;;

Handler_delete)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_delete"|cut -d"|" -f3`
echo $result
;;

Handler_discover)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_discover"|cut -d"|" -f3`
echo $result
;;

Handler_external_lock)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_external_lock"|cut -d"|" -f3`
echo $result
;;

Handler_mrr_init)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_mrr_init"|cut -d"|" -f3`
echo $result
;;

Handler_prepare)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_prepare"|cut -d"|" -f3`
echo $result
;;

Handler_read_first)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_read_first"|cut -d"|" -f3`
echo $result
;;

Handler_read_key)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_read_key"|cut -d"|" -f3`
echo $result
;;

Handler_read_last)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_read_last"|cut -d"|" -f3`
echo $result
;;

Handler_read_next)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_read_next"|cut -d"|" -f3`
echo $result
;;

Handler_read_prev)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_read_prev"|cut -d"|" -f3`
echo $result
;;

Handler_read_rnd)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_read_rnd"|cut -d"|" -f3`
echo $result
;;

Handler_read_rnd_next)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_read_rnd_next"|cut -d"|" -f3`
echo $result
;;

Handler_rollback)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_rollback"|cut -d"|" -f3`
echo $result
;;

Handler_savepoint)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_savepoint"|cut -d"|" -f3`
echo $result
;;

Handler_savepoint_rollback)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_savepoint_rollback"|cut -d"|" -f3`
echo $result
;;

Handler_update)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_update"|cut -d"|" -f3`
echo $result
;;

Handler_write)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Handler_write"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_dump_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_dump_status"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_load_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_load_status"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_resize_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_resize_status"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_pages_data)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_pages_data"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_bytes_data)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_bytes_data"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_pages_dirty)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_pages_dirty"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_bytes_dirty)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_bytes_dirty"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_pages_flushed)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_pages_flushed"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_pages_free)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_pages_free"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_pages_misc)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_pages_misc"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_pages_total)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_pages_total"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_read_ahead_rnd)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_read_ahead_rnd"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_read_ahead)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_read_ahead"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_read_ahead_evicted)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_read_ahead_evicted"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_read_requests)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_read_requests"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_reads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_reads"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_wait_free)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_wait_free"|cut -d"|" -f3`
echo $result
;;

Innodb_buffer_pool_write_requests)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_buffer_pool_write_requests"|cut -d"|" -f3`
echo $result
;;

Innodb_data_fsyncs)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_data_fsyncs"|cut -d"|" -f3`
echo $result
;;

Innodb_data_pending_fsyncs)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_data_pending_fsyncs"|cut -d"|" -f3`
echo $result
;;

Innodb_data_pending_reads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_data_pending_reads"|cut -d"|" -f3`
echo $result
;;

Innodb_data_pending_writes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_data_pending_writes"|cut -d"|" -f3`
echo $result
;;

Innodb_data_read)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_data_read"|cut -d"|" -f3`
echo $result
;;

Innodb_data_reads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_data_reads"|cut -d"|" -f3`
echo $result
;;

Innodb_data_writes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_data_writes"|cut -d"|" -f3`
echo $result
;;

Innodb_data_written)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_data_written"|cut -d"|" -f3`
echo $result
;;

Innodb_dblwr_pages_written)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_dblwr_pages_written"|cut -d"|" -f3`
echo $result
;;

Innodb_dblwr_writes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_dblwr_writes"|cut -d"|" -f3`
echo $result
;;

Innodb_log_waits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_log_waits"|cut -d"|" -f3`
echo $result
;;

Innodb_log_write_requests)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_log_write_requests"|cut -d"|" -f3`
echo $result
;;

Innodb_log_writes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_log_writes"|cut -d"|" -f3`
echo $result
;;

Innodb_os_log_fsyncs)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_os_log_fsyncs"|cut -d"|" -f3`
echo $result
;;

Innodb_os_log_pending_fsyncs)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_os_log_pending_fsyncs"|cut -d"|" -f3`
echo $result
;;

Innodb_os_log_pending_writes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_os_log_pending_writes"|cut -d"|" -f3`
echo $result
;;

Innodb_os_log_written)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_os_log_written"|cut -d"|" -f3`
echo $result
;;

Innodb_page_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_page_size"|cut -d"|" -f3`
echo $result
;;

Innodb_pages_created)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_pages_created"|cut -d"|" -f3`
echo $result
;;

Innodb_pages_read)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_pages_read"|cut -d"|" -f3`
echo $result
;;

Innodb_pages_written)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_pages_written"|cut -d"|" -f3`
echo $result
;;

Innodb_row_lock_current_waits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_row_lock_current_waits"|cut -d"|" -f3`
echo $result
;;

Innodb_row_lock_time)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_row_lock_time"|cut -d"|" -f3`
echo $result
;;

Innodb_row_lock_time_avg)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_row_lock_time_avg"|cut -d"|" -f3`
echo $result
;;

Innodb_row_lock_time_max)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_row_lock_time_max"|cut -d"|" -f3`
echo $result
;;

Innodb_row_lock_waits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_row_lock_waits"|cut -d"|" -f3`
echo $result
;;

Innodb_rows_deleted)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_rows_deleted"|cut -d"|" -f3`
echo $result
;;

Innodb_rows_inserted)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_rows_inserted"|cut -d"|" -f3`
echo $result
;;

Innodb_rows_read)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_rows_read"|cut -d"|" -f3`
echo $result
;;

Innodb_rows_updated)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_rows_updated"|cut -d"|" -f3`
echo $result
;;

Innodb_num_open_files)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_num_open_files"|cut -d"|" -f3`
echo $result
;;

Innodb_truncated_status_writes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_truncated_status_writes"|cut -d"|" -f3`
echo $result
;;

Innodb_available_undo_logs)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Innodb_available_undo_logs"|cut -d"|" -f3`
echo $result
;;

Key_blocks_not_flushed)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Key_blocks_not_flushed"|cut -d"|" -f3`
echo $result
;;

Key_blocks_unused)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Key_blocks_unused"|cut -d"|" -f3`
echo $result
;;

Key_blocks_used)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Key_blocks_used"|cut -d"|" -f3`
echo $result
;;

Key_read_requests)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Key_read_requests"|cut -d"|" -f3`
echo $result
;;

Key_reads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Key_reads"|cut -d"|" -f3`
echo $result
;;

Key_write_requests)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Key_write_requests"|cut -d"|" -f3`
echo $result
;;

Key_writes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Key_writes"|cut -d"|" -f3`
echo $result
;;

Last_query_cost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Last_query_cost"|cut -d"|" -f3`
echo $result
;;

Last_query_partial_plans)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Last_query_partial_plans"|cut -d"|" -f3`
echo $result
;;

Locked_connects)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Locked_connects"|cut -d"|" -f3`
echo $result
;;

Max_execution_time_exceeded)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Max_execution_time_exceeded"|cut -d"|" -f3`
echo $result
;;

Max_execution_time_set)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Max_execution_time_set"|cut -d"|" -f3`
echo $result
;;

Max_execution_time_set_failed)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Max_execution_time_set_failed"|cut -d"|" -f3`
echo $result
;;

Max_used_connections)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Max_used_connections"|cut -d"|" -f3`
echo $result
;;

Max_used_connections_time)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Max_used_connections_time"|cut -d"|" -f3`
echo $result
;;

Not_flushed_delayed_rows)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Not_flushed_delayed_rows"|cut -d"|" -f3`
echo $result
;;

Ongoing_anonymous_transaction_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ongoing_anonymous_transaction_count"|cut -d"|" -f3`
echo $result
;;

Open_files)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Open_files"|cut -d"|" -f3`
echo $result
;;

Open_streams)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Open_streams"|cut -d"|" -f3`
echo $result
;;

Open_table_definitions)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Open_table_definitions"|cut -d"|" -f3`
echo $result
;;

Open_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Open_tables"|cut -d"|" -f3`
echo $result
;;

Opened_files)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Opened_files"|cut -d"|" -f3`
echo $result
;;

Opened_table_definitions)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Opened_table_definitions"|cut -d"|" -f3`
echo $result
;;

Opened_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Opened_tables"|cut -d"|" -f3`
echo $result
;;

Performance_schema_accounts_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_accounts_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_cond_classes_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_cond_classes_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_cond_instances_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_cond_instances_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_digest_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_digest_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_file_classes_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_file_classes_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_file_handles_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_file_handles_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_file_instances_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_file_instances_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_hosts_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_hosts_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_index_stat_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_index_stat_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_locker_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_locker_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_memory_classes_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_memory_classes_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_metadata_lock_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_metadata_lock_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_mutex_classes_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_mutex_classes_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_mutex_instances_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_mutex_instances_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_nested_statement_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_nested_statement_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_prepared_statements_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_prepared_statements_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_program_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_program_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_rwlock_classes_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_rwlock_classes_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_rwlock_instances_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_rwlock_instances_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_session_connect_attrs_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_session_connect_attrs_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_socket_classes_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_socket_classes_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_socket_instances_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_socket_instances_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_stage_classes_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_stage_classes_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_statement_classes_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_statement_classes_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_table_handles_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_table_handles_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_table_instances_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_table_instances_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_table_lock_stat_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_table_lock_stat_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_thread_classes_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_thread_classes_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_thread_instances_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_thread_instances_lost"|cut -d"|" -f3`
echo $result
;;

Performance_schema_users_lost)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Performance_schema_users_lost"|cut -d"|" -f3`
echo $result
;;

Prepared_stmt_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Prepared_stmt_count"|cut -d"|" -f3`
echo $result
;;

Qcache_free_blocks)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Qcache_free_blocks"|cut -d"|" -f3`
echo $result
;;

Qcache_free_memory)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Qcache_free_memory"|cut -d"|" -f3`
echo $result
;;

Qcache_hits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Qcache_hits"|cut -d"|" -f3`
echo $result
;;

Qcache_inserts)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Qcache_inserts"|cut -d"|" -f3`
echo $result
;;

Qcache_lowmem_prunes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Qcache_lowmem_prunes"|cut -d"|" -f3`
echo $result
;;

Qcache_not_cached)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Qcache_not_cached"|cut -d"|" -f3`
echo $result
;;

Qcache_queries_in_cache)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Qcache_queries_in_cache"|cut -d"|" -f3`
echo $result
;;

Qcache_total_blocks)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Qcache_total_blocks"|cut -d"|" -f3`
echo $result
;;

Queries)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Queries"|cut -d"|" -f3`
echo $result
;;

Questions)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Questions"|cut -d"|" -f3`
echo $result
;;

Select_full_join)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Select_full_join"|cut -d"|" -f3`
echo $result
;;

Select_full_range_join)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Select_full_range_join"|cut -d"|" -f3`
echo $result
;;

Select_range)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Select_range"|cut -d"|" -f3`
echo $result
;;

Select_range_check)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Select_range_check"|cut -d"|" -f3`
echo $result
;;

Select_scan)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Select_scan"|cut -d"|" -f3`
echo $result
;;

Slave_open_temp_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Slave_open_temp_tables"|cut -d"|" -f3`
echo $result
;;

Slow_launch_threads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Slow_launch_threads"|cut -d"|" -f3`
echo $result
;;

Slow_queries)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Slow_queries"|cut -d"|" -f3`
echo $result
;;

Sort_merge_passes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Sort_merge_passes"|cut -d"|" -f3`
echo $result
;;

Sort_range)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Sort_range"|cut -d"|" -f3`
echo $result
;;

Sort_rows)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Sort_rows"|cut -d"|" -f3`
echo $result
;;

Sort_scan)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Sort_scan"|cut -d"|" -f3`
echo $result
;;

Ssl_accept_renegotiates)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_accept_renegotiates"|cut -d"|" -f3`
echo $result
;;

Ssl_accepts)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_accepts"|cut -d"|" -f3`
echo $result
;;

Ssl_callback_cache_hits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_callback_cache_hits"|cut -d"|" -f3`
echo $result
;;

Ssl_cipher)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_cipher"|cut -d"|" -f3`
echo $result
;;

Ssl_cipher_list)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_cipher_list"|cut -d"|" -f3`
echo $result
;;

Ssl_client_connects)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_client_connects"|cut -d"|" -f3`
echo $result
;;

Ssl_connect_renegotiates)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_connect_renegotiates"|cut -d"|" -f3`
echo $result
;;

Ssl_ctx_verify_depth)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_ctx_verify_depth"|cut -d"|" -f3`
echo $result
;;

Ssl_ctx_verify_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_ctx_verify_mode"|cut -d"|" -f3`
echo $result
;;

Ssl_default_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_default_timeout"|cut -d"|" -f3`
echo $result
;;

Ssl_finished_accepts)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_finished_accepts"|cut -d"|" -f3`
echo $result
;;

Ssl_finished_connects)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_finished_connects"|cut -d"|" -f3`
echo $result
;;

Ssl_server_not_after)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_server_not_after"|cut -d"|" -f3`
echo $result
;;

Ssl_server_not_before)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_server_not_before"|cut -d"|" -f3`
echo $result
;;

Ssl_session_cache_hits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_session_cache_hits"|cut -d"|" -f3`
echo $result
;;

Ssl_session_cache_misses)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_session_cache_misses"|cut -d"|" -f3`
echo $result
;;

Ssl_session_cache_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_session_cache_mode"|cut -d"|" -f3`
echo $result
;;

Ssl_session_cache_overflows)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_session_cache_overflows"|cut -d"|" -f3`
echo $result
;;

Ssl_session_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_session_cache_size"|cut -d"|" -f3`
echo $result
;;

Ssl_session_cache_timeouts)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_session_cache_timeouts"|cut -d"|" -f3`
echo $result
;;

Ssl_sessions_reused)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_sessions_reused"|cut -d"|" -f3`
echo $result
;;

Ssl_used_session_cache_entries)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_used_session_cache_entries"|cut -d"|" -f3`
echo $result
;;

Ssl_verify_depth)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_verify_depth"|cut -d"|" -f3`
echo $result
;;

Ssl_verify_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_verify_mode"|cut -d"|" -f3`
echo $result
;;

Ssl_version)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Ssl_version"|cut -d"|" -f3`
echo $result
;;

Table_locks_immediate)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Table_locks_immediate"|cut -d"|" -f3`
echo $result
;;

Table_locks_waited)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Table_locks_waited"|cut -d"|" -f3`
echo $result
;;

Table_open_cache_hits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Table_open_cache_hits"|cut -d"|" -f3`
echo $result
;;

Table_open_cache_misses)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Table_open_cache_misses"|cut -d"|" -f3`
echo $result
;;

Table_open_cache_overflows)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Table_open_cache_overflows"|cut -d"|" -f3`
echo $result
;;

Tc_log_max_pages_used)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Tc_log_max_pages_used"|cut -d"|" -f3`
echo $result
;;

Tc_log_page_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Tc_log_page_size"|cut -d"|" -f3`
echo $result
;;

Tc_log_page_waits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Tc_log_page_waits"|cut -d"|" -f3`
echo $result
;;

Threads_cached)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Threads_cached"|cut -d"|" -f3`
echo $result
;;

Threads_connected)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Threads_connected"|cut -d"|" -f3`
echo $result
;;

Threads_created)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Threads_created"|cut -d"|" -f3`
echo $result
;;

Threads_running)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Threads_running"|cut -d"|" -f3`
echo $result
;;

Uptime)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Uptime"|cut -d"|" -f3`
echo $result
;;

Uptime_since_flush_status)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK extended-status |grep -w "Uptime_since_flush_status"|cut -d"|" -f3`
echo $result
;;

status_log_queries_not_using_indexes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_queries_not_using_indexes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
status_general_log)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "general_log" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
*)
echo "Usage:$0(Uptime|Com_update|Slow_queries|Com_select|Com_rollback|Questions)"
;;
esac

huoyuanshen

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
mysql监控的chk_mysql.sh脚本内容for show status

该脚本内容比网上的更全，包括zabbix模板中参数和mysql5.7的show status命令全部参数，部分show variables参数。对于后期追加监控参数，可以避免在该脚本中添加监控项的操作。#!/bin/sh# -------------------------------------------------------------------------------# F
复制链接

扫一扫

专栏目录