Comparing MySQL Performance

An anonymous reader writes "With the introduction of the 2.6 Linux kernel, FreeBSD 5-STABLE, Solaris 10, and now NetBSD 2.0, you might be wondering which of them offers superior database performance. These two articles will show you how to benchmark operating system performance using MySQL on these operating systems so you can find out for yourself if you're missing out. While this may not necessarily be indicative of overall system performance or overall database application performance, it will tell you specifically how well MySQL performs on your platform."

Comments

Re:Did you even read the article?

[someonehasmyname]

Trolls like to make shit up. FreeBSD4 + LinuxThreads is gonna rock the house.

Re:Why do people use MySQL over Postgres?

[nileshbansal]

One reason for prefering MySQL over Postgres is that MySQL has more (fancy) features. For example MySQL supports unicode while Postgres does not (this was the case 1 year back, I don't know about present status of Postgres).

Re:Useless Benchmarks

[LuSiDe]

Whine, whine.

The guy received feedback from Sun regarding his optimalisations. So he's open to optimalisations.

He didn't recompile his Linux kernel for i686 and even if he did that won't give you a lot more performance.

He compiled MySQL for every OS he posted. Fair compare ain't it.

He compiled Gentoo from the ground, yes. So? Gentoo's default compile options are just as FreeBSD's aimed at stability and it has conservative flags. I've never seen benchmarks which showed Gentoo, with whatever flags, delivers a significant better performance than e.g. Mandrake or Debian (fact i named *those* 2 is a hint!). With significant i mean ~ 5% or more.

As for his Linux knowledge i don't see why he's a Linux guru. In the past his articles were just as well about OpenBSD and other BSDs. Perhaps you're just seeking stupid arguments? Why not whine that he didn't use the same filesystem?!

You BSD zealots are losers who can't stand it that Linux is better in a regard such as this. Even though its quite known FreeBSD 5.3 ain't doing very well (DFBSD is) and even though its known NetBSD and OpenBSD have biglock and even though they weren't doing well in Fefe's Scalability benchmark (but improved a lot!!!) why not cut the dodging and admit? Or start doing something about it? When you'd just said: "this is merely MySQL, i'll do the same test but then with PostgreSQL" i'd say 'good point' and 'kudos' afterwards because those are valid points. Go ahead, go test it with Debian instead of Gentoo while you're at it. I challenge you -- but n/m, i already know its just chewbacca who's talking..

Re:Why do people use MySQL over Postgres?

[SerialHistorian]

Your post was flamebait, but I'll answer it anyway. If an entire business runs their operations on it and I have a 99.9% or greater SLA on it, then it's enterprise-class. The systems I generally build integrate all of the operations of a business ... from the external customer service integration with the internet website to email handling to lead generation to the sales & billing & commission / affiliate payouts processes... it's all web-based, everyone in the company uses it constantly, there's very little training required because everyone's familiar with the way the web works, and it's never slow or down. It's funny, one of my clients is opening a 2nd office halfway across the city, and we sat down today with their telecom provider to talk about connectivity. They thought my client was using something like GoldMine or Act, and said they'd need to do a dedicated T1 haul. When we told them what we were actually using and gave them the bandwidth figures, they almost freaked out because they couldn't believe my client had something that ran their whole business and could work effectively over a 56k line...