MySQL Performance on OS X

Ever wondered why performance of MySQL on OS X was so much worse than a Linux or windows counterpart - especially when doing DROP/CREATE statements (ie in the setup of integration tests etc)? It turns out Mac OS has a safer file creation function than is available on other operating systems and the use of that slows down performance of file operations in MySQL.

You can fix this quickly by adding the following to your my.cnf file in the [server] block. It’s probably best not to do this in production, but who actually uses OS X as a production web server anyway?


Source: The original MySQL bug report (although it’s not really a bug).