I am using a Cicco VPN client version 4.6.00.0049 to connect to a remote server.
When I go to the command prompt and type:
mysql -u -p -h my_database
> show tables;
(tables show)
1794 rows in set (0.54 sec)
mysql>
Pretty fast!
If I start up SQLyog Enterprise, connect to the database server and then click on the (+) sign to expand the database in question, it takes about two minutes. I am starting to think this may be a MySQL issue because I typed all of the stuff in the SQLyog history and MySQL took a long time to return the resultant tables.
Evidently SQLyog is not doing simply a “show tables”. It's doing
Navicat MySQL must be doing a “show tables” which is why it returns the table names so fast.
Here's the history log from SQLyog.
/*[8:09:22 AM][ 94 ms]*/ show variables like '%character%'
/*[8:09:22 AM][ 62 ms]*/ Set character_set_connection=latin1
/*[8:09:22 AM][ 47 ms]*/ Set character_set_results=latin1
/*[8:09:22 AM][ 63 ms]*/ Set character_set_client=latin1
/*[8:09:22 AM][ 46 ms]*/ set sql_mode=''
/*[8:09:22 AM][ 63 ms]*/ show databases
/*[8:09:26 AM][ 32 ms]*/ use 'my_database'
/*[8:13:01 AM][215000 ms]*/ select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'my_database' and `TABLE_TYPE` = 'BASE TABLE'
