Performance schema

In Version 5.5.3, you can use the performance_schema monitoring feature of MariaDB to monitor performance. It has been implemented as an engine (that's why you can see it on a show engines command) with a database that stores data performance.

To activate the performance schema, add this line to your my.cnf configuration file:

performance_schema=on

You can then check whether it has been correctly activated:

MariaDB [(none)]> SHOW VARIABLES LIKE 'performance_schema';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| performance_schema | ON |
+--------------------+-------+
1 row in set (0.00 sec)

You can now list the complete table list to see the available monitoring features:

MariaDB [(none)]> USE PERFORMANCE_SCHEMA;
MariaDB [performance_schema]> show tables;
+----------------------------------------------------+
| Tables_in_performance_schema |
+----------------------------------------------------+
| accounts |
| cond_instances |
| events_stages_current |
[...]
| table_lock_waits_summary_by_table |
| threads |
| users |
+----------------------------------------------------+
52 rows in set (0.00 sec)

You can get a complete list of all the features in the MariaDB documentation at https://mariadb.com/kb/en/list-of-performance-schema-tables/.