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?