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...
If I recall the original question properly, it wasn't what system will
run out or capacity first, or crash first, etc. It was if MySQL run well
on OpenBSD and can handle good traffic. The answer is yes. Then the
question was to get stats and DMESG, so I took the less busy and smaller
system to show that even that can do well. Yes, 5 to 6 query per seconds
is not that much, but how many actually even reach that. Plus, I am not
running dual processor and at 3.2GHz, but run this on an old Pentium III
at 850MHz. So that was a good example to show that OpenBSD sure can
handle good traffic even on old equipment and just like I said, even on
that slow speed and old hardware by today standard with only one
processor, the load is very small.
Quote:
# uptime
3:53PM up 9 days, 10:34, 1 user, load averages: 0.21, 0.15, 0.14
So, in all you have a dual processor at 3.2 GHz doing 40 query per
seconds, 4 times faster then this old one, with dual processor on top of
that, so a minimum or 8 times I guess and then you run a dual XEON that
is suppose to be better and faster with more optimization as well, so I
sure hope you can do a minimum of 40 queries per seconds with it!
But again that answer the question very well. Old slow hardware run very
stable and very well on load that would be good for most and sure can do
lots more and all this under a load that doesn't even break the system
to sweat, just like I said before.
In the end, run what you fell comfortable with, but to the original
question, is MySQL run good on OpenBSD.
The answer to that is YES!
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...
Again, I don't think that was the question anyway. May be instead of
speculating, it would be nice one day to have someone push each system
to the limit and see witch crash, or doesn't keep up, but even that,
wasn't the question.
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) :)
Again use what you like and see fit, but know for me, I sure wouldn't
run my database on Linux. My data is to important for me to risk it and
yes security is also very important in the picture and I get the benefit
of having a system that is very stable as well.
Do, don't recall the question to be, what system will crash first and
can handle the biggest load, but is it running good on OpenBSD and to
that question the answer is again YES!
Hope this answer the original question.
Daniel
