thus Marian Hettwer spake:
-----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
wrt to your Linux vs. OpenBSD/FreeBSD stanza... i have a bunch of
machines running NetBSD. i had to move a customer to another machine
because the contract was at an end and the guy they moved to has
absolutely no knowledge of computing. they also run a huge MySQL
database and i took the chance and did a bit benchmarking.
the results were surprising to me: NetBSD was a bit faster overall (than
GNU/Linux, Fedora Core 5) on the same hardware! surprising because IMHO
scheduling on FreeBSD is better, especially on MP machines (IIRC, NetBSD
handles all IRQs on CPU0, but i am not sure). so it may be that FreeBSD
is even faster. maybe worth a try...
--
Timo Schoeler | http://riscworks.net/~tis | [EMAIL PROTECTED]
RISCworks -- Perfection is a powerful message
ISP | POWER & PowerPC afficinados | Networking, Security, BSD services
GPG Key fingerprint = B5F6 68A4 EC45 C309 6770 38C4 50E8 2740 9E0C F20A
There are 10 types of people in the world. Those who understand binary
and those who don't.
