1 Answer
- Newest
- Most votes
- Most comments
1
It seems different optimization was applied. Rowid filtering is an optimization available from MariaDB 10.4.3+, so please disable rowid_filter
optimizer switch, and re-issue the query.
SET SESSION optimizer_switch='rowid_filter=off';
, then issue the query.
answered 2 years ago
Relevant content
- asked 4 years ago
- asked 2 years ago
- asked 2 years ago
- asked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 4 years ago
- How do I resolve the storage full issue on my RDS for MySQL instance or my RDS for MariaDB instance?AWS OFFICIALUpdated 9 months ago
Thanks! I need to investigate why a new optimization is degrading performance, but works as workaround.