[thelist] MySQL Performance Question

Jay Blanchard jay.blanchard at niicommunications.com
Tue Apr 30 13:05:01 CDT 2002


[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





More information about the thelist mailing list