Announcement

Announcement Module
Collapse
No announcement yet.

Node hangs when running load data infile

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

  • Node hangs when running load data infile

    Hi, all
    Installed 3-node cluster.
    There's an issue.
    Running Load DATA INFILE or Insert into Select * from.. hangs all other queries
    Show processlist shows all threads with "wsrep in pre-commit stage"
    Does anybody facing same issues?


  • #2
    Hi,

    How large are those data imports? Or the tables you are trying to copy?
    Note that very large transactions are not the best thing for Galera replication - both in terms of memory usage as well as for cluster operations.
    If you show the output of:
    show status like 'ws%';
    and
    show engine innodb status\G (cut irrelevant parts)
    we should see more details.

    Comment

    Working...
    X