-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Daniel Ouellet wrote:

> mysql> status;
> --------------
> 44  Open tables: 455  Queries per second avg: 5.117
> --------------
> 
> 
> 
> # dmesg
> OpenBSD 3.9 (GENERIC) #617: Thu Mar  2 02:26:48 MST 2006
>     [EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/GENERIC
> cpu0: Intel Pentium III ("GenuineIntel" 686-class) 844 MHz
> real mem  = 2138677248 (2088552K)
> avail mem = 1945370624 (1899776K)

5 queries per second ain't that much. At work we use to have 40
queries/second on a dual xeon 3,2 box running Debian Linux (2.4.31).
However, I guess I can't compare that at all. Would be like comparing
apples to oranges.
It all winds down to your database  design...

But nice to see statistics at all.
I'd prefer to run OpenBSD or FreeBSD on our database servers anyway, but
if you're searching the FreeBSD mail archives, Linux is still ahead in
regards to speed with MySQL...

To cut that short: I'd use Linux for MySQL if it is all about speed and
not security. If performance ain't the first goal, go with OpenBSD (or
FreeBSD) :)

unluckily, I don't have a choice at work and it'll be Linux :-(

./Marian
iD8DBQFEnfcPgAq87Uq5FMsRAuR4AJ0VnyuA2TMJedcOGgpkAkCT8eZHsgCg7ZLA
OIl4NptdC2sOzKCLDbY0GFo=
=RtEN
-----END PGP SIGNATURE-----

Reply via email to