Add query sequence id to SHOW INNODB STATUS
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Triaged
|
Wishlist
|
Unassigned | ||
Percona patches |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
I'd like SHOW INNODB STATUS to show information about the sequence of queries in a transaction. For example, currently we have this:
> ---TRANSACTION 671D852DC, ACTIVE 129 sec, OS thread id 645706 fetching rows
> mysql tables in use 40, locked 20
> 53464 lock struct(s), heap size 5470192, 581114 row lock(s)
> MySQL thread id 249386396, query id 2074123394 192.168.62.210 user1 preparing
I'd like to see more information, like this:
> ---TRANSACTION 671D852DC, ACTIVE 129 sec, OS thread id 645706 fetching rows
> First query id 2074123390; 2 queries in transaction
This tells me what query ID the transaction started with. It tells me this is the 2nd in the transaction. This can be very useful for getting context about a query. For example, there is a SELECT query with some locks. Why? Maybe because an earlier query was an UPDATE. Or, there is an active transaction that doesn't seem to have any query currently. Has this transaction ever executed a query?
Changed in percona-patches: | |
status: | New → Won't Fix |
Changed in percona-server: | |
status: | New → Triaged |
importance: | Undecided → Wishlist |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-2300