Re: Problem with MySQL and SMP?
Any suggestions on loging tools I cna run to try to find out more information? The machine is coloced about 3 hours for me, so I would hate to have to drive there and install FreeBSD on it, when it was just something I could have fixed. Gavin Blestan Tabakov wrote: hi! i'm running mysql on a dual pIII for 3 years now and i have no problems . the machine is running slackware 2.2.16 and mysql 3.23.47. so, i think that you have to check the motherboard of the server or even change it ( some bioses crashes linux on smp). the other problem may be is redhat it self - but i'm not sure - i'm always use slack - it' absolutely stable good luck blestan __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - 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
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
RE: Problem with MySQL and SMP?
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
Re: Problem with MySQL and SMP?
i don't have any problem with this config : slackware 7.1, kernel 2.2.18, MySQL 3.23.41 Dual PIII-800, 256MB RAM, SCSI Ultra-160 maybe it's kernel 2.4 fault. HTH (sorry for the duplicated message Joshua, forgot to send to the ML) At 18:26 11/01/2002, you wrote: 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 -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - 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
Re: Problem with MySQL and SMP?
Joshua J.Kugler writes: 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. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 If nothing works as you said, no ssh, no console, this is not MySQL issue. It is either hardware or some unknown (?) 2.4.17 SMP bug. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
RE: Problem with MySQL and SMP?
Forgot to say I was running MySQL v 3.23.39 Also, I read in one of the other messages on this thread that the problem might be RedHat. I don't relly belive this because a kernel is a kernel. RedHat = Every other Distro when it comes to issues with the kernel (memory,diskaccess,etc). In my opinion, I have been wrong before. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Johnny Withers [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 11:40 AM To: 'MySQL' Subject: RE: Problem with MySQL and SMP? 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 - 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
Re: Problem with MySQL and SMP?
Yes, this had occured to me. I am thinking about downgrading to kernel 2.4.8, or such. Not sure I really want to do that, but I'd rather do that than face system lock ups. j- k- On Friday 11 January 2002 08:55, Sinisa Milivojevic wrote: If nothing works as you said, no ssh, no console, this is not MySQL issue. It is either hardware or some unknown (?) 2.4.17 SMP bug. On Friday 11 January 2002 08:43, Thibaut Allender wrote: i don't have any problem with this config : slackware 7.1, kernel 2.2.18, MySQL 3.23.41 Dual PIII-800, 256MB RAM, SCSI Ultra-160 maybe it's kernel 2.4 fault. -- 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
Re: Problem with MySQL and SMP?
I'm running ok on my Dual PII machine, if this helps anyone. Redhat 7.1, 2.4.2-SGI_XFS kernel, MySQL 3.23.43. [root@willyjr /root]# uptime 1:07pm up 95 days, 4:08, 1 user, load average: 0.08, 0.04, 0.01 [root@willyjr /root]# cat /etc/redhat-release Red Hat Linux release 7.1 (Seawolf) [root@willyjr /root]# uname -a Linux willyjr.noguska.com 2.4.2-SGI_XFS_1.0smp #1 SMP Fri Apr 27 19:07:34 CDT 2001 i686 unknown mysql status -- mysql Ver 11.15 Distrib 3.23.43, for pc-linux-gnu (i686) Connection id: 5774 Current database: Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.43-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 9 days 50 min 33 sec Threads: 31 Questions: 103436 Slow queries: 0 Opens: 3449 Flush tables: 1 Open tables: 64 Queries per second avg: 0.133 -- - 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
Re: Problem with MySQL and SMP?
On Fri, Jan 11, 2002 at 11:54:26AM -0500, [EMAIL PROTECTED] wrote: Any suggestions on loging tools I cna run to try to find out more information? The machine is coloced about 3 hours for me, so I would hate to have to drive there and install FreeBSD on it, when it was just something I could have fixed. MySQL on FreeBSD won't take advantange of the dual-CPUs nearly as well as Linux, FYI. If it's a dedicated MySQL box, that's a big deal. If it is also running Apache and other stuff, not much of a big deal. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 8 days, processed 227,520,468 queries (294/sec. avg) - 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
Re: Problem with MySQL and SMP?
On Fri, Jan 11, 2002 at 01:11:11AM -0500, [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 Odd. Almost sounds like a hardware problem. Are you using MySQL's binaries or did you compile your own? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 8 days, processed 207,937,688 queries (289/sec. avg) - 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
Re: Problem with MySQL and SMP?
[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 - 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 Perhaps your problem lies in the IDE controller. For some reason, my friend and I have been through several dual (MSI Tyan) motherboards over the past few months that have almost always had IDE controller problems where they wouldn't work at all, or would lock up after using them for 20 to 30 minutes. If you're using IDE on the dual, try SCSI. Or perhaps the chipset? Did you use the same motherboard in both SMP servers? If so, perhaps there was a chipset problem in that brand, and you may have to check with the manufacturer. I'm just taking shots in the dark here, but there's no reason why the SQL server should keep crashing ONLY because the difference is single processor kernel, or smp kernel. I would assume that any good SQL server is designed with SMP kernel in mind for database apps that would require a lot of processing power. Try eliminating the possibilities of hardware problems first. David - 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