Saturday

MyISAM to InnoDB? Why and How

MySQL has a pluggable storage engine architecture that allows users to select the best storage engine for their application and workload. While InnoDB is by far the most popular storage engine, some users had to rely on MyISAM for its Full text search capabilities, and in some cases better performance in applications not needing transactional capabilities. Those reasons have now vanished with the release of MySQL 5.6. The best MySQL release ever indeed delivers native support for full-text search in InnoDB along with significant performance improvements. Users therefore no longer have to live with trade-offs and can rely on InnoDB for their various use cases.

In this technical webinar Dale Dasker, MySQL Technical Consultant, will review some of InnoDB’s new features, including Full Text search, and improvements that have boosted InnoDB’s performance. Dale will also show you how to migrate your applications and data from MyISAM to InnoDB. He’ll include specific examples and advice for MySQL ISV and OEM customers using MySQL within their products.

Dale will cover the following topics:
  • Portability of InnoDB files (individual .idb files and the Undo log)
  • Performance improvements with InnoDB Read-only transactions
  • Impact of changes to InnoDB page size
  • InnoDB Full Text Search

No comments:

LLM for Humanoid Robot

  Photo by Tara Winstead Let's consider a scenario where we aim to integrate Long-Term Memory (LLM) into a humanoid robot to enhance its...