Monitoring MariaDB
The MariaDB sensor is automatically deployed and installed after you install the Instana agent.
Support information
To make sure that the MariaDB sensor is compatible with your current setup, check the following support information sections:
Supported versions and support policy
The following table shows the latest supported version and support policy:
| Technology | Support policy | Latest technology version | Latest supported version |
|---|---|---|---|
| MariaDB | 45 days | 11.8.0 | 11.8.0 |
For more information about the support policy, see Support strategy for sensors.
Sensor (Data Collection)
Configuration
In order to enable in depth metric monitoring, you need to inform the Agent about the credentials to access monitoring information. You can configure it in the agent <agent_install_dir>/etc/instana/configuration.yaml:
com.instana.plugin.mariadb:
user: ''
password: ''
Required DB Permissions
For the sensor to be able to collect performance information about the DBMS, read-only access to the schema performance_schema is required.
The performance schema is disabled by default for performance reasons.
This is an example how to create an account with the required rights:
GRANT SELECT ON performance_schema.* TO '<instana_mon_user>'@'localhost' IDENTIFIED BY 'instana_mon_pwd';
Metrics collection
To view the metrics, select Infrastructure in the sidebar of the Instana User interface, click a specific monitored host, and then you can see a host dashboard with all the collected metrics and monitored processes.
Configuration data
- Process ID
- Port
- Version
- Start time
- Role
Performance metrics
| Metric | Description | Granularity |
|---|---|---|
| Client Connections | The number of connections | 1 second |
| Client Max used connections | The number of max used connections | 1 second |
| Client Aborted connects | The number of aborted connects | 1 second |
| Slow Queries | The number of slow queries | 1 second |
| Key Access | Read and Write Requests | 1 second |
| Aria Engine Properties | Pagecache Reads and Writes | 1 second |