[DOC] Document limitation of userstats regarding partitioned tables

Bug #1207644 reported by Przemek
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Hrvoje Matijakovic
5.1
Fix Released
Medium
Hrvoje Matijakovic
5.5
Fix Released
Medium
Hrvoje Matijakovic
5.6
Fix Released
Medium
Hrvoje Matijakovic

Bug Description

[In:Percona Server Documentation]
As per still not fixed bug: lp:625045 - table and index statistics don't work with partitioned tables. Please describe this limitation in documentation - http://www.percona.com/doc/percona-server/5.5/diagnostics/user_stats.html

Tags: doc

Related branches

Przemek (pmalkowski)
description: updated
Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

Same with documentation for 5.1 and 5.6 - we have to document this limitation until https://bugs.launchpad.net/percona-server/+bug/625045 is fixed:

[openxs@chief p5.6]$ bin/mysql --no-defaults -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.12 MySQL Community Server (GPL)

Copyright (c) 2009-2013 Percona Ireland Ltd.
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create table t1 (id int primary key) engine=InnoDB; Query OK, 0 rows affected (0.41 sec)

mysql> create table p1 (id int primary key) engine=InnoDB partition by hash(id) partitions 8;
Query OK, 0 rows affected (2.59 sec)

mysql> insert into t1 values (2), (33), (3), (100), (4);
Query OK, 5 rows affected (0.04 sec)
Records: 5 Duplicates: 0 Warnings: 0

mysql> insert into p1 values (2), (33), (3), (100), (4);
Query OK, 5 rows affected (0.03 sec)
Records: 5 Duplicates: 0 Warnings: 0

mysql> set global userstat=1;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+-----+
| id |
+-----+
| 2 |
| 3 |
| 4 |
| 33 |
| 100 |
+-----+
5 rows in set (0.00 sec)

mysql> select * from p1;
+-----+
| id |
+-----+
| 33 |
| 2 |
| 3 |
| 4 |
| 100 |
+-----+
5 rows in set (0.00 sec)

mysql> select * from INFORMATION_SCHEMA.INDEX_STATISTICS;
+--------------+------------+------------+-----------+
| TABLE_SCHEMA | TABLE_NAME | INDEX_NAME | ROWS_READ |
+--------------+------------+------------+-----------+
| test | t1 | PRIMARY | 5 |
+--------------+------------+------------+-----------+
1 row in set (0.00 sec)

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1406

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.