5 items | 114 visits
Ken Wei's List: MyISAM vs InnoDB
-
-
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.
-
The speed advantage of MyISAM is overstated IMO. LiveJournal with a mostly write environment saw a big increase in speed when it switched from MyISAM to InnoDB and they are very happy with InnoDB.
-
-
-
A database layout with most tables being InnoDB (for performance and data security) and the search tables being MyISAM (for performance on that particular workload and acknowledging the fact that, if that data was corrupted, it could be easily rebuilt) is an excellent fit.
-
It is important to not run at 100% usage of the innodb buffer, as this likely means that you're not buffering as much as you could for reads, and that you're starving your write buffer which also lives in the same global innodb_buffer.
-
1 - 5 of 5
20 items/page
List Comments
(0)
List Info