Inserting many rows

[Bruno Kamiche]

Hi.

I am working with a 3 node xtradb cluster, everything works fine most of the time, but I'm having problems in the following situation:

- Writes are only done on one node

- The other 2 nodes are used for read operations

When I insert many rows into a table (>100k), no matter the record size and even though the table is not being used by any other process all other DML operations get stuck, I think this happens once the activity is finished in the writing node and it has to reproduce the changes in the other nodes.

Is this a normal behavior, is there any parameter I shall change?

Bruno

[Kenny Gryp]

You are probably experiencing Flow Control, Have a look at http://www.percona.com/blog/2013/05/02/galera-flow-control-in-percona-xtradb-cluster-for-mysql/ for more information.

Kenny

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to percona-discuss...@googlegroups.com.
To post to this group, send email to percona-d...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.