Tests with PS 5.1.73-rel14.11 on Centos 6.5 Installed PS 5.1 and started server with innodb_track_changed_pages OFF [root@vagrant-centos65 lib]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql #innodb_data_home_dir=/var/lib/mysql/ibdata #innodb_track_changed_pages=1 socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [root@vagrant-centos65 lib]# service mysql start Starting MySQL (Percona Server). SUCCESS! [root@vagrant-centos65 lib]# ls mysql -lah total 21M drwx------ 5 mysql mysql 4.0K Jun 23 01:36 . drwxr-xr-x. 18 root root 4.0K Jun 23 01:35 .. drwxr-xr-x 2 mysql mysql 4.0K Jun 23 01:35 ibdata -rw-rw---- 1 mysql mysql 10M Jun 23 01:36 ibdata1 -rw-rw---- 1 mysql mysql 5.0M Jun 23 01:36 ib_logfile0 -rw-rw---- 1 mysql mysql 5.0M Jun 23 01:36 ib_logfile1 drwx------ 2 mysql mysql 4.0K Jun 23 01:35 mysql srwxrwxrwx 1 mysql mysql 0 Jun 23 01:36 mysql.sock drwx------ 2 mysql mysql 4.0K Jun 23 01:35 test -rw-rw---- 1 mysql mysql 5 Jun 23 01:36 vagrant-centos65.vagrantup.com.pid [root@vagrant-centos65 lib]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.73-rel14.11 Percona Server (GPL), 14.11, Revision 603 Copyright (c) 2009-2013 Percona LLC and/or its affiliates Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select @@version; +-----------------+ | @@version | +-----------------+ | 5.1.73-rel14.11 | +-----------------+ 1 row in set (0.00 sec) mysql> show variables like 'innodb_track%'; +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | innodb_track_changed_pages | OFF | +----------------------------+-------+ 1 row in set (0.00 sec) mysql> exit Bye Enabled innodb_track_changed_pages and also added innodb_data_home_dir [root@vagrant-centos65 lib]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql innodb_data_home_dir=/var/lib/mysql/ibdata innodb_track_changed_pages=1 socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [root@vagrant-centos65 lib]# service mysql restart Shutting down MySQL. SUCCESS! Starting MySQL (Percona Server). SUCCESS! [root@vagrant-centos65 lib]# ls -lah mysql total 21M drwx------ 5 mysql mysql 4.0K Jun 23 01:37 . drwxr-xr-x. 18 root root 4.0K Jun 23 01:35 .. drwxr-xr-x 2 mysql mysql 4.0K Jun 23 01:37 ibdata -rw-rw---- 1 mysql mysql 10M Jun 23 01:37 ibdata1 -rw-rw---- 1 mysql mysql 5.0M Jun 23 01:37 ib_logfile0 -rw-rw---- 1 mysql mysql 5.0M Jun 23 01:36 ib_logfile1 drwx------ 2 mysql mysql 4.0K Jun 23 01:35 mysql srwxrwxrwx 1 mysql mysql 0 Jun 23 01:37 mysql.sock drwx------ 2 mysql mysql 4.0K Jun 23 01:35 test -rw-rw---- 1 mysql mysql 5 Jun 23 01:37 vagrant-centos65.vagrantup.com.pid [root@vagrant-centos65 lib]# ls -lah mysql/ibdata total 11M drwxr-xr-x 2 mysql mysql 4.0K Jun 23 01:37 . drwx------ 5 mysql mysql 4.0K Jun 23 01:37 .. -rw-rw---- 1 mysql mysql 10M Jun 23 01:37 ibdata1 [root@vagrant-centos65 lib]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.73-rel14.11 Percona Server (GPL), 14.11, Revision 603 Copyright (c) 2009-2013 Percona LLC and/or its affiliates Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select @@version; +-----------------+ | @@version | +-----------------+ | 5.1.73-rel14.11 | +-----------------+ 1 row in set (0.00 sec) mysql> show variables like 'innodb_track%'; Empty set (0.00 sec) mysql> show engines; +------------+---------+----------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+----------------------------------------------------------------+--------------+------+------------+ | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | +------------+---------+----------------------------------------------------------------+--------------+------+------------+ 7 rows in set (0.00 sec) mysql> exit Bye Comment out innodb_track_change_pages and innodb_data_home_dir and then restart server will show innodb engine again. mysql> show variables like 'innodb_track%'; +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | innodb_track_changed_pages | OFF | +----------------------------+-------+ 1 row in set (0.00 sec) mysql> show engines; +------------+---------+----------------------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+----------------------------------------------------------------------------+--------------+------+------------+ | InnoDB | YES | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | +------------+---------+----------------------------------------------------------------------------+--------------+------+------------+ 8 rows in set (0.00 sec)