Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
AWS re:Postre:Post

Bad performance on RDS MariaDB

0

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 On_premises execution

EC2 over RDS in the same VPC RDS with EC2

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?

Argomenti
Migrazione e modernizzazioneAnalisiDatabase
Tag
Amazon Relational Database ServiceMariaDB
Lingua
English
Carlos Garces
posta 2 anni fa633 visualizzazioni
1 Risposta
1
Risposta accettata

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.

AWS
YUTAKA_H
con risposta 2 anni fa
  • Carlos Garces
    2 anni fa

    Thanks! I need to investigate why a new optimization is degrading performance, but works as workaround.

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente