I visited a customer some weeks back and saw some regression
problem during an upgrade to MySQL 5.6. Problem was during
initial setup of database, the CREATE TABLE statements was
running much slower on MySQL 5.6 compared to MySQL 5.5.
I created a simple test case where I create one SQL file
containing 1000 CREATE TABLE using the following statement
syntax: CREATE TABLE TNNNN (i int, name
VARCHAR(12))ENGINE=InnoDB;
Tested MySQL Versions:
- MySQL 5.5.42
- MySQL 5.6.22
OS: Ubuntu 14.04
HW: My Toshiba Portege laptop with 2 cores and SSD disk
MySQL 5.5.42 (Default settings)
Lets first get our baseline by running 10 runs: mysql test <
/tmp/1000tables
Result: average execution time is 7.5 seconds
MySQL 5.6.22 (Default settings)
Lets first get our baseline by running 10 runs: mysql …