We have a large OS X MySQL deployment on multiple servers and we have experienced a range of weirdness with table corruption that I was never able to fully determine the cause for.
Moving to G5 Xserves (from G5 Towers and G4 Xserves) has seen all the problems go away as if a switch were thrown. I don't have an explanation or even a root cause, but I also don't have a problem any more. The thing I see in this thread that several people are talking about is the differences and conflicts caused with OS X Server's MySQL install and the MySQL AB install... There were some issues starting with 4.0.17 that weren't fixed until 4.0.19 that could affect Mac users under certain circumstances. Apple was last I looked still deploying 4.0.18, I don't know what's current with 10.3.8, and I expect a significant version change from Apple when Tiger comes out at the end of the month. Our way of dealing with this is firstly to use MySQL AB binaries. Secondly we make sure the path includes /usr/local/mysql/bin/. Next we edit the Startup script to make sure it is launching mysqld_safe from /usr/local/mysql/bin and not from /usr/bin and finally, and this is the most important one... As root you: cd /usr/bin/ rm my* ln -s /usr/local/mysql/bin/* . This is not only replacing the Apple Binaries with the MySQL binaries, it is protecting you as you upgrade MySQL versions... Each time you upgrade MySQL versions the symlink to /usr/local/mysql/bin/ will always point to the current version of MySQL you are using. The only thing you need to watch is from time to time Apple will update their MySQL installs (snuck into a System Update), which will overwrite your symlinks with new Apple Binaries (which is why the real fix it so make sure you have the right path settings and replace the startup scripts, even if Apple overwrites your symlinks, you'll still be calling your binaries). Still, you should get in the habit of checking the files in /usr/bin/my* each time you install a System update in case Apple has updated versions. Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
