Hi all,
I'm using C* 3.10.
CREATE KEYSPACE mykeyspace WITH replication = {'class':
'SimpleStrategy', 'replication_factor': '2'} AND durable_writes = false;
CREATE TABLE mykeyspace.data (
id bigint PRIMARY KEY,
kafka text
) WITH bloom_filter_fp_chance = 0.5
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class':
'org.apache.cassandra.db.compaction.TimeWindowCompactionStrategy',
'compaction_window_size': '10', 'compaction_window_unit': 'HOURS',
'max_threshold': '32', 'min_threshold': '6'}
AND compression = {'chunk_length_in_kb': '64', 'class':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND crc_check_chance = 0.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 1555200
AND gc_grace_seconds = 10800
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99PERCENTILE';
UN 10.1.1.161 398.39 GiB 256 28.9%
UN 10.1.1.19 765.32 GiB 256 29.9%
UN 10.1.1.52 574.24 GiB 256 28.2%
UN 10.1.1.213 817.56 GiB 256 28.2%
UN 10.1.1.85 638.82 GiB 256 28.2%
UN 10.1.1.245 408.95 GiB 256 28.7%
UN 10.1.1.185 574.63 GiB 256 27.9%
At crontab in all nodes (only changes the time):
08 05 * * * root nodetool repair -pr
11 11 * * * root fstrim -a
04 12 * * * root nodetool clearsnapshot
33 13 * * 2 root nodetool cleanup
35 15 * * * root nodetool garbagecollect
46 19 * * * root nodetool clearsnapshot
50 23 * * * root nodetool flush
I can I fixed this?
Thanks in advance.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]