Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I know that MySQL is tested more on Linux (Oracle has it's own linux distribution and you canot have LAMP wit MySQL (meaning MySQL has always focused more on Linux)

My intuition says that MySQL has a better performance on Linux than on any other OS (including FreeBSD based MacOS). But I don't have facts to back it up.

Can you point me to any references which can help me determine whether moving MySQL from MacOS to Linux would give a performance boost= What has been your own experience?

I guess the only other way is to measure difference KPIs on both Linux and MacOS and then try to compare them. But I am trying to put more justifications for purchase of Linux ready hardware and cannot compare the two at the moment.

share|improve this question
    
For dev/test or production use? Hardly anybody uses Mac OS X Server in production. – Phil Mar 27 '12 at 14:13
    
we are the exception :). Macs every where Dev/Test/Production. – geoaxis Mar 27 '12 at 14:16
1  
I also ran on Mac XServes until recently (last 8 months). Anecdotal, but I didn't notice any performance increase that wasn't tied to hardware specs (moved to a clearly better server). Not part of your question, but the only issue I ran into in migration was table case sensitivity. Only pointing it out to help avoid mishaps! – Derek Downey Mar 27 '12 at 16:06
    
@DTest yeah table case sensitivity is a problem that we had to solve in application (make sure every thing was in in CAPS) – geoaxis Jun 5 '12 at 8:22
up vote 2 down vote accepted

As seen in the PDF, there's no clear winner when we compare MySql performance between different Kernel.

Since all databases are different, you will have to do benchmark to be sure. I think the hardware spec will affect the performance more than the OS.

share|improve this answer

Here is my opinion...

I've been working same database & routines on Debian 8 Database Virtual Server 32 GB RAM 8cpu Xenon vs MAC Maverics 8 GB RAM 4 cpu corei7 and MAC's performance is superior over 50 times on speed measures.

Then in order to use the same hardware settings I decided repeat the test Running debian 8 on my MAC versus MAC's Maverics. Again OSX is better.

The answer comes form the multicore response betwwen operatings systems. Debian Mysql trends to avoid multi-core while there is enought free memory reserving resources for other users. OSX performs distribution as soon as the process start consumming memory resources (of course Maverics is oriented on single user).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.