observIQ Cloud

The observIQ Cloud Developer Hub

Welcome to the observIQ Cloud developer hub. You'll find comprehensive guides and documentation to help you start working with observIQ Cloud as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

MySQL

Configure MySQL Log Source with observIQ

Supported Versions

MySQL versions

  • 9.0
  • 8.0
  • 5.7

MariaDB versions

  • 10.6
  • 10.5
  • 10.4
  • 10.3
  • 10.2

Prerequisites

To enable certain log files, it may be necessary to edit the MySQL configuration file: mysqld.cnf.

Error Log

This is generally enabled by default. To change the file path, you can set or update "log_error" within mysqld.cnf.

For more details, see the error log documentation here.

Query Log

🚧

Query Log

Note that by enabling the query log, all queries will be logged. This can consume significant disk space.

To enable the query log, set general_log_file to the desired log path and set general_log = 1.

For more details, see the query log documentation here.

Slow Query Log

To enable the slow query log, set slow_query_log_file to the desired log path. Set slow_query_log = 1 and optionally, configure long_query_time.

For more details, see the slow query log documentation here.

Configuration

OptionDescription
General LogsUse this field to verify the path to the General log file and adjust default as needed (/var/log/mysql/general.log).
Slow Query LogsUse this field to verify the path to the Slow Query log file and adjust default as needed (/var/log/mysql/slow.log).
Error LogsUse this field to verify the path to the Error log file and adjust default as needed (/var/log/mysql/mysqld.log).
Start AtChoose whether to start reading from the beginning or end of a file with "end" being the default.

Log Types

Types
mysql.slow_query
mysql.server-start
mysql.error
mysql.audit
mysql.general

Dashboards

Dashboards for this source will be added soon.

Advanced

For more information on the advanced configuration capabilities, see our detailed plugin guide here.

Updated 2 months ago

MySQL


Configure MySQL Log Source with observIQ

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.