adding checks to inspect db more closely

[Ramon Grullon]

Currently, percona charm is only performing 1 check and does not accurately report issues or errors in db itself.

nrpe_setup.add_check(
        shortname='mysql_proc',
        description='Check MySQL process {%s}' % current_unit,
        check_cmd='check_procs -c 1:1 -C mysqld'

Some checks needed -

define command{
        command_name check_mysql_connections
        command_line $USER1$/pmp-check-mysql-status -H $HOSTADDRESS$ -x Threads_connected -o / -y max_connections -T pct -w 80 -c 95
        }

define command{
        command_name check_mysql_active_threads
        command_line $USER1$/pmp-check-mysql-status -H $HOSTADDRESS$ -x Threads_running -w $ARG1$ -c $ARG2$
        }

define command{
        command_name check_mysql_processlist
        command_line $USER1$/pmp-check-mysql-processlist -H $HOSTADDRESS$ -C $ARG1$ -w $ARG2$ -c $ARG3$
        }

define command {
        command_name check_mysql_innodb
        command_line $USER1$/pmp-check-mysql-innodb -H $HOSTADDRESS$ -C $ARG1$ -w $ARG2$ -c $ARG3$
        }

define command{
        command_name check_mysql_replication_running
        command_line $USER1$/pmp-check-mysql-replication-running -H $HOSTADDRESS$
        }

[Alex Kavanagh (ajkavanagh)]

TRIAGE: wishlist as a new feature, not because it is unimportant.