Announcement

Announcement Module
Collapse
No announcement yet.

mysqldump import = deadlock?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysqldump import = deadlock?

    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?

  • #2
    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,

    Comment

    Working...
    X