Found a total of 1 related content
What is filesort in mysql
Article Introduction:In mysql, filesort refers to file sorting, which sorts the obtained data in memory through the corresponding sorting algorithm. There are two types of filesort: 1. Dual-way sorting, which first takes out the corresponding sorting field and the row pointer information that can directly locate the row data according to the corresponding conditions, and then sorts it in the sort buffer; 2. Single-way sorting, which is a one-time sorting Take out all the fields of the rows that meet the condition, and then sort them in the sort buffer.
2022-11-11comment 01734