MySQL Forums
Forum List  »  Performance

SHOW FULL TABLES - Very Slow
Posted by: Sreedhar Vengala
Date: December 19, 2019 11:18PM

Issue:

1. MySql dump created manually by scripting all objects from existing
MySql db which is on AWS. (MySql Version 5.7)
2. Restored dump file on to Azure MySql (Version 5.7)
3. Re-pointed Application (Appian) which sits on AWS to newly created MySql db on Azure.
4. When tried to validate Application (Appian) Objects (Data Stores), executes SHOW FULL TABLES FROM `database` LIKE 'xxxxxx' takes 4-5 seconds for each object, most of the time is 'checking permissions'.
5. But reading data from the tables are faster.


Any suggestions.

Options: ReplyQuote


Subject
Views
Written By
Posted
SHOW FULL TABLES - Very Slow
611
December 19, 2019 11:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.