Slashcode Log In
MySQL Compilation Issues with gcc Version 2.96
Regarding mySQL, "The Running Weblogs with Slash" book says "Choose a nearby mirror, follow the Downloads link, and look for the specific release mentioned in the Slash INSTALL file (usually the current stable version). Download the tarball to the source directory, then unpack it...." The Slash 2.2.5 INSTALL file calls for mySQL 3.23.42. The nearest version I could find to that is 3.23.49, which I assume is OK.
However, on the mySQL 3.23.49 Download Page under "Source downloads" , a section printed in red says: "Compiler advisory: Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. Although we were unable to duplicate the problems ourselves or understand their exact cause, we suspect with a great degree of confidence that the problem was compiler related. Replacing the faulty binary with our binary always eliminated the problem. We recommend that MySQL be compiled with gcc 2.95 if you have to compile your own binary at all."
The page goes on to say that gcc 2.96 (standard on RedHat 7.x and Mandrake 8.x) should be downgraded before the source is compiled. Is downgrading the gcc compiler to 2.95 the best approach, or should the pre-compiled binaries be used in this case?