MySQL Windows vs. Linux: performance, caveats, pros and cons?

Posted by gravyface on Server Fault See other posts from Server Fault or by gravyface
Published on 2010-06-09T19:02:57Z Indexed on 2010/06/09 19:12 UTC
Read the original article Hit count: 300

Looking for (preferrably) some hard data or at least some experienced anecdotal responses with regards to hosting a MySQL database (roughly 5k transactions a day, 60-70% more reads than writes, < 100k of data per transaction i.e. no large binary objects like images, etc.) on Windows 2003/2008 vs. a Debian-based derivative (Ubuntu/Debian, etc.). This server will function only as a database server with a separate Web server on another physical box; this server will require remote access for management (SSH for Linux, RDP for Windows).

I suspect that the Linux kernel/OS will compete less than the Windows Server for resources, but for this I can't be certain. There's also security footprint: even with Windows 2008, I'm thinking that the Linux box can be locked down more easily than the Windows Server.

Anyone have any experience with both configurations?

© Server Fault or respective owner

Related posts about windows-server-2003

Related posts about mysql