Comment 2 for bug 1323889

Revision history for this message
Muhammad Irfan (muhammad-irfan) wrote :

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%';
+-------------------------+------------------------+
| Variable_name | Value |
+-------------------------+------------------------+
| innodb_version | 5.6.17-65.0 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.17-65.0-587.wheezy |
| version_comment | (Debian) |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+------------------------+

mysql> SHOW VARIABLES LIKE 'innodb_track_changed_pages';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| innodb_track_changed_pages | ON |
+----------------------------+-------+

# cat /etc/my.cnf
[mysqld]
datadir = /var/lib/mysql
innodb_data_home_dir= /var/lib/mysql/ibdata
innodb_track_changed_pages = 1

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