mysql show innodb status output

mysql database buffer innodb status
Michael picture Michael · May 24, 2012 · Viewed 18.2k times · Source

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

Answer

Rahul picture Rahul · May 24, 2012

Try this:

SHOW ENGINE INNODB STATUS\G

See here for more http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html

Related questions

'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More
How do I quickly rename a MySQL database (change schema name)?

The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This is not an option for very big databases. Apparently RENAME {DATABASE | SCHEMA} db_name TO new_db_name; does …

Read More
MySQL Error: : 'Access denied for user 'root'@'localhost'

$ ./mysqladmin -u root -p 'redacted' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' How can I fix this?

Read More