Merge lp:~hrvojem/percona-server/bug1056603-5.5 into lp:percona-server/5.5

[Hrvoje Matijakovic]

[Alexey Kopytov (akopytov)]

Same comments as in the 5.1 MP plus:

- new docs for INNODB_BUFFER_POOL_PAGES, INNODB_BUFFER_POOL_PAGES_INDEX
  and INNODB_BUFFER_POOL_PAGES_BLOB. I wonder if they deserve a separate
  section, like there are sections for "InnoDB Undo Logs", "Temporary
  Tables", etc.?

- s/These tables show the buffer pool data structure/The following
  tables provide various information about the contents of the InnoDB
  buffer pool/

- s/Possible values,/Possible values:/

- SPACE_ID is the tablespace ID, rather than the table ID

- PAGE_NO is the page offset within its tablespace

- LRU_POSITION is the page position in the LRU list

- FIX_COUNT is the reference count of a page. It is incremented every
  time the page is accessed by InnoDB, and is 0 if and only if the page
  is not currently being accessed

- ACCESS_TIME (in INNODB_BUFFER_POOL_PAGES_INDEX) is not a boolean value
  as the description suggests. It is the time of the last access to that
  page.

review: Needs Fixing

[Alexey Kopytov (akopytov)]

Hrvoje,

Please use my descriptions of the SPACE_ID, PAGE_NO, LRU_POSITION, FIX_COUNT and ACCESS_TIME fields that I have provided in https://code.launchpad.net/~hrvojem/percona-server/bug1056603-5.5/+merge/134998 for all tables, rather than just for INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES. Just for consistency.

review: Needs Fixing

[Alexey Kopytov (akopytov)]

review: Approve

=== modified file 'doc/source/diagnostics/innodb_stats.rst'
--- doc/source/diagnostics/innodb_stats.rst	2012-09-18 05:04:43 +0000
+++ doc/source/diagnostics/innodb_stats.rst	2012-12-10 15:33:26 +0000
@@ -6,8 +6,6 @@
 
 This feature provides new startup options (control method and collection of index statistics estimation) and information schema views to confirm the statistics.
 
-This implements the fix for `MySQL Bug #30423 <http://bugs.mysql.com/bug.php?id=30423>`_.
-
 Version Specific Information
 ============================
 
@@ -30,18 +28,16 @@
    :default: ``nulls_equal``
    :allowed: ``nulls_equal``, ``nulls_unequal``, ``nulls_ignored``
 
-The values and meanings are almost same to ``myisam_stats_method`` option of native |MySQL| (``nulls_equal``, ``nulls_unequal``, ``nulls_ignored``). But |InnoDB| doesn't have several patterns of statistics currently. So, though this option able to be changed dynamically, we need re-calculate statistics to change the method for the table.
-
-(reference: `MyISAM Index Statistics Collection <http://dev.mysql.com/doc/refman/5.1/en/myisam-index-statistics.html>`_)
-
-**Note:** Beginning in release 5.1.56-12.7, a variable with the same and functionality was implemented in the upstream |InnoDB|.
+The values and meanings are almost same to ``myisam_stats_method`` option of native |MySQL| (``nulls_equal``, ``nulls_unequal``, ``nulls_ignored``). But |InnoDB| doesn't have several patterns of statistics currently. Even though this option can be changed dynamically, statistics needs to be re-calculated to change the method for the table.
+
+(reference: `MyISAM Index Statistics Collection <http://dev.mysql.com/doc/refman/5.5/en/myisam-index-statistics.html>`_)
 
 .. variable:: innodb_stats_auto_update
 
    :type: BOOLEAN
    :default: 1
 
-|InnoDB| updates the each index statistics automatically (many updates were done, some information_schema is accessed, table monitor, etc.). Setting this option 0 can stop these automatic recalculation of the statistics except for “first open” and “ANALYZE TABLE command”.
+|InnoDB| updates the each index statistics automatically (many updates were done, some information_schema is accessed, table monitor, etc.). Setting this option 0 can stop these automatic recalculation of the statistics except for "first open" and "ANALYZE TABLE command".
 
 
 .. variable:: innodb_stats_update_need_lock
@@ -63,7 +59,90 @@
 INFORMATION_SCHEMA Tables
 =========================
 
-Two new tables were introduced by this feature.
+.. table:: INFORMATION_SCHEMA.INNODB_SYS_STATS
+
+   Shows statistics of table indexes.
+   
+   :column INDEX_ID: Index ID
+   :column KEY_COLS: Number of key columns
+   :column DIFF_VALS: Number of Different Values
+   :column NON_NULL_VALS: Number of Non ``NULL`` Values
+
+.. table:: INFORMATION_SCHEMA.INNODB_SYS_TABLES
+
+   Shows the information about |InnoDB| tables
+
+   :column TABLE_ID: Table ID
+   :column SCHEMA: Database (schema) name
+   :column NAME: Table name
+   :column FLAG: Contains `0` if it is a InnoDB system table or `1` it is a user table
+   :column N_COLS: Number of columns in the table
+   :column SPACE: Tablespace ID
+
+.. table:: INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
+
+   Shows the information about the performance statistics of |InnoDB| tables.
+
+   :column TABLE_ID: Table ID
+   :column SCHEMA: Database (schema) Name
+   :column NAME: Table Name
+   :column STATS_INITIALIZED: Contains ``Initialized`` value if the statistics are collected or ``Uninitialized`` if they are not collected.
+   :column NUM_ROWS: Estimated number of rows in the table.
+   :column CLUST_INDEX_SIZE: Number of pages on disk that store the clustered index. 
+   :column OTHER_INDEX_SIZE: Number of pages on disk that store all secondary indexes. 
+   :column MODIFIED_COUNTER: Number of rows modified by DML operations.
+   :column AUTOINC: 
+   :column MYSQL_HANDLES_OPENED:
+
+.. table:: INFORMATION_SCHEMA.INNODB_SYS_INDEXES
+
+   Shows the information about |InnoDB| indexes
+
+   :column INDEX_ID: Index ID
+   :column NAME: Index Name
+   :column TABLE_ID: Table ID
+   :column TYPE: Numeric identifier signifying the index type
+   :column N_FIELDS: Number of columns in the index
+   :column PAGE_NO: Page offset within its tablespace
+   :column SPACE: Tablespace ID
+
+.. table:: INFORMATION_SCHEMA.INNODB_SYS_COLUMNS
+
+   Shows the information about the |InnoDB| table columns
+
+   :column TABLE_ID: Table ID
+   :column NAME: Column Name
+   :column POS: Position of the column inside the table. 
+   :column MTYPE: Numeric identifier for the column type.
+   :column PRTYPE: Binary value with bits representing data type, character set code and nullability.
+   :column LEN: Column length.
+
+.. table:: INFORMATION_SCHEMA.INNODB_SYS_FIELDS
+
+   Shows the information about the |InnoDB| index key fields.
+
+   :column INDEX_ID: Index ID
+   :column NAME: Index Name
+   :column POS: Position of the field inside the index.
+
+.. table:: INFORMATION_SCHEMA.INNODB_SYS_FOREIGN
+ 
+   Shows the information about the |InnoDB| foreign keys.
+
+   :column ID: Foreign Key ID
+   :column FOR_NAME: Database/Table which contains the Foreign Key 
+   :column FOR_REF: Database/Table being referenced by the Foreign Key
+   :column N_COLS: Number of columns in the foreign key.
+   :column TYPE: Type of foreign key, represented by the bit flags.
+
+.. table:: INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS
+
+   Shows the information about the columns of the |InnoDB| foreign keys.
+
+   :column ID: Foreign Key ID
+   :column FOR_COL_NAME: Foreign Key Column Name
+   :column FOR_REF: Referenced Column Name
+   :column POS: Position of the field inside the index.
 
 .. table:: INFORMATION_SCHEMA.INNODB_TABLE_STATS
 
@@ -76,7 +155,7 @@
    :column other_size: Other index (non primary key) size in number of pages.
    :column modified: Internal counter to judge whether statistics recalculation should be done.
 
-If the value of modified column exceeds “rows / 16” or 2000000000, the statistics recalculation is done when ``innodb_stats_auto_update == 1``. We can estimate the oldness of the statistics by this value.
+If the value of modified column exceeds "rows / 16" or 2000000000, the statistics recalculation is done when ``innodb_stats_auto_update == 1``. We can estimate the oldness of the statistics by this value.
 
 .. table:: INFORMATION_SCHEMA.INNODB_INDEX_STATS
 
@@ -101,9 +180,7 @@
 Example
 =======
 
-This example uses the same data to Bug #30423 of |MySQL|.
-
-``[innodb_stats_method = nulls_equal (default behavior of |InnoDB|)]`` ::
+``[innodb_stats_method = nulls_equal (default behavior of InnoDB)]`` ::
 
   mysql> explain SELECT COUNT(*), 0 FROM orgs2 orgs LEFT JOIN sa_opportunities2 sa_opportunities ON orgs.org_id=sa_opportunities.org_id LEFT JOIN contacts2 contacts ON orgs.org_id=contacts.org_id;
   +----+-------------+------------------+-------+-----------------+-----------------+---------+-------------------+-------+-------------+
@@ -143,15 +220,15 @@
   | table_name             | index_name      | fields | row_per_keys | index_size | leaf_pages |
   +------------------------+-----------------+--------+--------------+------------+------------+
   | test/sa_opportunities2 | GEN_CLUST_INDEX |      1 | 1            |         21 |         20 |
-  | test/sa_opportunities2 | sa_opp$org_id   |      2 | 338, 1       |         11|         10 |
+  | test/sa_opportunities2 | sa_opp$org_id   |      2 | 338, 1       |          11|         10 |
   | test/orgs2             | orgs$org_id     |      1 | 1            |          1 |          1 |
   | test/contacts2         | GEN_CLUST_INDEX |      1 | 1            |       97   |         80 |
-  | test/contacts2         | contacts$org_id |      2 | 516, 0       |         97   |         37 |
+  | test/contacts2         | contacts$org_id |      2 | 516, 0       |       97   |         37 |
   +------------------------+-----------------+--------+--------------+------------+------------+
   5 rows in set (0.00 sec)
 
 Other reading
 =============
 
-  * `InnoDB Table/Index stats <http://www.mysqlperformanceblog.com/2010/03/20/|InnoDB|-tableindex-stats/>`_
+  * `InnoDB Table/Index stats <http://www.mysqlperformanceblog.com/2010/03/20/InnoDB-tableindex-stats/>`_
 
 
=== modified file 'doc/source/diagnostics/misc_info_schema_tables.rst'
--- doc/source/diagnostics/misc_info_schema_tables.rst	2012-10-19 12:06:24 +0000
+++ doc/source/diagnostics/misc_info_schema_tables.rst	2012-12-10 15:33:26 +0000
@@ -4,54 +4,10 @@
  Misc. INFORMATION_SCHEMA Tables
 =================================
 
-This page lists the ``INFORMATION_SCHEMA`` tables added to standard |MySQL| by |Percona Server| that don't exist elsewhere in the documentation.
-
-|InnoDB| transactions
-=====================
-
-.. table:: INFORMATION_SCHEMA.INNODB_LOCK_WAITS
-
-   :column REQUESTING_TRX_ID:
-   :column REQUESTED_LOCK_ID:
-   :column BLOCKING_TRX_ID:
-   :column BLOCKING_LOCK_ID:
-
-.. table:: INFORMATION_SCHEMA.INNODB_LOCKS
-
-   :column LOCK_ID:  Internal unique lock ID
-   :column LOCK_TRX_ID: ID of the transaction holding the lock
-   :column LOCK_MODE: Mode of the lock (shared, exclusive, …)
-   :column LOCK_TYPE: ``RECORD`` for a record lock and ``TABLE`` for a table lock
-   :column LOCK_TABLE: Name of the table holding the lock
-   :column LOCK_INDEX: If lock type is ``RECORD``, name of the index
-   :column LOCK_SPACE: If lock type is ``RECORD``, tablespace id of the locked record
-   :column LOCK_PAGE: If lock type is ``RECORD``, page number of the locked record
-   :column LOCK_REC: If lock type is ``RECORD``, heap number of the locked record
-   :column LOCK_DATA: If lock type is ``RECORD``, primary key of the locked record
-
-This table contains information on each lock that is requested by any transaction and on each lock that is held by any transaction. You can get details about the transactions involved by joining INNODB_LOCKS with INNODB_TRX on TRX_ID.
-
-This table was introduced by the |InnoDB| plugin and you can find the full documentation here.
-
-.. table:: INFORMATION_SCHEMA.INNODB_TRX
-
-   :column TRX_ID: |InnoDB| internal unique transaction id
-   :column TRX_STATE: Execution state. Possible values are: ``Running``, ``Lock_wait``, ``Rolling_back``, ``Committing``
-   :column TRX_STARTED:  Transaction start time
-   :column TRX_REQUESTED_LOCK_ID: Id of the lock the transaction has requested
-   :column TRX_WAIT_STARTED: Date and time when the transaction started waiting for a lock
-   :column TRX_WEIGHT: Weight of the transaction, ie approximate number of locked and modified rows
-   :column TRX_MYSQL_THREAD_ID: Thread id
-   :column TRX_QUERY: SQL query being executed
-
-This table holds information on every transaction running in the |InnoDB| kernel. Contrary to the output of SHOW |InnoDB| STATUS, it doesn't show information on idle transactions.
-
-This table was introduced by the |InnoDB| plugin and you can find the full documentation here.
-
 Temporary tables
 ================
 
- Only the temporary tables that were explicitly created with `CREATE TEMPORARY TABLE` or `ALTER TABLE` are shown, and not the ones created to process complex queries.
+ Only the temporary tables that were explicitly created with `CREATE TEMPORARY TABLE` or `ALTER TABLE` are shown, and not the ones created to process complex queries. 
 
 .. table:: INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES
 
@@ -85,6 +41,128 @@
 
 This table holds information on the temporary tables existing for the running connection.
 
+Buffer Pool Data Structure Tables
+=================================
+
+The following tables provide various information about the contents of the |InnoDB| buffer pool.
+
+.. table:: INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES
+
+  :column PAGE_TYPE: Type of the page. Possible values: index, undo_log, inode, ibuf_free_list, allocated, bitmap, sys, trx_sys, fsp_hdr, xdes, blob, zblob, zblob2, unknown
+  :column SPACE_ID: Tablespace ID
+  :column PAGE_NO:  Page offset within its tablespace
+  :column LRU_POSITION: Page position in the LRU list
+  :column FIX_COUNT: reference count of a page. It is incremented every time the page is accessed by |InnoDB|, and is 0 if and only if the page is not currently being accessed
+  :column FLUSH_TYPE: type of the last flush of the page (0:LRU 2:flush_list)
+
+Example: ::
+
+  mysql> select * from information_schema.INNODB_BUFFER_POOL_PAGES LIMIT 20;  
+  +-----------+----------+---------+--------------+-----------+------------+
+  | page_type | space_id | page_no | lru_position | fix_count | flush_type |
+  +-----------+----------+---------+--------------+-----------+------------+
+  | allocated |        0 |       7 |            3 |         0 |          2 | 
+  | allocated |        0 |       1 |            4 |         0 |          0 | 
+  | allocated |        0 |       3 |            5 |         0 |          0 | 
+  | inode     |        0 |       2 |            6 |         0 |          2 | 
+  | index     |        0 |       4 |            7 |         0 |          2 | 
+  | index     |        0 |      11 |            8 |         0 |          0 | 
+  | index     |        0 |   12956 |            9 |         0 |          0 | 
+  | allocated |        0 |       5 |           10 |         0 |          2 | 
+  | allocated |        0 |       6 |           11 |         0 |          2 | 
+  | undo_log  |        0 |      51 |           12 |         0 |          2 | 
+  | undo_log  |        0 |      52 |           13 |         0 |          2 | 
+  | index     |        0 |       8 |           14 |         0 |          0 | 
+  | index     |        0 |     288 |           15 |         0 |          0 | 
+  | index     |        0 |     290 |           16 |         0 |          2 | 
+  | index     |        0 |     304 |           17 |         0 |          0 | 
+  | allocated |        0 |       0 |           18 |         0 |          2 | 
+  | index     |        0 |      10 |           19 |         0 |          0 | 
+  | index     |        0 |   12973 |           20 |         0 |          0 | 
+  | index     |        0 |       9 |           21 |         0 |          2 | 
+  | index     |        0 |      12 |           22 |         0 |          0 | 
+  +-----------+----------+---------+--------------+-----------+------------+
+  20 rows in set (0.81 sec)
+
+This table shows the characteristics of the allocated pages in buffer pool and current state of them.
+
+.. table:: INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_INDEX
+
+  :column index_id: index name
+  :column space_id: Tablespace ID
+  :column page_no: Page offset within its tablespace
+  :column n_recs: number of user records on page
+  :column data_size: sum of the sizes of the records in page
+  :column hashed: the block is in adaptive hash index (1) or not (0)
+  :column access_time: time of the last access to that page
+  :column modified: modified since loaded (1) or not (0)
+  :column dirty: modified since last flushed (1) or not (0)
+  :column old: is old blocks in the LRU list (1) or not (0)
+  :column lru_position: page position in the LRU list
+  :column fix_count: reference count of a page. It is incremented every time the page is accessed by |InnoDB|, and is 0 if and only if the page is not currently being accessed
+  :column flush_type: type of the last flush of the page (0:LRU 2:flush_list)
+
+Example: ::
+
+  +----------+----------+---------+--------+-----------+--------+-------------+----------+-------+-----+--------------+-----------+------------+
+  | index_id | space_id | page_no | n_recs | data_size | hashed | access_time | modified | dirty | old | lru_position | fix_count | flush_type |
+  +----------+----------+---------+--------+-----------+--------+-------------+----------+-------+-----+--------------+-----------+------------+
+  |       39 |        0 |    5787 |    468 |     14976 |      1 |  2636182517 |        1 |     0 |   1 |            0 |         0 |          2 |
+  |       40 |        0 |    5647 |   1300 |     15600 |      1 |  2636182517 |        1 |     0 |   1 |            0 |         0 |          2 |
+  |       39 |        0 |    5786 |    468 |     14976 |      1 |  2636182516 |        1 |     0 |   1 |            0 |         0 |          2 |
+  |       40 |        0 |    6938 |   1300 |     15600 |      1 |  2636193968 |        1 |     0 |   1 |            0 |         0 |          2 |
+  |       39 |        0 |    5785 |    468 |     14976 |      1 |  2636182514 |        1 |     0 |   1 |            0 |         0 |          2 |
+  |       39 |        0 |    5784 |    468 |     14976 |      1 |  2636182512 |        1 |     0 |   1 |            0 |         0 |          2 |
+  |       40 |        0 |    5646 |   1300 |     15600 |      1 |  2636182511 |        1 |     0 |   1 |            0 |         0 |          2 |
+  |       39 |        0 |    7203 |    468 |     14976 |      1 |  2636193967 |        1 |     0 |   1 |            0 |         0 |          2 |
+  |       39 |        0 |    5783 |    468 |     14976 |      1 |  2636182507 |        1 |     0 |   1 |            0 |         0 |          2 |
+  |       39 |        0 |    5782 |    468 |     14976 |      1 |  2636182506 |        1 |     0 |   1 |            0 |         0 |          2 |
+  +----------+----------+---------+--------+-----------+--------+-------------+----------+-------+-----+--------------+-----------+------------+
+
+This table shows information about the index pages located in the buffer pool.
+
+.. table:: INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_BLOB
+
+  :column space_id: tablespace ID
+  :column page_no: page offset within its tablespace
+  :column compressed:    contains compressed data (1) or not (0)
+  :column part_len:  data length in the page
+  :column next_page_no:  page number of the next data
+  :column lru_position: page position in the LRU list
+  :column fix_count: reference count of a page. It is incremented every time the page is accessed by InnoDB, and is 0 if and only if the page is not currently being accessed
+  :column flush_type:    type of the last flush of the page (0:LRU 2:flush_list)
+
+Example: ::
+
+  mysql> select * from information_schema.INNODB_BUFFER_POOL_PAGES_BLOB LIMIT 20;
+  +----------+---------+------------+----------+--------------+--------------+-----------+------------+
+  | space_id | page_no | compressed | part_len | next_page_no | lru_position | fix_count | flush_type |
+  +----------+---------+------------+----------+--------------+--------------+-----------+------------+
+  |     1748 |     111 |          0 |    10137 |            0 |          263 |         0 |          2 | 
+  |     1748 |     307 |          0 |     5210 |            0 |         1084 |         0 |          2 | 
+  |     1748 |    1329 |          0 |     6146 |            0 |         4244 |         0 |          2 | 
+  |     1748 |    1330 |          0 |    11475 |            0 |         4245 |         0 |          2 | 
+  |     1748 |    1345 |          0 |     5550 |            0 |         4247 |         0 |          2 | 
+  |     1748 |    1346 |          0 |     7597 |            0 |         4248 |         0 |          2 | 
+  |     1748 |    3105 |          0 |     6716 |            0 |         8919 |         0 |          2 | 
+  |     1748 |    3213 |          0 |     8170 |            0 |         9390 |         0 |          2 | 
+  |     1748 |    6142 |          0 |     5648 |            0 |        19638 |         0 |          2 | 
+  |     1748 |    7387 |          0 |    10634 |            0 |        24191 |         0 |          2 | 
+  |     1748 |    7426 |          0 |     5355 |            0 |        24194 |         0 |          2 | 
+  |     1748 |    7489 |          0 |    16330 |         7489 |        24196 |         0 |          2 | 
+  |     1748 |    7490 |          0 |     7126 |            0 |        24197 |         0 |          2 | 
+  |     1748 |    7657 |          0 |    13571 |            0 |        24681 |         0 |          2 | 
+  |     1748 |    7840 |          0 |    11208 |            0 |        25737 |         0 |          2 | 
+  |     1748 |    9599 |          0 |    11882 |            0 |        31989 |         0 |          2 | 
+  |     1748 |   11719 |          0 |     7367 |            0 |        40466 |         0 |          2 | 
+  |     1748 |   12051 |          0 |    11049 |            0 |        41441 |         0 |          2 | 
+  |     1748 |   12052 |          0 |    16330 |        12052 |        41442 |         0 |          2 | 
+  |     1748 |   12053 |          0 |     2674 |            0 |        41443 |         0 |          2 | 
+  +----------+---------+------------+----------+--------------+--------------+-----------+------------+
+  20 rows in set (0.05 sec)
+
+This table shows information from blob pages located in buffer pool.
+
 InnoDB Undo Logs
 ================
 
 
=== modified file 'doc/source/diagnostics/response_time_distribution.rst'
--- doc/source/diagnostics/response_time_distribution.rst	2012-09-18 05:04:43 +0000
+++ doc/source/diagnostics/response_time_distribution.rst	2012-12-10 15:33:26 +0000
@@ -6,7 +6,7 @@
 
 The slow query log provides exact information about queries that take a long time to execute. However, sometimes there are a large number of queries that each take a very short amount of time to execute. This feature provides a tool for analyzing that information by counting and displaying the number of queries according to the the length of time they took to execute. The user can define time intervals that divide the range 0 to positive infinity into smaller intervals and then collect the number of commands whose execution times fall into each of those intervals.
 
-Note that in a replication environment, the server will not take into account *any* queries executed by the slave's SQL thread (whether they are slow or not) for the time distribution unless the log_slow_slave_statements variable is set.
+Note that in a replication environment, the server will not take into account *any* queries executed by the slave's SQL thread (whether they are slow or not) for the time distribution unless the :variable:`log_slow_slave_statements` variable is set.
 
 The feature isn't implemented in all versions of the server. The variable :variable:`have_response_time_distribution` indicates whether or not it is implemented in the server you are running.
 
@@ -251,16 +251,7 @@
 
 .. table:: INFORMATION_SCHEMA.QUERY_RESPONSE_TIME
 
-   :column VARCHAR TIME: 
-   :column INT(11) COUNT: 
-   :column VARCHAR TOTAL:  
-
-Implementation Details
-======================
-
-Implementation details on this feature are provided here.
-
-Related Reading
-===============
-
-  * `Blueprint about Response Time Distribution <https://blueprints.launchpad.net/percona-server/+spec/response-time-distribution>`_
+   :column VARCHAR TIME: Interval range in which the query occurred
+   :column INT(11) COUNT: Number of queries with execution times that fell into that interval
+   :column VARCHAR TOTAL: Total execution time of the queries 
+
 
=== modified file 'doc/source/diagnostics/user_stats.rst'
--- doc/source/diagnostics/user_stats.rst	2012-09-18 05:04:43 +0000
+++ doc/source/diagnostics/user_stats.rst	2012-12-10 15:33:26 +0000
@@ -108,7 +108,7 @@
 
 This table shows statistics on index usage. An older version of the feature contained a single column that had the ``TABLE_SCHEMA``, ``TABLE_NAME`` and ``INDEX_NAME`` columns concatenated together. The |Percona| version of the feature separates these into three columns. Users can see entries only for tables to which they have ``SELECT`` access.
 
-This table makes it possible to do many things that were difficult or impossible previously. For example, you can use it to find unused indexes and generate DROP commands to remove them.
+This table makes it possible to do many things that were difficult or impossible previously. For example, you can use it to find unused indexes and generate DROP commands to remove them. If the index has not been used it won't be in this table.
 
 Example: ::
 
@@ -145,28 +145,30 @@
 
 .. table:: INFORMATION_SCHEMA.THREAD_STATISTICS
 
-  :column THREAD_ID: int(21)
-  :column TOTAL_CONNECTIONS: int(21)
-  :column CONCURRENT_CONNECTIONS: int(21)
-  :column CONNECTED_TIME: int(21)
-  :column BUSY_TIME: int(21)
-  :column CPU_TIME: int(21)
-  :column BYTES_RECEIVED: int(21)
-  :column BYTES_SENT: int(21)
-  :column BINLOG_BYTES_WRITTEN: int(21)
-  :column ROWS_FETCHED: int(21)
-  :column ROWS_UPDATED: int(21)
-  :column TABLE_ROWS_READ: int(21)
-  :column SELECT_COMMANDS: int(21)
-  :column UPDATE_COMMANDS: int(21)
-  :column OTHER_COMMANDS: int(21)
-  :column COMMIT_TRANSACTIONS: int(21)
-  :column ROLLBACK_TRANSACTIONS: int(21)
-  :column DENIED_CONNECTIONS: int(21)
-  :column LOST_CONNECTIONS: int(21)
-  :column ACCESS_DENIED: int(21)
-  :column EMPTY_QUERIES: int(21)
-  :column TOTAL_SSL_CONNECTIONS: int(21)
+  :column THREAD_ID: Thread ID
+  :column TOTAL_CONNECTIONS: The number of connections created from this thread.
+  :column CONCURRENT_CONNECTIONS: The number of concurrent connections from this thread.
+  :column CONNECTED_TIME: The cumulative number of seconds elapsed while there were connections from this thread.
+  :column BUSY_TIME: The cumulative number of seconds there was activity from this thread.
+  :column CPU_TIME: The cumulative CPU time elapsed while servicing this thread.
+  :column BYTES_RECEIVED: The number of bytes received from this thread.
+  :column BYTES_SENT: The number of bytes sent to this thread.
+  :column BINLOG_BYTES_WRITTEN: The number of bytes written to the binary log from this thread.
+  :column ROWS_FETCHED: The number of rows fetched by this thread.
+  :column ROWS_UPDATED: The number of rows updated by this thread.
+  :column TABLE_ROWS_READ: The number of rows read from tables by this tread.
+  :column SELECT_COMMANDS: The number of ``SELECT`` commands executed from this thread.
+  :column UPDATE_COMMANDS: The number of ``UPDATE`` commands executed from this thread.
+  :column OTHER_COMMANDS: The number of other commands executed from this thread.
+  :column COMMIT_TRANSACTIONS: The number of ``COMMIT`` commands issued by this thread.
+  :column ROLLBACK_TRANSACTIONS: The number of ``ROLLBACK`` commands issued by this thread.
+  :column DENIED_CONNECTIONS: The number of connections denied to this thread.
+  :column LOST_CONNECTIONS: The number of thread connections that were terminated uncleanly.
+  :column ACCESS_DENIED: The number of times this thread issued commands that were denied.
+  :column EMPTY_QUERIES: The number of times this thread sent empty queries to the server.
+  :column TOTAL_SSL_CONNECTIONS:  The number of thread connections that used SSL.
+
+In order for this table to be populated with statistics, additional variable :variable:`thread_statistics` should be set to ``ON``.
 
 .. table:: INFORMATION_SCHEMA.USER_STATISTICS
 
 
=== modified file 'doc/source/index.rst'
--- doc/source/index.rst	2012-10-31 16:45:42 +0000
+++ doc/source/index.rst	2012-12-10 15:33:26 +0000
@@ -136,7 +136,6 @@
    :maxdepth: 1
    :glob:
 
-   diagnostics/index_info_schema_tables
    diagnostics/innodb_stats
    diagnostics/user_stats
    diagnostics/slow_extended_55
@@ -169,6 +168,7 @@
    development
    trademark-policy
    upstream-bug-fixes
+   index_info_schema_tables
    faq
    compatibility
    release-notes/release-notes_index
 
=== renamed file 'doc/source/diagnostics/index_info_schema_tables.rst' => 'doc/source/index_info_schema_tables.rst'
--- doc/source/diagnostics/index_info_schema_tables.rst	2012-10-11 09:53:58 +0000
+++ doc/source/index_info_schema_tables.rst	2012-12-10 15:33:26 +0000
@@ -6,25 +6,53 @@
 
 This is a list of the ``INFORMATION_SCHEMA TABLES`` that exist in |Percona Server| with |XtraDB|. The entry for each table points to the page in the documentation where it's described.
 
+  * :table:`CLIENT_STATISTICS`
+
+  * :table:`INDEX_STATISTICS`
+
   * :table:`GLOBAL_TEMPORARY_TABLES`
 
-  * :table:`INNODB_INDEX_STATS`
-
-  * :table:`INNODB_LOCK_WAITS`
-
-  * :table:`INNODB_LOCKS`
-
-  * :table:`INNODB_RSEG`
-
-  * :table:`INNODB_TABLE_STATS`
-
-  * :table:`INNODB_TRX`
-
-  * :table:`PROCESSLIST`
-
   * :table:`QUERY_RESPONSE_TIME`
 
+  * :table:`TABLE_STATISTICS`
+
   * :table:`TEMPORARY_TABLES`
 
+  * :table:`THREAD_STATISTICS`
+
+  * :table:`USER_STATISTICS`
+
+  * :table:`INNODB_RSEG`
+
   * :table:`INNODB_UNDO_LOGS`
 
+  * :table:`INNODB_SYS_TABLESTATS`
+
+  * :table:`INNODB_INDEX_STATS`
+
+  * :table:`INNODB_CHANGED_PAGES`
+
+  * :table:`INNODB_BUFFER_POOL_PAGES`
+
+  * :table:`INNODB_BUFFER_POOL_PAGES_BLOB`
+
+  * :table:`INNODB_BUFFER_POOL_PAGES_INDEX`
+
+  * :table:`INNODB_SYS_TABLES`
+
+  * :table:`INNODB_SYS_FIELDS`
+
+  * :table:`INNODB_SYS_COLUMNS`
+
+  * :table:`INNODB_SYS_STATS`
+
+  * :table:`INNODB_SYS_FOREIGN`
+
+  * :table:`INNODB_SYS_INDEXES`
+
+  * :table:`XTRADB_ADMIN_COMMAND`
+
+  * :table:`INNODB_TABLE_STATS`
+
+  * :table:`INNODB_SYS_FOREIGN_COLS`
+
 
=== modified file 'doc/source/management/innodb_lru_dump_restore.rst'
--- doc/source/management/innodb_lru_dump_restore.rst	2012-09-04 23:24:39 +0000
+++ doc/source/management/innodb_lru_dump_restore.rst	2012-12-10 15:33:26 +0000
@@ -80,7 +80,7 @@
 Status Information
 ==================
 
-Status information about the dump and restore is written to the server``s error file: ::
+Status information about the dump and restore is written to the server's error file: ::
 
   ....
   091217 11:49:16 InnoDB: administration command ``XTRA_LRU_DUMP`` was detected.
@@ -145,7 +145,7 @@
      :default: OFF
      :range: ON/OFF
 
-When this variable is set to ON XtraDB waits until the restore of the dump is completed before reporting successful startup to the server.
+When this variable is set to ON |XtraDB| waits until the restore of the dump is completed before reporting successful startup to the server.
 
 
 .. variable:: innodb_buffer_pool_restore_at_startup
@@ -164,6 +164,14 @@
 
  This variable was added in release 5.5.10-20.1. Prior to that, it was named :variable:`innodb_auto_lru_dump`, which still exists in earlier versions.
 
+``INFORMATION_SCHEMA`` Tables
+=============================
+
+This feature provides the following table:
+
+.. table:: INFORMATION_SCHEMA.XTRADB_ADMIN_COMMAND
+
+  :column result_message: result message of the ``XTRADB_ADMIN_COMMAND`` 
 
 Other reading
 =============