Query Analytics: no 'Example' or 'Explain' data for MariaDB

Impact on the user:

• Users unable to monitor MariaDB

Steps to reproduce:

1. connect MariaDB with enabled performance-schema to pmm-server
2. exec any query 
3. find the query in QAN
4. check tabs "Example" and "Explain"

Actual result:

• Query example and some explain data

Expected Result:

• No example and no Explain/table data

Workaround:

Run following command to start collecting data into  performance_schema.events_statements_history

UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES'
 WHERE NAME LIKE 'statement/%';
 UPDATE performance_schema.setup_consumers SET ENABLED = 'YES'
 WHERE NAME LIKE '%statements%';

Documentation

To collect real examples user should execute following queries in DB.

UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES'
 WHERE NAME LIKE 'statement/%';
 UPDATE performance_schema.setup_consumers SET ENABLED = 'YES'
 WHERE NAME LIKE '%statements%';

Details