This is easy to verify: [openxs@chief p5.5]$ bin/mysql --no-defaults -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.32 MySQL Community Server (GPL) Copyright (c) 2009-2013 Percona Ireland Ltd. 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> CREATE TABLE tb1 ( -> id INT NOT NULL AUTO_INCREMENT, -> created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -> PRIMARY KEY (id, created), -> c1 INT, -> c2 INT, -> INDEX (c1), -> INDEX(c2) -> ) ENGINE=INNODB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED -> PARTITION BY RANGE (TO_DAYS(created)) -> ( -> PARTITION p83 VALUES LESS THAN (735484) ENGINE = InnoDB, -> PARTITION p84 VALUES LESS THAN (735491) ENGINE = InnoDB, -> PARTITION p85 VALUES LESS THAN (735498) ENGINE = InnoDB -> ); Query OK, 0 rows affected, 6 warnings (0.19 sec) mysql> show create table tb1\G *************************** 1. row *************************** Table: tb1 Create Table: CREATE TABLE `tb1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `c1` int(11) DEFAULT NULL, `c2` int(11) DEFAULT NULL, PRIMARY KEY (`id`,`created`), KEY `c1` (`c1`), KEY `c2` (`c2`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED /*!50100 PARTITION BY RANGE (TO_DAYS(created)) (PARTITION p83 VALUES LESS THAN (735484) ENGINE = InnoDB, PARTITION p84 VALUES LESS THAN (735491) ENGINE = InnoDB, PARTITION p85 VALUES LESS THAN (735498) ENGINE = InnoDB) */ 1 row in set (0.00 sec) mysql> exit Bye [openxs@chief p5.5]$ bin/mysqldump --no-defaults --innodb-optimize-keys -uroot test tb1 -- MySQL dump 10.13 Distrib 5.5.32, for Linux (x86_64) -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 5.5.32 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `tb1` -- DROP TABLE IF EXISTS `tb1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tb1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `c1` int(11) DEFAULT NULL, `c2` int(11) DEFAULT NULL, PRIMARY KEY (`id`,`created`), ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED /*!50100 PARTITION BY RANGE (TO_DAYS(created)) (PARTITION p83 VALUES LESS THAN (735484) ENGINE = InnoDB, PARTITION p84 VALUES LESS THAN (735491) ENGINE = InnoDB, PARTITION p85 VALUES LESS THAN (735498) ENGINE = InnoDB) */; /*!40101 SET character_set_client = @saved_cs_client */; ...