Hi Konstantin, You don't mention what version of MySQL you are using so I will assume that you are using the most recent. There were many problems with the threads libraries and even some compiler bugs on 4.1 and 4.2. The are resolved by 4.3 and 4.4 (and soon to be 4.5) Is there any chance that you can update your server to one of these newer version. Also if you are running any other services than MySQL you may have security problems on that version.
If you really need to get that particular setup going I think you will have to provide the developement team with more information. I also will assume since you build with Linux Threads you are using the latest ports. If you have with makefile you can modify confgiure to add a --with-debug to the MySQL configuration. The run MySQL with gdb and see exactly where it crashes. Also if you want to edit the Makefile you might try and remove --enable-assembler option. I would really suggest upgrading if you are going to use threaded progams. Best of luck. Ken ----- Original Message ----- From: "Smirnov Konstantin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 05, 2001 4:24 AM Subject: MySQL with LinuxThreads - CHECK TABLE causes crash in mysqld > Hello list! > > We have a dual-CPU machine with FreeBSD 4.1.1 (well-known problem with > MySQL, eh? ;)) Yesterday, after our server died 4 or 5 times during 8 > hours, I compiled MySQL with LinuxThreads. It works pretty cool now, > but two things annoy me very much: > 1. MySQL dies when I try to CHECK TABLE (output is: "illegal > instruction in mysqld; mysqld ended) > 2. Then, I can't REPAIR TABLE. MySQL dies on it again ;) > > Could anyone help me? > Thanks! > > Best regards, > Konstantin Smirnov, > eHouse, Moscow, Russia > -------------------- > > > > -------------------------------------------------------------------- - > 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 > > --------------------------------------------------------------------- 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