Hi Yonah, I can see the same problem on my system. I will create a support issue for you and will let you when this get fixed.
I found that if you take out libmysql.o from libmysqlclient.a and then link it as -
icpc -O3 -DDBUG_OFF -O3 -ipo -axWN -march=pentium4 -mcpu=pentium4 -fno-implicit-templates -fno-exceptions
-fno-rtti -rdynamic -o mysql mysql.o readline.o sql_string.o completion_hash.o -lreadline -lncurses
../libmysql/.libs/libmysqlclient.a ../libmysql/libmysql.o -lz -lcrypt -lnsl -lm
it works fine.
you can try this as a workaround for your problem, till it get fixed.
The problem is you have to include ../libmysql/libmysql.o explicitly whereever
../libmysql/.libs/libmysqlclient.a is linked.
HTH, CP
in addition- I got these helpful instructions from the folks on the mysql-packagers list- I specifically asked about 4.0.18 so they should work- I have successfully compiled 4.1.1 several times and the binaries passed the tests although I'm having trouble with the benchmark suite.
good luck yonah
That really sounds like an icc bug. Here's the line we currently use for our binaries on icc:
CFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" CC=icc CXX=icc CXXFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" ./configure - --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data - --libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex - --enable-thread-safe-client --enable-local-infile --enable-assembler - --disable-shared --with-client-ldflags=-all-static - --with-mysqld-ldflags=-all-static --with-readline --with-embedded-server - --with-innodb
You may be able to use higher optimization levels (e.g. by removing "-mp", which will however cause some loss in floatingpoint accuracy - some of the test suite tests will fail). I assume the "--no-gcc" is key here.
Bye,
LenZ
- -- Lenz Grimmer <[EMAIL PROTECTED]>
Senior Production Engineer
Walter Andreas wrote:
Hi there,
how to compile mysql 4.0.18 on a pentium for best performance? I searched the net now for 2 days and found lots of hints on compiling with icc and pgcc, but it looks to me that icc is not working with mysql 4.0.18 and pgcc is out of date (maybe gcc already catched up with pgcc?). Setting compiler flags is also a miraqle for me. This is going to be a production server, so it should be really stable and not the trade for performance.
Can anybody advice a configure command with compiler settings for a p4 machine with 1G ram?
Thank you for your advice,
Andy _____________________________________________________________________ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Netsky.A-P! Kostenfrei fuer alle FreeMail Nutzer. http://f.web.de/?mc=021157
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
