mysql> SHOW VARIABLES LIKE 'innodb_track_changed_pages';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| innodb_track_changed_pages | ON |
+----------------------------+-------+
root: /var/lib/mysql
# ll
total 98376
-rw-rw---- 1 mysql mysql 56 Jun 5 05:12 auto.cnf
-rw-r--r-- 1 root root 0 Jun 5 05:12 debian-5.6.flag
-rw-r----- 1 mysql root 30587 Jun 5 05:34 debian.err
-rw-rw---- 1 mysql mysql 5 Jun 5 05:34 debian.pid
drwxr-xr-x 2 mysql mysql 4096 Jun 5 05:34 ibdata
-rw-rw---- 1 mysql mysql 50331648 Jun 5 05:36 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Jun 5 05:28 ib_logfile1
drwx------ 2 mysql mysql 4096 Jun 5 05:28 mysql
-rw------- 1 root root 11 Jun 5 05:28 mysql_upgrade_info
drwx------ 2 mysql mysql 4096 Jun 5 05:28 performance_schema
drwx------ 2 mysql mysql 4096 Jun 5 05:30 test
root: /var/lib/mysql
# ls -lah ibdata/
total 13M
drwxr-xr-x 2 mysql mysql 4.0K Jun 5 05:34 .
drwx------ 6 mysql mysql 4.0K Jun 5 05:34 ..
-rw-rw---- 1 mysql mysql 12M Jun 5 05:36 ibdata1
-rw-rw---- 1 mysql mysql 80K Jun 5 05:36 ib_modified_log_1_0.xdb
I didn't able to reproduce it on PS 5.6.17-65.0, PS 5.5.37-35.0-35.0 & PS 5.1.73-14.11
mysql> SHOW VARIABLES LIKE '%version%'; ------- ------- -----+- ------- ------- ------- --+ ------- ------- -----+- ------- ------- ------- --+ conversions | | 65.0-587. wheezy | compile_ machine | x86_64 | ------- ------- -----+- ------- ------- ------- --+
+------
| Variable_name | Value |
+------
| innodb_version | 5.6.17-65.0 |
| protocol_version | 10 |
| slave_type_
| version | 5.6.17-
| version_comment | (Debian) |
| version_
| version_compile_os | debian-linux-gnu |
+------
mysql> SHOW VARIABLES LIKE 'innodb_ track_changed_ pages'; ------- ------- ------- -+----- --+ ------- ------- ------- -+----- --+ track_changed_ pages | ON | ------- ------- ------- -+----- --+
+------
| Variable_name | Value |
+------
| innodb_
+------
# cat /etc/my.cnf data_home_ dir= /var/lib/ mysql/ibdata track_changed_ pages = 1
[mysqld]
datadir = /var/lib/mysql
innodb_
innodb_
root: /var/lib/mysql
# ll
total 98376
-rw-rw---- 1 mysql mysql 56 Jun 5 05:12 auto.cnf
-rw-r--r-- 1 root root 0 Jun 5 05:12 debian-5.6.flag
-rw-r----- 1 mysql root 30587 Jun 5 05:34 debian.err
-rw-rw---- 1 mysql mysql 5 Jun 5 05:34 debian.pid
drwxr-xr-x 2 mysql mysql 4096 Jun 5 05:34 ibdata
-rw-rw---- 1 mysql mysql 50331648 Jun 5 05:36 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Jun 5 05:28 ib_logfile1
drwx------ 2 mysql mysql 4096 Jun 5 05:28 mysql
-rw------- 1 root root 11 Jun 5 05:28 mysql_upgrade_info
drwx------ 2 mysql mysql 4096 Jun 5 05:28 performance_schema
drwx------ 2 mysql mysql 4096 Jun 5 05:30 test
root: /var/lib/mysql log_1_0. xdb
# ls -lah ibdata/
total 13M
drwxr-xr-x 2 mysql mysql 4.0K Jun 5 05:34 .
drwx------ 6 mysql mysql 4.0K Jun 5 05:34 ..
-rw-rw---- 1 mysql mysql 12M Jun 5 05:36 ibdata1
-rw-rw---- 1 mysql mysql 80K Jun 5 05:36 ib_modified_