[thelist] MySQL Performance Question

[Hans Zaunere]

Have you tried using the mysql.com supplied binary for FreeBSD?  They
often recommend this for all production level environments (ie Linux).
Also, I think freebsd.org has a port.

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


--- Jay Blanchard <jay.blanchard at niicommunications.com> wrote:
> [snip]
> Have you run top while the query runs??
>
> Also what switches did you use to compile mySQL?
> [/snip]
>
> top reports that the query is using 95-96% of resources, it is the
> only
> major process running. Here are the flags set in the makefile;
>
> CONFIGURE_ARGS= --localstatedir=${DB_DIR} \
>                 --without-perl \
>                 --without-debug \
>                 --without-readline \
>                 --without-bench \
>                 --with-mit-threads=no \
>                 --with-libwrap \
>                 --with-low-memory \
>                 --with-comment='FreeBSD port: ${PKGNAME}'
>
> We did find some documentation concerning --with-low-memory, so we
> had a
> do-over remming out --with-low-memory. No joy (although this was the
> first
> time that the query ran a sub 40 minute time.... 39 min 39.85 sec.
> Woo Hoo!
> (he says facetiously)
>
> Jay
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !


__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com