Optimizing Storage Engines, Schemas, and Data Types

Storage engines are the backbone of MySQL – they power our data and tell our database how to interact with it. I’ve told you about them in Chapter 2 of this book. Storage engines don’t walk alone: they harbor database schemas, data types, collations, indexes, and other things, and each of those things has its remits on one side and downsides on the other. Regardless, storage engines were, are, and will be the spark that starts a fire; the fire that makes your data warm, and the users of your application happy.