AWS Builder Center is the official home for builders on AWS. Share and read what others are working on, follow people who inspire you, explore training and workshops, and find tools to support what you're building.
Bad performance on RDS MariaDB
I'm migrating an ancient on-premises 5.5.65 MariaDB to RDS. The new RDS MariaDB 10.6 not show CPU, IOPs or Memory problems but the SQLs are too slow. One complex SELECT cost 0,89 sec on premises and 2,93 using an EC2 in the same VPC. I have compared the execution plans an are different but probably is because the different versions.
On_premises execution
EC2 over RDS in the same VPC
I don't know if the differences on the "key" column are relevant to this issue.
Any experience on bad performance with RDS and MariaDB?
- Topics
- Database
- Language
- English
asked 4 years ago1.1K views
- Newest
- Most votes
- Most comments
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 4 years ago
Relevant content
asked 5 years ago
asked a year ago
asked 2 years ago
Thanks! I need to investigate why a new optimization is degrading performance, but works as workaround.