Re: Mysql performance between installation

[Rick James]

And nothing else is going on on the machines?

Puzzling.

The 40-minute load could _partially_ be explained by a terribly fragmented disk. But I would not expect 8x slowdown. Probably not even 2x.

Here's what is going on:
CREATE DATABASE --> mkdir
CREATE TABLE --> creates 1-3 files in the directory, plus some stuff in ibdata1 (if ENGINE=InnoDB). .frm file contains schema.
INSERT --> populate the data and index(es) for the table. This goes into .ibd or ibdata1 (InnoDB) or .MYD and .MYI (MyISAM).

The effort taken for those should be virtually the same for given OS and MySQL versions. (Windows vs Unix has some noticeable differences.)

Are both using the same "engine"? Is innodb_file_per_table the same on both? You may as well compare all of
SHOW VARIABLES LIKE 'innodb%'.