Re: Provider claims 'it's normal that mysql crashes', is that true?
On Wed, Apr 04, 2001 at 05:26:39PM +0200, Gunnar von Boehn wrote: As I asked them why their mysql-server die so often, I got their standard problem email-answer that claims "mysql is scaling rather badly". The truth is probably closer to "we are scaling mysql badly". A well run MySQL server doesn't crash. There's no good reason you can't have hundreds of days of uptime. 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
RE: Provider claims 'it's normal that mysql crashes', is that true?
If its a hosting PROVIDER, the table locking issue should really only be a factor for your database. If your design is good, then the rest shouldn't matter. Machine memory and processing power are another issue entirely. Other users could drag the machine down with poor design issues. One issue that we encountered, due to our own ignorance of course, was not allowing enough swap space for our mysql installation. We had 64MB of swap on a machine with 64MB of RAM. When we tried to process large queries the machine ran out of memory and crashed hard. Our short term work around was to take another, unused, partition and reformat it as swap. With 1.5 GB of swap, we never saw another problem, but we don't let users build their own databases either. -Original Message- From: mysql-digest-help [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 11:27 AM To: mysql Cc: gvb Subject: Provider claims 'it's normal that mysql crashes', is that true? Hello My provider 11-Puretec (www.puretec.de) hosting more than 1.000.000 domains runs about 14 Databaseserver with MySQL 3.22.32-log on Linux dual Penti-III 500Mhz machines. In the last 6 month the average uptime of the mysql-servers was around 8 hours. As I asked them why their mysql-server die so often, I got their standard problem email-answer that claims "mysql is scaling rather badly". After further asking I got a personal answer that says: "it's normal the mysql-servers die because of heavy load". "We can't help that the mysql task keeps crashing if to many users access it. That's totally normal for a mysql database" Is that true? regards Gunnar von Boehn - 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: Provider claims 'it's normal that mysql crashes', is that true?
No this is not true... a lot of the stability of the database server has to do with the #1 the load, and #2 the design of the database. But no MySQL should not be crashing this much. Scott At 05:26 PM 4/4/2001 +0200, Gunnar von Boehn wrote: Hello My provider 11-Puretec (www.puretec.de) hosting more than 1.000.000 domains runs about 14 Databaseserver with MySQL 3.22.32-log on Linux dual Penti-III 500Mhz machines. In the last 6 month the average uptime of the mysql-servers was around 8 hours. As I asked them why their mysql-server die so often, I got their standard problem email-answer that claims "mysql is scaling rather badly". After further asking I got a personal answer that says: "it's normal the mysql-servers die because of heavy load". "We can't help that the mysql task keeps crashing if to many users access it. That's totally normal for a mysql database" Is that true? regards Gunnar von Boehn - 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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "It has been said that the primary function of schools is to impart enough facts to make children stop asking questions. Some, with whom the schools do not succeed, become scientists." - Knut Schmidt-Nielson - 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: Provider claims 'it's normal that mysql crashes', is that true?
We've been running on RedHat distribution (starting with 5.2 or so) and Slackware before that for the last few years (currently running mysql 3.23.32... that update bug introduced in 3.23.34 really spanked us hard, we'll be moving to "latest" again soon). Currently, we've got dual and quad PII and PIII machines with upwards of 2GB of memory averaging around 400 queries/second (150-400 sessions at any given time). Our mysql uptime depends on how often we do software or hardware upgrades, not on mysql "mean time to crash". Translated: our mysql servers run for weeks/months. I consider our mysql databases to be very stable. :) Owen On Wed, 4 Apr 2001, Gunnar von Boehn wrote: Hello My provider 11-Puretec (www.puretec.de) hosting more than 1.000.000 domains runs about 14 Databaseserver with MySQL 3.22.32-log on Linux dual Penti-III 500Mhz machines. In the last 6 month the average uptime of the mysql-servers was around 8 hours. As I asked them why their mysql-server die so often, I got their standard problem email-answer that claims "mysql is scaling rather badly". After further asking I got a personal answer that says: "it's normal the mysql-servers die because of heavy load". "We can't help that the mysql task keeps crashing if to many users access it. That's totally normal for a mysql database" Is that true? regards Gunnar von Boehn - 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 -- USMail: CareerSite Corporation, 310 Miller Avenue, Ann Arbor, MI 48103 Phone:+1 734 213-9500 FAX:+1 734 213-9011 mailto:[EMAIL PROTECTED] http://www.careersite.com/~osm/ - 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: Provider claims 'it's normal that mysql crashes', is that true?
On Wed, 04 Apr 2001, Gunnar von Boehn wrote: Hello My provider 11-Puretec (www.puretec.de) hosting more than 1.000.000 domains runs about 14 Databaseserver with MySQL 3.22.32-log on Linux dual Penti-III 500Mhz machines. In the last 6 month the average uptime of the mysql-servers was around 8 hours. As I asked them why their mysql-server die so often, I got their standard problem email-answer that claims "mysql is scaling rather badly". After further asking I got a personal answer that says: "it's normal the mysql-servers die because of heavy load". "We can't help that the mysql task keeps crashing if to many users access it. That's totally normal for a mysql database" Is that true? Only if their servers/queries are set up wrong. We use Sparc/Solaris exclusively in our production network now but used to have more data than this hosted on a similar machine. They could be telling the truth is they have huge queries that lock the tables for extended periods. The table level locking of .ism tables can cause problems on very busy servers. MySQL's newer tables avoid this problem but I'm not sure how production ready they are. Nigel - 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: Provider claims 'it's normal that mysql crashes', is that true?
After further asking I got a personal answer that says: "it's normal the mysql-servers die because of heavy load". "We can't help that the mysql task keeps crashing if to many users access it. That's totally normal for a mysql database" Running 3.22.32 that's prehistoric (sort of).. I think I even remember some problems with 3.22.32 .. not sure though.. Our own mysqlservers have an average downtime of 1 hour (maybe 2 hours) per year, per server!! mostly because of maintenance. To many users accessing their MySQL server.. can be.. but then you increase the amount of servers you've got. An average of 71000 users per server might be a little to must.. even if only 10 percent would use MySQL sound still as to many users. Time to find yourself another ISP.. if they can't be convinced in spending a few DM extra that is.. Bye, B. - 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