Friday, February 13, 2015

MySQL hanging when switching databases after login with "use" command

Sometimes MySQL hangs after logging in and switching databases using "use" command.

mysql> use testdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

As explained in discussion link , MySQL scans the databases, tables and column names for sake of auto-completion. You can disable the scan by using -A switch (or --no-auto-rehash) when logging into mysql. E.g.

$ mysql -h <rds url> -u testuser -p -A

No comments:

Post a Comment