mohit | Shared With: Everyone - Jul 22 2008 | mysql, development, databases, reliability, myisam, innodb
We inadvertently provisioned a few database machines with MyISAM instead of InnoDB, and it has been a nightmare. I strongly advice against using MyISAM -- ever.
With MyISAM, we periodically get these incorrect "duplicate key" errors that don't go away until you run the lenghty "repair table" command that somehow fixes everything.
Quoted: Use MyISAM when: The data isn't too critical ( "unreliable and slow, related to table size, table repair process" )
...
Use InnoDB for tables when: The table will be big (100Mb+ - "For reliability and performance, we use InnoDB for almost everything at Wikipedia - we just can't afford the downtime implied by MyISAM use and check table for 400GB of data when we get a crash." )
Related Content from Around Faves
database
-
Those plucky penguins--already passé. Whales and polar bears--just fads. But dinosaurs have kept their scaly grip our imaginations. The new DinoBase from the University of Bristol in the U.K. offers plenty of information for everyone from dino dabblers to devotees who want to check whether there's such an animal as "Elvisaurus." (There isn't.) A database holds vital statistics--such as length, weight, and time span--for several hundred dinosaur species, including Stygimoloch spinifer (above), a 3-meter-long herbivore from what is now Montana. Its elaborate headgear might have served as a weapon or as a lure for mates. Visitors can tour a gallery of dino art or dig into the site's forum for announcements of fresh finds and the latest on current debates, such as whether commercial fossil hunters hurt or help paleontology.
Volume 316, Number 5828, Issue of 25 May 2007
1 FaverViewed: 9 Times - mohit - Jul 22 20081 FaverViewed: 2 Times
- AmmInfo - Jun 22 20081 FaverViewed: 36 Times
mysql
-
This is a detailed description about how to set up a Mandriva 2008 Free (Mandriva 2008.0) server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Courier POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 32-bit version of Mandriva 2008, but should apply to the 64-bit version with very little modifications as well.
1 FaverViewed: 14 Times - falko - Jun 17 20081 FaverViewed: 8 Times
- ketchup - Sep 11 20081 FaverViewed: 6 Times
