Re: MySQL 4.1, GCC 3.x, FreeBSD 4.x

2005-09-21 Thread Kris Kennaway
On Wed, Sep 21, 2005 at 02:31:18PM -0400, John Nielsen wrote:
 Should it be possible to compile and run MySQL 4.1 with GCC 3.4 on a FreeBSD 
 4.11 machine?
 
 I have a server which, for the time being at least, cannot be updated to 
 FreeBSD 5.  I'm currently running the stock MySQL 4.1.14 compiled from the 
 port with no make flags.
 
 I would like to experiment with different build options/flags in the hopes 
 of boosting performance.  Specifically, I'd like to build it with 
 linuxthreads and optimized C flags, but I am wary of using -O3 with gcc 
 2.9.  Am I just being paranoid?
 
 When I try this from databases/mysql41-server:
 make WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes USE_GCC=3.4

USE_GCC is wrong, it's not a user-controllable variable. Set CC
instead.

This might be OK as long as there is no C++ code involved, which
cannot be linked to C++ code from gcc 2.95.

-O3 can be dangerous, so use with care.

Kris

pgpv8W9t0eFKa.pgp
Description: PGP signature


Re: MySQL 4.1, GCC 3.x, FreeBSD 4.x

2005-09-21 Thread Alex Dupre

John Nielsen wrote:
I would like to experiment with different build options/flags in the hopes 
of boosting performance.  Specifically, I'd like to build it with 
linuxthreads and optimized C flags, but I am wary of using -O3 with gcc 
2.9.  Am I just being paranoid?


Yes, you are. Most MySQL binary packages are compiled with gcc 2.9 and -O3.

--
Alex Dupre
___
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: MySQL 4.1, GCC 3.x, FreeBSD 4.x

2005-09-21 Thread John Nielsen
On Wednesday 21 September 2005 14:41, Alex Dupre wrote:
 John Nielsen wrote:
  I would like to experiment with different build options/flags in the
  hopes of boosting performance.  Specifically, I'd like to build it with
  linuxthreads and optimized C flags, but I am wary of using -O3 with gcc
  2.9.  Am I just being paranoid?

 Yes, you are. Most MySQL binary packages are compiled with gcc 2.9 and
 -O3.

Good to know.  Thanks!

On Wednesday 21 September 2005 14:39, Kris Kennaway wrote:
 USE_GCC is wrong, it's not a user-controllable variable. Set CC
 instead.

 This might be OK as long as there is no C++ code involved, which
 cannot be linked to C++ code from gcc 2.95.

 -O3 can be dangerous, so use with care.

I might play around with the CC option.  Thanks for straightening me out.

JN
___
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: MySQL 4.1, GCC 3.x, FreeBSD 4.x

2005-09-21 Thread Simon Barner
John Nielsen wrote:
[...]
 if gcc34 -DHAVE_CONFIG_H -I. -I. -I.. -I../include -I../include   
 -I/usr/local/include  -DDBUG_OFF -O -pipe  -D__USE_UNIX98 -D_REENTRANT 
 -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -O3 
 -fno-omit-frame-pointer -MT conf_to_src.o -MD -MP -MF 
 .deps/conf_to_src.Tpo -c -o conf_to_src.o conf_to_src.c;  then mv -f 
 .deps/conf_to_src.Tpo .deps/conf_to_src.Po; else rm -f 
 .deps/conf_to_src.Tpo; exit 1; fi
 /usr/local/bin/libtool15 --preserve-dup-deps --mode=link gcc34  -DDBUG_OFF 
 -O -pipe  -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE 
 -I/usr/local/include/pthread/linuxthreads -O3 -fno-omit-frame-pointer   
 -L/usr/local/lib -o conf_to_src  conf_to_src.o xml.o  ctype.o bcmp.o  
 -DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE 
 -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthread 
 -llgcc_r -lcrypt -lm  -DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE 
 -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthread 
 -llgcc_r
 libtool15: link: unable to infer tagged configuration
 libtool15: link: specify a tag with `--tag'

[...]

I recently had the same problem, but the other way round (gcc295 on
FreeBSD 6).

I fixed it by pkg_deleting libtool, autoconf, automake and reinstalling
them with the same compiler that you want to use later.

This is most easily done, when you simply run

make CC=gcc34 CXX=g++34 in the mysql port directory, since this will
pull in missing dependencies.

Don't forget to delete them again when you're done -- otherwise you
will break other ports (that use the stock gcc).

HTH, and best regards,
 Simon


pgpXfhQE95wRW.pgp
Description: PGP signature


Re: MySQL 4.1, GCC 3.x, FreeBSD 4.x

2005-09-21 Thread Greg 'groggy' Lehey
On Wednesday, 21 September 2005 at 14:39:55 -0400, Kris Kennaway wrote:
 On Wed, Sep 21, 2005 at 02:31:18PM -0400, John Nielsen wrote:
 Should it be possible to compile and run MySQL 4.1 with GCC 3.4 on a FreeBSD
 4.11 machine?

 I have a server which, for the time being at least, cannot be updated to
 FreeBSD 5.  I'm currently running the stock MySQL 4.1.14 compiled from the
 port with no make flags.

 I would like to experiment with different build options/flags in the hopes
 of boosting performance.  Specifically, I'd like to build it with
 linuxthreads and optimized C flags, but I am wary of using -O3 with gcc
 2.9.  Am I just being paranoid?

 When I try this from databases/mysql41-server:
 make WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes USE_GCC=3.4

 USE_GCC is wrong, it's not a user-controllable variable. Set CC
 instead.

 This might be OK as long as there is no C++ code involved, which
 cannot be linked to C++ code from gcc 2.95.

There's lots of C++ code in MySQL.

Greg
--
See complete headers for address and phone numbers.


pgpLI7rqcFgCt.pgp
Description: PGP signature