MySQL Forums
Forum List  »  MySQL Workbench

Re: Slow first statement after connection to remote MySQL server
Posted by: Jason Brunette
Date: December 05, 2023 09:59AM

Does your default schema have a lot of tables? When a schema is "loaded" (opened), Workbench runs queries to fetch table DDL and other stuff and does it using the same connection as query tabs for some reason. This means you have to wait for Workbench to silently collect all of the table data before it will be able to run any other queries.

I haven't found a workaround, other than switching to a smaller default schema. Even then, opening the bigger schema manually in Workbench triggers the same process, causing your query to quietly wait anyway.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Slow first statement after connection to remote MySQL server
278
December 05, 2023 09:59AM


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.