C:\dbs>net start mysqld56 The MySQLD56 service is starting. The MySQLD56 service was started successfully. C:\dbs>56 C:\dbs>c:\dbs\5.6\bin\mysql -uroot --port=3560 --debug-info --prompt="mysql 5.6 > " Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.24 Source distribution Copyright (c) 2000, 2015, 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 5.6 > use test Database changed mysql 5.6 > CREATE TABLE `digest_partition_test` ( -> `id` int NOT NULL, -> `end_time` datetime NOT NULL, -> PRIMARY KEY (`id`,`end_time`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 -> /*!50100 PARTITION BY RANGE (TO_DAYS(end_time)) -> (PARTITION invalid_dates VALUES LESS THAN (0) ENGINE = InnoDB, -> PARTITION day_20150201 VALUES LESS THAN (735996) ENGINE = InnoDB, -> PARTITION day_20150202 VALUES LESS THAN (735997) ENGINE = InnoDB, -> PARTITION day_20150203 VALUES LESS THAN (735998) ENGINE = InnoDB, -> PARTITION day_20150204 VALUES LESS THAN (735999) ENGINE = InnoDB, -> PARTITION day_20150205 VALUES LESS THAN (736000) ENGINE = InnoDB, -> PARTITION day_20150206 VALUES LESS THAN (736001) ENGINE = InnoDB, -> PARTITION day_20150207 VALUES LESS THAN (736002) ENGINE = InnoDB, -> PARTITION day_20150208 VALUES LESS THAN (736003) ENGINE = InnoDB, -> PARTITION day_20150209 VALUES LESS THAN (736004) ENGINE = InnoDB, -> PARTITION day_20150210 VALUES LESS THAN (736005) ENGINE = InnoDB, -> PARTITION day_20150211 VALUES LESS THAN (736006) ENGINE = InnoDB, -> PARTITION day_20150212 VALUES LESS THAN (736007) ENGINE = InnoDB, -> PARTITION day_20150213 VALUES LESS THAN (736008) ENGINE = InnoDB, -> PARTITION day_20150214 VALUES LESS THAN (736009) ENGINE = InnoDB, -> PARTITION max VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; Query OK, 0 rows affected (2.41 sec) mysql 5.6 > mysql 5.6 > UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE '%statements%'; Query OK, 2 rows affected (0.00 sec) Rows matched: 4 Changed: 2 Warnings: 0 mysql 5.6 > mysql 5.6 > ALTER TABLE digest_partition_test DROP PARTITION day_20150201; Query OK, 0 rows affected (0.44 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql 5.6 > ALTER TABLE digest_partition_test DROP PARTITION day_20150202; Query OK, 0 rows affected (0.38 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql 5.6 > SELECT SQL_TEXT,DIGEST,DIGEST_TEXT FROM performance_schema.events_statements_history; +----------------------------------------------------------------------------------------------+----------------------------------+--------------------------------------------------------------------------------+ | SQL_TEXT | DIGEST | DIGEST_TEXT | +----------------------------------------------------------------------------------------------+----------------------------------+--------------------------------------------------------------------------------+ | UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE '%statements%' | b8e52ce9f72eff66025a0ae4876e9696 | UPDATE performance_schema . setup_consumers SET ENABLED = ? WHERE NAME LIKE ? | | ALTER TABLE digest_partition_test DROP PARTITION day_20150201 | c51621124025ea4c9cf819138da6ccf5 | ALTER TABLE digest_partition_test DROP PARTITION day_20150201 | | ALTER TABLE digest_partition_test DROP PARTITION day_20150202 | 787acb4ab613d4dc30e47b04e2a74c2d | ALTER TABLE digest_partition_test DROP PARTITION day_20150202 | +----------------------------------------------------------------------------------------------+----------------------------------+--------------------------------------------------------------------------------+ 3 rows in set (0.00 sec) mysql 5.6 > exit Bye C:\dbs>net start mysqld57 The requested service has already been started. More help is available by typing NET HELPMSG 2182. C:\dbs>57 C:\dbs>c:\dbs\5.7\bin\mysql -uroot --port=3570 --prompt="mysql 5.7 > " Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.6-m16-debug Source distribution Copyright (c) 2000, 2015, 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 5.7 > use test Database changed mysql 5.7 > CREATE TABLE `digest_partition_test` ( -> `id` int NOT NULL, -> `end_time` datetime NOT NULL, -> PRIMARY KEY (`id`,`end_time`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 -> /*!50100 PARTITION BY RANGE (TO_DAYS(end_time)) -> (PARTITION invalid_dates VALUES LESS THAN (0) ENGINE = InnoDB, -> PARTITION day_20150201 VALUES LESS THAN (735996) ENGINE = InnoDB, -> PARTITION day_20150202 VALUES LESS THAN (735997) ENGINE = InnoDB, -> PARTITION day_20150203 VALUES LESS THAN (735998) ENGINE = InnoDB, -> PARTITION day_20150204 VALUES LESS THAN (735999) ENGINE = InnoDB, -> PARTITION day_20150205 VALUES LESS THAN (736000) ENGINE = InnoDB, -> PARTITION day_20150206 VALUES LESS THAN (736001) ENGINE = InnoDB, -> PARTITION day_20150207 VALUES LESS THAN (736002) ENGINE = InnoDB, -> PARTITION day_20150208 VALUES LESS THAN (736003) ENGINE = InnoDB, -> PARTITION day_20150209 VALUES LESS THAN (736004) ENGINE = InnoDB, -> PARTITION day_20150210 VALUES LESS THAN (736005) ENGINE = InnoDB, -> PARTITION day_20150211 VALUES LESS THAN (736006) ENGINE = InnoDB, -> PARTITION day_20150212 VALUES LESS THAN (736007) ENGINE = InnoDB, -> PARTITION day_20150213 VALUES LESS THAN (736008) ENGINE = InnoDB, -> PARTITION day_20150214 VALUES LESS THAN (736009) ENGINE = InnoDB, -> PARTITION max VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; Query OK, 0 rows affected (4.25 sec) mysql 5.7 > mysql 5.7 > UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE '%statements%'; Query OK, 2 rows affected (0.00 sec) Rows matched: 4 Changed: 2 Warnings: 0 mysql 5.7 > mysql 5.7 > ALTER TABLE digest_partition_test DROP PARTITION day_20150201; Query OK, 0 rows affected (0.58 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql 5.7 > ALTER TABLE digest_partition_test DROP PARTITION day_20150202; Query OK, 0 rows affected (0.52 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql 5.7 > SELECT SQL_TEXT,DIGEST,DIGEST_TEXT FROM performance_schema.events_statements_history; +----------------------------------------------------------------------------------------------+----------------------------------+--------------------------------------------------------------------------------+ | SQL_TEXT | DIGEST | DIGEST_TEXT | +----------------------------------------------------------------------------------------------+----------------------------------+--------------------------------------------------------------------------------+ | UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE '%statements%' | 6f2ef0e3df7d9764b0485717dcd05012 | UPDATE performance_schema . setup_consumers SET ENABLED = ? WHERE NAME LIKE ? | | ALTER TABLE digest_partition_test DROP PARTITION day_20150201 | 50c8f37d1908e4fb2ac63feb4b5b4c1b | ALTER TABLE digest_partition_test DROP PARTITION day_20150201 | | ALTER TABLE digest_partition_test DROP PARTITION day_20150202 | bab802f8d42f6f451e0a74172abcdf20 | ALTER TABLE digest_partition_test DROP PARTITION day_20150202 | +----------------------------------------------------------------------------------------------+----------------------------------+--------------------------------------------------------------------------------+ 3 rows in set (0.00 sec)