MySQL InnoDB insertion is very slow

Question

We use MySQL server 5.1.43 64-bit edition. InnoDB is used as engine.

We have a sql script which we execute every time we build the application.

On ubuntu machine with MySQL server and InnoDB engine it takes about 55 seconds to complete the execution.

If I run the same script on OSX, it takes close to 3 minutes!

Any ideas why OSX is so slow while executing this script?

Answer 1

my crystal balls need more information. its not the same executing a script against a db on the same machine , consider the network overhead. especially if the inserts are data intensive

Answer 2

You may want to try starting the server with my.ini changed

innodb_flush_log_at_trx_commit=2

and change back to

innodb_flush_log_at_trx_commit=1

for production usage.

I suspected that the fsync api in osx is slower than linux?