MySQL Stability Problem
Hi all, I seem to be running into a stability problem with our current mySQL server. I'm at a loss as to where to begin looking. We first noticed a problem with large files being created in the /tmp directory. That hasn't happened since, but yesterday the server bogged down twice. There were about 100 or so connections to the server, mostly sleeping, and the server was acting extremely sluggish. It took about 60 seconds to get a processlist via mysqladmin... Can anyone give me any pointers as to where to look first? Are there any settings I can tweak that may help this? The machine is a dual 1.3 Ghz machine with 512 Meg RAM It used to be running on a dual 733 Mhz machine and we never experienced anything like this ... -- --- Jason 'XenoPhage' Frisvold Senior ATM Engineer Penteledata Engineering [EMAIL PROTECTED] RedHat Certified - RHCE # 807302349405893 --- Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming. - 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: MySQL stability on OS X
Clay, Thank you, this sounds very promissing! I will try this and let you know if it helps. This will take a few weeks because the vacation is here soon. /Aryan Aryan, I faced a similar problem, as have a few other people on the list, it seems. On the recommendation of another Mac OS X MySQL user (the extremely helpful Tony Niesz), I compiled my own MySQL server (rather than using the one Apple distributes or the binary Marc Liyanage maintains). Prior to running ./configure, I typed: setenv CFLAGS -DHAVE_BROKEN_REALPATH My MySQL server -- running on a dual 500mhz G4 averaging 25 queries per second, which was crashing several times per day -- has run without a hitch for nearly 3 weeks since I did this. That's two weeks on 3.49.50, and a week on 4.0.1-alpha. Both have been rock-solid with that -DHAVE_BROKEN_REALPATH CFLAG value set. If you can compile on your own, I'd recommend going that route. I believe Tony Niesz is working on compiling a bug report/heads up to send to the MySQL team, Apple and Marc Liyanage. I don't know if he's sent that yet, but in the meantime I'd recommend trying this. Good luck! -Clay From: Aryan Schmitz [EMAIL PROTECTED] Date: Tue, 18 Jun 2002 17:02:08 +0200 To: [EMAIL PROTECTED] Subject: MySQL stability on OS X Hi, Is anyone using MySQL with PHP and Apache on Darwin/OS X as a dynamic content webserver with medium/high load? We have had al lot of MySQL crashes (once a week) on a 400Mhz G4 getting an average of 5 SQL queries per second and eventually had to move the database to an old Linux 160Mhz Pentium server which has not had a single crash since then! Would be nice to now why MySQL seems so unstable under load on OS X. We tried an old G3 233 Mhz as well but then MySQL crashed already after some hours with the same load. Kind regards, Aryan - 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 -- -- Aryan Schmitz Korridor AB [EMAIL PROTECTED] http://www.korridor.se Tel +46 8 720 41 50 [EMAIL PROTECTED] Fax +46 8 720 41 60 Tantogatan 5 GSM +46 70 749 66 84 118 67 STOCKHOLM SMS mailto:[EMAIL PROTECTED] Sweden -- - 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: MySQL stability on OS X
Hi all, I faced a similar problem, as have a few other people on the list, it seems. On the recommendation of another Mac OS X MySQL user (the extremely helpful Tony Niesz), I compiled my own MySQL server (rather than using the one Apple distributes or the binary Marc Liyanage maintains). Prior to running ./configure, I typed: setenv CFLAGS -DHAVE_BROKEN_REALPATH This sounds very interesting... Aryan, if I update my package accordingly today, would you be able/willing to test it under load to see if th problem goes away? Cheers -Marc _ Marc Liyanage [EMAIL PROTECTED] http://www.entropy.ch ICQ 5077985 Yoda I am. Grammar I can't. _ - 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
MySQL stability on OS X
Hi, Is anyone using MySQL with PHP and Apache on Darwin/OS X as a dynamic content webserver with medium/high load? We have had al lot of MySQL crashes (once a week) on a 400Mhz G4 getting an average of 5 SQL queries per second and eventually had to move the database to an old Linux 160Mhz Pentium server which has not had a single crash since then! Would be nice to now why MySQL seems so unstable under load on OS X. We tried an old G3 233 Mhz as well but then MySQL crashed already after some hours with the same load. Kind regards, Aryan -- -- Aryan Schmitz Korridor AB [EMAIL PROTECTED] http://www.korridor.se Tel +46 8 720 41 50 [EMAIL PROTECTED] Fax +46 8 720 41 60 Tantogatan 5 GSM +46 70 749 66 84 118 67 STOCKHOLM SMS mailto:[EMAIL PROTECTED] Sweden -- - 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: MySQL stability on OS X
Aryan, I faced a similar problem, as have a few other people on the list, it seems. On the recommendation of another Mac OS X MySQL user (the extremely helpful Tony Niesz), I compiled my own MySQL server (rather than using the one Apple distributes or the binary Marc Liyanage maintains). Prior to running ./configure, I typed: setenv CFLAGS -DHAVE_BROKEN_REALPATH My MySQL server -- running on a dual 500mhz G4 averaging 25 queries per second, which was crashing several times per day -- has run without a hitch for nearly 3 weeks since I did this. That's two weeks on 3.49.50, and a week on 4.0.1-alpha. Both have been rock-solid with that -DHAVE_BROKEN_REALPATH CFLAG value set. If you can compile on your own, I'd recommend going that route. I believe Tony Niesz is working on compiling a bug report/heads up to send to the MySQL team, Apple and Marc Liyanage. I don't know if he's sent that yet, but in the meantime I'd recommend trying this. Good luck! -Clay From: Aryan Schmitz [EMAIL PROTECTED] Date: Tue, 18 Jun 2002 17:02:08 +0200 To: [EMAIL PROTECTED] Subject: MySQL stability on OS X Hi, Is anyone using MySQL with PHP and Apache on Darwin/OS X as a dynamic content webserver with medium/high load? We have had al lot of MySQL crashes (once a week) on a 400Mhz G4 getting an average of 5 SQL queries per second and eventually had to move the database to an old Linux 160Mhz Pentium server which has not had a single crash since then! Would be nice to now why MySQL seems so unstable under load on OS X. We tried an old G3 233 Mhz as well but then MySQL crashed already after some hours with the same load. Kind regards, Aryan - 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: Mysql Stability
We have one (WinNT) installation with a database that has grown to +250mb. This particular database was ported to MySQL from MSSQL7. Our experience has been that if you supply adequate resources for the server (RAM, CPU and Virtual Memory) the size of the database only becomes an issue during dump/backup operations. The particular server hardware with the database referenced above is a P-III 733mHz with 512mb RAM and 20gb SCSI RAID-5. Ultimately, we will use replication to provide the backup, but so far our customers have been happy with the present scheme. G. Jensen - Original Message - From: "guru prasad" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 10, 2001 11:32 AM Subject: Mysql Stability Hi, I have a site with the database of size 90 MB on Mysql-3.22.25. It is performing quite well right now, Please let us know the maximum limit of the database size that Mysql can handle efficiently. Regards, Guru _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 - 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: Mysql Stability
On Sat, Feb 10, 2001 at 11:32:25AM +, guru prasad wrote: I have a site with the database of size 90 MB on Mysql-3.22.25. It is performing quite well right now, Please let us know the maximum limit of the database size that Mysql can handle efficiently. It really depends on the hardware you are using. MySQL can easily handle multi-gigabyte databases on reasonably modern hardware with sufficient RAM. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
