How to use the Netdata Mysql health monitoring plug-in
This article is to share with you about how to use the Netdata Mysql health monitoring plug-in. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.
One: mysql file configuration
/ usr/local/netdata/etc/netdata add profile mysql.conf
Mysql_ cmds [my _ A] = "/ usr/local/mysql/bin/mysql"
Mysql_ opts [my _ A] = "- h localhost-uroot"
Two: mysql.chart.sh plug-in script
#! / bin/bash
# http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html
#
# https://dev.mysql.com/doc/refman/5.1/en/show-status.html
# SHOW STATUS provides server status information (see Section 5.1.6, "Server Status Variables").
# This statement does not require any privilege.
# It requires only the ability to connect to the server.
Mysql_update_every=5
Mysql_priority=60000
Declare-A mysql_cmds= () mysql_opts= () mysql_ids= ()
Mysql_exec () {
Local ret
"${@}"-s-e "show global status;"
Ret=$?
[$ret-ne 0] & & echo "plugin_command_failure $ret"
Return $ret
}
Mysql_get () {
Unset\
Mysql_Bytes_received\
Mysql_Bytes_sent\
Mysql_Queries\
Mysql_Questions\
Mysql_Slow_queries\
Mysql_Handler_commit\
Mysql_Handler_delete\
Mysql_Handler_prepare\
Mysql_Handler_read_first\
Mysql_Handler_read_key\
Mysql_Handler_read_next\
Mysql_Handler_read_prev\
Mysql_Handler_read_rnd\
Mysql_Handler_read_rnd_next\
Mysql_Handler_rollback\
Mysql_Handler_savepoint\
Mysql_Handler_savepoint_rollback\
Mysql_Handler_update\
Mysql_Handler_write\
Mysql_Table_locks_immediate\
Mysql_Table_locks_waited\
Mysql_Select_full_join\
Mysql_Select_full_range_join\
Mysql_Select_range\
Mysql_Select_range_check\
Mysql_Select_scan\
Mysql_Sort_merge_passes\
Mysql_Sort_range\
Mysql_Sort_scan\
Mysql_Created_tmp_disk_tables\
Mysql_Created_tmp_files\
Mysql_Created_tmp_tables\
Mysql_Connection_errors_accept\
Mysql_Connection_errors_internal\
Mysql_Connection_errors_max_connections\
Mysql_Connection_errors_peer_addr\
Mysql_Connection_errors_select\
Mysql_Connection_errors_tcpwrap\
Mysql_Connections\
Mysql_Aborted_connects\
Mysql_Binlog_cache_disk_use\
Mysql_Binlog_cache_use\
Mysql_Binlog_stmt_cache_disk_use\
Mysql_Binlog_stmt_cache_use\
Mysql_Threads_connected\
Mysql_Threads_created\
Mysql_Threads_cached\
Mysql_Threads_running\
Mysql_Innodb_data_read\
Mysql_Innodb_data_written\
Mysql_Innodb_data_reads\
Mysql_Innodb_data_writes\
Mysql_Innodb_data_fsyncs\
Mysql_Innodb_data_pending_reads\
Mysql_Innodb_data_pending_writes\
Mysql_Innodb_data_pending_fsyncs\
Mysql_Innodb_log_waits\
Mysql_Innodb_log_write_requests\
Mysql_Innodb_log_writes\
Mysql_Innodb_os_log_fsyncs\
Mysql_Innodb_os_log_pending_fsyncs\
Mysql_Innodb_os_log_pending_writes\
Mysql_Innodb_os_log_written\
Mysql_Innodb_row_lock_current_waits\
Mysql_Innodb_rows_inserted\
Mysql_Innodb_rows_read\
Mysql_Innodb_rows_updated\
Mysql_Innodb_rows_deleted\
Mysql_Innodb_buffer_pool_pages_data\
Mysql_Innodb_buffer_pool_pages_dirty\
Mysql_Innodb_buffer_pool_pages_flushed\
Mysql_Innodb_buffer_pool_pages_free\
Mysql_Innodb_buffer_pool_pages_misc\
Mysql_Innodb_buffer_pool_pages_total\
Mysql_Innodb_buffer_pool_bytes_data\
Mysql_Innodb_buffer_pool_bytes_dirty\
Mysql_Innodb_buffer_pool_read_ahead_rnd\
Mysql_Innodb_buffer_pool_read_ahead\
Mysql_Innodb_buffer_pool_read_ahead_evicted\
Mysql_Innodb_buffer_pool_read_requests\
Mysql_Innodb_buffer_pool_reads\
Mysql_Innodb_buffer_pool_wait_free\
Mysql_Innodb_buffer_pool_write_requests\
Mysql_Qcache_free_blocks\
Mysql_Qcache_free_memory\
Mysql_Qcache_hits\
Mysql_Qcache_inserts\
Mysql_Qcache_lowmem_prunes\
Mysql_Qcache_not_cached\
Mysql_Qcache_queries_in_cache\
Mysql_Qcache_total_blocks\
Mysql_Key_blocks_not_flushed\
Mysql_Key_blocks_unused\
Mysql_Key_blocks_used\
Mysql_Key_read_requests\
Mysql_Key_reads\
Mysql_Key_write_requests\
Mysql_Key_writes\
Mysql_Open_files\
Mysql_Opened_files
Mysql_plugin_command_failure=0
Eval "$(mysql_exec" ${@} ") |\
Sed\
-e "s / [[: space:]]\ + / / g"\
-e "s /. / _ / g"\
-e "s / ^\ ([a-zA-Z0-9]\ +\) [[: space:]]\ +\ ([0-9]\ +\) $/ mysql_\ 1 =\ 2Unigram" |\
Egrep "^ mysql_ [a-zA-Z0-9] + = [[: digit:]] + $") "
[$mysql_plugin_command_failure-eq 1] & & return 1
[- z "$mysql_Connections"] & & return 1
Mysql_Thread_cache_misses=0
[$((mysql_Connections + 1-1))-gt 0] & & mysql_Thread_cache_misses=$ ((mysql_Threads_created * 10000 / mysql_Connections))
Return 0
}
Mysql_check () {
# this should return:
#-0 to enable the chart
#-1 to disable the chart
Local x m mysql_cmd tryroot=0 unconfigured=0
If ["${1}" = "tryroot"]
Then
Tryroot=1
Shift
Fi
[- z "${mysql_cmd}"] & & mysql_cmd= "$(which mysql)"
If [${# mysql_opts [@]}-eq 0]
Then
Unconfigured=1
Mysql_ cmds [local] = "$mysql_cmd"
If [$tryroot-eq 1]
Then
# the user has not configured us for mysql access
# if the root user is passwordless in mysql, we can
# attempt to connect to mysql as root
Mysql_ opts [local] = "- u root"
Else
Mysql_ opts [local]
Fi
Fi
# check once if the url works
For m in "${! mysql_opts [@]}"
Do
[- z "${mysql_cmds [$m]}] & & mysql_cmds [$m] =" $mysql_cmd "
If [- z "${mysql_cmds [$m]}"]
Then
Echo > & 2 "$PROGRAM_NAME: mysql: cannot get mysql command for'$m'. Please set mysql_cmds [$m] ='/ path/to/mysql', in $confd/mysql.conf"
Fi
Mysql_get "${mysql_cmds [$m]}" ${mysql_opts [$m]}
If [! $?-eq 0]
Then
Echo > & 2 "$PROGRAM_NAME: mysql: cannot get global status for'$m'. Please set mysql_opts [$m] = 'options' to whatever needed to get connected to the mysql server, in $confd/mysql.conf"
Unset mysql_cmds [$m]
Unset mysql_opts [$m]
Unset mysql_ids [$m]
Continue
Fi
Mysql_ids [$m] = "$(fixid" $m ")"
Done
If [${# mysql_opts [@]}-eq 0]
Then
If [${unconfigured}-eq 1 & & ${tryroot}-eq 0]
Then
Mysql_check tryroot "${@}"
Return $?
Else
Echo > & 2 "$PROGRAM_NAME: mysql: no mysql servers found. Please set mysql_ opts [name] = 'options' to whatever needed to get connected to the mysql server, in $confd/mysql.conf"
Return 1
Fi
Fi
Return 0
}
Mysql_create () {
Local x
# create the charts
For x in "${mysql_ids [@]}"
Do
Cat
