I've tried a variety of configure and 'make' options, all of which
have been giving me shoddy results.
Also, someone finally told me today that they've heard that
debian-based distros are still having problems with some threading
(pthread) libraries - and MySQL relies on them heavily.
LinuxThreads is not supported on AMD64 - so that's obviously out.
I'm even trying to use MySQL-supplied x86_64 binaries and they're
eating up CPU and seem to be locking up in general - the server can't
even shut itself down properly using the initscript.
I'm running kernel 2.6.11.12, debian-amd64 sarge, mysql 4.1.7, .10,
.12 - .12 is by far the worst.
I've had to add in CFLAGS="-DUSE_MUTEX_INSTEAD_OF_RW_LOCKS
-DPTHREAD_ADAPTIVE_MUTEX_INITIALIZER_NP" in the past - it seemed to
help one time, but it doesn't seem to work properly anymore.
Right now I'm running the x86 (686) version of 4.1.7 and it's working;
but not as good as it should, I believe, and is not using NPTL as far
as I can tell ('ps' shows one 'process' for each connection, like
LinuxThreads would do...) - and it's running somewhat sloppy. It
appears it's not designed to run like this or something (tables are
crashing off and on a few times an hour now...but auto repairing
itself)
Anyway. The long and the short of it. I think there is -still- an
issue here, that shows up in SMP-based AMD64 installs. Unless perhaps
someone running this same platform can help out with their
installation configuration (configure and 'make' options) that have
worked properly for them, I'm afraid I've exhausted as much as I can
on my production server trying to get this to work. I can't afford to
do much more tweaking of compile options and such to get this to work.
I believe this bug has been reported/discussed in many places, even
reported to Debian already...
As many people have posted here, it appears that there are a variety
of possible configuration issues/whatnot with AMD64 and MySQL - it'd
be great if someone who knows what they're doing (re: threading,
scheduling, etc.) could step up and try to diagnose and make Debian
lead the pack as far as MySQL performance goes...
- http://hashmysql.org/index.php?title=Opteron_HOWTO
Here's related other URLs of interest:
- debian: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=314408
- redhat: http://sources.redhat.com/ml/libc-hacker/2004-02/msg00019.html
- ubuntu: https://bugzilla.ubuntu.com/show_bug.cgi?id=11730
- mysql: http://bugs.mysql.com/bug.php?id=8555
- mysql: http://bugs.mysql.com/bug.php?id=7254
- someone's blog: http://trainedmonkey.com/entry/2248
I've posted on both MySQL and Debian's forums as well looking for
help, but nothing worthwhile so far:
- http://forums.debian.net/viewtopic.php?p=4472
- http://forums.mysql.com/read.php?11,31593,33658
Thanks in advance. I'm available for any questions regarding my
configuration or anything. This is a high priority for me.
- mike
