The Sumo Logic App for MySQL provides insight into the health of your MySQL servers, replication status, and errors. It assists in tracking slow queries, and helps to troubleshoot issues before they become serious problems. The app consists of predefined searches and Dashboards, providing visibility into your environment for real time or historical analysis.
The MySQL App supports following versions:
- Ubuntu 5.5.35-1 and later
- Percona MySQL 5.6.17 and later
The Sumo Logic App for MySQL assumes the default MySQL error log file format for error logs, and the MySQL slow query file format for slow query logs.
Specifically, the MySQL app Dashboards depend on these two log files:
- MySQL Overview is based on logs from both the Error and Slow Query log formats, so as to correlate information between the two.
- MySQL General Health is based on logs from the MySQL Error log format.
- MySQL Replication is based on logs from the MySQL Error log format.
- MySQL Slow Queries is based on logs from the the MySQL Slow Queries log format.
The MySQL app Dashboards dependent on error logs are based on the message types ERROR, NOTE, Warning, and Info.
For more details on the MySQL log file format, see http://dev.mysql.com/doc/refman/5.5/en/server-logs.html.
MySQL App Searches
In the MySQL app, the predefined searches are based on the following log types:
Search Based on Error logs
- MySQL Crash Recovery Attempts by Host
- MySQL Server Latest Replication State
- MySQL Server Latest Running State
- MySQL Server Up-Down Events by Host
- Number of Replication Completion Events by Host
- Replication Failures by Host
Search Based on Slow Query logs
- Slow Query Server Location. If your servers are not using private IP addresses, you can use the Slow Query Server Location search to visualize their locations on a map of the world
- Slow Query Seven Day Average Count. This search query computes the hourly count of slow queries over the last week. It is used by the Overview Dashboard.