Andy Tolbert created CASSANDRA-20186:
----------------------------------------
Summary: AutoRepair should splay repairs based on
min_repair_interval
Key: CASSANDRA-20186
URL: https://issues.apache.org/jira/browse/CASSANDRA-20186
Project: Apache Cassandra
Issue Type: Bug
Reporter: Andy Tolbert
For smaller node count clusters AutoRepair currently schedules repairs in quick
succession.
Ideally we should try to evenly spread, to do this we could try to splay
repairs out over min_repair_interval.
Observationally, i've seen that with a 1 day {{{}min_repair_interval{}}}, all
repairs might get executed within ~3hours as they are effectively throttled by
a combination of {{parallel_repair_count}} , {{repair_check_interval}} and how
long it takes to complete replicas for a replica.
{noformat}
select host_id, repair_start_ts from system_distributed.auto_repair_history
where repair_type='FULL';
host_id | repair_start_ts
-------------------------------------+--------------------------------
6d194555-f6eb-41d0-c000-000000000001 | 2025-01-06 03:59:53.399000+0000
6d194555-f6eb-41d0-c000-000000000002 | 2025-01-06 05:36:49.299000+0000
6d194555-f6eb-41d0-c000-000000000003 | 2025-01-06 05:46:48.505000+0000
6d194555-f6eb-41d0-c000-000000000004 | 2025-01-06 04:04:27.126000+0000
6d194555-f6eb-41d0-c000-000000000005 | 2025-01-06 03:53:32.573000+0000
6d194555-f6eb-41d0-c000-000000000006 | 2025-01-06 06:31:49.930000+0000
6d194555-f6eb-41d0-c000-000000000007 | 2025-01-06 05:41:46.562000+0000
6d194555-f6eb-41d0-c000-000000000008 | 2025-01-06 04:45:57.136000+0000
6d194555-f6eb-41d0-c000-000000000009 | 2025-01-06 06:32:59.428000+0000
6d194555-f6eb-41d0-c000-00000000000a | 2025-01-06 04:50:14.020000+0000
6d194555-f6eb-41d0-c000-00000000000b | 2025-01-06 06:33:30.846000+0000
6d194555-f6eb-41d0-c000-00000000000c | 2025-01-06 04:40:05.365000+0000{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
