mysql performance / tuning in 10.3.7

Hello,

I’m in the process of moving a mysql 4.1 database for a reasonably busy website over to a new dual proc XServe running os x 10.3. Initial impressions of the performance as compared to the i386 freebsd machine it ran on before are not good. During peak load times it seems to really pack up worse than under freebsd! Not good news considering the old machine was a dual P-III 866.

Does anyone have experience running a large and fairly heavily loaded mysql database on 10.3? If so, any tips for tuning my.cnf, sysctls etc?

I haven’t tried compiling my own mysql for os x yet. Can anyone comment on the performance of a custom build versus the stock mysql binaries?

In general I’d love to see a document along the lines of the freebsd tuning man page. Or maybe you already know of such a thing?

many thanks in advance.

scott

PS – I’ve already come accross several gems on AFP548 in my short time moving over to OS X Server. Keep up the great work!