|
hi guys, based on MDEV-4672 / MDEV-4748
could we see when a query will be executed?
(i think in mdl.h this is called as wait-for graph? or maybe it's the "A pending metadata lock request."?)
something like:
show query order <query id>
it will return:
| message |
query id |
| waiting unlock table |
1 |
| waiting alter table |
2 |
| waiting xxxxxx |
999999 |
this is nice when we have a busy server and want know when a query will be executed (or not), and help DBA to kill it or not
—
we could put another column to see informations about a lock
in MDEV-4619 we have a lock table in information schema, maybe this could be used here to link to that table, example:
| message |
locks |
query id |
| waiting table lock |
1,2,3,4,5 |
1234 |
| waiting lock tables |
44 |
423 |
| waiting update |
66 |
44 |
|