MySQL - solving problems with MyISAM tables

Sasha Pachev (12.Jul.2017 at 11:30, 50 min)
Talk at OpenWest Conference 2017 (English - US)

Rating: 0 of 5

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]

Who are you?

Claim talk

Talk claims have been moved to the new Joind.in site.

Please login to the new site to claim your talk

Want to comment on this talk? Log in or create a new account or comment anonymously

Write a comment

 
Please note: you are not logged in and will be posting anonymously!
= eight minus five
 
No comments yet.
© Joind.in 2017