mysql-5.7 Show engine InnoDB status detailed

First, show engine InnoDB status profile:

Show engine InnoDB status is a tool that MySQL provides to view the time information of the InnoDB engine, and for now there are two comparisons

Common place One, deadlock analysis two, InnoDB memory usage

Second, check memory usage through show engine InnoDB status:

----------------------BUFFER POOL and MEMORY----------------------Total Large Memory allocated274857984#total amount of memory allocated for InnoDB (byte)Dictionary Memory Allocated 116177#The amount of memory allocated for the InnoDB data Dictionary (byte)Buffer Pool Size 16384#size of the Innodb_buffer_pool (page)Free Buffers 16004#innodb_buffer_pool Number of free pages in the LRU listDatabase pages 380#Innodb_buffer_pool Number of non-free pages in the LRU listOld database pages 0#number of pages in the Innodb_buffer_pool old child listModified db pages 0#number of dirty pages in Innodb_buffer_poolPending reads 0#number of pending readsPending WRITES:LRU 0, flush list 0, single page 0#Pages made young 0, notYoung 00.00 YOUNGS/S, 0.00 non-youngs/Spages Read345, created, written 370.00 reads/s, 0.00 creates/s, 0.00 writes/sNo Buffer Pool page gets since the last printoutpages read ahead0.00/S, evicted without access 0.00/s, Random read ahead 0.00/Slru Len:380, Unzip_lru len:0i/O sum[0]:cur[0], unzip sum[0]:cur[0]

----

Not finished ...

mysql-5.7 Show engine InnoDB status detailed