Comment 1 for bug 1078759

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]
datadir=/var/lib/mysql
binlog_format=ROW

thread_cache_size=4
query_cache_size=8M

wsrep_provider=/usr/lib64/libgalera_smm.so

wsrep_slave_threads=4
wsrep_cluster_name=something
wsrep_sst_method=xtrabackup

innodb_buffer_pool_size=128M
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_flush_method=O_DIRECT
innodb_file_per_table