Could be the 2.4.17 kernel.. I run a Dual RH 7.1 machine:
mysql> status; -------------- <--snip--> Uptime: 57 days 11 hours 57 min 28 sec #uptime 11:36am up 57 days, 13:28, 1 user, load average: 0.00, 0.00, 0.00 #uname -a Linux [hidden] 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686 unknown --- In a message from Heikki Tuuri <[EMAIL PROTECTED]> The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer. Somewhere in about version 2.4.10 Linus changed the virtual memory. I am not sure how stable kernels 2.4.10 - .17 are, but at least some people are running them with success. ---- That could be the problem. Down grade to 2.4.9 or .8, patch up the security holes, if any in that kernel, and give that a test run. --------------------- Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -----Original Message----- From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 11:26 AM To: MySQL Subject: Re: Problem with MySQL and SMP? We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our application relies on SELECT id ... WHERE id IS NULL behaving the same way as LAST_INSERT_ID(), and to do that, I have to comment out one (yes, just one) line of code. Which means I have to compile. Anyway, this is sort of a longish "me too," but I wanted to confirm that Gavin was not alone in this problem. j----- k----- On Thursday 10 January 2002 21:11, [EMAIL PROTECTED] wrote: > I am having a problem with MySQL that I believe is related to SMP. I > have a machine that is an exact copy of another machine, only difference > is that this one is Dual processor, and the other one is single. The > single one has had no problems for the last 6 months the dual dies every > 2 days This is the 2nd SMP server that I have had (i thought it was the > mobo or something) both produce the same results. I get no output to > logs, machine just goes black (and hangs). Any input? > > This is on RedHat 7.2 linux with the 2.4.17 kernel and MySQL 3.23.47 > > Gavin -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 --------------------------------------------------------------------- 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