1

My questions is quite similar to Mysqldump from the Amazon RDS. I have the same behavior. Everytime when I do a backup using mysqldump my entire RDS freezes and hence my application is not responding. I am using --single-transaction with the mysqldump command but that doesn't help at all. With this, RDS is quite unusable since I can not dump a backup or data sample during live operation. Is there a way to get the data out of RDS without freezing everything?

Improve this question
2
  • Have you looked at processlist while the DB is dumping? There could be locked MyISAM tables causing queue of statements waiting for locks to be released.
    – Manny Calavera
    Commented Oct 9, 2014 at 19:10
  • That was a great hint! Thanks, it helped me finding out, that in the deepness of my fab management scripts there was still one mysqldump command without the --single-transaction which locked the tables for write access. It would be great if you could write your hint as the answer so I can close the question. Thank you!
    – danielt
    Commented Oct 10, 2014 at 10:31

1 Answer 1

Reset to default
0

I suggest taking a look at processlist while the DB is dumping. There could be locked MyISAM tables causing queue of statements waiting for locks to be released.

Improve this answer

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.