# Mysql data  archiving with percona getting Lost connection to MySQL server

**URL:** <https://forums.percona.com/t/mysql-data-archiving-with-percona-getting-lost-connection-to-mysql-server/6497>\
**Category:** Percona Toolkit\
**Created:** [August 7, 2018, 3:04am UTC](https://forums.percona.com/t/mysql-data-archiving-with-percona-getting-lost-connection-to-mysql-server/6497 "2018-08-07T03:04:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sreenu1430](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@sreenu1430](https://forums.percona.com/u/sreenu1430)\
**Post date:** [August 7, 2018, 3:04am UTC](https://forums.percona.com/t/mysql-data-archiving-with-percona-getting-lost-connection-to-mysql-server/6497/1 "2018-08-07T03:04:44Z")

</div>

Data base is MYSQL and enabled constraints while arching the data . archiving is going smooth and after some time getting error at some table  
" DBD::mysql::st execute failed: Lost connection to MySQL server during query [for Statement “SELECT …”" .

I increased the following mysql properties and tried but no luck getting same error,

connect\_timeout=31536000;  
interactive\_timeout=31536000;  
wait\_timeout=31536000;  
max\_allowed\_packet=1073741824;

DBD::mysql::st execute failed: Lost connection to MySQL server during query [for Statement "SELECT /\*!40001 SQL\_NO\_CACHE \*/ …'] at /usr/bin/pt-archiver line 6773.

TIME ELAPSED COUNT  
2018-07-12T03:49:24 0 0  
2018-07-12T04:08:21 1136 1000  
.  
.  
.  
2018-07-12T04:09:54 1229 55000  
2018-07-12T04:19:21 1797 56000

real 150m2.297s  
user 0m4.776s  
sys 0m1.296s

but no luck . can anybody help on this ? in advance i appreciate you.

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [December 21, 2018, 9:27am UTC](https://forums.percona.com/t/mysql-data-archiving-with-percona-getting-lost-connection-to-mysql-server/6497/2 "2018-12-21T09:27:35Z")

</div>

What pt-archiver version do you use? Can you show the archived table definition?