]]>
Call us: 1-888-316-9775 • Contact Us
MySQL and InnoDB are trademarks of Oracle Corp.
Proudly running Percona Server
Copyright © 2006-2012 Percona Inc.
Copyright, Trademark, and Privacy Policy • Sitemap
]]>
innodb_show_sys_tables
Description
This page describes three INFORMATION_SCHEMA tables that make internal InnoDB information visible.
Version Specific Information
| Percona Server Version | Comments |
|---|---|
| 5.1.56-12.7 | Added column NON_NULL_VALS in INNODB_SYS_STATS. |
INFORMATION_SCHEMA Tables
INNODB_SYS_INDEXES
InnoDB index statistics in memory
| Field | Notes |
|---|---|
| TABLE_ID | bigint(21) unsigned |
| ID | bigint(21) unsigned |
| NAME | varchar(192) |
| N_FIELDS | bigint(21) unsigned |
| TYPE | bigint(21) unsigned |
| SPACE | bigint(21) unsigned |
| PAGE_NO | bigint(21) unsigned |
INNODB_SYS_STATS
| Field | Notes |
|---|---|
| INDEX_ID | bigint(21) unsigned |
| KEY_COLS | bigint(21) unsigned |
| DIFF_VALS | bigint(21) unsigned |
| NON_NULL_VALS | bigint(21) unsigned |
INNODB_SYS_TABLES
InnoDB table statistics in memory
| Field | Notes |
|---|---|
| SCHEMA | varchar(192) |
| NAME | varchar(192) |
| ID | bigint(21) unsigned |
| N_COLS | bigint(21) unsigned |
| TYPE | bigint(21) unsigned |
| MIX_ID | bigint(21) unsigned |
| MIX_LEN | bigint(21) unsigned |
| CLUSTER_NAME | varchar(192) |
| SPACE | bigint(21) unsigned |
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
