« Previous 1 2 3
A storage engine for every use case
Data Machine
Final Words
The MySQL default storage engine InnoDB is fast, feature-rich, extremely advanced, and normally the best choice for most tables.
Companies like Facebook that use MySQL on a very large scale and with intensive workloads have developed storage engines that are more tailored to their needs (e.g., to optimize physical and system resource usage). The same optimizations can prove useful for much smaller companies if the code is released as open source.
When it comes to deciding what data to write and how, you have a great deal of freedom in the choice of storage engines, many of which have been designed for specific needs, such as a very high compression ratio or importing and exporting data to different technologies.
Storage engines make MySQL extremely flexible, and exploring them can open interesting possibilities.
Infos
- MySQL bugs: http://bugs.mysql.com
- Apache Thrift: https://thrift.apache.org
« Previous 1 2 3
Buy this article as PDF
(incl. VAT)