Not the answer you need?
Register and ask your own question!

XtraDB not cleaning up galera.cache pages

dchernivdcherniv EntrantCurrent User Role Beginner
We are seeing a strange issue where xtradb on one of our 3 cluster nodes just stopped using galera.cache file and started creating gcache.page.xxxxx at a rate of about one file every 5 minutes.
Looking wsrep% variables, wsrep_gcache_pool_size is now 113021942801 even though it is supposedly capped at 64GB in my.cnf.
All the other nodes seem to honor the cap. The node in question is synced and all the transactions are replicated to it.
Cached down to variable is extremely low. Lowest in the entire cluster.

| wsrep_local_cached_downto | 83655 |

One of the other nodes:
| wsrep_local_cached_downto | 62524343 |

Anyone seen anything like that?

All the nodes are:
Server version: 5.6.34-79.1-56-log Percona XtraDB Cluster (GPL), Release rel79.1, Revision 7c38350, WSREP version 26.19, wsrep_26.19

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.