Re: Problems with MySQL 4.1.x on Debian-AMD64 (threading?)
On Saturday 16 July 2005 12:09, mike wrote: > > 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. > Hi, I also experienced this 2 weeks ago on a Dual Opteron machine running debian-amd64 (kernel v2.6.11), but only after upgrading to 4.1.12. Running a "show processlist;" query would show several clients making SQL queries but no progress at all. And mysql would not shut down no matter what; Only a kill would do it. After that I downgraded mysql-server-4.1 to version 4.1.11a-4 and it has been running stable and in production ever since. Have you tried this version? I'd like to know if more people have managed to work with this version. > - 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 for the links! Regards Claudio Martins -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Problems with MySQL 4.1.x on Debian-AMD64 (threading?)
I also sent this to the 'debian-users' list, but I have a feeling it
may get mixed in with a lot of more beginner questions.
This could be tied to the behavior I just found in this post too:
http://lists.debian.org/debian-amd64/2005/07/msg00048.html
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
Re: mysql 4.1
Corin Langosch <[EMAIL PROTECTED]> writes: > Hi! > > thanks everyone for your help so far! > > by the way, when trying to install mysql-server > (currently a 4.0 version) it also wants to install > exim4 etc. this isnt necessary at all and should > be fixed for mysql 4.1 package? mysql-server depends on mailx, mailx depends on exim4 | mail-transport-agent. If you are sure mysql-server doesn't need mailx then talk to the maintainer about it. Maybe you overlooked something. MfG Goswin
Re[2]: mysql 4.1
Hi! thanks everyone for your help so far! by the way, when trying to install mysql-server (currently a 4.0 version) it also wants to install exim4 etc. this isnt necessary at all and should be fixed for mysql 4.1 package? # apt-get -s install mysql-server Reading Package Lists... Done Building Dependency Tree... Done The following extra packages will be installed: exim4 exim4-base exim4-config exim4-daemon-light libdbd-mysql-perl libdbi-perl liblockfile1 libmysqlclient10 libmysqlclient12 libnet-daemon-perl libpcre3 libplrpc-perl mailx mysql-client mysql-common Suggested packages: eximon4 exim4-doc-html exim4-doc-info dbishell libcompress-zlib-perl mysql-doc The following NEW packages will be installed: exim4 exim4-base exim4-config exim4-daemon-light libdbd-mysql-perl libdbi-perl liblockfile1 libmysqlclient10 libmysqlclient12 libnet-daemon-perl libpcre3 libplrpc-perl mailx mysql-client mysql-common mysql-server # apt-get check Reading Package Lists... Done Building Dependency Tree... Done Corin Sunday, December 12, 2004, 4:56:55 PM, you wrote: FS> Hello, FS> On Sun, Dec 12, 2004 at 04:38:41PM +0100, Goswin von Brederlow wrote: >> Corin Langosch <[EMAIL PROTECTED]> writes: >> > i downloaded the sources but cant compile them. it always >> > complains about linuxthreads..? i didnt find a mysql-4.1.7 >> > precompiled on alioth, isnt it exisiting? FS> A patched version will be uploaded, as soon as the build is done. >> The libmysqlclinet10-lgpl had the same problem and I forced it to use >> pthread despite the missing comment. I'm waiting to hear from the >> maintainer if this was ok. FS> Please check the attached patch fron Andreas Jochens, it works for both FS> mysql 4.0 and 4.1. FS> Greetings FS> Frederik Schueler
Re: mysql 4.1
Hi, On Sun, Dec 12, 2004 at 04:56:55PM +0100, Frederik Schueler wrote: > A patched version will be uploaded, as soon as the build is done. unfortunately the package FTBFS, an error in the documentation package. See http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=285344 Greetings Frederik Schueler -- ENOSIG pgphsHDCsEcHC.pgp Description: PGP signature
Re: mysql 4.1
Hello,
On Sun, Dec 12, 2004 at 04:38:41PM +0100, Goswin von Brederlow wrote:
> Corin Langosch <[EMAIL PROTECTED]> writes:
> > i downloaded the sources but cant compile them. it always
> > complains about linuxthreads..? i didnt find a mysql-4.1.7
> > precompiled on alioth, isnt it exisiting?
A patched version will be uploaded, as soon as the build is done.
> The libmysqlclinet10-lgpl had the same problem and I forced it to use
> pthread despite the missing comment. I'm waiting to hear from the
> maintainer if this was ok.
Please check the attached patch fron Andreas Jochens, it works for both
mysql 4.0 and 4.1.
Greetings
Frederik Schueler
--
ENOSIG
diff -urN ../tmp-orig/mysql-dfsg-4.0.21/configure ./configure
--- ../tmp-orig/mysql-dfsg-4.0.21/configure 2004-10-01 14:22:20.900250208
+0200
+++ ./configure 2004-10-01 14:22:17.787723384 +0200
@@ -24953,18 +24953,10 @@
else
echo "$as_me:$LINENO: result: \"Not found\"" >&5
echo "${ECHO_T}\"Not found\"" >&6
- # If this is a linux machine we should barf
if test "$IS_LINUX" = "true"
then
- { { echo "$as_me:$LINENO: error: This is a linux system and
Linuxthreads was not
-found. On linux Linuxthreads should be used. Please install Linuxthreads
-(or a new glibc) and try again. See the Installation chapter in the
-Reference Manual for more information." >&5
-echo "$as_me: error: This is a linux system and Linuxthreads was not
-found. On linux Linuxthreads should be used. Please install Linuxthreads
-(or a new glibc) and try again. See the Installation chapter in the
-Reference Manual for more information." >&2;}
- { (exit 1); exit 1; }; }
+# use nptl instead of linuxthreads
+CFLAGS="$CFLAGS -DUSE_MUTEX_INSTEAD_OF_RW_LOCKS
-DPTHREAD_ADAPTIVE_MUTEX_INITIALIZER_NP"
else
echo "$as_me:$LINENO: checking \"DEC threads\"" >&5
echo $ECHO_N "checking \"DEC threads\"... $ECHO_C" >&6
diff -urN ../tmp-orig/mysql-dfsg-4.0.21/configure.in ./configure.in
--- ../tmp-orig/mysql-dfsg-4.0.21/configure.in 2004-09-07 00:29:39.0
+0200
+++ ./configure.in 2004-10-01 14:22:10.295862320 +0200
@@ -1238,13 +1238,10 @@
with_named_thread="-lpthread"
else
AC_MSG_RESULT("Not found")
- # If this is a linux machine we should barf
if test "$IS_LINUX" = "true"
then
- AC_MSG_ERROR([This is a linux system and Linuxthreads was not
-found. On linux Linuxthreads should be used. Please install Linuxthreads
-(or a new glibc) and try again. See the Installation chapter in the
-Reference Manual for more information.])
+# use nptl instead of linuxthreads
+CFLAGS="$CFLAGS -DUSE_MUTEX_INSTEAD_OF_RW_LOCKS
-DPTHREAD_ADAPTIVE_MUTEX_INITIALIZER_NP"
else
AC_MSG_CHECKING("DEC threads")
if test -f /usr/shlib/libpthread.so -a -f /usr/lib/libmach.a -a -f
/usr/ccs/lib/cmplrs/cc/libexc.a
pgplUbb227leF.pgp
Description: PGP signature
Re: mysql 4.1
Corin Langosch <[EMAIL PROTECTED]> writes: > Hi, > > after further testing it shows that the official mysql > binary from www.mysql.com > mysql-standard-4.1.7-unknown-linux-x86_64-glibc23.tar.gz > doesnt' work with the latest pure64 or gcc-3.4. > as mentioned, always the locks block the whole mysql-server > and it cant even be killed. > > i'm now running mysql-standard-4.1.7-pc-linux-i686.tar.gz > and it works again. but now it's running in emulated 32-bit > mode, i guess? > > i downloaded the sources but cant compile them. it always > complains about linuxthreads..? i didnt find a mysql-4.1.7 > precompiled on alioth, isnt it exisiting? > > any help would be really appreciated :) > > corin Amd64 has no support for kernel 2.4 in glibc and I think because of this pthread does not have the LinuxThread comment other archs have. The libmysqlclinet10-lgpl had the same problem and I forced it to use pthread despite the missing comment. I'm waiting to hear from the maintainer if this was ok. MfG Goswin
mysql 4.1
Hi, after further testing it shows that the official mysql binary from www.mysql.com mysql-standard-4.1.7-unknown-linux-x86_64-glibc23.tar.gz doesnt' work with the latest pure64 or gcc-3.4. as mentioned, always the locks block the whole mysql-server and it cant even be killed. i'm now running mysql-standard-4.1.7-pc-linux-i686.tar.gz and it works again. but now it's running in emulated 32-bit mode, i guess? i downloaded the sources but cant compile them. it always complains about linuxthreads..? i didnt find a mysql-4.1.7 precompiled on alioth, isnt it exisiting? any help would be really appreciated :) corin
