Hello, I'm interested to hear peoples' experiences running mysql on OS X. I've moved the database for a fairly heaily used website (~ 2M queries a day) over to a new dual 2GHz XServe running OS X Server 10.3.7. This database has run smoothly on an aging dual PIII machine running freebsd for the past several years.
My initial impression is that the performance gains aren't nearly what I would have expected. For the most part the new machine is less loaded, but at peak times it's arguably doing worse that it did the old freebsd machine. The number a variables involved has hindered my creating comprehensive benchmarks but some initial impressions from running stock mysql benchmarks are that 4.0.23a on OS X performs around 10% faster than 4.1.8a and that my old freebsd machine running 4.0.18 is less than a factor of two slower. These are all using similar my.cnf settings tuned along the lines of the my-huge.cnf sample config. Does anyone have any tips to offer for tuning OS X and mysql to play well together? Is anyone running a heavily loaded mysql server in production under OS X? Thanks for you help! scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
