Oracle released the results of a test the MySQL team performance in which they were made to compare the performance of MyISAM and InnoDB engine in MySQL. The graph in the blog speaks for itself: by the trend curves can not think of anything other than the effects of serialization operations MyISAM, compared to the efficiency of multi-versioning operated by InnoDB. Of course, the multi-versioning
coast, is heavy to manage, slow down the query individually, but the scale is different. The
downloadable whitepaper is enlightening, especially in the sections "Comparing InnoDB & MyISAM" and "Conclusions", which read bluntly advantages and disadvantages of the two solutions, and even their most appropriate uses.
version of InnoDB taken into consideration is the last, 1.1, in which great improvements have been introduced (all reported in detail), but the discussion is also valid for earlier versions: just look at the graphs in Appendix B.
no surprise that MySQL 5.5 becomes the default InnoDB engine, recommended for new applications.
0 comments:
Post a Comment