XtraDB changed page tracking is broken when innodb_data_home_dir and datadir are different
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
|
Undecided
|
Unassigned | |||
5.5 |
New
|
Undecided
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
When enabling innodb_
data:
-rw-rw---- 1 user group 56 May 27 16:58 auto.cnf
-rw-rw---- 1 user group 4096 May 27 16:58 ib_modified_
-rw-rw---- 1 user group 4096 May 27 17:34 ib_modified_
-rw-rw---- 1 user group 4376 May 27 17:49 innodb_status.12624
drwxrwx--- 2 user group 4096 May 27 16:58 mysql
drwxrwx--- 2 user group 4096 May 27 16:58 performance_schema
-r-------- 1 user group 1675 May 7 16:29 private_key.pem
-r--r--r-- 1 user group 451 May 7 16:29 public_key.pem
ibdata:
-rw-rw---- 1 user group 962 May 27 17:32 ib_buffer_pool
-rw-rw---- 1 user group 12582912 May 27 17:34 ibdata1
-rw-rw---- 1 user group 32768 May 27 16:58 ib_modified_
-rw-rw---- 1 user group 4096 May 27 16:58 ib_modified_
I suspect that XtraDB changed page tracking is incorrectly implemented and using two variables (datadir and innodb_
Sample my.cnf values:
datadir=
innodb_
Changed in percona-server: | |
assignee: | nobody → Muhammad Irfan (muhammad-irfan) |
The bitmap directory is setup using srv_data_home source code variable, which in turn is innodb_ data_home_ dir if that one is set, or datadir if the former is not set.