Add thread information to show engine innodb status (under TRANSACTIONS)
Bug #431148 reported by
fmpwizard
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Drizzle |
Fix Released
|
Wishlist
|
fmpwizard | ||
Bug Description
This is the current output from show engine innodb status
drizzle> show engine innodb status \G
....
------------
TRANSACTIONS
------------
Trx id counter 2301
Purge done for trx's n:o < D20 undo n:o < 0
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started, OS thread id 4497080320
Unknown thread accessing table
....
We should show at least the same information the mysql server returns:
...
------------
TRANSACTIONS
------------
Trx id counter 2301
Purge done for trx's n:o < D20 undo n:o < 0
History list length 3
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started, OS thread id 4497080320
Drizzle thread 2, query id 18646, hostname.local, 192.168.0.99, root
show engine innodb status
....
Related branches
lp://staging/~diego-fmpwizard/drizzle/plugin-innodb-fixes
- Jay Pipes (community): Approve
- fmpwizard: Pending requested
- Monty Taylor: Pending requested
-
Diff: 42 lines2 files modifiedplugin/innobase/handler/ha_innodb.cc (+13/-2)
plugin/innobase/include/ha_prototypes.h (+3/-0)
| Changed in drizzle: | |
| status: | New → In Progress |
| Changed in drizzle: | |
| status: | In Progress → Fix Committed |
| Changed in drizzle: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
