innodb_show_status

We made next change to SHOW INNODB STATUS command;

• TRANSACTION section moved to the end of output, the reason is list of transaction may be big and an important information is not abandoned.
• Added two variables to control SHOW INNODB STATUS (bugfix for http://bugs.mysql.com/bug.php?id=29126) :
  • innodb_show_verbose_locks - Whether to show records locked in SHOW INNODB STATUS
  • innodb_show_locks_held - Number of locks held to print for each InnoDB transaction in SHOW INNODB STATUS.
• Added extended information of InnoDB internal hash tables sizes (in bytes) in BUFFER POOL AND MEMORY section. It also adds Buffer pool size in bytes information.

  ----------------------
  BUFFER POOL AND MEMORY
  ----------------------
  Total memory allocated 328830416; in additional pool allocated 2117120
+ Internal hash tables (constant factor + variable factor)
+     Adaptive hash index 4839388         (4425628 + 413760)
+     Page hash           138716
+     Dictionary cache    3383508         (3320220 + 63288)
+     File system         41848   (41336 + 512)
+     Lock system         332788  (332468 + 320)
+     Recovery system     0       (0 + 0)
+     Threads             41900   (41348 + 552)
  Buffer pool size        16384
+ Buffer pool size, bytes 268435456
  Free buffers            12396
  Database pages          3963
  Modified db pages       1510
  Pending reads 0