4

I have a 4 node cluster(percona PXC) and one of the nodes have more than 150 gcache disk files each of size ~128 MB. I would like to purge or flush them so that the server user fresh gcache disk file.

I am not sure if the node restart will do it for me.

Thank You.

Improve this question

1 Answer 1

Reset to default
3

shutdown the node while maintaining quorum. so that there will be no downtime for application. manually move those all gcache files to some other location(don't delete them for safer side).Restart the server. You will get new gcache file.

Improve this answer
4
  • kasi, thank you for the answer. do we have any workarounds similar to "purge binary logs" in mysql. We would like to keep the node up and running.
    – Uday
    Jul 13, 2016 at 14:12
  • Hi Uday, ideally we will assign gcache size in Giga Bytes( for my case we assigned 8GB). ofcourse it depends on your disk size and accepted downtime of cluster node to avoid SST when node is up. whats your disk size?
    – kasi
    Jul 14, 2016 at 13:40
  • i have one more question. 150 gcache disk files--whats their extension. as per this severalnines.com/blog/understanding-gcache-galera those pages will be deleted i guess. And gcache is a circular log file. So it will flush out the old contents in it. we do have kind of GRA_1_14961.log files also in data directory. each file is indication for each failed transaction.
    – kasi
    Jul 14, 2016 at 13:46
  • there is no purge binary logs kind of stuff here.
    – kasi
    Jul 14, 2016 at 13:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.