[thelist] MySQL Performance Question

Anthony Baratta Anthony at Baratta.com
Tue Apr 30 13:15:01 CDT 2002

At 11:04 AM 4/30/2002, Jay Blanchard wrote:

>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;

Is the machine "swapping" or has any "high IO Wait" numbers during the query?

Also - how does the mySQL compile parameters compare to the other box?

And I found this:


  The recommended way to compile and install MySQL on FreeBSD with gcc
(2.95.2 and up) is:

CC=gcc CFLAGS="-O2 -fno-strength-reduce" \
CXX=gcc CXXFLAGS="-O2 -fno-rtti -fno-exceptions -felide-constructors \
-fno-strength-reduce" \
./configure --prefix=/usr/local/mysql --enable-assembler
gmake install
cd /usr/local/mysql
./bin/mysqld_safe &

Which you might have already seen.
Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list