| John N 2007-09-02, 4:02 am |
| > I'm reluctant to do, as the normal tarball doesn't have the patches
> for XNU's threading (the default ones lead to terrible performance).
In simple hope to provide an option to you, I'll assume that you are
refering to the Thread-prioritization performance problems discussed
in this thread,
"Make skip-thread-priority a build flag and enable for all OSX binaries"
http://bugs.mysql.com/bug.php?id=18526
and the Patch they've made available to everyone.
You may notice there also that,
"Noted in 5.0.34, 5.1.15 changelogs.
The --skip-thread-priority option now is enabled by default for
binary Mac OS X distributions. Use of thread priorities degrades
performance on Mac OS X."
and that the solution is now in the tarballs.
As also discussed here,
"Mac OS X Server: Improving MySQL Performance"
http://docs.info.apple.com/article.html?artnum=303225
by addition of
"skip-thread-priority"
to the MySql my.cnf configuration file's section of,
[mysqld]
one can,simply, turn off the prioritization for very increased performance.
But, one then uses more memory. We in fact, have been using this for
our servers for a while.
If this is the performance patch you refered to, then, an alternative
without "the hassle" of patching is available to you.
Really, the MySQL build from Source is quite effortless, although it
is long. And, perhaps, until the Php developers believe your bug
report and fix it, then there is an alternative once and for all to
the symbolic linking solution.
Of course, if that's your choice.
John
|