MySQL Newsletter Updated Mac OS X 3.23.51 binaries

Thanks to Clay Loveless, Marc Liyanage, Aryan Schmitz and Tony Niesz (in no particular order), we discovered a problem with the Mac OS X binaries that only show up under high load. For a more detailed description please see Tony's detailed description of the problem:

http://marc.theaimsgroup.com/?l=mysql&m=101771686423933&w=2

The solution is pretty simple - you have to recompile the binary by adding the following compile flag: CFLAGS=-DHAVE_BROKEN_REALPATH

This will make the problem go away, but also has a downside: it is not possible to use symbolic links for a database directory to point to another database directory anymore. See the chapter about "Using Symbolic Link for Databases" and "BSD/OS Version 4.x Notes" for more information about this subject:

http://www.mysql.com/doc/en/Symbolic_links_to_databases.html (http://www.mysql.com/doc/en/Symbolic_links_to_databases.html)
http://www.mysql.com/doc/en/BSDI4.html (http://www.mysql.com/doc/en/BSDI4.html)

We have now recompiled the MySQL 3.23.51 binaries for Mac OS X with this compile flag and placed them on our download pages at http://www.mysql.com/downloads/ (http://www.mysql.com/downloads/)

The MD5 checksums for these files:
mysql-3.23.51-apple-darwin5.3-powerpc.tar.gz
9e02147ca784d73d5e0722f52cae5eb7

mysql-max-3.23.51-apple-darwin5.3-powerpc.tar.gz
37e1f60381420ffa6e97a70ced29ee4d

Future versions of MySQL (3.23.52 und up as well as 4.0.2 and up) will automatically be compiled with this flag.