A full-text index needed raw SQL in a migration until 9.0, which meant it was invisible to anything reading the schema definition. Natural language mode is the default…
InnoDB requires an index on the referencing column and creates one silently if none exists, which is convenient and produces indexes nobody chose. The auto-created index is a…
A composite index serves any query using a leftmost prefix of its columns, which means three separate indexes are frequently one index somebody did not notice. The gap…
An index containing every column a query needs answers it without reading the table, which on a wide row is the difference between one page read and two.…
MariaDB replaced XtraDB with its own InnoDB fork some versions ago, and 10.6 is where the accumulated differences from MySQL stop being cosmetic. The two are no longer…