BDB tables for better performance. For most sites, myisam tables are thought to offer the best performance.
Indexes corrupt themselves regularly.
Doing a repair table locks the table which brings down the db server in a couple of seconds at this load. Allowing indexes to stay corrupted seems to lead to mysql restarting itself and all kinds of ugly problems. This is probably the most serious issue, especially since it means my pager tends to go off at 4 AM Sunday morning. All rights reserved.