Oracle MySQL Insight Pack

Posted: October 6, 2015 Modified: October 8, 2015


Overview

The Oracle MySQL Insight Pack gives customers support to ingest data from various Oracle MySQL Server Logs into IBM Operations Analytics – Log Analysis. They can then use a rich set of analytical dashboards to visualize metadata and derived metrics from log content, along with performing additional queries on the content.

Oracle MySQL Server Insight Pack Health Dashboard

This dashboard displays the health of database servers based on the number of errors and slow queries from the datasources specific to Oracle MySQL Server.

Oracle MySQL Server Insight Pack Health Dashboard
Oracle MySQL Server Insight Pack Health Dashboard

Oracle MySQL Server Insight Pack Error Log Dashboard

This dashboard displays the distribution charts for various events and the top 10 errors, which have error codes in the log that occurred for the configured time period.

Oracle MySQL Server Insight Pack Error Log Dashboard
Oracle MySQL Server Insight Pack Error Log Dashboard

Oracle MySQL Insight Pack Slow Query Log Dashboard

This dashboard displays the distribution charts for various slow queries executed with top 10 queries executed on the server and their result set statistics for the configured time period. It also displays the top 5 users who executed maximum slow queries for the configured time period.

Oracle MySQL Insight Pack Slow Query Log Dashboard
Oracle MySQL Insight Pack Slow Query Log Dashboard

Additional information

The Insight Pack includes support for ingesting and performing metadata searches against the following log files.

  • MySQL Server Error Log: .err or mysqld.log
  • MySQL Server Slow Query Log: -slow.log

Training Information

Review the following video for information on using and setting up the Insight Pack.


Overview presentation used in the training video.

View US Price & Buy

IBM Operations Analytics-Log Analysis Insight Packs for Infrastructure-Standard Install License.

Released: 29 September 2015
Version: 1.1.0.0
Cost: License Fee
Support: Supported

Resources

Product Information
Product Documentation
Forum

Requirements

  • IBM Operations Analytics – Log Analysis version 1.3.0 or above
  • MySQL Server v5.5
  • MySQL Server v5.6
  • Purchased “IBM Operations Analytics-Log Analysis Insight Packs for Infrastructure-Standard 1.1” License for each installed Insight Pack.

Support

This package is subject to the License terms included with the Insight Pack, along with those displayed upon download.

To report a problem with deploying this entry, entitled customers may contact the country specific IBM support channel, reference the IBM Worldwide Directory. Also use the “Support” link to access the support site for IBM Operations Analytics – Log Analysis information.