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

  1. MySQL bugs: http://bugs.mysql.com
  2. Apache Thrift: https://thrift.apache.org

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy ADMIN Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

comments powered by Disqus