maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #06309
485 GB of galera.page.xxxxx files never deleted!?
-
To:
Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
From:
Cédric Counotte <cedric.counotte@xxxxxxxxxx>
-
Date:
Mon, 1 Aug 2022 06:52:47 +0000
-
Accept-language:
en-US, fr-FR
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=1check.com; dmarc=pass action=none header.from=1check.com; dkim=pass header.d=1check.com; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=GF3BN0GBU6OeTzq1yn2oOxFwT3w0m8MttRCb4Wz337M=; b=BTJU9w9lMFuVIXr+KIgnOXv3BUnzq1AJ5PxNWA1j9a3tVFDr2Q6zr1VTFdAan9BmlUH6WaVxz8o0jan4lc2BlyU8joCFH3Vg5oi8MPG3NIrmo7In2bEbF6tCOyp5gJOulPWVLaUKzXWBhSMoe5/IOieC9g3cR4P2BzkE3I1VRLXoSkGM0BgUci+DI43uNTUltDffGNg3OzViSf+uW8XsMAB2FVZuyDyrjIR8gF7aPSgBDw/YCZTVBGSmm9YcaUNBX8bLnqJnRUVtU1ryXQIuKKHflkKME7shKnuYPU5l9l0ivVbNrOn0nanKzI+WDdYuICDni8ojMq8boa0EoJUB3A==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=AHL95qCCiRImQX7wgp6kiDReOAaY+JEuUvnC6JIK0pYRAyYlVoaZyQSFOoipSK6cyNO84jckNSnlkFliW2GhQd4KZYvbyLf+N6mhM/owphrdkAPuSUVs26Yqmq6xE9DlKtqXeOrMOy7pNy0CkbgQ2mxF7Kd9nOxGgq7fGEo2Yz6I3/I7nG18Mc6Lv0bVjcEqJdMd+liNq8Upy7cndxtKrd1skbz8aVBnQFBnLb2K3Vv63vSGXXhCu08KEPjsr5/XX0BXg4T7NLgYPanIfTddhwjFSsUdtFGyS47EvsxLJnqTJDqVAguM+MMNzVHelkvTviI14YUvBpXdP9RXSzwpsQ==
-
Authentication-results:
dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=1check.com;
-
In-reply-to:
<CAMx4oe167vWqZDuLh4i8w35MyyFjzFc6H+1dHF6qE96vh-5q5w@mail.gmail.com>
-
Thread-index:
AQHYpXNPLsQX0DDSskilIG07egvUjA==
-
Thread-topic:
485 GB of galera.page.xxxxx files never deleted!?
Hello all,
Again, I need help with a galera cluster.
One of the galera has about 3800 files named galera.page.0000xxx (not galera.cache) of 128MB each stored in /var/lib/mysql, which is about twice the size of the total DB !? and it keeps creating files every minute, never deleting any of them for 3 days.
The other nodes have no such files, but only one galera.cache file of 128MB.
I tried deleting some of them, but it doesn’t reclaim disk space and in about 2 days disk would be entirely filled and the server would obviously stop functioning if not the entire cluster.
Can’t find any information about galera.page files but only galera.cache file so I’m not sure it’s related. As far as I could tell those are used when replicating information between node? Does that mean that the changes on that node are not replicated to others?
Any help would be appreciated.
C.
Follow ups
References
-
MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: William Edwards, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Marko Mäkelä, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: jocelyn fournier, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-27
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Cédric Counotte, 2022-07-28
-
Re: MariaDB server horribly slow on start
From: Gordan Bobic, 2022-07-28