Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

MySQL is hanging when I try to do SHOW COLLATION on my Amazon RDS instance. I can use SHOW COLLATION fine with my local database, and other SQL commands work fine on my RDS instance. But Amazon SHOW COLLATION hangs every time. Maybe I have too many collations? I'd be perfectly happy just setting it to utf8 or Latin1 collation.

I'm using mysql(5.6.12) on a micro instance.

Any ideas on what I can do? Or how can I get more information on what's happening?

share|improve this question
up vote 1 down vote accepted

Not sure if you found a solution to this but for us it seems to be related to the size of data leaving the VPC.

If you run a query with a small result set:

show collation like '%utf8_swedish%';

The result returns fine, but if you take away the like and get a large result set back it fails. We're still investigating the problem but not sure you found a solution.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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