Not the answer you need?
Register and ask your own question!

Connect through mysql client is slow, fast when connect through MySQL Workbench

Van PhamVan Pham EntrantInactive User Role Beginner
This is for 10.0.16-MariaDB-1~trusty-wsrep-log Galera cluster. When I connet to the cluster using MySQL Workbench, connection is fine. Howver, when I tried to connect using the MySQL client and execute use aa (user databasename), it's very slow and sometimes timeout. For example:

MariaDB [(none)]> use uaa;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [uaa]>

Just doing something like the above takes seconds to several minutes, but we don't see the same behavior when using MySQL workbench. ARe we having some kind of corruption issues ? What is going on ?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.