Huge performance differences between systems

[Julien Galiano]

Hello,

I'm new here so I hope I'm posting in the right section.

I'm having trouble executing a specific kind of query (it'a a CREATE TABLE statement with some UNION, LEFT JOIN, ... )

This query take 2.5 seconds to execute on my laptop running OSX, take 3.5 seconds on a Windows 7 desktop computer.

But when I run it on a linux, the exact same query with the exact same dump of data take 30 to 50 MINUTES.

I tried several physical servers (Dual Xeon, SAS disk, ...), several versions of MySQL (5.1, 5.5 and 5.6), on Virtual Machine on the cloud...

For all my tests I'm using a regular Mysql Installation, from the distribution using the default settings.

My question is How can I identify what's going wrong ?
And how it is possible that the differences between systems are so big, from a few seconds to tens of minutes ?

Thanks in advance for your help.

Regards,

Julien