- This topic has 4 replies, 4 voices, and was last updated 18 years, 2 months ago by
.
-
Posts
-
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?
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.
Here’s another reason you might be seeing poor MySQL performance on Intel builds of Mac OS X 10.5 Server…
mysql -V mysql Ver 14.12 Distrib 5.0.45, for apple-darwin9.0 (powerpc) using EditLine wrapper
— John C. Welch (@bynkii) April 23, 2008
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).
MikeRose wrote:
Here’s another reason you might be seeing poor MySQL performance on Intel builds of Mac OS X 10.5 Server…
mysql -V mysql Ver 14.12 Distrib 5.0.45, for apple-darwin9.0 (powerpc) using EditLine wrapper
— John C. Welch (@bynkii) April 23, 2008
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).
Easy enough to find out:
otool -f /path/to/mysql
- You must be logged in to reply to this topic.