[MDEV-26098] improve deleting many files in datadir during SST Created: 2021-07-06  Updated: 2023-08-02

Status: Open
Project: MariaDB Server
Component/s: Galera SST
Fix Version/s: None

Type: Task Priority: Major
Reporter: Richard Stracke Assignee: Seppo Jaakola
Resolution: Unresolved Votes: 1
Labels: None


 Description   

Description: The problem:
When an SST is started on a server, but the server still contains old data, old table files will all be removed. If you have a very large number of tables (we have 100K+) and a large number of data (we have 1.5TB+), this removal process puts an incredible strain on the machine, even if it is a very fast machine with very fast I/O. This can cause time-out/downtime issues for a few seconds if the machine is also running another service, such as a proxy server.

The solution:
The idea is to reduce overhead via ionice or similar techniques



 Comments   
Comment by Sergei Golubchik [ 2021-09-24 ]

no, I don't. may be sysprg does.

Generated at Thu Feb 08 09:42:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.