1

I'm running performance testing on my application that lives in AWS environment and I see a weird behavior of the DB after certain loading.

When I have more than 1500 queries per second to the RDS MySQL, the queries are performed much slower.

The query is a SELECT statement from one table by 2 columns, we have an index created for these 2 columns.

The current setup is the following:

RDS MySQL r5.2xlarge InnoDB

Increasing the type of RDS instance doesn't help.

Is there any way to improve the performance of the current setup?

Is there any limitation on SELECT queries to the same Table or using the same Index?

Any suggestions would be much appreciated.

Strawberry
  • 33,750
  • 13
  • 40
  • 57
Oleh Pylypchak
  • 11
  • 2
  • you can look this thread --https://stackoverflow.com/questions/43844706/20-30-concurrent-mysql-connections-causes-rds-to-spike-above-80 – Ahmmed Sep 03 '20 at 10:54
  • Too much hand-waving. Please provide `SHOW CREATE TABLE`, an example of the query, and `EXPLAIN SELECT ...`. Also, how big is the table? From those, it will probably be obvious what the issue is. – Rick James Sep 03 '20 at 17:41

1 Answers1

0

The problem was on the application level with ORM, so this question is not relevant anymore.

Oleh Pylypchak
  • 11
  • 2