SHOW FULL TABLES - Very Slow
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.
Subject
Views
Written By
Posted
SHOW FULL TABLES - Very Slow
897
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.