0

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.

1
  • 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, 2013 at 13:22

1 Answer 1

1

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...

1
  • 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). Feb 27, 2013 at 13:23

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .