I have web server which uses php+mysql. As far as I have searched the best thing to use mysql on FreeBSD is to use linuxthreads. For the performance and stability I have done following things on my FreeBSD-4.X Stable system:
Compile mysql with linuxthreads and as static binary. I have read http://jeremy.zawodny.com/blog/archives/000697.html. I have used mysql 4.0 and 4.1 for my setup but had problems on both of the version.
My problem is the mysql eats away lots of CPU time especially in "nice" and "system" which is really very very weird. A snapshot of the top is like this:
------------------------------
240 processes: 7 running, 233 sleeping
CPU states: 10.9% user, 73.9% nice, 12.5% system, 2.7% interrupt, 0.0% idle
Mem: 244M Active, 1309M Inact, 309M Wired, 93M Cache, 199M Buf, 56M Free
Swap: 3072M Total, 24K Used, 3072M Free
-----------------------------------
This system is HTT enabled 2 Xeon 2.8 GHZ with 2 GB RAM. I have disabled SMP and recompiled my kernel but my problem (nice and system cpu times..) still persists.
I would appreciate if any of you help me..
REGARDS.
-----------------------
Omer Faruk Sen
http://www.EnderUNIX.ORG
Software Development Team @ Turkey
http://www.Faruk.NET
For Public key: http://www.enderunix.org/ofsen/ofsen.asc
********************************************************
First Turkish FreeBSD book is out! Go check it.
Duydunuz mu! Turkiye'nin ilk FreeBSD kitabi cikti.
http://www.acikkod.com/freebsd.php
_______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
