Take the 2-minute tour ×
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.

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

1 Answer 1

up vote 1 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

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.