[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