Leopard server mysql poor performance

[Gerk]

Wondering if anyone here is doing anything heavy with mysql and leopard server … I’m doing some dev work on it and seeing pretty poor performance compared to my generic Linux box sitting beside it.

My Leopard Server Xserve (dual 2.0Ghz G5, 6G ram) is giving me about 50% of the performance I’m seeing out of the Linux box (generic x86 box, CentOS 5.1, Cheapo Intel E2160 dual core 1.8Ghz, 1G ram).

Considering the Linux box is using generic 32 bit binaries, has much less ram and cheapo processor/mboard and nothing special as far as the hard drive goes something seems amiss here … is it just me or are others seeing poor mysql performance?

[Gerk]

Thanks for the pointer, but it seems that 10.5.x server has changed this behavior, I have an /etc/my.cnf already (for large systems default). It looks like the server Setup Assistant put it there for me.

[MikeRose]

Here’s another reason you might be seeing poor MySQL performance on Intel builds of Mac OS X 10.5 Server…

http://twitter.com/bynkii/statuses/795224854

Try a mysql -V and you’ll see that the build indicated is for PPC. Not entirely clear if this just represents the code fork or also means that it was compiled for PPC (which seems drastically unlikely, but you never know).

[khiltd]

[QUOTE][u]Quote by: MikeRose[/u][p]Here’s another reason you might be seeing poor MySQL performance on Intel builds of Mac OS X 10.5 Server…

http://twitter.com/bynkii/statuses/795224854

Try a mysql -V and you’ll see that the build indicated is for PPC. Not entirely clear if this just represents the code fork or also means that it was compiled for PPC (which seems drastically unlikely, but you never know). [/p][/QUOTE]

Easy enough to find out:

[code]otool -f /path/to/mysql[/code]

[iyeat]

Has anyone else done any more research on this? We’re having definite performance issues on identical hardware with the only difference being Tiger vs Leopard server.

Thanks!

C

[Author]

Posts