Search results for "sort_buffer_size"

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 ... read more

Fun MySQL fact of the day: OR not

We started discussing secondary indices yesterday, and we considered how we might create two separate indices on our user table. We also started to build an understanding of when MySQL can and shouldn't use an index for a query, but we omitted one fun fact. ... read more