HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How to clear gcache pages in Percona PXC

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
gcachepxchowperconaclearpages

Problem

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.

Solution

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.

Context

StackExchange Database Administrators Q#142040, answer score: 3

Revisions (0)

No revisions yet.