Re: Losing connection when querying the database
Posted by:
Patric F
Date: January 15, 2014 01:46AM
No not exactly 15 minutes. It can be around 12-20 minutes.
However I'm more concerned about the error when it hits row 17457397.
Is this something to be concerned about?
In MySQL Workbench it will only backup to around 2.5GB and then get this error and quit, and deleting the backup in the process.
If I run mysqldump I get a 4.7GB big backup-file and it still gets the same error message, but the backup-file is still there.
This is what I get:
+----------------------------+----------+
| Variable_name | Value |
+----------------------------+----------+
| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 28800 |
| lock_wait_timeout | 31536000 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| slave_net_timeout | 3600 |
| wait_timeout | 28800 |
+----------------------------+----------+
Subject
Written By
Posted
Re: Losing connection when querying the database
January 15, 2014 01:46AM
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.