Faves for this Web page
- mohit - 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." )
Add a Fave for this Web page
- What happens when I press Publish?
- Your Fave for this Web page gets shared with the Faves community. You can access it at any time by selecting "My Faves" from the menu above.
- Why do you ask for my email address?
- We use your email address to create an account, so you can easily find your Fave again at a later time.
Related Content from Around Faves
mysql
-
This guide describes how to set up a full email solution in Debian Linux (all code is from Debian Etch). I was asked to design a secure, scalable, portable solution for a small company. While the guide references many servers, the company only had 4 physical machines, Xen was used to virtualize the entire solution. That particular aspect of the system is not discussed in this guide, although I will try to get it into the next revision.
1 FaverViewed: 10 Times - falko - Nov 20 20071 FaverViewed: 16 Times
- falko - Oct 10 20071 FaverViewed: 18 Times
linux
- Converting All Your MS Outlook PST Files To Maildir Format | HowtoForge - Linux Howtos and Tutorials
One of the challenges you may face when converting an office from Microsoft Windows to Linux is that many people archive their emails in PST files. There are PST tools available, but most of them are commercial, since the PST file format is closed and protected by Microsoft. There are several non-commercial methods to achieve roughly the same goal, and in this tutorial we use IMAP (more specifically, courier-imap) to convert all our emails from PST to the Maildir format. The advantage of this approach is that you also lay the foundation for a new mail system, with all your old emails already imported the day you switch over.
1 FaverViewed: 50 Times - micmacred - Mar 24 20071 FaverViewed: 31 Times
- DotU - Nov 04 20071 FaverViewed: 30 Times