ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: usr / local / lib / python3.9 / site-packages / agent360 / plugins

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import time
import MySQLdb
import plugins

class Plugin(plugins.BasePlugin):
    __name__ = 'mysql'

def run(self, config):
        '''
        MySQL metrics plugin
        '''

prev_cache = self.get_agent_cache()  # Get absolute values from previous check
        auth = {}
        try:
            auth['port'] = int(config.get('mysql', 'port'))
        except ValueError:
            auth['port'] = 3306
        try:
            auth['user'] = config.get('mysql', 'username')
        except:
            auth['user'] = 'root'
        try:
            auth['passwd'] = config.get('mysql', 'password')
        except:
            auth['passwd'] = ''
        try:
            auth['host'] = config.get('mysql', 'host')
        except:
            auth['unix_socket'] = config.get('mysql', 'socket')
        try:
            auth['db'] = config.get('mysql', 'database')
        except:
            auth['db'] = 'mysql'

db = MySQLdb.connect(**auth)
        cursor = db.cursor()
        cursor.execute("SHOW GLOBAL STATUS;")
        query_result = cursor.fetchall()
        non_delta = (
            'max_used_connections',
            'open_files',
            'open_tables',
            'qcache_free_blocks',
            'qcache_free_memory',
            'qcache_total_blocks',
            'slave_open_temp_tables',
            'threads_cached',
            'threads_connected',
            'threads_running',
            'uptime'
        )
        delta_keys = (
            'aborted_clients',
            'aborted_connects',
            'binlog_cache_disk_use',
            'binlog_cache_use',
            'bytes_received',
            'bytes_sent',
            'com_delete',
            'com_delete_multi',
            'com_insert',
            'com_insert_select',
            'com_load',
            'com_replace',
            'com_replace_select',
            'com_select',
            'com_update',
            'com_update_multi',
            'connections',
            'created_tmp_disk_tables',
            'created_tmp_files',
            'created_tmp_tables',
            'key_reads',
            'key_read_requests',
            'key_writes',
            'key_write_requests',
            'max_used_connections',
            'open_files',
            'open_tables',
            'opened_tables',
            'qcache_free_blocks',
            'qcache_free_memory',
            'qcache_hits',
            'qcache_inserts',
            'qcache_lowmem_prunes',
            'qcache_not_cached',
            'qcache_queries_in_cache',
            'qcache_total_blocks',
            'questions',
            'select_full_join',
            'select_full_range_join',
            'select_range',
            'select_range_check',
            'select_scan',
            'slave_open_temp_tables',
            'slave_retried_transactions',
            'slow_launch_threads',
            'slow_queries',
            'sort_range',
            'sort_rows',
            'sort_scan',
            'table_locks_immediate',
            'table_locks_waited',
            'threads_cached',
            'threads_connected',
            'threads_created',
            'threads_running'
        )

results = dict()
        data = dict()
        constructors = [str, float]
        for key, value in query_result:
            key = key.lower().strip()
            for c in constructors:
                try:
                    value = c(value)
                except ValueError:
                    pass
            if key in non_delta:
                results[key] = value
            elif key in delta_keys and type(value) is not str:
                results[key] = self.absolute_to_per_second(key, float(value), prev_cache)
                data[key] = float(value)
            else:
                pass

cursor = db.cursor(MySQLdb.cursors.DictCursor)
        cursor.execute('SHOW SLAVE STATUS')
        query_result_slave = cursor.fetchone()
        non_delta_slave = (
            'slave_io_state',
            'master_host',
            'seconds_behind_master',
            'read_master_log_pos',
            'relay_log_pos',
            'slave_io_running',
            'slave_sql_running',
            'last_error',
            'exec_master_log_pos',
            'relay_log_space',
            'slave_sql_running_state',
            'master_retry_count'
        )
        if query_result_slave is None:
            query_result_slave = dict()
        for key, value in query_result_slave.items():
            key = key.lower().strip()
            if key == 'slave_sql_running':
                value = 1 if value == 'Yes' else 0
            if key == 'slave_io_running':
                value = 1 if value == 'Yes' else 0

for c in constructors:
                try:
                    value = c(value)
                except ValueError:
                    pass
            if key in non_delta_slave and type(value) is not str:
                results[key] = value
            else:
                pass

db.close()
        data['ts'] = time.time()
        self.set_agent_cache(data)
        return results

if __name__ == '__main__':
    Plugin().execute()

[-] wp-toolkit.py [open]
[+] ..
[-] plugins.py [open]
[-] yum-updates.py [open]
[-] proftpd.py [open]
[-] sleeper.py [open]
[-] network.py [open]
[+] __pycache__
[-] bird.py [open]
[-] diskusage.py [open]
[-] exim.py [open]
[-] cpanel.py [open]
[-] loggedin.py [open]
[-] memory.py [open]
[-] megacli.py [open]
[-] phpfpm.py [open]
[-] rabbitmq.py [open]
[-] elasticsearch.py [open]
[-] mysql.py [open]
[-] iostat.py [open]
[-] plesk-cgroups.py [open]
[-] fail2ban.py [open]
[-] loadavg.py [open]
[-] dirsize.py [open]
[-] openvpn.py [open]
[-] apt-updates.py [open]
[-] postfix.py [open]
[-] diskstatus.py [open]
[-] tcpports.py [open]
[-] haproxy.py [open]
[-] ping.py [open]
[-] unbound.py [open]
[-] dovecot.py [open]
[-] memcached.py [open]
[-] bitninja.py [open]
[-] powerdns.py [open]
[-] mailq.py [open]
[-] gpu.py [open]
[-] system.py [open]
[-] cloudlinux.py [open]
[-] cpu_freq.py [open]
[-] janus.py [open]
[-] nginx.py [open]
[-] bind.py [open]
[-] cpu.py [open]
[-] litespeed.py [open]
[-] swap.py [open]
[-] temp.py [open]
[-] kamailio.py [open]
[-] httpd.py [open]
[-] diskstatus-nvme.py [open]
[-] process.py [open]
[-] mongodb.py [open]
[-] __init__.py [open]
[-] minecraft.py [open]
[-] docker.py [open]
[-] vms.py [open]
[-] asterisk.py [open]
[-] redis_stat.py [open]
[-] mdstat.py [open]
[-] cloudlinux-dbgov.py [open]
[-] diskinodes.py [open]