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 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 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.
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:
Review the following video for information on using and setting up the Insight Pack.
IBM Operations Analytics-Log Analysis Insight Packs for Infrastructure-Standard Install License.
Cost: License Fee
- 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.
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.