A version 2 file could share a container’s volumes with volumes_from, which is how the data-container pattern worked. Version 3 removes it, because a scheduler placing containers on…
The default sql_mode changed, and with it a decade of behaviour: inserting a string into a numeric column, a date of 0000-00-00, or more characters than the column…
5.6 made many ALTER operations online, and the ones that are not — changing a column type, adding a full-text index — still copy the table while holding…
MySQL used to allow selecting a column that is neither grouped nor aggregated, returning an arbitrary row’s value for it. 5.7 turns that off by default, and every…
LIKE cannot use an index and everyone knows it. The mapping, the analyzers that decide what matching means, the indexing pipeline, and the drift it introduces.
Reindexing into a new index leaves two: the old one still serving and the new one ready. Pointing the application at the new one by editing configuration means…
A single DELETE removing two million rows holds locks for the duration, generates one enormous transaction in the binary log, and a replica applying it single-threadedly falls behind…