i am trying to view the buffer pool and row stats that is usually shown when running SHOW INNODB STATUS
.
But for some reason this infomation is not being displayed, just lots of record locks. Does anyone now how to view the buffer pool infomation?
Update
After reading the MySQL docs again, i noticed this:
InnoDB Monitor output is limited to 64,000 bytes when produced using
the SHOW ENGINE INNODB STATUS statement. This limit does not apply to
output written to the server's error output.
Answer I found the answer i was looking for,
here: A quest for the full InnoDB status
Also how to clear the deadlocks here: How to deliberately cause a deadlock in MySQL
Thanks
Try this:
SHOW ENGINE INNODB STATUS\G
See here for more http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With