CODEWITHSUNDEEP
mysqldatabasebufferinnodbstatus
Michael
Michael

Reputation: 3659

mysql show innodb status output

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

Upvotes: 8

Views: 35643

Answers (4)

Michael
Michael

Reputation: 3659

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."

here is more information about inndb status: A quest for the full InnoDB status

Also how to clear the deadlocks here: How to deliberately cause a deadlock in MySQL

Upvotes: 3

RolandoMySQLDBA
RolandoMySQLDBA

Reputation: 44363

MySQL does not have the InnoDB Buffer Pool in its INFORMATION_SCHEMA database

Interesting, XtraDB (used in MariaDB and Percona Server) does have INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES.

If you really need to see the InnoDB Buffer Pool, switch to MariaDB or Percona Server.

Upvotes: 2

Rahul
Rahul

Reputation: 77896

Try this:

SHOW ENGINE INNODB STATUS\G

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

Upvotes: 17

Ike Walker
Ike Walker

Reputation: 65577

Run this:

show global status like 'innodb_buffer_pool%';

Upvotes: 0

Related Questions