printf_grid.sh格式化输出脚本-优快云博客

#!/bin/bash
##monitoring the mysql performance status ##
##created by jacobxian ##
##script in /home/mysql/scripts/status/mysqlstatus.sh ##
##change the UltraEdit row limit 4096 to 10000 /senior/configuration/normal/
## $1=1 format the mysql important status values
## $1=2 format the mysql all status values
## $1=3 format the mysql important status values title
## $1=4 format the mysql all status values title

WORKPATH="/home/mysql/scripts/status"

function printf_grid_1
{
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..6}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..9}
printf "+"
printf "%0.1s" "-"{1..6}
printf "+"
printf "%0.1s" "-"{1..7}
printf "+"
printf "%0.1s" "-"{1..5}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..7}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..10}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+\n"
}

function printf_grid_2
{
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..28}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..8}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..10}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..10}
printf "+"
printf "%0.1s" "-"{1..10}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..27}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..25}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..26}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..27}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..26}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..26}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..25}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..25}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..28}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..31}
printf "+"
printf "%0.1s" "-"{1..32}
printf "+"
printf "%0.1s" "-"{1..31}
printf "+"
printf "%0.1s" "-"{1..32}
printf "+"
printf "%0.1s" "-"{1..34}
printf "+"
printf "%0.1s" "-"{1..31}
printf "+"
printf "%0.1s" "-"{1..31}
printf "+"
printf "%0.1s" "-"{1..32}
printf "+"
printf "%0.1s" "-"{1..26}
printf "+"
printf "%0.1s" "-"{1..31}
printf "+"
printf "%0.1s" "-"{1..39}
printf "+"
printf "%0.1s" "-"{1..35}
printf "+"
printf "%0.1s" "-"{1..34}
printf "+"
printf "%0.1s" "-"{1..30}
printf "+"
printf "%0.1s" "-"{1..35}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..28}
printf "+"
printf "%0.1s" "-"{1..27}
printf "+"
printf "%0.1s" "-"{1..28}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..28}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..29}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..27}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..30}
printf "+"
printf "%0.1s" "-"{1..30}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..31}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..26}
printf "+"
printf "%0.1s" "-"{1..26}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..32}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..26}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..26}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..38}
printf "+"
printf "%0.1s" "-"{1..40}
printf "+"
printf "%0.1s" "-"{1..38}
printf "+"
printf "%0.1s" "-"{1..38}
printf "+"
printf "%0.1s" "-"{1..40}
printf "+"
printf "%0.1s" "-"{1..32}
printf "+"
printf "%0.1s" "-"{1..39}
printf "+"
printf "%0.1s" "-"{1..41}
printf "+"
printf "%0.1s" "-"{1..40}
printf "+"
printf "%0.1s" "-"{1..42}
printf "+"
printf "%0.1s" "-"{1..39}
printf "+"
printf "%0.1s" "-"{1..41}
printf "+"
printf "%0.1s" "-"{1..40}
printf "+"
printf "%0.1s" "-"{1..42}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..22}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..25}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..13}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..24}
printf "+"
printf "%0.1s" "-"{1..27}
printf "+"
printf "%0.1s" "-"{1..28}
printf "+"
printf "%0.1s" "-"{1..15}
printf "+"
printf "%0.1s" "-"{1..21}
printf "+"
printf "%0.1s" "-"{1..14}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..12}
printf "+"
printf "%0.1s" "-"{1..11}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..20}
printf "+"
printf "%0.1s" "-"{1..23}
printf "+"
printf "%0.1s" "-"{1..18}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..16}
printf "+"
printf "%0.1s" "-"{1..19}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..17}
printf "+"
printf "%0.1s" "-"{1..10}
printf "+"
printf "%0.1s" "-"{1..27}
printf "+\n"
}

if [ $1 == 1 ] ; then
printf_grid_1
elif [ $1 == 2 ] ; then
printf_grid_2
elif [ $1 == 3 ] ; then
printf "|%15s|%6s|%11s|%9s|%6s|%7s|%5s|%11s|%14s|%7s|%15s|%11s|%10s|%23s|%12s|\n" "report_time" "Uptime" "T_connected" "T_running" "Qps" "Com_tps" "I_tps" "I_b_p_r_pe%" "I_r_l_time_avg" "I_r_l_w" "I_OS_LOG_FSYNCS" "Open_tables" "Open_files" "Created_tmp_disk_tables" "C_tmp_tables">>${WORKPATH}/result/mysqlstatus.log
elif [ $1 == 4 ] ; then
printf "|%17s|%18s|%23s|%18s|%28s|%23s|%16s|%15s|%13s|%20s|%14s|%22s|%17s|%20s|%21s|%18s|%17s|%22s|%13s|%24s|%11s|%12s|%20s|%15s|%19s|%11s|%14s|%12s|%15s|%18s|%21s|%18s|%22s|%19s|%18s|%20s|%16s|%17s|%17s|%17s|%12s|%18s|% 8s|%13s|%16s|%19s|%16s|%20s|%17s|%16s|%18s|%15s|%15s|%17s|%17s|%11s|%11s|%14s|%13s|%13s|%10s|%12s|%19s|%20s|%10s|%10s|%17s|%14s|%18s|%17s|%11s|%23s|%23s|%18s|%17s|%12s|%13s|%20s|%11s|%14s|%12s|%16s|%14s|%27s|%15s|%12s|%16s|%18s|%18s|%24s|%19s|%21s|%23s|%20s|%23s|%22s|%22s|%23s|%25s|%20s|%22s|%23s|%24s|%17s|%17s|%17s|%26s|%17s|%15s|%24s|%22s|%18s|%21s|%27s|%22s|%18s|%19s|%26s|%22s|%23s|%17s|%26s|%17s|%23s|%19s|%20s|%19s|%12s|%17s|%16s|%16s|%18s|%16s|%18s|%20s|%16s|%25s|%14s|%22s|%19s|%12s|%18s|%15s|%12s|%16s|%16s|%17s|%14s|%13s|%25s|%19s|%20s|%16s|%24s|%16s|%16s|%16s|%16s|%18s|%17s|%20s|%18s|%19s|%19s|%19s|%18s|%23s|%18s|%19s|%28s|%16s|%15s|%31s|%32s|%31s|%32s|%34s|%31s|%31s|%32s|%26s|%31s|%39s|%35s|%34s|%30s|%35s|%20s|%28s|%27s|%28s|%18s|%19s|%20s|%21s|%28s|%21s|%29s|%18s|%19s|%27s|%22s|%30s|%30s|%23s|%22s|%19s|%22s|%18s|%21s|%22s|%18s|%21s|%31s|%22s|%26s|%26s|%23s|%32s|%24s|%19s|%17s|%11s|%19s|%12s|%20s|%17s|%22s|%26s|%14s|%15s|%26s|%12s|%14s|%13s|%24s|%38s|%40s|%38s|%38s|%40s|%32s|%39s|%41s|%40s|%42s|%39s|%41s|%40s|%42s|%21s|%20s|%20s|%13s|%16s|%22s|%19s|%25s|%21s|%13s|%13s|%13s|%18s|%24s|%14s|%20s|%13s|%24s|%24s|%27s|%28s|%15s|%21s|%14s|%19s|%12s|%12s|%11s|%23s|%20s|%23s|%18s|%19s|%16s|%19s|%17s|%17s|%10s|%27s|\n" "Aborted_clients" "Aborted_connects" "Binlog_cache_disk_use" "Binlog_cache_use" "Binlog_stmt_cache_disk_use" "Binlog_stmt_cache_use" "Bytes_received" "Bytes_sent" "Compression" "Com_admin_commands" "Com_alter_db" "Com_alter_db_upgrade" "Com_alter_event" "Com_alter_function" "Com_alter_procedure" "Com_alter_server" "Com_alter_table" "Com_alter_tablespace" "Com_analyze" "Com_assign_to_keycache" "Com_begin" "Com_binlog" "Com_call_procedure" "Com_change_db" "Com_change_master" "Com_check" "Com_checksum" "Com_commit" "Com_create_db" "Com_create_event" "Com_create_function" "Com_create_index" "Com_create_procedure" "Com_create_server" "Com_create_table" "Com_create_trigger" "Com_create_udf" "Com_create_user" "Com_create_view" "Com_dealloc_sql" "Com_delete" "Com_delete_multi" "Com_do" "Com_drop_db" "Com_drop_event" "Com_drop_function" "Com_drop_index" "Com_drop_procedure" "Com_drop_server" "Com_drop_table" "Com_drop_trigger" "Com_drop_user" "Com_drop_view" "Com_empty_query" "Com_execute_sql" "Com_flush" "Com_grant" "Com_ha_close" "Com_ha_open" "Com_ha_read" "Com_help" "Com_insert" "Com_insert_select" "Com_install_plugin" "Com_kill" "Com_load" "Com_lock_tables" "Com_optimize" "Com_preload_keys" "Com_prepare_sql" "Com_purge" "Com_purge_before_date" "Com_release_savepoint" "Com_rename_table" "Com_rename_user" "Com_repair" "Com_replace" "Com_replace_select" "Com_reset" "Com_resignal" "Com_revoke" "Com_revoke_all" "Com_rollback" "Com_rollback_to_savepoint" "Com_savepoint" "Com_select" "Com_set_option" "Com_show_authors" "Com_show_binlogs" "Com_show_binlog_events" "Com_show_charsets" "Com_show_collations" "Com_show_contributors" "Com_show_create_db" "Com_show_create_event" "Com_show_create_func" "Com_show_create_proc" "Com_show_create_table" "Com_show_create_trigger" "Com_show_databases" "Com_show_engine_logs" "Com_show_engine_mutex" "Com_show_engine_status" "Com_show_errors" "Com_show_events" "Com_show_fields" "Com_show_function_status" "Com_show_grants" "Com_show_keys" "Com_show_master_status" "Com_show_open_tables" "Com_show_plugins" "Com_show_privileges" "Com_show_procedure_status" "Com_show_processlist" "Com_show_profile" "Com_show_profiles" "Com_show_relaylog_events" "Com_show_slave_hosts" "Com_show_slave_status" "Com_show_status" "Com_show_storage_engines" "Com_show_tables" "Com_show_table_status" "Com_show_triggers" "Com_show_variables" "Com_show_warnings" "Com_signal" "Com_slave_start" "Com_slave_stop" "Com_stmt_close" "Com_stmt_execute" "Com_stmt_fetch" "Com_stmt_prepare" "Com_stmt_reprepare" "Com_stmt_reset" "Com_stmt_send_long_data" "Com_truncate" "Com_uninstall_plugin" "Com_unlock_tables" "Com_update" "Com_update_multi" "Com_xa_commit" "Com_xa_end" "Com_xa_prepare" "Com_xa_recover" "Com_xa_rollback" "Com_xa_start" "Connections" "Created_tmp_disk_tables" "Created_tmp_files" "Created_tmp_tables" "Delayed_errors" "Delayed_insert_threads" "Delayed_writes" "Flush_commands" "Handler_commit" "Handler_delete" "Handler_discover" "Handler_prepare" "Handler_read_first" "Handler_read_key" "Handler_read_last" "Handler_read_next" "Handler_read_prev" "Handler_read_rnd" "Handler_read_rnd_next" "Handler_rollback" "Handler_savepoint" "Handler_savepoint_rollback" "Handler_update" "Handler_write" "Innodb_buffer_pool_bytes_data" "Innodb_buffer_pool_bytes_dirty" "Innodb_buffer_pool_pages_data" "Innodb_buffer_pool_pages_dirty" "Innodb_buffer_pool_pages_flushed" "Innodb_buffer_pool_pages_free" "Innodb_buffer_pool_pages_misc" "Innodb_buffer_pool_pages_total" "Innodb_buffer_pool_reads" "Innodb_buffer_pool_read_ahead" "Innodb_buffer_pool_read_ahead_evicted" "Innodb_buffer_pool_read_ahead_rnd" "Innodb_buffer_pool_read_requests" "Innodb_buffer_pool_wait_free" "Innodb_buffer_pool_write_requests" "Innodb_data_fsyncs" "Innodb_data_pending_fsyncs" "Innodb_data_pending_reads" "Innodb_data_pending_writes" "Innodb_data_read" "Innodb_data_reads" "Innodb_data_writes" "Innodb_data_written" "Innodb_dblwr_pages_written" "Innodb_dblwr_writes" "Innodb_have_atomic_builtins" "Innodb_log_waits" "Innodb_log_writes" "Innodb_log_write_requests" "Innodb_os_log_fsyncs" "Innodb_os_log_pending_fsyncs" "Innodb_os_log_pending_writes" "Innodb_os_log_written" "Innodb_pages_created" "Innodb_pages_read" "Innodb_pages_written" "Innodb_page_size" "Innodb_rows_deleted" "Innodb_rows_inserted" "Innodb_rows_read" "Innodb_rows_updated" "Innodb_row_lock_current_waits" "Innodb_row_lock_time" "Innodb_row_lock_time_avg" "Innodb_row_lock_time_max" "Innodb_row_lock_waits" "Innodb_truncated_status_writes" "Key_blocks_not_flushed" "Key_blocks_unused" "Key_blocks_used" "Key_reads" "Key_read_requests" "Key_writes" "Key_write_requests" "Last_query_cost" "Max_used_connections" "Not_flushed_delayed_rows" "Opened_files" "Opened_tables" "Opened_table_definitions" "Open_files" "Open_streams" "Open_tables" "Open_table_definitions" "Performance_schema_cond_classes_lost" "Performance_schema_cond_instances_lost" "Performance_schema_file_classes_lost" "Performance_schema_file_handles_lost" "Performance_schema_file_instances_lost" "Performance_schema_locker_lost" "Performance_schema_mutex_classes_lost" "Performance_schema_mutex_instances_lost" "Performance_schema_rwlock_classes_lost" "Performance_schema_rwlock_instances_lost" "Performance_schema_table_handles_lost" "Performance_schema_table_instances_lost" "Performance_schema_thread_classes_lost" "Performance_schema_thread_instances_lost" "Prepared_stmt_count" "Qcache_free_blocks" "Qcache_free_memory" "Qcache_hits" "Qcache_inserts" "Qcache_lowmem_prunes" "Qcache_not_cached" "Qcache_queries_in_cache" "Qcache_total_blocks" "Queries" "Questions" "Rpl_status" "Select_full_join" "Select_full_range_join" "Select_range" "Select_range_check" "Select_scan" "Slave_heartbeat_period" "Slave_open_temp_tables" "Slave_received_heartbeats" "Slave_retried_transactions" "Slave_running" "Slow_launch_threads" "Slow_queries" "Sort_merge_passes" "Sort_range" "Sort_rows" "Sort_scan" "Table_locks_immediate" "Table_locks_waited" "Tc_log_max_pages_used" "Tc_log_page_size" "Tc_log_page_waits" "Threads_cached" "Threads_connected" "Threads_created" "Threads_running" "Uptime" "Uptime_since_flush_status" >>${WORKPATH}/result/all_mysqlstatus.log
fi

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29114615/viewspace-1407506/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29114615/viewspace-1407506/