| Bug #57195 | some small improvements in readability for INNODB_METRICS descriptions | ||
|---|---|---|---|
| Submitted: | 2 Oct 2010 10:12 | Modified: | 11 Feb 2011 0:56 |
| Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.6, mysql-trunk | OS: | Any |
| Assigned to: | Jimmy Yang | CPU Architecture: | Any |
[2 Oct 2010 10:12]
Shane Bester
[2 Oct 2010 11:03]
Valeriy Kravchuk
Verified with current mysql-trunk from bzr: macbook-pro:trunk openxs$ bin/mysql -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.1-m4-debug Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select description from information_schema.INNODB_METRICS; +-----------------------------------------------------------+ | description | +-----------------------------------------------------------+ | Number of table handler opened | | Number of table handler closed | ...
[6 Oct 2010 6:05]
Jimmy Yang
Will have John Russell take a look at the comments wording: mysql> select COMMENT from innodb_metrics; +------------------------------------------------------------+ | COMMENT | +------------------------------------------------------------+ | Number of table handlers opened | | Number of table handlers closed | | Number of deadlocks | | Number of lock timeouts | | Number of times waited for record lock | | Number of record locks requested | | Number of record locks created | | Number of record locks destroyed | | Total number of record locks | | Number of table locks created | | Number of table locks destroyed | | Total number of table locks | | Current row lock wait | | Time waited for lock acquisition | | Total row lock waits | | Number of reads from disk | | Number of read requests | | Number of write requests | | Number of pages in flush list | | Number of times waited for free buffer | | Number of pages read as read ahead | | Read ahead pages evicted without being accessed | | Total buffer pool pages | | Buffer pages for misc use | | Buffer pages contain data | | Buffer pages currently dirty | | Buffer pages currently free | | Number of pages created | | Number of pages written | | Number of pages read | | Amount of data read in bytes | | Amount of data written in bytes | | Number of Index Leaf Pages read | | Number of Index Non-leaf Pages read | | Number of Insert Buffer Index Leaf Pages read | | Number of Insert Buffer Index Non-Leaf Pages read | | Number of Undo Log Pages read | | Number of Index Inode Pages read | | Number of Insert Buffer Free List Pages read | | Number of Insert Buffer Bitmap Pages read | | Number of System Pages read | | Number of Transaction System Pages read | | Number of File Space Header Pages read | | Number of Extent Descriptor Pages read | | Number of Uncompressed Blob Pages read | | Number of First Compressed Blob Pages read | | Number of Subsequent Compressed Blob Pages read | | Number of other/unknown (old version InnoDB) Pages read | | Number of Index Leaf Pages written | | Number of Index Non-leaf Pages written | | Number of Insert Buffer Index Leaf Pages written | | Number of Insert Buffer Index Non-Leaf Pages written | | Number of Undo Log Pages written | | Number of Index Inode Pages written | | Number of Insert Buffer Free List Pages written | | Number of Insert Buffer Bitmap Pages written | | Number of System Pages written | | Number of Transaction System Pages written | | Number of File Space Header Pages written | | Number of Extent Descriptor Pages written | | Number of Uncompressed Blob Pages written | | Number of First Compressed Blob Pages written | | Number of Subsequent Compressed Blob Pages written | | Number of other/unknown (old version InnoDB) Pages written | | Number of reads initiated | | Number of writes initiated | | Number of fsync() calls | | Number of reads pending | | Number of writes pending | | Bytes of log written | | Number of fsync log writes | | Number of pending fsync write | | Number of pending log file writes | | Number of transactions committed | | Number of transactions aborted | | Number of active transactions | | Number of rows purged | | Microseconds DML to be delayed due to purge lagging | | Length of the TRX_RSEG_HISTORY list | | Number of checkpoints | | Last flush's LSN | | LSN at last checkpoint | | Current LSN value | | Pending Log Writes | | Pending Checkpoints | | Number of log I/Os | | Number of log waits due to small log buffer | | Number of log write requests | | Number of log writes | | Percent of Server I/O capacity during flushing | | Number of flush calls when the max dirty page pct was hit | | Number of pages compressed | | Number of pages decompressed | | Number of index splits | | Number of index merges | | Number of files currently open | | Number of rows read | | Number of rows inserted | | Number of rows deleted | | Number of rows updated | +------------------------------------------------------------+ 100 rows in set (0.00 sec)
[13 Nov 2010 16:23]
Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)
[13 Nov 2010 16:31]
Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:alexander.nozdrin@oracle.com-20101113152540-gxro4g0v29l27f5x) (pib:21)
