Timeline for MySQL InnoDB Sorting Issue
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 2, 2021 at 20:34 | history | edited | RolandoMySQLDBA | edited tags | |
| S Mar 3, 2014 at 11:38 | history | bounty ended | Ulrich Thomas Gabor | ||
| S Mar 3, 2014 at 11:38 | history | notice removed | Ulrich Thomas Gabor | ||
| Feb 27, 2014 at 17:24 | answer | added | RolandoMySQLDBA | timeline score: 3 | |
| Feb 27, 2014 at 15:47 | answer | added | Van | timeline score: 1 | |
| S Feb 25, 2014 at 8:03 | history | bounty started | Ulrich Thomas Gabor | ||
| S Feb 25, 2014 at 8:03 | history | notice added | Ulrich Thomas Gabor | Draw attention | |
| Jun 28, 2013 at 10:11 | comment | added | ypercubeᵀᴹ | @Darhazer The ASC and DESC descriptors are allowed in index definitions but ignored in MySQL. | |
| Jun 28, 2013 at 8:50 | comment | added | Maxim Krizhanovsky | What if you are ordering ASC? Maybe you have to declare your index as object_id, object_setting_id DESC | |
| Jun 28, 2013 at 8:45 | answer | added | Maxim Krizhanovsky | timeline score: 0 | |
| Jun 27, 2013 at 16:18 | comment | added | ypercubeᵀᴹ | I can't reproduce the EXPLAIN output with InnoDB tables. Are you sure that the table is not a MyISAM table (or some other engine)? See the SQL-Fiddle (removed my previous, wrong comments.) | |
| Jun 24, 2013 at 14:54 | comment | added | clops | Well, but the documentation is implying that the primary key is part of any index. If I dig further I see that in case I want to sort a resultset with no filesort, the column that I want the data to be sorted by has to be the last member of an index. The two prerequisites kind of match, hence a filesort is not what I expect to see :( | |
| Jun 24, 2013 at 14:39 | comment | added | clops | Selection only the object_setting_id yields an additional "Using Index" (as expected), filesort stays :( No Order By clause has then only "Using Index" (also as expected). However, NOT using a Where immediately picks PRIMARY as the key and thus does not yield a filesort. Why is that so? The documentation leads me to believe something different 8) | |
| Jun 24, 2013 at 13:22 | comment | added | ypercubeᵀᴹ | And what if you keep the SELECT * but remove the ORDER BY clause? | |
| Jun 24, 2013 at 13:17 | comment | added | ypercubeᵀᴹ | What is the EXPLAIN if you do SELECT object_setting_id ... (the rest as it is)? | |
| Jun 24, 2013 at 12:00 | history | asked | clops | CC BY-SA 3.0 |