Latest Content

Fun MySQL fact of the day: filesort uses files

Last Thursday, I provided incorrect information. As it usually happens, I was misled by the Internet, and in turn, I contributed to further misleading the Internet. I only realized it after couple hours with a debug build of MySQL and some breakpoints in some non-obvious places. Thankfully, the incorrect information ... read more

Fun MySQL fact of the day: a free ORDER

On February 28, we discussed that the order of results from a query in the absence of an ORDER BY clause are implementation specific. We also observed that in InnoDB, this implementation-specific behaviour tends to be the order of records as they are sorted in the index from which they ... read more
2 3 4 5 6 7 8