Speeding up MySQL on Mac OS X and Mac OS X server
Posted by Daniel Tue, 28 Feb 2006 13:48:51 GMT
Speeding up MySQL on Mac OS X and Mac OS X server: Basically: you want to add “skip-thread-priority” to your my.conf, or use “–skip-thread-priority” when you start up MySQL on an OS X box. There’s an assumption about how thread priorities are ordered which isn’t true on OS X. By turning this off, you can significantly improve your overall database performance. On some of my databases, I’ve been able to double the queries-per-second just by setting this value. [Cool.]
Source: Chuqui
Source: Chuqui
