mysql监控的chk_mysql.sh脚本内容for show variables
来源：互联网 发布：怎么看端口是否被占用 编辑：程序博客网 时间：2024/05/22 01:41
包含所有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
auto_increment_increment)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "auto_increment_increment" |cut -d"|" -f3 | sed s/[[:space:]]//g `echo $result
;;
auto_increment_offset)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "auto_increment_offset" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
autocommit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "autocommit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
automatic_sp_privileges)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "automatic_sp_privileges" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
avoid_temporal_upgrade)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "avoid_temporal_upgrade" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
back_log)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "back_log" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
basedir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "basedir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
big_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "big_tables" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
bind_address)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "bind_address" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_checksum)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_checksum" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_direct_non_transactional_updates)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_direct_non_transactional_updates" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_error_action)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_error_action" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_format)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_format" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_group_commit_sync_delay)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_group_commit_sync_delay" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_group_commit_sync_no_delay_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_group_commit_sync_no_delay_count" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_gtid_simple_recovery)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_gtid_simple_recovery" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_max_flush_queue_time)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_max_flush_queue_time" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_order_commits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_order_commits" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_row_image)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_row_image" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_rows_query_log_events)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_rows_query_log_events" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
binlog_stmt_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "binlog_stmt_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
block_encryption_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "block_encryption_mode" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
bulk_insert_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "bulk_insert_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
character_set_client)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "character_set_client" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
character_set_connection)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "character_set_connection" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
character_set_database)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "character_set_database" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
character_set_filesystem)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "character_set_filesystem" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
character_set_results)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "character_set_results" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
character_set_server)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "character_set_server" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
character_set_system)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "character_set_system" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
character_sets_dir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "character_sets_dir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
check_proxy_users)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "check_proxy_users" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
collation_connection)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "collation_connection" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
collation_database)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "collation_database" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
collation_server)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "collation_server" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
completion_type)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "completion_type" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
concurrent_insert)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "concurrent_insert" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
connect_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "connect_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
core_file)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "core_file" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
datadir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "datadir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
date_format)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "date_format" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
datetime_format)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "datetime_format" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
default_authentication_plugin)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "default_authentication_plugin" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
default_password_lifetime)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "default_password_lifetime" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
default_storage_engine)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "default_storage_engine" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
default_tmp_storage_engine)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "default_tmp_storage_engine" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
default_week_format)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "default_week_format" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
delay_key_write)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "delay_key_write" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
delayed_insert_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "delayed_insert_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
delayed_insert_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "delayed_insert_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
delayed_queue_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "delayed_queue_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
disabled_storage_engines)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "disabled_storage_engines" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
disconnect_on_expired_password)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "disconnect_on_expired_password" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
div_precision_increment)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "div_precision_increment" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
end_markers_in_json)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "end_markers_in_json" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
enforce_gtid_consistency)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "enforce_gtid_consistency" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
eq_range_index_dive_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "eq_range_index_dive_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
error_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "error_count" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
event_scheduler)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "event_scheduler" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
expire_logs_days)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "expire_logs_days" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
explicit_defaults_for_timestamp)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "explicit_defaults_for_timestamp" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
external_user)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "external_user" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
flush)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "flush" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
flush_time)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "flush_time" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
foreign_key_checks)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "foreign_key_checks" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ft_boolean_syntax)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ft_boolean_syntax" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ft_max_word_len)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ft_max_word_len" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ft_min_word_len)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ft_min_word_len" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ft_query_expansion_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ft_query_expansion_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ft_stopword_file)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ft_stopword_file" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
general_log)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "general_log" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
general_log_file)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "general_log_file" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
group_concat_max_len)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "group_concat_max_len" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
gtid_executed_compression_period)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "gtid_executed_compression_period" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
gtid_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "gtid_mode" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
gtid_next)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "gtid_next" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
gtid_owned)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "gtid_owned" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
gtid_purged)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "gtid_purged" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_compress)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_compress" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_crypt)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_crypt" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_dynamic_loading)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_dynamic_loading" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_geometry)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_geometry" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_openssl)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_openssl" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_profiling)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_profiling" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_query_cache)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_query_cache" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_rtree_keys)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_rtree_keys" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_ssl)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_ssl" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_statement_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_statement_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
have_symlink)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "have_symlink" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
host_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "host_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
hostname)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "hostname" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
identity)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "identity" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ignore_builtin_innodb)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ignore_builtin_innodb" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ignore_db_dirs)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ignore_db_dirs" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
init_connect)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "init_connect" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
init_file)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "init_file" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
init_slave)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "init_slave" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_adaptive_flushing)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_adaptive_flushing" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_adaptive_flushing_lwm)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_adaptive_flushing_lwm" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_adaptive_hash_index)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_adaptive_hash_index" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_adaptive_hash_index_parts)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_adaptive_hash_index_parts" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_adaptive_max_sleep_delay)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_adaptive_max_sleep_delay" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_api_bk_commit_interval)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_api_bk_commit_interval" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_api_disable_rowlock)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_api_disable_rowlock" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_api_enable_binlog)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_api_enable_binlog" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_api_enable_mdl)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_api_enable_mdl" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_api_trx_level)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_api_trx_level" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_autoextend_increment)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_autoextend_increment" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_autoinc_lock_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_autoinc_lock_mode" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_chunk_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_chunk_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_dump_at_shutdown)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_dump_at_shutdown" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_dump_now)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_dump_now" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_dump_pct)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_dump_pct" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_filename)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_filename" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_load_abort)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_load_abort" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_load_at_startup)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_load_at_startup" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_load_now)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_load_now" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_buffer_pool_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_buffer_pool_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_change_buffer_max_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_change_buffer_max_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_change_buffering)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_change_buffering" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_checksum_algorithm)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_checksum_algorithm" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_checksums)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_checksums" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_cmp_per_index_enabled)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_cmp_per_index_enabled" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_commit_concurrency)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_commit_concurrency" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_compression_failure_threshold_pct)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_compression_failure_threshold_pct" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_compression_level)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_compression_level" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_compression_pad_pct_max)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_compression_pad_pct_max" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_concurrency_tickets)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_concurrency_tickets" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_data_file_path)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_data_file_path" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_data_home_dir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_data_home_dir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_deadlock_detect)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_deadlock_detect" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_default_row_format)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_default_row_format" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_disable_sort_file_cache)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_disable_sort_file_cache" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_doublewrite)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_doublewrite" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_fast_shutdown)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_fast_shutdown" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_file_format)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_file_format" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_file_format_check)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_file_format_check" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_file_format_max)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_file_format_max" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_file_per_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_file_per_table" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_fill_factor)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_fill_factor" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_flush_log_at_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_flush_log_at_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_flush_log_at_trx_commit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_flush_log_at_trx_commit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_flush_method)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_flush_method" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_flush_neighbors)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_flush_neighbors" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_flush_sync)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_flush_sync" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_flushing_avg_loops)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_flushing_avg_loops" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_force_load_corrupted)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_force_load_corrupted" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_force_recovery)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_force_recovery" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_aux_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_aux_table" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_enable_diag_print)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_enable_diag_print" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_enable_stopword)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_enable_stopword" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_max_token_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_max_token_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_min_token_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_min_token_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_num_word_optimize)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_num_word_optimize" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_result_cache_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_result_cache_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_server_stopword_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_server_stopword_table" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_sort_pll_degree)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_sort_pll_degree" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_total_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_total_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_ft_user_stopword_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_ft_user_stopword_table" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_io_capacity)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_io_capacity" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_io_capacity_max)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_io_capacity_max" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_large_prefix)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_large_prefix" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_lock_wait_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_lock_wait_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_locks_unsafe_for_binlog)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_locks_unsafe_for_binlog" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_log_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_log_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_log_checksums)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_log_checksums" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_log_compressed_pages)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_log_compressed_pages" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_log_file_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_log_file_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_log_files_in_group)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_log_files_in_group" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_log_group_home_dir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_log_group_home_dir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_log_write_ahead_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_log_write_ahead_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_lru_scan_depth)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_lru_scan_depth" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_max_dirty_pages_pct)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_max_dirty_pages_pct" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_max_dirty_pages_pct_lwm)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_max_dirty_pages_pct_lwm" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_max_purge_lag)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_max_purge_lag" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_max_purge_lag_delay)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_max_purge_lag_delay" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_max_undo_log_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_max_undo_log_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_monitor_disable)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_monitor_disable" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_monitor_enable)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_monitor_enable" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_monitor_reset)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_monitor_reset" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_monitor_reset_all)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_monitor_reset_all" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_old_blocks_pct)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_old_blocks_pct" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_old_blocks_time)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_old_blocks_time" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_online_alter_log_max_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_online_alter_log_max_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_open_files)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_open_files" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_optimize_fulltext_only)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_optimize_fulltext_only" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_page_cleaners)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_page_cleaners" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_page_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_page_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_print_all_deadlocks)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_print_all_deadlocks" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_purge_batch_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_purge_batch_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_purge_rseg_truncate_frequency)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_purge_rseg_truncate_frequency" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_purge_threads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_purge_threads" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_random_read_ahead)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_random_read_ahead" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_read_ahead_threshold)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_read_ahead_threshold" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_read_io_threads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_read_io_threads" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_read_only)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_read_only" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_replication_delay)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_replication_delay" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_rollback_on_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_rollback_on_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_rollback_segments)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_rollback_segments" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_sort_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_sort_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_spin_wait_delay)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_spin_wait_delay" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_stats_auto_recalc)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_stats_auto_recalc" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_stats_method)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_stats_method" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_stats_on_metadata)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_stats_on_metadata" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_stats_persistent)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_stats_persistent" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_stats_persistent_sample_pages)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_stats_persistent_sample_pages" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_stats_sample_pages)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_stats_sample_pages" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_stats_transient_sample_pages)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_stats_transient_sample_pages" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_status_output)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_status_output" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_status_output_locks)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_status_output_locks" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_strict_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_strict_mode" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_support_xa)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_support_xa" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_sync_array_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_sync_array_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_sync_spin_loops)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_sync_spin_loops" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_table_locks)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_table_locks" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_temp_data_file_path)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_temp_data_file_path" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_thread_concurrency)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_thread_concurrency" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_thread_sleep_delay)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_thread_sleep_delay" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_tmpdir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_tmpdir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_undo_directory)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_undo_directory" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_undo_log_truncate)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_undo_log_truncate" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_undo_logs)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_undo_logs" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_undo_tablespaces)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_undo_tablespaces" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_use_native_aio)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_use_native_aio" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_version)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_version" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
innodb_write_io_threads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "innodb_write_io_threads" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
insert_id)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "insert_id" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
interactive_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "interactive_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
internal_tmp_disk_storage_engine)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "internal_tmp_disk_storage_engine" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
join_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "join_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
keep_files_on_create)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "keep_files_on_create" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
key_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "key_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
key_cache_age_threshold)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "key_cache_age_threshold" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
key_cache_block_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "key_cache_block_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
key_cache_division_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "key_cache_division_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
large_files_support)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "large_files_support" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
large_page_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "large_page_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
large_pages)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "large_pages" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
last_insert_id)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "last_insert_id" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
lc_messages)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "lc_messages" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
lc_messages_dir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "lc_messages_dir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
lc_time_names)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "lc_time_names" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
license)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "license" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
local_infile)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "local_infile" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
lock_wait_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "lock_wait_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
locked_in_memory)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "locked_in_memory" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_bin)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_bin" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_bin_basename)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_bin_basename" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_bin_index)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_bin_index" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_bin_trust_function_creators)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_bin_trust_function_creators" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_bin_use_v1_row_events)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_bin_use_v1_row_events" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_builtin_as_identified_by_password)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_builtin_as_identified_by_password" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_error)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_error" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_error_verbosity)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_error_verbosity" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_output)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_output" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
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
;;
log_slave_updates)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_slave_updates" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_slow_admin_statements)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_slow_admin_statements" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_slow_slave_statements)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_slow_slave_statements" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_statements_unsafe_for_binlog)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_statements_unsafe_for_binlog" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_syslog)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_syslog" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_syslog_facility)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_syslog_facility" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_syslog_include_pid)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_syslog_include_pid" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_syslog_tag)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_syslog_tag" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_throttle_queries_not_using_indexes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_throttle_queries_not_using_indexes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_timestamps)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_timestamps" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
log_warnings)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "log_warnings" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
long_query_time)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "long_query_time" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
low_priority_updates)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "low_priority_updates" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
lower_case_file_system)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "lower_case_file_system" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
lower_case_table_names)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "lower_case_table_names" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
master_info_repository)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "master_info_repository" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
master_verify_checksum)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "master_verify_checksum" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_allowed_packet)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_allowed_packet" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_binlog_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_binlog_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_binlog_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_binlog_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_binlog_stmt_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_binlog_stmt_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_connect_errors)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_connect_errors" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_connections)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_connections" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_delayed_threads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_delayed_threads" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_digest_length)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_digest_length" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_error_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_error_count" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_execution_time)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_execution_time" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_heap_table_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_heap_table_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_insert_delayed_threads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_insert_delayed_threads" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_join_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_join_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_length_for_sort_data)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_length_for_sort_data" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_points_in_geometry)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_points_in_geometry" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_prepared_stmt_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_prepared_stmt_count" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_relay_log_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_relay_log_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_seeks_for_key)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_seeks_for_key" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_sort_length)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_sort_length" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_sp_recursion_depth)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_sp_recursion_depth" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_tmp_tables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_tmp_tables" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_user_connections)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_user_connections" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
max_write_lock_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "max_write_lock_count" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
metadata_locks_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "metadata_locks_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
metadata_locks_hash_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "metadata_locks_hash_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
min_examined_row_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "min_examined_row_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
multi_range_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "multi_range_count" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
myisam_data_pointer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "myisam_data_pointer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
myisam_max_sort_file_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "myisam_max_sort_file_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
myisam_mmap_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "myisam_mmap_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
myisam_recover_options)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "myisam_recover_options" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
myisam_repair_threads)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "myisam_repair_threads" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
myisam_sort_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "myisam_sort_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
myisam_stats_method)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "myisam_stats_method" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
myisam_use_mmap)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "myisam_use_mmap" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
mysql_native_password_proxy_users)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "mysql_native_password_proxy_users" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
net_buffer_length)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "net_buffer_length" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
net_read_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "net_read_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
net_retry_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "net_retry_count" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
net_write_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "net_write_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
new)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "new" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ngram_token_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ngram_token_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
offline_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "offline_mode" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
old)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "old" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
old_alter_table)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "old_alter_table" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
old_passwords)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "old_passwords" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
open_files_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "open_files_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
optimizer_prune_level)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "optimizer_prune_level" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
optimizer_search_depth)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "optimizer_search_depth" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
optimizer_switch)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "optimizer_switch" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
optimizer_trace)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "optimizer_trace" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
optimizer_trace_features)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "optimizer_trace_features" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
optimizer_trace_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "optimizer_trace_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
optimizer_trace_max_mem_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "optimizer_trace_max_mem_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
optimizer_trace_offset)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "optimizer_trace_offset" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
parser_max_mem_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "parser_max_mem_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_accounts_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_accounts_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_digests_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_digests_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_events_stages_history_long_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_events_stages_history_long_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_events_stages_history_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_events_stages_history_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_events_statements_history_long_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_events_statements_history_long_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_events_statements_history_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_events_statements_history_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_events_transactions_history_long_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_events_transactions_history_long_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_events_transactions_history_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_events_transactions_history_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_events_waits_history_long_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_events_waits_history_long_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_events_waits_history_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_events_waits_history_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_hosts_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_hosts_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_cond_classes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_cond_classes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_cond_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_cond_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_digest_length)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_digest_length" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_file_classes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_file_classes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_file_handles)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_file_handles" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_file_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_file_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_index_stat)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_index_stat" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_memory_classes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_memory_classes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_metadata_locks)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_metadata_locks" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_mutex_classes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_mutex_classes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_mutex_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_mutex_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_prepared_statements_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_prepared_statements_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_program_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_program_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_rwlock_classes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_rwlock_classes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_rwlock_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_rwlock_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_socket_classes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_socket_classes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_socket_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_socket_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_sql_text_length)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_sql_text_length" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_stage_classes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_stage_classes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_statement_classes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_statement_classes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_statement_stack)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_statement_stack" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_table_handles)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_table_handles" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_table_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_table_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_table_lock_stat)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_table_lock_stat" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_thread_classes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_thread_classes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_max_thread_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_max_thread_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_session_connect_attrs_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_session_connect_attrs_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_setup_actors_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_setup_actors_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_setup_objects_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_setup_objects_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
performance_schema_users_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "performance_schema_users_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
pid_file)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "pid_file" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
plugin_dir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "plugin_dir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
port)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "port" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
preload_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "preload_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
profiling)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "profiling" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
profiling_history_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "profiling_history_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
protocol_version)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "protocol_version" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
proxy_user)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "proxy_user" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
pseudo_slave_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "pseudo_slave_mode" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
pseudo_thread_id)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "pseudo_thread_id" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
query_alloc_block_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "query_alloc_block_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
query_cache_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "query_cache_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
query_cache_min_res_unit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "query_cache_min_res_unit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
query_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "query_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
query_cache_type)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "query_cache_type" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
query_cache_wlock_invalidate)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "query_cache_wlock_invalidate" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
query_prealloc_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "query_prealloc_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
rand_seed1)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "rand_seed1" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
rand_seed2)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "rand_seed2" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
range_alloc_block_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "range_alloc_block_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
range_optimizer_max_mem_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "range_optimizer_max_mem_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
rbr_exec_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "rbr_exec_mode" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
read_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "read_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
read_only)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "read_only" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
read_rnd_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "read_rnd_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
relay_log)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "relay_log" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
relay_log_basename)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "relay_log_basename" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
relay_log_index)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "relay_log_index" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
relay_log_info_file)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "relay_log_info_file" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
relay_log_info_repository)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "relay_log_info_repository" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
relay_log_purge)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "relay_log_purge" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
relay_log_recovery)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "relay_log_recovery" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
relay_log_space_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "relay_log_space_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
report_host)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "report_host" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
report_password)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "report_password" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
report_port)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "report_port" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
report_user)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "report_user" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
require_secure_transport)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "require_secure_transport" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
rpl_stop_slave_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "rpl_stop_slave_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
secure_auth)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "secure_auth" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
secure_file_priv)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "secure_file_priv" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
server_id)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "server_id" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
server_id_bits)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "server_id_bits" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
server_uuid)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "server_uuid" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
session_track_gtids)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "session_track_gtids" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
session_track_schema)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "session_track_schema" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
session_track_state_change)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "session_track_state_change" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
session_track_system_variables)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "session_track_system_variables" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
session_track_transaction_info)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "session_track_transaction_info" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sha256_password_proxy_users)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sha256_password_proxy_users" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
show_compatibility_56)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "show_compatibility_56" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
show_old_temporals)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "show_old_temporals" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
skip_external_locking)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "skip_external_locking" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
skip_name_resolve)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "skip_name_resolve" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
skip_networking)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "skip_networking" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
skip_show_database)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "skip_show_database" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_allow_batching)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_allow_batching" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_checkpoint_group)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_checkpoint_group" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_checkpoint_period)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_checkpoint_period" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_compressed_protocol)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_compressed_protocol" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_exec_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_exec_mode" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_load_tmpdir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_load_tmpdir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_max_allowed_packet)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_max_allowed_packet" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_net_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_net_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_parallel_type)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_parallel_type" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_parallel_workers)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_parallel_workers" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_pending_jobs_size_max)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_pending_jobs_size_max" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_preserve_commit_order)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_preserve_commit_order" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_rows_search_algorithms)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_rows_search_algorithms" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_skip_errors)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_skip_errors" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_sql_verify_checksum)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_sql_verify_checksum" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_transaction_retries)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_transaction_retries" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slave_type_conversions)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slave_type_conversions" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slow_launch_time)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slow_launch_time" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slow_query_log)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slow_query_log" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
slow_query_log_file)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "slow_query_log_file" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
socket)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "socket" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sort_buffer_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sort_buffer_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_auto_is_null)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_auto_is_null" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_big_selects)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_big_selects" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_buffer_result)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_buffer_result" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_log_bin)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_log_bin" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_log_off)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_log_off" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_mode)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_mode" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_notes)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_notes" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_quote_show_create)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_quote_show_create" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_safe_updates)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_safe_updates" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_select_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_select_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_slave_skip_counter)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_slave_skip_counter" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sql_warnings)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sql_warnings" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ssl_ca)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ssl_ca" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ssl_capath)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ssl_capath" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ssl_cert)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ssl_cert" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ssl_cipher)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ssl_cipher" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ssl_crl)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ssl_crl" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ssl_crlpath)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ssl_crlpath" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
ssl_key)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "ssl_key" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
stored_program_cache)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "stored_program_cache" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
super_read_only)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "super_read_only" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sync_binlog)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sync_binlog" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sync_frm)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sync_frm" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sync_master_info)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sync_master_info" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sync_relay_log)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sync_relay_log" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
sync_relay_log_info)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "sync_relay_log_info" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
system_time_zone)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "system_time_zone" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
table_definition_cache)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "table_definition_cache" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
table_open_cache)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "table_open_cache" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
table_open_cache_instances)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "table_open_cache_instances" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
thread_cache_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "thread_cache_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
thread_handling)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "thread_handling" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
thread_stack)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "thread_stack" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
time_format)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "time_format" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
time_zone)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "time_zone" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
timestamp)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "timestamp" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
tls_version)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "tls_version" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
tmp_table_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "tmp_table_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
tmpdir)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "tmpdir" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
transaction_alloc_block_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "transaction_alloc_block_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
transaction_allow_batching)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "transaction_allow_batching" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
transaction_prealloc_size)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "transaction_prealloc_size" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
transaction_write_set_extraction)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "transaction_write_set_extraction" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
tx_isolation)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "tx_isolation" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
tx_read_only)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "tx_read_only" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
unique_checks)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "unique_checks" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
updatable_views_with_limit)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "updatable_views_with_limit" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
version)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "version" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
version_comment)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "version_comment" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
version_compile_machine)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "version_compile_machine" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
version_compile_os)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "version_compile_os" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
wait_timeout)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "wait_timeout" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
warning_count)
result=`mysqladmin -h$MYSQL_HOST -S $MYSQL_SOCK variables |grep -w "warning_count" |cut -d"|" -f3 | sed s/[[:space:]]//g `
echo $result
;;
*)
echo "Usage:$0(Uptime|Com_update|Slow_queries|Com_select|Com_rollback|Questions)"
;;
esac
0 0
- mysql监控的chk_mysql.sh脚本内容for show variables
- mysql监控的chk_mysql.sh脚本内容for show status
- mysql的 show status 和 show variables
- mysql show variables
- MYSQL SHOW VARIABLES简介
- MYSQL SHOW VARIABLES简介
- MYSQL SHOW VARIABLES简介
- MYSQL SHOW VARIABLES简介
- MYSQL SHOW VARIABLES简介
- MYSQL SHOW VARIABLES简介
- MYSQL-SHOW VARIABLES 详解
- Temporary tables for SHOW VARIABLES in MySQL 5.0
- MySql之show status、show variables
- 利用mysql里的show global status和show variables来优化mysql的配置参数
- 利用mysql中show global status和show variables来优化mysql的配置参数
- mysql监控-常用的mysql监控脚本
- 如何利用mysql里的show global status和show variables来优化mysql的配置参数
- sh脚本监控网站状态
- JS设置页面下拉刷新
- java web项目内存溢出
- Qt之描绘轮廓
- Oracle存放时间问题
- SurfaceCreated不调用的解决方法
- mysql监控的chk_mysql.sh脚本内容for show variables
- tensorflow训练了10万次，运行完毕，对这个word2vec终于有点感觉了
- 常用工具脚本1
- samba配置
- opencv(16)---图像边缘检测
- Mysql笔记
- CentOS7下安装mysql-5.7.18
- neo4j jdbc连接数据库用http协议和bolt协议得到的数据不一样
- string容器
