MySQL
Supported Platforms
| Platform | Metrics | Logs | Traces |
|---|---|---|---|
| Linux | ✓ | ✓ | |
| Windows | ✓ | ✓ | |
| macOS | ✓ | ✓ |
Prerequisites
This source supports MySQL versions 5.7 and 8.0.
Configuration Table
| Parameter | Type | Default | Description |
|---|---|---|---|
| enable_metrics | bool | true | Enable to collect metrics. |
| username* | string | Username used to authenticate. | |
| password* | string | Password used to authenticate. | |
| endpoint | string | localhost:3306 | The endpoint of the mysql server. |
| transport | enum | tcp | The transport protocol being used to connect to mysql. |
| database | string | The database name. If not specified, metrics will be collected for all databases. | |
| collection_interval | int | 60 | How often (seconds) to scrape for metrics. |
| enable_logs | bool | true | Enable to collect logs. |
| enable_general_log | bool | false | Enable to read and parse the general log file. |
| general_log_paths | strings | - \"/var/log/mysql/general.log\" | Path to the general log file(s). |
| enable_slow_log | bool | true | Enable to read and parse the slow query log. |
| slow_query_log_paths | strings | - \"/var/log/mysql/slow*.log\" | Path to the slow query log file(s). |
| enable_error_log | bool | true | Enable to read and parse the error log. |
| error_log_paths | strings | For CentOS / RHEL: - \"/var/log/mysqld.log\" \nFor SLES: - \"/var/log/mysql/mysqld.log\" \nFor Debian / Ubuntu: - \"/var/log/mysql/error.log\" | Path to the error log file(s). |
| start_at | enum | end | Start reading file from 'beginning' or 'end'. |
*required field
Updated 3 months ago