MySQL数据库监控工具，实现了对MySQL节点的管理和监控

# Mycat-eye 监控平台 监控平台分为三大功能模块(MyCat监控、MySql监控、可视化配置)。监控数据从MyCat管理端口获取信息： ```sql mysql> show @@help; +------------------------------------------+--------------------------------------------+ | STATEMENT | DESCRIPTION | +------------------------------------------+--------------------------------------------+ | show @@time.current | Report current timestamp | | show @@time.startup | Report startup timestamp | | show @@version | Report Mycat Server version | | show @@server | Report server status |√ | show @@threadpool | Report threadPool status | | show @@database | Report databases | | show @@datanode | Report dataNodes | | show @@datanode where schema = ? | Report dataNodes | | show @@datasource | Report dataSources | | show @@datasource where dataNode = ? | Report dataSources | | show @@datasource.synstatus | Report datasource data synchronous | | show @@datasource.syndetail where name=? | Report datasource data synchronous detail | | show @@datasource.cluster | Report datasource galary cluster variables | | show @@processor | Report processor status | | show @@command | Report commands status | | show @@connection | Report connection status |√ | show @@cache | Report system cache usage |. | show @@backend | Report backend connection status |√ | show @@session | Report front session details | | show @@connection.sql | Report connection sql |√跟踪当前应用执行sql情况 | show @@sql.execute | Report execute status |√ | show @@sql.detail where id = ? | Report execute detail status |√ | show @@sql | Report SQL list |√ | show @@sql.high | Report Hight Frequency SQL |√ | show @@sql.slow | Report slow SQL |√ | show @@sql.resultset | Report BIG RESULTSET SQL |√ | show @@sql.sum | Report User RW Stat |√ | show @@sql.sum.user | Report User RW Stat |√ | show @@sql.sum.table | Report Table RW Stat |√ | show @@parser | Report parser status | | show @@router | Report router status | | show @@heartbeat | Report heartbeat status | | show @@heartbeat.detail where name=? | Report heartbeat current detail | | show @@slow where schema = ? | Report schema slow sql | | show @@slow where datanode = ? | Report datanode slow sql | | show @@sysparam | Report system param | | show @@syslog limit=? | Report system mycat.log | | show @@white | show mycat white host | | show @@white.set=?,? | set mycat white host,[ip,user] | | show @@directmemory=1 or 2 | show mycat direct memory usage | | switch @@datasource name:index | Switch dataSource | | kill @@connection id1,id2,... | Kill the specified connections | | stop @@heartbeat name:time | Pause dataNode heartbeat | | reload @@config | Reload basic config from file | | reload @@config_all | Reload all config from file |* | reload @@route | Reload route config from file | | reload @@user | Reload user config from file | | reload @@sqlslow= | Set Slow SQL Time(ms) | | reload @@user_stat | Reset show @@sql @@sql.sum @@sql.slow | | rollback @@config | Rollback all config from memory | | rollback @@route | Rollback route config from memory | | rollback @@user | Rollback user config from memory | | reload @@sqlstat=open | Open real-time sql stat analyzer | | reload @@sqlstat=close | Close real-time sql stat analyzer | | offline | Change MyCat status to OFF | | online | Change MyCat status to ON | | clear @@slow where schema = ? | Clear slow sql by schema | | clear @@slow where datanode = ? | Clear slow sql by datanode | +------------------------------------------+--------------------------------------------+ ``` ## Mycat 监控 ### Mycat服务 #### Mycat 内存分析 √ ```sql mysql> show @@server; +--------------+-------------+--------------+------------+---------------+---------------+---------+--------+ | UPTIME | USED_MEMORY | TOTAL_MEMORY | MAX_MEMORY | RELOAD_TIME | ROLLBACK_TIME | CHARSET | STATUS | +--------------+-------------+--------------+------------+---------------+---------------+---------+--------+ | 16h 32m 55s | 90145912 | 182976512 | 1908932608 | 1524574388986 | -1 | utf8 | ON | +--------------+-------------+--------------+------------+---------------+---------------+---------+--------+ ``` ```sql mysql> show @@directmemory=1 or 2 ; +----------------------+--------------------+-------------------------+-----------------+------------------------+ | MDIRECT_MEMORY_MAXED | DIRECT_MEMORY_USED | DIRECT_MEMORY_AVAILABLE | SAFETY_FRACTION | DIRECT_MEMORY_RESERVED | +----------------------+--------------------+-------------------------+-----------------+------------------------+ | 1820MB | 64KB | 1274MB | 0.7 | 450MB | +----------------------+--------------------+-------------------------+-----------------+------------------------+ ``` #### Mycat 连接分析 √ * 前端 ```sql mysql> show @@connection; +------------+------+-----------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+ | PROCESSOR | ID | HOST | PORT | LOCAL_PORT | USER | SCHEMA | CHARSET | NET_IN | NET_OUT | ALIVE_TIME(S) | RECV_BUFFER | SEND_QUEUE | txlevel | autocommit | +------------+------+-----------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+ | Processor1 | 1 | 127.0.0.1 | 9066 | 61721 | root | NULL | utf8:33 | 378 | 5399 | 1298 | 4096 | 0 | | | +------------+------+-----------+------+------------+------+--------+---------+--------+---------+---------------+-------------+------------+---------+--------