[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