I'll be setting up a new box soon. Since I colo, I can easily choose the OS I'm going to use on it. The box is going to serve as a dedicated mysqld server, apache won't even be installed on it.

Any recommendations for the best OS for mysqld?

I use freebsd 4.x for apache, but due to it's threading problems it isnt good for sql. I don't want to mess with freebsd 5.x till its stable, either.

Greetings:

We found Sun Solaris to be the best OS for working with high load mySQL sites.

RedHat Linux does ok.

Thank you.

I'd go with either Solaris, allthough it's a pain to work with, or Gentoo / Debian linux running the 2.6 series kernel.

I would have to agree that Solaris or a Linux would be your best bet. In a low-load situation mysql works fine on windows or one of the *BSD's though.

I've heard Fedora and the AMD Opterons work very well with eachother for MySQL.

Originally posted by Speakerguy
I don't want to mess with freebsd 5.x till its stable, either.

FreeBSD-5.2.1 is very stable, and works very well under SQL load. I would suggest going that route if you plan to use x86 hardware.

regards,
M.

Originally posted by Miha
FreeBSD-5.2.1 is very stable, and works very well under SQL load. I would suggest going that route if you plan to use x86 hardware.

regards,
M.

You don't by chance run any semi-high load SQL servers on 5.x, do you? I'd definately be interested in keeping all my servers on the same OS. Maybe its time to run 5.x on everything?

That aside, so far it's looking like Gentoo nix will work best. If I had money I'd go with Solaris, but I dont :-P

Originally posted by Speakerguy
You don't by chance run any semi-high load SQL servers on 5.x, do you? I'd definately be interested in keeping all my servers on the same OS. Maybe its time to run 5.x on everything?


I personally do not run the sites, but I administer quite number of servers running sites with pretty high SQL load. FreeBSD-5.1 did not work out well, however 5.2 appears to be very stable. We are slowly migrating from to 5.2, especially the SMP machines.

regards,
M.

I would use solaris if you could. At my work we have a mysql database on a 280r which is accessed by 16 blade servers which can handle anything we throw at it. If you are using x86, any distro with the 2.6 kernel would perform very well under high load. Also do not forget to tune mysql as that can have a large impact on performance too.

some ideas here

http://jeremy.zawodny.com/blog/archives/000203.html
http://jeremy.zawodny.com/blog/archives/000697.html