Save the settings, exit MySQL Workbench and reopen the connection.Īdjust the timeout variables in your MySQL configuration filesĪlternatively, if you’re using a MySQL configuration file to control the settings of your connections, then you can edit the my.cnf file (Mac) used by your MySQL connection. Querious 2.1. Reactotron(Mac) V2.1.2 Mac41.94M Skipper() V3.2.14 Mac24.05MB JSON Editor(JSON) Mac5.8MB MongoDB() Mac52.0 MB JetBrains AppCode for Mac 403 MB Receigen() V4.0.3 Mac2.7M Origami Studio(Mac) Mac42.9 MB Querious(Mac MySQL.Look for the MySQL Session section and increase the DBMS connection read time out value.In the application menu, select Edit > Preferences > SQL Editor.You can edit the SQL Editor preferences in MySQL Workbench: You can increase your MySQL client’s timeout values if you don’t have administrator access to the MySQL server. The MySQL documentation suggests increasing the net_read_timeout or connect_timeout values on the server. If you’re an administrator for your MySQL server, try changing some values. Re-writing the queries isn’t always option so you can try the following server-side and client-side workarounds. For my purposes, I’ve found that denormalizing content into working tables can improve the read performance. This should have the added benefit of making your query easier to read. Where possible, try reducing the number of joins in a single query.
For example, instead of joining all the contents of two very large tables, try filtering out the records you don’t need. Hi can avoid the problem entirely by refining your SQL queries.
0 kommentar(er)
