QAN: Explain and Examples missing for MariaDB (Performance Schema) as it doesn't implement query history for transactions
Description
How to test
How to document
Attachments
blocks
Smart Checklist
Activity
Carlos Salguero September 8, 2021 at 3:01 PM
Updated the doc. You cannot see queries because to generate load in the DB we use sysbench and sysben run queries inside a transaction and MariaDB doesn't implement query history for transactions.
These consumers (from the performance_schema.setup_consumers) are not implemented in MariaDB and PMM relies on the history table to get the query examples.
Carlos Salguero September 6, 2021 at 5:38 PM
Check if there are disabled instruments (listing all enabled instruments is a big list, so I am checking the opposite)
checking consumers
Carlos Salguero September 1, 2021 at 12:26 PM
As , MariaDB needs extra configuration because not all consumers are enabled by default.
Roma Novikov August 12, 2021 at 9:01 AM
might be related to or
Roma Novikov August 12, 2021 at 8:47 AM
I've checked with our Stage system and clarified the issue
But, according to https://www.percona.com/doc/percona-monitoring-and-management/2.x/setting-up/client/mysql.html
There are some additional settings needed for MariaDB. Can someone recheck them and confirm we have them in our Stage setup?
Details
Details
Assignee
Carlos SalgueroReporter
Former userPriority
HighComponents
Labels
Needs QA
Needs Doc
Story Points
Smart Checklist
Open Smart Checklist
Smart Checklist
User impact:
There are no Examples found and Explains is not working for MariaDB with Performance Schema monitoring
STR:
Add MariaDB to monitoring with P_S
Go to QAN and check Explain/Examples/Tables tab for MariaDB queries
Actual result:
Sorry, no examples found for this query
No classic explain found
No JSON explain found
No table info from example nor explain
Tested with MariaDB 10.1-10.5.
Workaround:
Add MariaDB service to monitoring with SlowLog agent
Note: worked on PMM 2.5 + MariaDB 10.1 (P_S) .