Hi Team,
How to find locking tables on the QAN dashboard?
And also, how do we know which query is locking the other query? Is there any way we can show a separate dashboard because the other query is locked?
1 Like
Hi Team,
How to find locking tables on the QAN dashboard?
And also, how do we know which query is locking the other query? Is there any way we can show a separate dashboard because the other query is locked?
1 Like
Hi @Naresh9999,
There is no dashboard that can show you locking table including QAN.
QAN can show you if the query was locked during the execution but it will not reveal why or how.
Usually you identify such things by querying show processlist, show engine innodb status OR the information_schema tables. (information_schema.innodb_trx , information_schema.innodb_locks, information_schema.innodb_lock_waits)
If you need those things in dashboard, you will need to constantly perform such queries and feed the data in PMM. This would be a considerable overhead as you will need to fetch this data may be every minute (even quicker)?
how do we know which query is locking the other query?
Use queries on client, not possible through PMM.
Is there any way we can show a separate dashboard because the other query is locked?
No.
In QAN you have “Details” section for each query which does exhibit “Lock Time” for each query run. You may identify which query was locked for how long and then try debugging from there.
Thanks,
K