Differences in file size of .ibds across cluster
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Expired
|
Undecided
|
Unassigned |
Bug Description
We have a galera cluster with pxc 5.6.22:
root@elvispresl
|/ Err?=(none)
ii percona-toolkit 2.2.13 all Advanced MySQL and system command-line tools
ii percona-xtrabackup 2.2.10-1.wheezy amd64 Open source backup tool for InnoDB and XtraDB
ii percona-
ii percona-
ii percona-
ii percona-
ii xtrabackup 2.2.10-1.wheezy all Transitional package for percona-xtrabackup
we noticed that on disk we have a particular table with different file size on one node then all the other nodes:
root@elvispresl
-rw-rw---- 1 mysql mysql 4538236928 Sep 9 01:58 api_facebook_
while on all other nodes:
root@johnnycash
-rw-rw---- 1 mysql mysql 11932794880 Sep 9 01:58 api_facebook_
When we check inside mysql:
mysql {elvispresley} >SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" FROM information_
+------
| Table | Size in MB |
+------
| api_facebook_
+------
1 row in set (0.00 sec)
on all the other nodes:
mysql {johnnycash} >SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" FROM information_
+------
| Table | Size in MB |
+------
| api_facebook_
+------
1 row in set (0.00 sec)
However the data seems to be okay:
mysql {elvispresley} >select count(*) from example.
| count(*) |
+----------+
| 1016 |
+----------+
1 row in set (10.19 sec)
while on all others it returns immediately:
mysql {johnnycash} >select count(*) from example.
| count(*) |
+----------+
| 1016 |
+----------+
1 row in set (0.00 sec)
This shouldn't happen?
Changed in percona-xtradb-cluster: | |
status: | New → Incomplete |
No response in close to a month?