On Fri, 2002-03-08 at 10:02, Ireneusz Piasecki wrote: > Hi, > > It is very interesting, what are you wwriting, but: > > > " To determine if you should be concerned about this compiler issue, execute > gcc -v from the command prompt on your system. If the compiler reports > version 2.96, then there is a problem (this is the case, for example on RH > 7.x series or Mandrake 8.x). In this case, you should not try to compile > your own binary before downgrading to one of the compilers mentioned above. > You should also NOT use the MySQL server provided with your distribution -- > as this copy of MySQL was compiled with the same ill-advised compiler > version. " > this is from http://www.mysql.com/downloads/mysql-3.23.html > I understud, don't compile mysql with 2.96 of gcc. > I'm confiused. > > The query is: Compile server mysql with 2.96 or not ?
Ireneusz, Our (MySQL AB) recommendation is to NOT compile *mysql* with RedHat's 2.96 compiler. Instead, in the case of RedHat, you should use 2.91 EGCS or 2.95 GCC compilers. If you do choose to compile with 2.96RH, then you are most likely going to run into problems in a production system. We definitely have a difference of opinion with Trond here. The bottom line is that if you want a stable MySQL server, then you should compile with GCC 2.91 or 2.95. These are the compilers for which our extensive testing has shown MySQL to be stable with. In any large and complicated project there are going to be dependencies on the compiler that the software was written for. Please note that the reason (atleast one of the reasons) RedHat includes 2.91 EGCS in their distribution is to compile the Linux kernel correctly. The Linux kernel -- another large and complicated project -- requires 2.91 EGCS. Read the kernel documentation for more information (README file included in every stock kernel tarball). This is absolutely normal and acceptable for large, complex softwares. Software simply cannot be changed everytime a software vendor (RH in this case) decides to fork their own version of something as fundamental as a compiler. MySQL in particular is a software product that gives your system a real work-out. We have discovered many critical bugs in the libc's, kernels and compilers of various systems -- for instance Glibc, the Linux kernel, and RedHat's forked 2.96 compiler. You will find the same is true of projects like ReiserFS (who do not recommend 2.96 either). While RedHat's 2.96 compiler may indeed work fine for relatively lightweight software that is most likely not going to be used in a high-performance production environment. We (MySQL AB) have determined -- through many investigations of MySQL under high-load compiled with 2.96RH -- that this compiler is not good for MySQL. Now that GCC 3.x has been released, we will be looking at making MySQL 4.x series (and higher) work well with it. GCC 3.x is looking very promising. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php