information_schema.index_statistics isn't populated for tokudb tables
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.6 |
Fix Released
|
Wishlist
|
George Ormond Lorch III | |||
5.7 |
Fix Released
|
Wishlist
|
George Ormond Lorch III |
Bug Description
No index stats are written for tables that use the tokudb engine.
While the test case is simple, this holds true for complex tables with billions of rows of data.
[test]> create table test_innodb (id tinyint(3) not null primary key) engine=innodb;
Query OK, 0 rows affected (0.03 sec)
[test]> create table test_tokudb (id tinyint(3) not null primary key) engine=tokudb;
Query OK, 0 rows affected (0.04 sec)
[test]> insert into test_innodb values (1);
Query OK, 1 row affected (0.01 sec)
[test]> insert into test_innodb values (2);
Query OK, 1 row affected (0.00 sec)
[test]> insert into test_tokudb values (1);
Query OK, 1 row affected (0.01 sec)
[test]> insert into test_tokudb values (2);
Query OK, 1 row affected (0.01 sec)
[test]> flush index_statistics;
Query OK, 0 rows affected (0.01 sec)
[test]> select * from test_innodb where id = 1;
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.00 sec)
[test]> select * from test_tokudb where id = 1;
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.00 sec)
[test]> select * from information_
+------
| TABLE_SCHEMA | TABLE_NAME | INDEX_NAME | ROWS_READ |
+------
| test | test_innodb | PRIMARY | 1 |
+------
3 rows in set (0.00 sec)
[test]> select version();
+--------------+
| version() |
+--------------+
| 5.7.14-8-log |
+--------------+
1 row in set (0.00 sec)
[test]> show global variables like 'userstat';
+------
| Variable_name | Value |
+------
| userstat | ON |
+------
1 row in set (0.00 sec)
tags: | added: tokudb |
This is correct, tokudb does not nor has ever provided any of the Percona Server added user statistics described here https:/ /www.percona. com/doc/ percona- server/ 5.5/diagnostics /user_stats. html
It is on the long term roadmap with no scheduled implementation time.