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
 
percona-xtradb/patch/innodb_show_status.txt · Last modified: 2010/03/21 06:56 (external edit)
 
Except where otherwise noted, content on this wiki is licensed under the following license:GNU Free Documentation License 1.2
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki