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

mysqldump import = deadlock?

nickdemasternickdemaster EntrantInactive User Role Beginner
I have a default install of Percona XtraDB Server version: 5.5.24-log Percona XtraDB Cluster (GPL), wsrep_23.6.r341.

The environment is 4 node, OEL 5.5 VM with 6GB (4GB allocated to MySQL).

These are the my.cnf variables pertaining to galera:

wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_address=gcomm://
wsrep_slave_threads=8
wsrep_sst_method=rsync
wsrep_cluster_name=percona_cluster
binlog_format=ROW
default_storage_engine=InnoDB


Anytime I try to import a mysqldump import, no matter the size - from 12MB to 8GB so far, I get a deadlock error and the import stops.

Am I missing something easy here?

Comments

  • lefredlefred Contributor Inactive User Role Beginner
    Hello,

    That should not be a problem, but some remarks:

    - check the size of your transaction logs (innodb_log_file_size)
    - do you import in one single transaction ?
    - you should try to have odd number of nodes (for quorum), but that's is of course not the problem.

    What I would try is:
    perform the import with only one node active and then join the other nodes and let them do their SST.

    regards,
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.