I am seeing the same problem with 5.5.28-23.7-369.squeeze on Debian Squeeze on a 3-node Galera cluster.
Each node has 1GB of RAM, which should be plenty, given that a plain text dump of the data in question is only 150M big. There are a few tables with some hundred thousand entries in it which are mostly appended and seldomly read (mail logs). Performance is just fine. However when I start a cleaning job that just removes 100000 entries from a table the memory usage on all nodes goes through the roof. It usually is enough to push them deep into swapping which makes recovery a mess.
I am seeing the same problem with 5.5.28- 23.7-369. squeeze on Debian Squeeze on a 3-node Galera cluster.
Each node has 1GB of RAM, which should be plenty, given that a plain text dump of the data in question is only 150M big. There are a few tables with some hundred thousand entries in it which are mostly appended and seldomly read (mail logs). Performance is just fine. However when I start a cleaning job that just removes 100000 entries from a table the memory usage on all nodes goes through the roof. It usually is enough to push them deep into swapping which makes recovery a mess.
[mysqld] /var/lib/ mysql
datadir=
binlog_format=ROW
thread_cache_size=4
query_cache_size=8M
wsrep_provider= /usr/lib64/ libgalera_ smm.so
wsrep_slave_ threads= 4 name=something method= xtrabackup
wsrep_cluster_
wsrep_sst_
innodb_ buffer_ pool_size= 128M locks_unsafe_ for_binlog= 1 autoinc_ lock_mode= 2 flush_method= O_DIRECT file_per_ table
innodb_
innodb_
innodb_
innodb_