Geek asks and answers

Mysql shows innodb status output

I am trying to view the buffer pool and row statistics that usually appears at startup SHOW INNODB STATUS.

But for some reason this information is not displayed, just a lot of record locks. Anyone now how to view buffer pool information?

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 error output.

Answer I found the answer I was looking for

here: Quest for the full state of InnoDB

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

thank

+5
source share
4 answers

mysql, : " InnoDB 64 000 SHOW ENGINE INNODB STATUS. , ".

inndb: InnoDB

: MySQL

+2

:

SHOW ENGINE INNODB STATUS\G

. http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html

+8

MySQL InnoDB INFORMATION_SCHEMA

, XtraDB ( MariaDB Percona Server) INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES.

InnoDB, MariaDB Percona Server.

+1

:

show global status like 'innodb_buffer_pool%';
0

More articles:


All Articles