The MariaDB sensor is automatically deployed and installed after you install the Instana agent.
- Supported Versions
- Sensor (Data Collection)
- Metrics collection
Monitoring of all metrics is supported for MariaDB versions from 10.0.x to 10.5.x.
Sensor (Data Collection)
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
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.
Note: 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';
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.
- Process ID
- Start time
|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|