Recently we have encountered seriously problem since we moved our mysql database from EC2 to RDS.

We do have high cpu usage before moved to rds, but our website has a good speed for our customers. After set up instance in RDS, our speed dramatically down without any reasons.

We checked our metrics on RDS, then we found that we have almost 100 write count/sec in anytime of day, even we do not have too many customers at nighttime, but the write count/sec is still remain around 100 count/sec.

And we have checked our general_log and slow_log files, but we do not where the write operations from ?

Anyone experience similar problems ?

Our configuration of rds:

Mysql 5.6.23 db.r3.large

Our metrics snapshot: enter image description here

enter image description here

Many Thanks


1 Answer 1


The poor performance of this is due to the pager of view, just modify the view setting to "Mini Pager" or others except "Full". Your database performance will boost twice times as before.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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