Hi, I have been thinking about scheduling a daily routine to force repairs on a cluster to maintain its health.
I saw that by running a nodetool tablestats [keyspace] there is an attribute called "Percent repaired" that show the percentage of data repaired on the each table. This attribute seems to be only modified when executing "nodetool repair [keyspace] [table....]", but not when executing with other options like --in-local-dc or --pr. My main concern is about building the whole MERKLE tree for a big table. I have also check to repair by token ranges, but this also seems not to modify this attribute of the table. Is this an expected behavior? Or there is something missing on the code that needs to be fixed? My "maintenance" script would be calling nodetool tablestats per each keyspace that has replication_factor > 0 to check for the value of the "Percent repaired" of each table and, in case it is below some threshold, I would execute a repair on it. Any ideas? Thanks in advance. Javier.
