Skip to main content

filesort

Short Description

The using_filesort node is seen where MySQL is performing an extra pass in order to sort the data

Detailed Description

The using_filesort node is seen where MySQL is performing an extra pass in order to sort the data. This typically happens where no supporting index can be used to satisfy the query.

Sorting is performed in memory so long as the sorted data fits within sort_buffer_size. If this is exceeded, the sort will spill to disk and performance will suffer.

JSON property: using_filesort

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.

DBmarlin Trial