[nycbug-talk] Future Meeting: AMP on BSD

[Hans Zaunere]

> > > I'd love to hear more about how to make mysql run right.  It's an
> > ongoing
> > > issue that comes up on the lists, and I for one still see issues
under
> > > moderate load with Linux Threads and the "skip-name-resolve"
option.
> >
> > Interesting... which BSD?  I run MySQL both with native threads and
> > LinuxThreads on FreeBSD without issue.  I'll certainly touch on some
of
> > this, and answer any questions people have.
> 
> FreeBSD 4.7, 4.8 and 4.9.  While going with LinuxThreads gets rid of
the
> "spinning at 99% cpu" problem, I've found that if the box is doing
> anything else (especially mail delivery w/qmail or sendmail
periodically
> chugging through a queue), mysql just starts timing out on local
(socket)
> or network queries.  We're talking both select-only at 15 q/S tops
here on
> a database that only is about 20MB.  I recently brought this up on the
> mysql list with lots of specifics (no, the machine's not swapping,
disk io
> is sane, cpu is not pegged).  The one thing that does seem to stand
out is
> that the box spends lots of time in "system" cpu and context switches
as
> qmail spikes, and this seems to be when either threading library
starves
> mysqld and the application (vpopmail) starts timing out.

Quite strange.  I use MySQL on fairly loaded FreeBSD boxes of the same
version - with many other servers running - and haven't seen these
issues.  Did you use MySQL from ports, or the binary supplied from
http://dev.mysql.com ?  Give the binary supplied if not.

> > > Also some good tips on configuring php beyond the port build; what
do
> > you
> > > recommend changing in the stock php.ini, what are some performance
> > tips,
> > > and which of the various accellerators do you find work best
> > > (turck-mmcache looked good, but that project apparently died)?
> >
> > Good points, too  (hint: always use php.ini-recommended).
> 
> Excellent... thanks.  If you can live with Turck-mmcache's sig 11's on
> HUPs, the speed increase on a single purpose application like
squirrelmail
> is staggering.

Yeah, I wouldn't live with that.  There are IonCube Accelerator and
Zend, too.

> In general, I'm something of a stranger to php.ini and more
specifically
> getting a sane and usable safe-mode config going...  Hope you've got
four
> or five hours blocked out for the meeting. :)

Sure I do... bars are open until 4am :)

---
Hans Zaunere
President
New York PHP
http://nyphp.org