Talk in English - US at OpenWest Conference 2017
Track Name:
200A - Data
Short URL: https://joind.in/talk/d41da
(QR-Code (opens in new window))
MySQL database supports multiple storage engines. The two main ones are InnoDB (transactional) and MyISAM (non-transactional). The transactional nature and other features of InnoDB have made it a popular choice in recent years. However, the extra features of InnoDB come at a cost - slower performance, larger storage overhead, difficulty in moving the data from server to server, crash recovery nightmares when things go wrong. There are use cases where MyISAM tables in the hands of knowledgeable DBAs/database application developers will provide a more flexible, performant, and stable solution. We will discuss the advantages and limitations of MyISAM tables, when it is appropriate to use them, how to avoid falling prey to their limitations, and how to fully benefit from their advantages. [2]
Comments
Comments are closed.