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?
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.