>> I just moved my databases from one machine to another. I recompiled
>> the whole thing, but I have some problems. MySQL now locks up, and
>> takes 100% cpu, after an hour or two. I need to shut it down and
>> restart it, and then it goes another hour again.
>> The machine is a dual pIII 866 with 2gb ram, dedicated to MySQL. It
>> serves two frontends running Apache. I am using the my-huge.cnf,
>> with max_connections set to (currently) 250, but I've tried both
>> more and less.
>> I am currently testing it with the binaries provided on MySQL.com,
>> and so far it hasn't crashed. But, it hasn't gone two hours yet.
>>
>> So, why does MySQL lock up on me?
Linux picard 2.4.9 #4 SMP Fri Aug 31 15:21:12 CEST 2001 i686 unknown
picard:/usr/local/var # ldd ../libexec/mysqld
libdl.so.2 => /lib/libdl.so.2 (0x4001f000)
libpthread.so.0 => /lib/libpthread.so.0 (0x40022000)
libz.so.1 => /lib/libz.so.1 (0x40038000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x40047000)
libnsl.so.1 => /lib/libnsl.so.1 (0x40075000)
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3
(0x4008b000)
libm.so.6 => /lib/libm.so.6 (0x400d4000)
libc.so.6 => /lib/libc.so.6 (0x400f2000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
>You did not even include your OS which makes it kinda hard for at
>least me to help.
*ashamed* sorry.. :)
>Did you compile the kernel with support for >1GB?
Yepp.
>Have you tried 2.2.19? I only use 2.2.* for production machines at
>work.
Nope. I need 2.4.x for various reasons..
>What options did you use with ./configure when you compiled MySQL?
./configure --with-raid --without-debug --enable-thread-safe-client
--disable-shared --enable-static
Running version mysql-3.23.40
Jens
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
