Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

In the following scenario:

  • same hardware
  • same mysql version
  • same configuration settings
  • same load
  • using latest stable version of the OS

Does the OS has an impact on MySQL overall performance? The customer's IT staff is advising on chaning Ubuntu LTS with CentOS to improve performance.

Am I missing something?

I would undestand the impact of a distro like Gentoo or Arch Linux, but not really CentOS.

share|improve this question
    
I think it will be difficult for anyone to answer this without doing an apples-to-apples test. You should do your own testing where you use the same version of MySQL with identical configuration settings not only of MySQL (my.cnf) but of the filesystem, etc. I would be very surprised if after all that effort to standardize if there was a significant performance difference. –  HTTP500 Feb 27 '13 at 13:22
add comment

1 Answer

up vote 1 down vote accepted

Benchmark it and test for yourself...

You will find that the different operating systems may have different application-level defaults. So examine configuration files closely before deeming that everything has the "same config".

The kernels are also different and have different OS-level default settings. Think about sysctl.conf settings, for instance.

Or think about how RHEL/CentOS 6 and newer systems have the tuned-adm framework to set server performance profiles...

share|improve this answer
    
I agree with ewwhite. You should ask them on what basis CentOS could give mysql faster perfomances. From what I know, performances differences are (in general) related to different kernel versions/patches, filesystems (and their mount options) and, of course, software versions (e.g. mysql 4 vs mysql 5). –  Andrea de Palo Feb 27 '13 at 13:23
    
Thank you for your input. –  FlorinelChis Feb 27 '13 at 13:46
add comment

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.