We help IT Professionals succeed at work.

Does a MySQL Database run better on Linux Server or Windows Server?

Medium Priority
423 Views
Last Modified: 2012-05-12
Does a MySQL Database run better/faster on Linux Server or Windows Server?
Comment
Watch Question

Technical Consultant - Linux
CERTIFIED EXPERT
Commented:
Hi,
MySQL under Linux always rocks because Windows MySQL has some limitations.
Check the given below URLs:
http://dev.mysql.com/doc/refman/5.0/en/limits-windows.html
http://informationideas.com/news/2008/05/01/mysql-on-windows-vs-linux/
Commented:
This may help

http://informationideas.com/news/2008/05/01/mysql-on-windows-vs-linux/

QUOTE

Then we decided to load the database onto other servers for more data points on this Mysql performance test. We ran the same query returning 429 rows of data with 13 table joins and a couple of sub-queries. All queries were run on the command line client on the servers themselves to avoid network lag.  All servers are running Mysql 5.0.x.

Results

1. Ubuntu Linux: 0.70 seconds
2. CentOS: 0.78 seconds
3. Windows 2003 Server: 1.40 seconds
4. Windows 2003 Server: 1.42 seconds

UNQUOTE

Commented:
Beat me to it...
Commented:
I'm running WAMP on a Windows box & LAMP on Ubuntu Server 11.10 with no issues on either. It really depends on how familair you are with either OS. I'd recomend using LAMP & Linux due to not having to worry with licensing issues.
Dave BaldwinFixer of Problems
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Yes, but the followup page of that article says that it ran the same when they ran it on the same hardware although their timing number is odd.

"The previous test just happened to have AMD 64s on the Linux machines and Intel Xeon 32bits on Windows."
I've used MySQL on both as well.  I have experienced no difference in performance.  Intuitively I've always wondered why a server needs to waste CPU on a GUI.  If you're databases start getting hefty, you may need to squeeze the CPU time for every ounce.  Linux runs easily without the GUI.  And again, no money for the the license, which can be quite painful, if you're not a non-profit.  I have command line scripts that make it easy to backup MySQL, and I'm not sure how they'd work on Windows.