3 ms·
Yes, but paged b-trees are more graceful when they can’t fit in memory—which was the default when I cut my teeth on databases. It’s also a reason why MyIsam se
by sroussey 4y ago
Yes, but paged b-trees are more graceful when they can’t fit in memory—which was the default when I cut my teeth on databases.
It’s also a reason why MyIsam separated data and index files. InnoDb is a clustered index, so all the data is packed next to the primary key.