I'm compiling my mysql server from source. I have started noticing this as of 4.1.10 - in fact, I was running 4.1.12 and it's changed the LinuxThreads detection (since LT does not exist on amd64) - and 4.1.12 kept locking up after only a few minutes of uptime consistently.
Once I figured this out, I rolled back to my 4.1.10 with a small patch to the "configure" script to force the calling of CFLAGS="$CFLAGS -DUSE_MUTEX_INSTEAD_OF_RW_LOCKS -DPTHREAD_ADAPTIVE_MUTEX_INITIALIZER_NP" I'm wondering though - am I missing something here? What would be the best threading library to call (or command line switch when compiling mysql) on a single processor amd64 machine - as well as a dual processor (SMP) amd64 machine? I have both... and would like to ensure maximum performance on both! This is my existing configure line: ./configure --prefix=/usr/local/mysql --enable-assembler --without-debug --with-mysqld-user=mysql --without-innodb --without-isam --enable-thread-safe-client --without-extra-tools For example, right now i have 4 mysql servers running, and this is what my process list looks like. mysql 634 29.9 0.7 45676 16400 ? Sl Jun15 5517:59 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mys mysql 640 41.7 1.2 52836 26696 ? Sl Jun15 7693:42 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mys mysql 647 13.6 1.0 69316 21920 ? Sl Jun15 2513:04 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mys mysql 650 33.9 1.6 72804 33064 ? Sl Jun15 6240:30 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mys they're not all running that intensively, so i'm not sure why they're all trying to hog as much CPU as possible. (yes, they're all pointing to separate datadirs, socket files, port numbers, etc. - the config hasn't changed since a properly running version in the past) Can anyone shed some light - perhaps someone else who compiles from source on Debian-amd64 and has tweaked settings either in the my.cnf or on the configure line... I'm willing to take any suggestions! Or perhaps somebody knows how the debian-amd64 mysql apt package is compiled? I would normally try using it, but it has an oddball setup - requiring a new user to be added and some other things that I don't want to have to maintain - and my existing setup [besides for this resource issue] has been rock solid and great. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
