I just upgraded my server to AWS, and I am using RDS for database. But here, it looks like the same query is taking such a long time as compared to my old server.

I was researching and found that there is RDS cache issue. It every time calls opening table and follow all the steps and in my server it was using cache so it was not opening tables every time. I am using MySQL on RDS.

I have hundreds of thousands of records in one one table. Can someone please help me to get good performance on RDS?

closed as too broad by mustaccio, joanolo, MDCCL, RLF, Marco Mar 6 '17 at 10:51

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


You can tune performance using Parameter Groups. Some (unfortunately, not all) variables can be configured there.

Also, if you used AWS Database Migration make sure you have all the keys you need because they're not transferred by default.

Not the answer you're looking for? Browse other questions tagged or ask your own question.