# hang on restore dump

**URL:** <https://forums.percona.com/t/hang-on-restore-dump/4565>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [December 3, 2015, 11:32pm UTC](https://forums.percona.com/t/hang-on-restore-dump/4565 "2015-12-03T23:32:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![umarzuki](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/umarzuki/32/1064_2.png) [@umarzuki](https://forums.percona.com/u/umarzuki)\
**Post date:** [December 3, 2015, 11:32pm UTC](https://forums.percona.com/t/hang-on-restore-dump/4565/1 "2015-12-03T23:32:01Z")

</div>

ubuntu 14.04 amd64  
percona xtradb 5.6.26-74.0

I have to stop haproxy in front of percona cluster nodes, then restoring dump file would not hang on CLI/mysql client “source dump.sql;”

I already tried using perl mysqltuner, increasing net\_buffer\_length to 100M, max\_allowed\_packet = 200M with same problem.

Any suggestions?

---

<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 16, 2015, 6:39pm UTC](https://forums.percona.com/t/hang-on-restore-dump/4565/2 "2015-12-16T18:39:30Z")

</div>

What actually did you see during this “hang”? A processlist and wsrep status sample would be a good start.