[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:

http://www.mysql.com/doc/F/r/FreeBSD.html

  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
gmake install
./scripts/mysql_install_db
cd /usr/local/mysql
./bin/mysqld_safe &

Which you might have already seen.
--
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."




More information about the thelist mailing list