Comment 5 for bug 698797
Revision history for this message
| Yasufumi Kinoshita (yasufumi-kinoshita) wrote | #5 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
35a32c5
(Get the code!)
> Also: Is there any value as number of locks or lock structure size (global) which Innodb maintains - this would allow to easily track cases
> when there are some transactions which are doing it
It is hash_table.
Lock system 380792 (332872 + 47920)
But I think it is not useful for your purpose. Because it is just about allocation of memory.
print entries in the hash table?
> Also is there any way to access the age of oldest transaction quickly ? (without scanning potentially large list) - this would also be helpful.
age? what the unit?
oldest view can be caught instead of "oldest?" transaction.
"trx_id of the oldest view" is ok?
helpful for what? I don't judge without your purpose.