15,041
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
m
→Error Code: 2013. Lost connection to MySQL server during query
| Line 158: | Line 158: | ||
Solution: | Solution: | ||
* Increase the setting of '''DBMS connection read time out (in seconds)''' on [https://www.mysql.com/products/workbench/ MySQL Workbench]. <ref>[http://stackoverflow.com/questions/16877574/how-can-i-execute-sql-queries-that-take-longer-99-999-seconds-on-mysql-workbench How can I execute SQL queries that take longer 99,999 seconds on MySQL Workbench? - Stack Overflow]</ref> | * Increase the setting of '''DBMS connection read time out (in seconds)''' on [https://www.mysql.com/products/workbench/ MySQL Workbench]. <ref>[http://stackoverflow.com/questions/16877574/how-can-i-execute-sql-queries-that-take-longer-99-999-seconds-on-mysql-workbench How can I execute SQL queries that take longer 99,999 seconds on MySQL Workbench? - Stack Overflow]</ref><ref>[http://stackoverflow.com/questions/10563619/error-code-2013-lost-connection-to-mysql-server-during-query Error Code: 2013. Lost connection to MySQL server during query - Stack Overflow]</ref> | ||
* Reduce the number of rows to reduce the execution time by using {{kbd | key=LIMIT}} clause ex: | * Reduce the number of rows to reduce the execution time by using {{kbd | key=LIMIT}} clause ex: | ||
<pre> | <pre> | ||