Not the answer you need?
Register and ask your own question!

hang on restore dump

umarzukiumarzuki ContributorCurrent User Role Beginner
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?

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    What actually did you see during this "hang"? A processlist and wsrep status sample would be a good start.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.