inserts and updates to MRG_MYISAM table not tracked in TABLE_STATISTICS
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Low
|
Unassigned | |||
5.5 |
Triaged
|
Low
|
Unassigned | |||
5.6 |
Triaged
|
Low
|
Unassigned | |||
5.7 |
Triaged
|
Low
|
Unassigned |
Bug Description
I just upgraded from mysql 5.0 to percona 5.1.55. I noticed that TABLE_STATISTIC
Here is sql to reproduce:
CREATE TABLE mrg_tbl1 (id INT(11) NOT NULL AUTO_INCREMENT, field1 INT(11) NULL DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MYISAM;
CREATE TABLE mrg_tbl2 (id INT(11) NOT NULL AUTO_INCREMENT, field1 INT(11) NULL DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MYISAM;
CREATE TABLE mrg_tbl ( id INT(11) NOT NULL AUTO_INCREMENT, field1 INT(11) NULL DEFAULT NULL, PRIMARY KEY (id)) ENGINE=MRG_MYISAM UNION=(mrg_tbl1, mrg_tbl2) INSERT_METHOD=LAST;
insert into mrg_tbl (field1) Values(
update mrg_tbl set field1=20 where field1=10;
select * from mrg_tbl;
select * from information_
Notice that it adds a row for mrg_tbl2 with ROWS_READ=3, ROWS_CHANGED=0.
These are our busiest tables and I really wanted to see statistics for them
Changed in percona-server: | |
assignee: | nobody → Valentine Gostev (core-longbow) |
tags: | added: userstat |
Setting to Low priority, unlikely to be looked at soon unless is customer request to fix sooner.