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

What no Windows benchmarks?

[sjrstory]

I thought Windows XP was supposed to be the Fastest and the Most Reliable OS in the World

...never believe everything you read on the Intarweb. ;)

use windows!

[mboverload]

I use Windows Server 2003 for all my SQL needs. It is 20% faster than an equivilent Linux machine!

Well, at least thats what Microsoft told me...

Re:Did you even read the article?

[isometrick]

Click the second link in the summary, sir.

Re:Other Benchmarking

[E_elven]

Does anyone know of a nice computational/science benchmark that runs on Linux/Windows/BSD and is free?

Try:

int main(int argc, char** argv)
{
for (long i = 0; true; ++i)
{
char* x = new char[i*i];
std::cout << "I love Stevie Hawking!" << std::endl;
}
}

You'll need a stopwatch.

Re:That's all well and good, but...

[iamsure]

Quoting Joey Tribbiani: "Its a moo point. It's like a cows opinion, its just moo."

Re:That's all well and good, but...

[dubl-u]

and it may even be a mute argument ...

or even more likely, a moot argument

So you think. It's all the rage now to have technial meetings where nobody speaks and all arguments are made through pantomime. I'm sure that's what he's talking about.

My favorite thing to explain that way is an elevator algorithm, although stochastic fair queueing is a close second.

Re:Why do people use MySQL over Postgres?

[aixou]

Why swat a fly with a sledgehammer?

As an exercise of motor skills.

Re:Different filesystems?

[PedanticSpellingTrol]

He's obviously added another layer of depth to the joke by counting in base one.

Re:That's all well and good, but...

[PieEye]

Man, if I had a nickel for every time I saw a mute stochastic fair queueing argument at Starbucks...I'd...uhhh...never mind.

Re:That's all well and good, but...

[LDoggg_]

Man, if I had a nickel for every time I saw a mute stochastic fair queueing argument at Starbucks...I'd...

Still not be able to afford a cup of their coffee?