MySQL Bugs: #84063: MySQL Workbench Freezes when fetching table meta data

Bug #84063	MySQL Workbench Freezes when fetching table meta data
Submitted:	5 Dec 2016 19:38	Modified:	6 Dec 2016 1:19
Reporter:	David Harp	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.3.8	OS:	Windows (10 Home)
Assigned to:		CPU Architecture:	Any

Description:
When connecting to a DB with large table count [180k+ for this example), MySQL Workbench freezes at Fetching Tables, Views, etc.  Same experience in other external access MySQL DB tools such as DBeaver.

Log excerpt: 
[ERR][SqlEditorSchemaTree]: Exception querying metadata from mysql.proc, will fallback to SHOW PROCEDURE: Exception: SELECT command denied to user 'XXXXX'@'XXXXXXX' for table 'proc' 

Other DBs with fewer tables on the same server instance load fine under same credentials.  Grants for user are all enabled, superuser. 

When connected to server via Putty SSH using the command line witht he same credentials, SHOW TABLES works fine and is performant (milliseconds)

How to repeat:
Connect to a MySQL server instance via SSH with 180k+ tables via MySQL Workbench or other external access tool.  Expand DB tree in schema navigator or try to display the tables within a DB.

Please try version 6.3.8. Thanks.

Unfortunately the issue persists on version 6.3.8

Thank you for the feedback. Are you using SSH connection with WorkBench?. Thanks.

Yes, I am using SSH with Workbench and able to successfully connect.

Thank you for the feedback. Then is duplicate of http://bugs.mysql.com/bug.php?id=83992 issue when connected using ssh.

Possibly, depends what the RCA shows for the issue.  To be clear, I am not able to "use" the DB, can't even get to the point where I can write then attempt to execute a query.  This is Workbench's query to the server for the DB metadata that's causing both a timeout and the Workbench application to completely freeze and require a hard task kill and restart to no resolve.  Thoughts?