Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

MySQL on Windows vs Linux

How does it compare?

6:40 pm on Sep 11, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 12, 2004
votes: 0

I run several MySQL databases on Windows 2003 servers and I'm always looking for ways to increase the speed that these servers serve up results. I know nothing about Linux but I'm wondering if I'd get any better performance if I ran MySQL on a Linux box as opposed to a Windows box.

Does anyone have any experience with both?


8:55 pm on Sept 11, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
votes: 0

uh oh....here comes the W v. L again.....

Being a moderator has it's privileges and I'm going to lay the ground rules for this one. Let's limit the discussion to only reliable specs, not heresay. And don't start bashing either of the two platforms.

I run on a Windows Server with mySQL as well, and the underlying guts of the server are what matter for speed. CPU cycles, RAM, Cache and services.

After comparing apples to apples that way, the queries themselves matter and memory leak issues.

Beyond that, I don't think it makes a hill of beans difference. If you are comparing time, also include the time saved by having a graphical windows interface for doing some of the other tasks.

9:06 pm on Sept 11, 2005 (gmt 0)

New User

10+ Year Member

joined:May 26, 2005
votes: 0

The complexity of installing/running software usually far outweighs any small gains by choosing one platform over another.

What I mean -- if you are comfortable with Windows or Linux - stay with it. Don't switch from one to another just become someone tells you the one you're not using is faster/better.

In the long run, knowing how to manage one system extremely well is better than only knowing a little bit about all of them.

Specifically, if you know windows really well, keep running MySql on Windows. If you know Linux well, stay with that.

If you have performance problems then learn how to tweak all the settings on the platform and operating system you are using.

Then, if you need more speed - as much as this sounds simplistic, just throw more hardware at it.

It is a lot easier (and in the long run cheaper) to just throw more ram in the server, use a faster hard disk/controller, and use a faster CPU than to switch architectures.

Although not as elegant, because servers are cheap and every few months are getting faster and cheaper, the overall cost to throw more hardware at a decent performing system to make it faster is the simplest approach.

You do need to have your system reasonably under control. A badly configured system will not improve if you throw more at it - but otherwise this is actually a pragmatic approach that works for the vast majority of sites/servers that don't need to squeeze every last ounce of performance out of the existing setup.

9:15 pm on Sept 11, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Mar 12, 2004
votes: 0

Thanks TX.... I guess I should have figured this could be a volatile issue.

I'll give a little more background. Last month I bought a new Dell 1800 with dual 3.0 ghz Xeons, fast SCSII's and a truckload of RAM. I've seen numerous reviews tauting how great this setup was for running MySQL. Then again, all the reviews talked about this hardware running Redhat, so I'm wondering if that should tell me something.

The server generates pages for a web directory which gets about a million pageviews per day (Each pageview is about 7 separate queries). I've nearly cut the processing time in half with this new server, but I'm wondering if it could do better.

Thanks for your input, whichever side of the fence you are on!

10:25 pm on Sept 11, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 12, 2003
votes: 0

touting right?

Anyways, you have three elements, hardware, os, and sql code.

I would suggest that you ensure that the sql code is optimal for your usage. That way it is optimal independent of hardware or os no matter what decision you may make in the end.

BTW, have a look at the raid config. Raid 10 everything and use a raid controller that has battery backed cache. I don't think the PERC2/3 series had battery backups. Not having it means that log commits are slowed down.

2:22 pm on Sept 16, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 18, 2002
votes: 0

I think almost always the big problem is:

Sql code and fragmentation of data pages/indexes.

I mean:

Use sp instead of query
Index your objects
Mantain them
Try to pre-aggregate mostyl used data


7:32 pm on Sept 19, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Dec 2, 2002
votes: 0

I recently switched from Windows to Linux.
Box is Dual Xeon, running Raid 5.

There is no noticable "speed" differance. However processor load has reduced.


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members