MySQL Forums
Forum List  »  General

very large query, Error Code: 2013. Lost connection to MySQL server during query
Posted by: ed ziffel
Date: December 15, 2011 07:18PM

Have table with just under 200meg records. When trying to do queries to sort all records even by one condition get Error Code: 2013. Lost connection to MySQL server during query.

Check on web some and ran:
mysql> show variables like "%timeout%";
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| connect_timeout            | 10    |
| delayed_insert_timeout     | 300   |
| innodb_lock_wait_timeout   | 50    |
| innodb_rollback_on_timeout | OFF   |
| interactive_timeout        | 28800 |
| net_read_timeout           | 30    |
| net_write_timeout          | 60    |
| slave_net_timeout          | 3600  |
| table_lock_wait_timeout    | 50    |
| wait_timeout               | 28800 |
+----------------------------+-------+
10 rows in set (0.00 sec)
[\CODE]

Using Ubuntu linux 10.04lts.  The server is on the local machine.  Did not see where to change these values as in which file.  Also do not what to play "guess-a-setting".  Can someone point me in the right direction and give me a hint or two about what settings to change and to what?

Thanks

Options: ReplyQuote




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.