Changes between Initial Version and Version 1 of Ticket #7500, comment 17
- Timestamp:
- 11/05/2024 01:56:16 PM (16 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #7500, comment 17
initial v1 68 68 }}} 69 69 70 I also removed only the `is_spam` index without applying the patch and got the same results.70 I also removed only the `is_spam` index without applying the patch, and got the same results. The composite index was not chosen by mysql. 71 71 72 72 73 @brandonliles I know it's been ages since you shared your feedback. But if we could use which index is being chosen, that would help confirm my findings.73 @brandonliles I know it's been ages since you shared your feedback. But if we could see which index is being chosen by mysql in your queries, that would help confirm my findings. 74 74 75 75 --- … … 77 77 Outcome: it seems that only removing the `is_spam` index is enough to mysql to use another index with good cardinality, rather than a full table scan. 78 78 79 It's not clear, based on my testing, the patch here will actually avoid table scan. On the contrary, it is technically possible it'll force a full table scan in certain situations.79 It's not clear, based on my testing, the patch here will actually avoid a table scan. On the contrary, it is technically possible it'll force a full table scan in certain situations.