PXC 8.0.27 - when inserting the data using LOAD DATA INTO TABLE - Nodes are hung

MySQL & MariaDB Percona XtraDB Cluster 8.x
,
1

Hi there,
we have 3 node PXC 8.0.27 cluster , when inserting the data using LOAD DATA INTO TABLE.
The nodes are not responding and there in hung state.
And also data is not replicated to other nodes

Is this expected …?

1 Like
2

Hi @AneeshBabu,

Thank you for your question. Could you provide more information about the data you are loading? How big is the file. Table structure.

From the documentation: Percona XtraDB Cluster limitations - Percona XtraDB Cluster

  • Maximum allowed transaction size is defined by the wsrep_max_ws_rows and wsrep_max_ws_size variables.
    LOAD DATA INFILE processing will commit every 10 000 rows. So large transactions due to LOAD DATA will be split to series of small transactions.

What is the value of those variables?

Pep

1 Like