Re: compiling mysql on a pentium
There does seem to be a bug in icc- I've posted on intel's message boards and they've confirmed a problem. There is a work around - here is the post: 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]
Re: compiling mysql on a pentium
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! CFLAGS=-O3 -march=i686 -mcpu=i686 -funroll-loops -fomit-frame-pointer - -fno-exceptions -fno-ftti -felide-constructors CXXFLAGS the same as above. Check out Securing and Optimizing Linux in the tldp.org i think is just what you nedd. Best Regards! - -- ~ |...| ~ | _ _|Victor Medina M | ~ |\ \ \| | _ \ / \ |Linux - Java - MySQL | ~ | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | ~ | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | ~ |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ~ ||Cel: +58-412-8859934 | ~ ||geek by nature - linux by choice | ~ |...| -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAe7068WJSBCrOXJ4RAvJCAJ0QIctA0Ov/gPzQww/hE1SFvphNMQCfYPl/ EJLxkX28Kc9Q67z29fHqJx4= =6vBO -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
compiling mysql on a pentium
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]
Re: compiling mysql on a pentium
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 Check the INSTALL-SOURCE file in your source distribution. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling mysql on a pentium
how to compile mysql 4.0.18 on a pentium for best performance? Check the INSTALL-SOURCE file in your source distribution. I found this: CFLAGS=-O2 -mcpu=pentiumpro CXX=gcc CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --disable-shared --localstatedir=/home/mysqladm/data --enable-assembler but it says for x86 which could also be amd?! What about pgcc and how about -march=pentium4 which I found somewhere else on the net? Andy Daniel Kasak [EMAIL PROTECTED] schrieb am 13.04.04 05:31:35: 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 Check the INSTALL-SOURCE file in your source distribution. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au hr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Sober.A-F! Kostenfrei fuer FreeMail Nutzer. http://f.web.de/?mc=021158 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling mysql on a pentium
Walter Andreas wrote: how to compile mysql 4.0.18 on a pentium for best performance? Check the INSTALL-SOURCE file in your source distribution. I found this: CFLAGS=-O2 -mcpu=pentiumpro CXX=gcc CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --disable-shared --localstatedir=/home/mysqladm/data --enable-assembler but it says for x86 which could also be amd?! What about pgcc and how about -march=pentium4 which I found somewhere else on the net? You haven't actually told us what processor ( 'pentium' is a marketing term, not a processor type ... there are many different types of pentiums ) you have, but you should be able to use -march=pentium4 or whatever matches your processor. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]