Slow query compared mysql 8.0.30(innodbcluster) vs RDS(8.0.30)
Posted by: Ales Verbic
Date: November 30, 2022 08:33AM

Hi,

I tried the same app using the same queries/hibernate 5.4.33 vs rds-mysql-8.0,30 and mysql-innodbcluster 8.0.30 with using ro and rw ports to achieve max performance.

App/Hibernate got very slow with some queries talking to mysql-innodbcluster (10s) while executing directly in mysql-innodbcluster got executed in 1s. This kind of latency, I am not experiencing with talking to RDS.

If I only use ro port is even worse.

Do you have any ideas?

Options: ReplyQuote


Subject
Written By
Posted
Slow query compared mysql 8.0.30(innodbcluster) vs RDS(8.0.30)
November 30, 2022 08:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.