homepage Welcome to WebmasterWorld Guest from 54.204.127.56
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
MySQL on Windows vs Linux
How does it compare?
dataguy




msg:1580204
 6:40 pm on Sep 11, 2005 (gmt 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?

Thanks...

 

txbakers




msg:1580205
 8:55 pm on Sep 11, 2005 (gmt 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.

spiv




msg:1580206
 9:06 pm on Sep 11, 2005 (gmt 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.

dataguy




msg:1580207
 9:15 pm on Sep 11, 2005 (gmt 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!

plumsauce




msg:1580208
 10:25 pm on Sep 11, 2005 (gmt 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.

joker197cinque




msg:1580209
 2:22 pm on Sep 16, 2005 (gmt 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

HTH

Namaste




msg:1580210
 7:32 pm on Sep 19, 2005 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved