Calculating gcache.size value

Is there some formula for determining how large I should set the gcache.size value to? I have a db that looks like it is too large for the default 128M, so IST transfers won’t happen. The total size of the .ibd files in the datadir/dbfolder is about 11GB if that makes any difference.

1 Like

@brucehvn There is no real guidance on gcache size. The idea is that you size the cache to the amount of data changes you do and how much time you’re willing to accept. For example, regardless of your dataset size, if you only change 5GB/hr, then a 5GB gcache will allow downtime of 1 member up to 1 hour before SST is required. If you change 2GB/hr, a 5GB gcache will allow 2.5hrs of downtime before SST. The choice/decision is up to you and your environment.

You must also ensure gcache.recover=YES is set in your config, otherwise IST will never happen.

BTW; if you know that you will be doing some planned maintenance you can use “freeze_purge_at_seqno” to avoid trashing the gcache until the down is back with IST

source: Want IST Not SST for Node Rejoins? We Have a Solution!