· 6 years ago · Nov 20, 2019, 03:30 PM
1cqlsh> CREATE KEYSPACE IF NOT EXISTS ecole WITH REPLICATION= { 'class' : 'SimpleStrategy', 'replication_factor': 3}
2 ... ;
3cqlsh> DESCRIBE KEYSPACES
4
5ecole system_schema system_auth system system_distributed system_traces
6
7cqlsh> use ecole;
8cqlsh:ecole> CREATE TABLE Cours (idCours INT, Intitule VARCHAR, Responsable INT, Niveau VARCHAR, nbHeuresMax INT, Coeff INT, PRIMARY KEY (idCours));
9cqlsh:ecole> CREATE TABLE Enseignant ( idEnseignant INT PRIMARY KEY, Nom VARCHAR, Prenom VARCHAR, status VARCHAR);
10cqlsh:ecole> DESC ecole;
11
12CREATE KEYSPACE ecole WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'} AND durable_writes = true;
13
14CREATE TABLE ecole.cours (
15 idcours int PRIMARY KEY,
16 coeff int,
17 institule text,
18 nbheuresmax int,
19 niveau text,
20 responsable int
21) WITH bloom_filter_fp_chance = 0.01
22 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
23 AND comment = ''
24 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
25 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
26 AND crc_check_chance = 1.0
27 AND dclocal_read_repair_chance = 0.1
28 AND default_time_to_live = 0
29 AND gc_grace_seconds = 864000
30 AND max_index_interval = 2048
31 AND memtable_flush_period_in_ms = 0
32 AND min_index_interval = 128
33 AND read_repair_chance = 0.0
34 AND speculative_retry = '99PERCENTILE';
35
36CREATE TABLE ecole.enseignant (
37 idenseignant int PRIMARY KEY,
38 nom text,
39 prenom text,
40 status text
41) WITH bloom_filter_fp_chance = 0.01
42 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
43 AND comment = ''
44 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
45 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
46 AND crc_check_chance = 1.0
47 AND dclocal_read_repair_chance = 0.1
48 AND default_time_to_live = 0
49 AND gc_grace_seconds = 864000
50 AND max_index_interval = 2048
51 AND memtable_flush_period_in_ms = 0
52 AND min_index_interval = 128
53 AND read_repair_chance = 0.0
54 AND speculative_retry = '99PERCENTILE';
55
56
57
58cqlsh:ecole> INSERT INTO Enseignant (idEnseignant, Nom, Prenom, status) VALUES (1, 'Travers', 'Nicolas', 'Vacataire');
59cqlsh:ecole> INSERT INTO Enseignant (idEnseignant, Nom, Prenom, status) VALUES (2, 'Mourier', 'Pascale', 'Titulaire');
60cqlsh:ecole> INSERT INTO Enseignant (idEnseignant, Nom, Prenom, status) VALUES (3, 'Boisson', 'François', 'Vacataire');
61cqlsh:ecole> INSERT INTO Enseignant (idEnseignant, Nom, Prenom, status) VALUES (4, 'Mathieu', 'Eric', 'Titulaire');
62cqlsh:ecole> INSERT INTO Enseignant (idEnseignant, Nom, Prenom, status) VALUES (5, 'Chu', 'Chengbin', 'Titulaire');
63cqlsh:ecole> INSERT INTO Enseignant (idEnseignant, Nom, Prenom, status) VALUES (6, 'Boutin', 'Philipe', 'Titulaire');
64cqlsh:ecole> INSERT INTO Enseignant (idEnseignant, Nom, Prenom, status) VALUES (7, 'Escribe', 'Julien', 'Vacataire');
65cqlsh:ecole> INSERT INTO Enseignant (idEnseignant, Nom, Prenom, status) VALUES (8, 'Znaty', 'David', 'Vacataire');
66cqlsh:ecole> INSERT INTO Enseignant (idEnseignant, Nom, Prenom, status) VALUES (9, 'Abal-Kassim', 'Cheik Ahamed', 'Vacataire');
67
68cqlsh:ecole> INSERT INTO cours ( idCours , Intitule , Responsable , Niveau , nbHeuresMax , Coeff ) VALUES (
69 ... 1 , 'Introduction aux Bases de Donnees' ,1 , 'M1' ,30 ,3);
70cqlsh:ecole> INSERT INTO cours ( idCours , Intitule , Responsable , Niveau , nbHeuresMax , Coeff ) VALUES (
71 ... 2 , 'Immeubles de Grandes Hauteurs' ,4 , 'M1' ,30 ,2);
72cqlsh:ecole> INSERT INTO cours ( idCours , Intitule , Responsable , Niveau , nbHeuresMax , Coeff ) VALUES (
73 ... 3 , 'Production et distribution de biens et de ser' ,5 , 'M1' ,30 ,2);
74cqlsh:ecole> INSERT INTO cours ( idCours , Intitule , Responsable , Niveau , nbHeuresMax , Coeff ) VALUES (
75 ... 4 , 'Bases de Donnees Avancees' ,1 , 'M2' ,30 ,5);
76cqlsh:ecole> INSERT INTO cours ( idCours , Intitule , Responsable , Niveau , nbHeuresMax , Coeff ) VALUES (
77 ... 5 , 'Architecture des Systemes Materiel' ,6 , 'M2' ,8 ,1);
78cqlsh:ecole> INSERT INTO cours ( idCours , Intitule , Responsable , Niveau , nbHeuresMax , Coeff ) VALUES (
79 ... 6 , 'IT Business / Introduction' ,7 , 'M2' ,20 ,3);
80cqlsh:ecole> INSERT INTO cours ( idCours , Intitule , Responsable , Niveau , nbHeuresMax , Coeff ) VALUES (
81 ... 7 , 'IT Business / Strategie et Management' ,8 , 'M2' ,10 ,1);
82
83cqlsh:ecole> SELECT intitule from cours
84 ... ;
85
86 intitule
87-----------------------------------------------
88 Architecture des Systemes Materiel
89 Introduction aux Bases de Donnees
90 Immeubles de Grandes Hauteurs
91 Bases de Donnees Avancees
92 IT Business / Strategie et Management
93 IT Business / Introduction
94 Production et distribution de biens et de ser
95
96(7 rows)
97
98cqlsh:ecole> SELECT nom FROM Enseignant WHERE idEnseignant = 4 ;
99
100 nom
101---------
102 Mathieu
103
104(1 rows)
105
106cqlsh:ecole> CREATE INDEX ENseignement_idx ON cours ( responsable )
107
108cqlsh:ecole> SELECT intitule FROM cours WHERE responsable = 1
109 ... ;
110
111 intitule
112-----------------------------------
113 Introduction aux Bases de Donnees
114 Bases de Donnees Avancees
115
116(2 rows)
117
118cqlsh:ecole> SELECT intitule FROM cours WHERE nbheuresmax = 30 ALLOW FILTERING;
119
120 intitule
121-----------------------------------------------
122 Introduction aux Bases de Donnees
123 Immeubles de Grandes Hauteurs
124 Bases de Donnees Avancees
125 Production et distribution de biens et de ser
126
127(4 rows)
128
129cqlsh:ecole> SELECT intitule FROM cours WHERE responsable = 1 AND niveau = 'M1' ALLOW FILTERING ;
130
131 intitule
132-----------------------------------
133 Introduction aux Bases de Donnees
134
135(1 rows)
136
137cqlsh:ecole> SELECT intitule FROM cours WHERE responsable < 5 ALLOW FILTERING;
138
139 intitule
140-----------------------------------
141 Introduction aux Bases de Donnees
142 Immeubles de Grandes Hauteurs
143 Bases de Donnees Avancees
144
145(3 rows)
146
147cqlsh:ecole> select token(intitule) from cours where responsable < 5 allow filtering
148 ... ;
149
150 system.token(intitule)
151------------------------
152 7504347749518213391
153 6654501433230775446
154 -3630385096691577150
155
156(3 rows)
157
158
159cqlsh:ecole> SELECT COUNT(intitule) FROM COURS WHERE RESPONSABLE < 5 ALLOW FILTERING;
160
161 system.count(intitule)
162------------------------
163 3
164
165(1 rows)
166
167Warnings :
168Aggregation query used without partition key
169
170cqlsh:ecole> CREATE KEYSPACE nos WITH REPLICATION = { 'class': 'NetworkTopologyStrategy', 'DC1' : 3, 'DC2' : 3 } ;
171//cqlsh:ecole> use nos; <== le keyspace nos renvoi nohostname available... donc on reste sur ecole
172cqlsh:ecole> SELECT * FROM system_schema.keyspaces;
173
174 keyspace_name | durable_writes | replication
175--------------------+----------------+-------------------------------------------------------------------------------------------
176 system_auth | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '1'}
177 system_schema | True | {'class': 'org.apache.cassandra.locator.LocalStrategy'}
178 nos | True | {'DC1': '3', 'DC2': '3', 'class': 'org.apache.cassandra.locator.NetworkTopologyStrategy'}
179 ecole | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '3'}
180 system_distributed | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '3'}
181 system | True | {'class': 'org.apache.cassandra.locator.LocalStrategy'}
182 system_traces | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '2'}
183
184(7 rows)
185cqlsh:ecole> CREATE TABLE ftfra_parameters ( tabname text PRIMARY KEY, datemaj timestamp, params list<text>, LAST_UPDATE timestamp);
186
187cqlsh:ecole> CREATE TYPE Enseignant ( idEnseignant INT, Nom VARCHAR, Prenom VARCHAR, status VARCHAR);
188
189cqlsh:ecole> CREATE TABLE coursEnseignant ( idCours INT, Intitule VARCHAR, Responsable frozen<Enseignant>, Niveau VARCHAR, nbHeuresMax INT, Coeff INT, PRIMARY KEY ( idCours ));
190cqlsh:ecole> INSERT INTO CoursEnseignant ( idCours , Intitule , Responsable , Niveau , nbHeuresMax , Coeff )VALUES (1 ,'Introduction aux Bases de Donnees', {idenseignant:1,nom:'Travers',prenom:'Nicolas',status:'Vacataire'} ,'M1',30 ,3);
191cqlsh:ecole> INSERT INTO CoursEnseignant ( idCours , Intitule , Responsable , Niveau , nbHeuresMax ,Coeff ) VALUES (2 ,'Immeubles de Grandes Hauteurs',{idenseignant:4,nom:'Mathieu',prenom: 'Eric',status:'Titulaire'},'M1',30 ,2);
192cqlsh:ecole> INSERT INTO CoursEnseignant ( idCours , Intitule , Responsable , Niveau ,nbHeuresMax , Coeff ) VALUES (3 ,'Production et distribution de biens et de ser',{idenseignant:5,nom:'Chu',prenom:'Chengbin',status:'Titulaire'} ,'M1',30 ,2);
193cqlsh:ecole> INSERT INTO CoursEnseignant ( idCours , Intitule , Responsable , Niveau , nbHeuresMax ,Coeff ) VALUES (4 ,'Bases de Donnees Avancees',{idenseignant:1,nom:'Travers',prenom:'Nicolas',status:'Vacataire'} ,'M2',30 ,5);
194cqlsh:ecole> INSERT INTO CoursEnseignant ( idCours , Intitule , Responsable , Niveau , nbHeuresMax ,Coeff ) VALUES (5 ,'Architecture des Systemes Materiel',{idenseignant:6,nom:'Boutin',prenom:'Philippe',status:'Titulaire'} ,'M2',8 ,1);
195cqlsh:ecole> INSERT INTO CoursEnseignant ( idCours , Intitule , Responsable , Niveau , nbHeuresMax ,Coeff ) VALUES (6 ,'IT Business / Introduction',{idenseignant:7,nom:'Escribe',prenom:'Julien',status:'Vacataire'} ,'M2',20 ,3);
196cqlsh:ecole> INSERT INTO CoursEnseignant ( idCours , Intitule , Responsable , Niveau , nbHeuresMax, Coeff ) VALUES (7 ,'IT Business / Strategie et Management',{idenseignant:8,nom:'Znaty',prenom:'David',status:'Vacataire'} ,'M2',10 ,1);
197cqlsh:ecole> select * from coursEnseignant
198 ... ;
199
200 idcours | coeff | intitule | nbheuresmax | niveau | responsable
201---------+-------+------------------------------------------------------+-------------+--------+---------------------------------------------------------------------------
202 5 | 1 | Architecture des Systemes Materiel | 8 | M2 | {idenseignant: 6, nom: 'Boutin', prenom: 'Philippe', status: 'Titulaire'}
203 1 | 3 | Introduction aux Bases de Donnees | 30 | M1 | {idenseignant: 1, nom: 'Travers', prenom: 'Nicolas', status: 'Vacataire'}
204 2 | 2 | Immeubles de Grandes Hauteurs | 30 | M1 | {idenseignant: 4, nom: 'Mathieu', prenom: 'Eric', status: 'Titulaire'}
205 4 | 5 | Bases de Donnees Avancees | 30 | M2 | {idenseignant: 1, nom: 'Travers', prenom: 'Nicolas', status: 'Vacataire'}
206 7 | 1 | IT Business / Strategie et Management | 10 | M2 | {idenseignant: 8, nom: 'Znaty', prenom: 'David', status: 'Vacataire'}
207 6 | 3 | IT Business / Introduction | 20 | M2 | {idenseignant: 7, nom: 'Escribe', prenom: 'Julien', status: 'Vacataire'}
208 3 | 2 | Production et distribution de biens et de ser | 30 | M1 | {idenseignant: 5, nom: 'Chu', prenom: 'Chengbin', status: 'Titulaire'}
209
210(7 rows)
211cqlsh:ecole> CREATE INDEX Niveau_idx ON coursenseignant ( Niveau ) ;
212cqlsh:ecole> SELECT responsable.nom from coursenseignant WHERE niveau = 'M1' ALLOW FILTERING ;
213
214 responsable.nom
215-----------------
216 Travers
217 Mathieu
218 Chu
219
220(3 rows)
221cqlsh:ecole> SELECT intitule FROM coursenseignant WHERE responsable = {status : 'Vacataire'} ALLOW FILTERING ;
222
223 intitule
224----------
225
226(0 rows)
227cqlsh:ecole> CREATE TYPE cour( idCours INT, Intitule VARCHAR, Niveau VARCHAR, nbHeuresMax INT, Coeff INT);
228cqlsh:ecole> CREATE TABLE Enseignantcours (idEnseignant INT, nom VARCHAR, prenom VARCHAR, status VARCHAR, cours map<int, frozen <cour>>, PRIMARY KEY (idEnseignant));
229cqlsh:ecole> INSERT INTO EnseignantCours ( idEnseignant , Nom , Prenom , status , cours )
230 ... VALUES (2 , 'Mourier' ,'Pascale','Titulaire', {});
231cqlsh:ecole> INSERT INTO EnseignantCours ( idEnseignant , Nom , Prenom , status , cours )
232 ... VALUES (3 , 'Boisson' ,'Francois', 'Vacataire', {});
233cqlsh:ecole> INSERT INTO EnseignantCours ( idEnseignant , Nom , Prenom , status , cours )
234 ... VALUES (4 , 'Mathieu' ,'Eric', 'Titulaire',
235 ... {4:{ idcours :2 , intitule : 'Immeubles de Grandes Hauteurs', niveau : 'M1 ',
236 ... nbHeuresMax :30 , coeff :2}});
237cqlsh:ecole> INSERT INTO EnseignantCours ( idEnseignant , Nom , Prenom , status , cours )
238 ... VALUES (5 , ' Chu ' ,' Chengbin ', ' Titulaire ', {});
239cqlsh:ecole> INSERT INTO EnseignantCours ( idEnseignant , Nom , Prenom , status , cours )
240 ... VALUES (6 , 'Boutin', 'Philippe','Titulaire',
241 ... {5:{ idcours :5 , intitule : 'Architecture des Systemes Materiel',
242 ... niveau : ' M2 ', nbHeuresMax :8 , coeff :1}});
243cqlsh:ecole> INSERT INTO EnseignantCours ( idEnseignant , Nom , Prenom , status , cours )
244 ... VALUES (7 , 'Escribe' ,'Julien','Vacataire',
245 ... {6:{ idcours :6 , intitule : 'IT Business/Introduction', niveau : 'M2',
246 ... nbHeuresMax :20 , coeff :3}});
247cqlsh:ecole> INSERT INTO EnseignantCours ( idEnseignant , Nom , Prenom , status , cours )
248 ... VALUES (8 , 'Znaty','David','Vacataire',
249 ... {7:{ idcours :7 , intitule : 'IT Business/Strategie et Management ', niveau : 'M2',
250 ... nbHeuresMax :10 , coeff :1}});
251cqlsh:ecole> INSERT INTO EnseignantCours ( idEnseignant , Nom , Prenom , status , cours )
252 ... VALUES (9 , ' Abal - Kassim ' ,'Cheik Ahamed', 'Vacataire', {});
253cqlsh:ecole> CREATE INDEX statuts_idx ON Enseignantcours ( status ) ;
254cqlsh:ecole> SELECT cours FROM Enseignantcours WHERE status = 'Vacataire' ALLOW FILTERING ;
255
256 cours
257--------------------------------------------------------------------------------------------------------------
258 {7: {idcours: 7, intitule: 'IT Business/Strategie et Management ', niveau: 'M2', nbheuresmax: 10, coeff: 1}}
259 {6: {idcours: 6, intitule: 'IT Business/Introduction', niveau: 'M2', nbheuresmax: 20, coeff: 3}}
260 null
261 null
262
263(4 rows)
264cqlsh:ecole> SELECT idcours ,sum(nbHeuresMax) FROM cours GROUP BY idCours, Niveau;
265InvalidRequest: Error from server: code=2200 [Invalid query] message="Group by is currently only supported on the columns of the PRIMARY KEY, got niveau"
266
267cqlsh:ecole> CREATE MATERIALIZED VIEW ecole.cours_niveau AS SELECT * FROM ecole.cours WHERE idcours IS NOT NULL AND niveau IS NOT NULL PRIMARY KEY ( idcours , niveau );
268
269Warnings :
270Materialized views are experimental and are not recommended for production use.
271cqlsh:ecole> SELECT * FROM system.views_builds_in_progress;
272
273 keyspace_name | view_name | generation_number | last_token
274---------------+-----------+-------------------+------------
275
276(0 rows)
277cqlsh:ecole> select idcours ,sum(nbHeuresMax) from cours_niveau group by idCours,Niveau;
278
279 idcours | system.sum(nbheuresmax)
280---------+-------------------------
281 5 | 8
282 1 | 30
283 2 | 30
284 4 | 30
285 7 | 10
286 6 | 20
287 3 | 30
288
289(7 rows)
290
291Warnings :
292Aggregation query used without partition key
293
294florian@florian-VirtualBox:~$ nodetool status
295Datacenter: datacenter1
296=======================
297Status=Up/Down
298|/ State=Normal/Leaving/Joining/Moving
299-- Address Load Tokens Owns Host ID Rack
300UN 127.0.0.1 313.77 KiB 256 ? 44ca3516-38b1-4a12-af4e-62d6c321884b rack1
301
302Note: Non-system keyspaces don't have the same replication settings, effective ownership information is meaningless
303florian@florian-VirtualBox:~$ nodetool info
304ID : 44ca3516-38b1-4a12-af4e-62d6c321884b
305Gossip active : true
306Thrift active : false
307Native Transport active: true
308Load : 313.77 KiB
309Generation No : 1574244335
310Uptime (seconds) : 14943
311Heap Memory (MB) : 133.79 / 1954.00
312Off Heap Memory (MB) : 0.00
313Data Center : datacenter1
314Rack : rack1
315Exceptions : 0
316Key Cache : entries 58, size 4.3 KiB, capacity 97 MiB, 555 hits, 659 requests, 0.842 recent hit rate, 14400 save period in seconds
317Row Cache : entries 0, size 0 bytes, capacity 0 bytes, 0 hits, 0 requests, NaN recent hit rate, 0 save period in seconds
318Counter Cache : entries 0, size 0 bytes, capacity 48 MiB, 0 hits, 0 requests, NaN recent hit rate, 7200 save period in seconds
319Chunk Cache : entries 25, size 1.56 MiB, capacity 456 MiB, 160 misses, 1190 requests, 0.866 recent hit rate, NaN microseconds miss latency
320Percent Repaired : 0.0%
321Token : (invoke with -T/--tokens to see all 256 tokens)
322florian@florian-VirtualBox:~$ nodetool netstats
323Mode: NORMAL
324Not sending any streams.
325Read Repair Statistics:
326Attempted: 0
327Mismatch (Blocking): 0
328Mismatch (Background): 0
329Pool Name Active Pending Completed Dropped
330Large messages n/a 0 0 0
331Small messages n/a 0 0 0
332Gossip messages n/a 0 0 0
333florian@florian-VirtualBox:~$ nodetool tablestats
334Total number of tables: 44
335----------------
336Keyspace : system_traces
337 Read Count: 0
338 Read Latency: NaN ms
339 Write Count: 0
340 Write Latency: NaN ms
341 Pending Flushes: 0
342 Table: events
343 SSTable count: 0
344 Space used (live): 0
345 Space used (total): 0
346 Space used by snapshots (total): 0
347 Off heap memory used (total): 0
348 SSTable Compression Ratio: -1.0
349 Number of partitions (estimate): 0
350 Memtable cell count: 0
351 Memtable data size: 0
352 Memtable off heap memory used: 0
353 Memtable switch count: 0
354 Local read count: 0
355 Local read latency: NaN ms
356 Local write count: 0
357 Local write latency: NaN ms
358 Pending flushes: 0
359 Percent repaired: 100.0
360 Bloom filter false positives: 0
361 Bloom filter false ratio: 0.00000
362 Bloom filter space used: 0
363 Bloom filter off heap memory used: 0
364 Index summary off heap memory used: 0
365 Compression metadata off heap memory used: 0
366 Compacted partition minimum bytes: 0
367 Compacted partition maximum bytes: 0
368 Compacted partition mean bytes: 0
369 Average live cells per slice (last five minutes): NaN
370 Maximum live cells per slice (last five minutes): 0
371 Average tombstones per slice (last five minutes): NaN
372 Maximum tombstones per slice (last five minutes): 0
373 Dropped Mutations: 0
374
375 Table: sessions
376 SSTable count: 0
377 Space used (live): 0
378 Space used (total): 0
379 Space used by snapshots (total): 0
380 Off heap memory used (total): 0
381 SSTable Compression Ratio: -1.0
382 Number of partitions (estimate): 0
383 Memtable cell count: 0
384 Memtable data size: 0
385 Memtable off heap memory used: 0
386 Memtable switch count: 0
387 Local read count: 0
388 Local read latency: NaN ms
389 Local write count: 0
390 Local write latency: NaN ms
391 Pending flushes: 0
392 Percent repaired: 100.0
393 Bloom filter false positives: 0
394 Bloom filter false ratio: 0.00000
395 Bloom filter space used: 0
396 Bloom filter off heap memory used: 0
397 Index summary off heap memory used: 0
398 Compression metadata off heap memory used: 0
399 Compacted partition minimum bytes: 0
400 Compacted partition maximum bytes: 0
401 Compacted partition mean bytes: 0
402 Average live cells per slice (last five minutes): NaN
403 Maximum live cells per slice (last five minutes): 0
404 Average tombstones per slice (last five minutes): NaN
405 Maximum tombstones per slice (last five minutes): 0
406 Dropped Mutations: 0
407
408----------------
409Keyspace : nos
410 Read Count: 0
411 Read Latency: NaN ms
412 Write Count: 0
413 Write Latency: NaN ms
414 Pending Flushes: 0
415 Table: coursenseignant
416 SSTable count: 0
417 Space used (live): 0
418 Space used (total): 0
419 Space used by snapshots (total): 0
420 Off heap memory used (total): 0
421 SSTable Compression Ratio: -1.0
422 Number of partitions (estimate): 0
423 Memtable cell count: 0
424 Memtable data size: 0
425 Memtable off heap memory used: 0
426 Memtable switch count: 0
427 Local read count: 0
428 Local read latency: NaN ms
429 Local write count: 0
430 Local write latency: NaN ms
431 Pending flushes: 0
432 Percent repaired: 100.0
433 Bloom filter false positives: 0
434 Bloom filter false ratio: 0.00000
435 Bloom filter space used: 0
436 Bloom filter off heap memory used: 0
437 Index summary off heap memory used: 0
438 Compression metadata off heap memory used: 0
439 Compacted partition minimum bytes: 0
440 Compacted partition maximum bytes: 0
441 Compacted partition mean bytes: 0
442 Average live cells per slice (last five minutes): NaN
443 Maximum live cells per slice (last five minutes): 0
444 Average tombstones per slice (last five minutes): NaN
445 Maximum tombstones per slice (last five minutes): 0
446 Dropped Mutations: 0
447
448 Table: ftfra_parameters
449 SSTable count: 0
450 Space used (live): 0
451 Space used (total): 0
452 Space used by snapshots (total): 0
453 Off heap memory used (total): 0
454 SSTable Compression Ratio: -1.0
455 Number of partitions (estimate): 0
456 Memtable cell count: 0
457 Memtable data size: 0
458 Memtable off heap memory used: 0
459 Memtable switch count: 0
460 Local read count: 0
461 Local read latency: NaN ms
462 Local write count: 0
463 Local write latency: NaN ms
464 Pending flushes: 0
465 Percent repaired: 100.0
466 Bloom filter false positives: 0
467 Bloom filter false ratio: 0.00000
468 Bloom filter space used: 0
469 Bloom filter off heap memory used: 0
470 Index summary off heap memory used: 0
471 Compression metadata off heap memory used: 0
472 Compacted partition minimum bytes: 0
473 Compacted partition maximum bytes: 0
474 Compacted partition mean bytes: 0
475 Average live cells per slice (last five minutes): NaN
476 Maximum live cells per slice (last five minutes): 0
477 Average tombstones per slice (last five minutes): NaN
478 Maximum tombstones per slice (last five minutes): 0
479 Dropped Mutations: 0
480
481----------------
482Keyspace : system
483 Read Count: 95
484 Read Latency: 2.177421052631579 ms
485 Write Count: 1024
486 Write Latency: 0.4987841796875 ms
487 Pending Flushes: 0
488 Table: IndexInfo
489 SSTable count: 1
490 Space used (live): 5029
491 Space used (total): 5029
492 Space used by snapshots (total): 0
493 Off heap memory used (total): 41
494 SSTable Compression Ratio: 0.9719626168224299
495 Number of partitions (estimate): 1
496 Memtable cell count: 0
497 Memtable data size: 0
498 Memtable off heap memory used: 0
499 Memtable switch count: 4
500 Local read count: 8
501 Local read latency: NaN ms
502 Local write count: 4
503 Local write latency: NaN ms
504 Pending flushes: 0
505 Percent repaired: 0.0
506 Bloom filter false positives: 0
507 Bloom filter false ratio: 0.00000
508 Bloom filter space used: 16
509 Bloom filter off heap memory used: 8
510 Index summary off heap memory used: 17
511 Compression metadata off heap memory used: 16
512 Compacted partition minimum bytes: 104
513 Compacted partition maximum bytes: 124
514 Compacted partition mean bytes: 124
515 Average live cells per slice (last five minutes): NaN
516 Maximum live cells per slice (last five minutes): 0
517 Average tombstones per slice (last five minutes): NaN
518 Maximum tombstones per slice (last five minutes): 0
519 Dropped Mutations: 0
520
521 Table: available_ranges
522 SSTable count: 0
523 Space used (live): 0
524 Space used (total): 0
525 Space used by snapshots (total): 0
526 Off heap memory used (total): 0
527 SSTable Compression Ratio: -1.0
528 Number of partitions (estimate): 0
529 Memtable cell count: 0
530 Memtable data size: 0
531 Memtable off heap memory used: 0
532 Memtable switch count: 0
533 Local read count: 0
534 Local read latency: NaN ms
535 Local write count: 0
536 Local write latency: NaN ms
537 Pending flushes: 0
538 Percent repaired: 100.0
539 Bloom filter false positives: 0
540 Bloom filter false ratio: 0.00000
541 Bloom filter space used: 0
542 Bloom filter off heap memory used: 0
543 Index summary off heap memory used: 0
544 Compression metadata off heap memory used: 0
545 Compacted partition minimum bytes: 0
546 Compacted partition maximum bytes: 0
547 Compacted partition mean bytes: 0
548 Average live cells per slice (last five minutes): NaN
549 Maximum live cells per slice (last five minutes): 0
550 Average tombstones per slice (last five minutes): NaN
551 Maximum tombstones per slice (last five minutes): 0
552 Dropped Mutations: 0
553
554 Table: batches
555 SSTable count: 0
556 Space used (live): 0
557 Space used (total): 0
558 Space used by snapshots (total): 0
559 Off heap memory used (total): 0
560 SSTable Compression Ratio: -1.0
561 Number of partitions (estimate): 6
562 Memtable cell count: 7
563 Memtable data size: 56
564 Memtable off heap memory used: 0
565 Memtable switch count: 0
566 Local read count: 0
567 Local read latency: NaN ms
568 Local write count: 7
569 Local write latency: NaN ms
570 Pending flushes: 0
571 Percent repaired: 100.0
572 Bloom filter false positives: 0
573 Bloom filter false ratio: 0.00000
574 Bloom filter space used: 0
575 Bloom filter off heap memory used: 0
576 Index summary off heap memory used: 0
577 Compression metadata off heap memory used: 0
578 Compacted partition minimum bytes: 0
579 Compacted partition maximum bytes: 0
580 Compacted partition mean bytes: 0
581 Average live cells per slice (last five minutes): 1.0
582 Maximum live cells per slice (last five minutes): 1
583 Average tombstones per slice (last five minutes): 1.0
584 Maximum tombstones per slice (last five minutes): 1
585 Dropped Mutations: 0
586
587 Table: batchlog
588 SSTable count: 0
589 Space used (live): 0
590 Space used (total): 0
591 Space used by snapshots (total): 0
592 Off heap memory used (total): 0
593 SSTable Compression Ratio: -1.0
594 Number of partitions (estimate): 0
595 Memtable cell count: 0
596 Memtable data size: 0
597 Memtable off heap memory used: 0
598 Memtable switch count: 0
599 Local read count: 0
600 Local read latency: NaN ms
601 Local write count: 0
602 Local write latency: NaN ms
603 Pending flushes: 0
604 Percent repaired: 100.0
605 Bloom filter false positives: 0
606 Bloom filter false ratio: 0.00000
607 Bloom filter space used: 0
608 Bloom filter off heap memory used: 0
609 Index summary off heap memory used: 0
610 Compression metadata off heap memory used: 0
611 Compacted partition minimum bytes: 0
612 Compacted partition maximum bytes: 0
613 Compacted partition mean bytes: 0
614 Average live cells per slice (last five minutes): NaN
615 Maximum live cells per slice (last five minutes): 0
616 Average tombstones per slice (last five minutes): NaN
617 Maximum tombstones per slice (last five minutes): 0
618 Dropped Mutations: 0
619
620 Table: built_views
621 SSTable count: 2
622 Space used (live): 9932
623 Space used (total): 9932
624 Space used by snapshots (total): 0
625 Off heap memory used (total): 66
626 SSTable Compression Ratio: 1.175
627 Number of partitions (estimate): 1
628 Memtable cell count: 0
629 Memtable data size: 0
630 Memtable off heap memory used: 0
631 Memtable switch count: 2
632 Local read count: 1
633 Local read latency: NaN ms
634 Local write count: 2
635 Local write latency: NaN ms
636 Pending flushes: 0
637 Percent repaired: 0.0
638 Bloom filter false positives: 0
639 Bloom filter false ratio: 0.00000
640 Bloom filter space used: 32
641 Bloom filter off heap memory used: 16
642 Index summary off heap memory used: 34
643 Compression metadata off heap memory used: 16
644 Compacted partition minimum bytes: 36
645 Compacted partition maximum bytes: 42
646 Compacted partition mean bytes: 42
647 Average live cells per slice (last five minutes): NaN
648 Maximum live cells per slice (last five minutes): 0
649 Average tombstones per slice (last five minutes): NaN
650 Maximum tombstones per slice (last five minutes): 0
651 Dropped Mutations: 0
652
653 Table: compaction_history
654 SSTable count: 2
655 Space used (live): 12073
656 Space used (total): 12073
657 Space used by snapshots (total): 0
658 Off heap memory used (total): 112
659 SSTable Compression Ratio: 0.4639468690702087
660 Number of partitions (estimate): 28
661 Memtable cell count: 10
662 Memtable data size: 2315
663 Memtable off heap memory used: 0
664 Memtable switch count: 5
665 Local read count: 0
666 Local read latency: NaN ms
667 Local write count: 28
668 Local write latency: NaN ms
669 Pending flushes: 0
670 Percent repaired: 0.0
671 Bloom filter false positives: 0
672 Bloom filter false ratio: 0.00000
673 Bloom filter space used: 48
674 Bloom filter off heap memory used: 32
675 Index summary off heap memory used: 56
676 Compression metadata off heap memory used: 24
677 Compacted partition minimum bytes: 87
678 Compacted partition maximum bytes: 149
679 Compacted partition mean bytes: 130
680 Average live cells per slice (last five minutes): NaN
681 Maximum live cells per slice (last five minutes): 0
682 Average tombstones per slice (last five minutes): NaN
683 Maximum tombstones per slice (last five minutes): 0
684 Dropped Mutations: 0
685
686 Table: hints
687 SSTable count: 0
688 Space used (live): 0
689 Space used (total): 0
690 Space used by snapshots (total): 0
691 Off heap memory used (total): 0
692 SSTable Compression Ratio: -1.0
693 Number of partitions (estimate): 0
694 Memtable cell count: 0
695 Memtable data size: 0
696 Memtable off heap memory used: 0
697 Memtable switch count: 0
698 Local read count: 0
699 Local read latency: NaN ms
700 Local write count: 0
701 Local write latency: NaN ms
702 Pending flushes: 0
703 Percent repaired: 100.0
704 Bloom filter false positives: 0
705 Bloom filter false ratio: 0.00000
706 Bloom filter space used: 0
707 Bloom filter off heap memory used: 0
708 Index summary off heap memory used: 0
709 Compression metadata off heap memory used: 0
710 Compacted partition minimum bytes: 0
711 Compacted partition maximum bytes: 0
712 Compacted partition mean bytes: 0
713 Average live cells per slice (last five minutes): NaN
714 Maximum live cells per slice (last five minutes): 0
715 Average tombstones per slice (last five minutes): NaN
716 Maximum tombstones per slice (last five minutes): 0
717 Dropped Mutations: 0
718
719 Table: local
720 SSTable count: 3
721 Space used (live): 21007
722 Space used (total): 21007
723 Space used by snapshots (total): 0
724 Off heap memory used (total): 107
725 SSTable Compression Ratio: 0.7768860353130016
726 Number of partitions (estimate): 2
727 Memtable cell count: 11
728 Memtable data size: 61
729 Memtable off heap memory used: 0
730 Memtable switch count: 15
731 Local read count: 75
732 Local read latency: NaN ms
733 Local write count: 43
734 Local write latency: NaN ms
735 Pending flushes: 0
736 Percent repaired: 0.0
737 Bloom filter false positives: 0
738 Bloom filter false ratio: 0.00000
739 Bloom filter space used: 48
740 Bloom filter off heap memory used: 24
741 Index summary off heap memory used: 51
742 Compression metadata off heap memory used: 32
743 Compacted partition minimum bytes: 43
744 Compacted partition maximum bytes: 6866
745 Compacted partition mean bytes: 2322
746 Average live cells per slice (last five minutes): NaN
747 Maximum live cells per slice (last five minutes): 0
748 Average tombstones per slice (last five minutes): NaN
749 Maximum tombstones per slice (last five minutes): 0
750 Dropped Mutations: 0
751
752 Table: paxos
753 SSTable count: 0
754 SSTables in each level: [0, 0, 0, 0, 0, 0, 0, 0, 0]
755 Space used (live): 0
756 Space used (total): 0
757 Space used by snapshots (total): 0
758 Off heap memory used (total): 0
759 SSTable Compression Ratio: -1.0
760 Number of partitions (estimate): 0
761 Memtable cell count: 0
762 Memtable data size: 0
763 Memtable off heap memory used: 0
764 Memtable switch count: 0
765 Local read count: 0
766 Local read latency: NaN ms
767 Local write count: 0
768 Local write latency: NaN ms
769 Pending flushes: 0
770 Percent repaired: 100.0
771 Bloom filter false positives: 0
772 Bloom filter false ratio: 0.00000
773 Bloom filter space used: 0
774 Bloom filter off heap memory used: 0
775 Index summary off heap memory used: 0
776 Compression metadata off heap memory used: 0
777 Compacted partition minimum bytes: 0
778 Compacted partition maximum bytes: 0
779 Compacted partition mean bytes: 0
780 Average live cells per slice (last five minutes): NaN
781 Maximum live cells per slice (last five minutes): 0
782 Average tombstones per slice (last five minutes): NaN
783 Maximum tombstones per slice (last five minutes): 0
784 Dropped Mutations: 0
785
786 Table: peer_events
787 SSTable count: 0
788 Space used (live): 0
789 Space used (total): 0
790 Space used by snapshots (total): 0
791 Off heap memory used (total): 0
792 SSTable Compression Ratio: -1.0
793 Number of partitions (estimate): 0
794 Memtable cell count: 0
795 Memtable data size: 0
796 Memtable off heap memory used: 0
797 Memtable switch count: 0
798 Local read count: 0
799 Local read latency: NaN ms
800 Local write count: 0
801 Local write latency: NaN ms
802 Pending flushes: 0
803 Percent repaired: 100.0
804 Bloom filter false positives: 0
805 Bloom filter false ratio: 0.00000
806 Bloom filter space used: 0
807 Bloom filter off heap memory used: 0
808 Index summary off heap memory used: 0
809 Compression metadata off heap memory used: 0
810 Compacted partition minimum bytes: 0
811 Compacted partition maximum bytes: 0
812 Compacted partition mean bytes: 0
813 Average live cells per slice (last five minutes): NaN
814 Maximum live cells per slice (last five minutes): 0
815 Average tombstones per slice (last five minutes): NaN
816 Maximum tombstones per slice (last five minutes): 0
817 Dropped Mutations: 0
818
819 Table: peers
820 SSTable count: 0
821 Space used (live): 0
822 Space used (total): 0
823 Space used by snapshots (total): 0
824 Off heap memory used (total): 0
825 SSTable Compression Ratio: -1.0
826 Number of partitions (estimate): 0
827 Memtable cell count: 0
828 Memtable data size: 0
829 Memtable off heap memory used: 0
830 Memtable switch count: 0
831 Local read count: 0
832 Local read latency: NaN ms
833 Local write count: 0
834 Local write latency: NaN ms
835 Pending flushes: 0
836 Percent repaired: 100.0
837 Bloom filter false positives: 0
838 Bloom filter false ratio: 0.00000
839 Bloom filter space used: 0
840 Bloom filter off heap memory used: 0
841 Index summary off heap memory used: 0
842 Compression metadata off heap memory used: 0
843 Compacted partition minimum bytes: 0
844 Compacted partition maximum bytes: 0
845 Compacted partition mean bytes: 0
846 Average live cells per slice (last five minutes): NaN
847 Maximum live cells per slice (last five minutes): 0
848 Average tombstones per slice (last five minutes): NaN
849 Maximum tombstones per slice (last five minutes): 0
850 Dropped Mutations: 0
851
852 Table: prepared_statements
853 SSTable count: 0
854 Space used (live): 0
855 Space used (total): 0
856 Space used by snapshots (total): 0
857 Off heap memory used (total): 0
858 SSTable Compression Ratio: -1.0
859 Number of partitions (estimate): 0
860 Memtable cell count: 0
861 Memtable data size: 0
862 Memtable off heap memory used: 0
863 Memtable switch count: 0
864 Local read count: 0
865 Local read latency: NaN ms
866 Local write count: 0
867 Local write latency: NaN ms
868 Pending flushes: 0
869 Percent repaired: 100.0
870 Bloom filter false positives: 0
871 Bloom filter false ratio: 0.00000
872 Bloom filter space used: 0
873 Bloom filter off heap memory used: 0
874 Index summary off heap memory used: 0
875 Compression metadata off heap memory used: 0
876 Compacted partition minimum bytes: 0
877 Compacted partition maximum bytes: 0
878 Compacted partition mean bytes: 0
879 Average live cells per slice (last five minutes): NaN
880 Maximum live cells per slice (last five minutes): 0
881 Average tombstones per slice (last five minutes): NaN
882 Maximum tombstones per slice (last five minutes): 0
883 Dropped Mutations: 0
884
885 Table: range_xfers
886 SSTable count: 0
887 Space used (live): 0
888 Space used (total): 0
889 Space used by snapshots (total): 0
890 Off heap memory used (total): 0
891 SSTable Compression Ratio: -1.0
892 Number of partitions (estimate): 0
893 Memtable cell count: 0
894 Memtable data size: 0
895 Memtable off heap memory used: 0
896 Memtable switch count: 0
897 Local read count: 0
898 Local read latency: NaN ms
899 Local write count: 0
900 Local write latency: NaN ms
901 Pending flushes: 0
902 Percent repaired: 100.0
903 Bloom filter false positives: 0
904 Bloom filter false ratio: 0.00000
905 Bloom filter space used: 0
906 Bloom filter off heap memory used: 0
907 Index summary off heap memory used: 0
908 Compression metadata off heap memory used: 0
909 Compacted partition minimum bytes: 0
910 Compacted partition maximum bytes: 0
911 Compacted partition mean bytes: 0
912 Average live cells per slice (last five minutes): NaN
913 Maximum live cells per slice (last five minutes): 0
914 Average tombstones per slice (last five minutes): NaN
915 Maximum tombstones per slice (last five minutes): 0
916 Dropped Mutations: 0
917
918 Table: size_estimates
919 SSTable count: 2
920 Space used (live): 113704
921 Space used (total): 113704
922 Space used by snapshots (total): 0
923 Off heap memory used (total): 142
924 SSTable Compression Ratio: 0.1925282094170463
925 Number of partitions (estimate): 9
926 Memtable cell count: 38188
927 Memtable data size: 467889
928 Memtable off heap memory used: 0
929 Memtable switch count: 5
930 Local read count: 0
931 Local read latency: NaN ms
932 Local write count: 620
933 Local write latency: NaN ms
934 Pending flushes: 0
935 Percent repaired: 0.0
936 Bloom filter false positives: 0
937 Bloom filter false ratio: 0.00000
938 Bloom filter space used: 32
939 Bloom filter off heap memory used: 16
940 Index summary off heap memory used: 46
941 Compression metadata off heap memory used: 80
942 Compacted partition minimum bytes: 35426
943 Compacted partition maximum bytes: 88148
944 Compacted partition mean bytes: 71229
945 Average live cells per slice (last five minutes): NaN
946 Maximum live cells per slice (last five minutes): 0
947 Average tombstones per slice (last five minutes): NaN
948 Maximum tombstones per slice (last five minutes): 0
949 Dropped Mutations: 0
950
951 Table: sstable_activity
952 SSTable count: 2
953 Space used (live): 12432
954 Space used (total): 12432
955 Space used by snapshots (total): 0
956 Off heap memory used (total): 211
957 SSTable Compression Ratio: 0.49144254278728605
958 Number of partitions (estimate): 74
959 Memtable cell count: 121
960 Memtable data size: 1085
961 Memtable off heap memory used: 0
962 Memtable switch count: 5
963 Local read count: 10
964 Local read latency: NaN ms
965 Local write count: 311
966 Local write latency: 0.089 ms
967 Pending flushes: 0
968 Percent repaired: 0.0
969 Bloom filter false positives: 0
970 Bloom filter false ratio: 0.00000
971 Bloom filter space used: 104
972 Bloom filter off heap memory used: 88
973 Index summary off heap memory used: 99
974 Compression metadata off heap memory used: 24
975 Compacted partition minimum bytes: 43
976 Compacted partition maximum bytes: 86
977 Compacted partition mean bytes: 60
978 Average live cells per slice (last five minutes): NaN
979 Maximum live cells per slice (last five minutes): 0
980 Average tombstones per slice (last five minutes): NaN
981 Maximum tombstones per slice (last five minutes): 0
982 Dropped Mutations: 0
983
984 Table: transferred_ranges
985 SSTable count: 0
986 Space used (live): 0
987 Space used (total): 0
988 Space used by snapshots (total): 0
989 Off heap memory used (total): 0
990 SSTable Compression Ratio: -1.0
991 Number of partitions (estimate): 0
992 Memtable cell count: 0
993 Memtable data size: 0
994 Memtable off heap memory used: 0
995 Memtable switch count: 0
996 Local read count: 0
997 Local read latency: NaN ms
998 Local write count: 0
999 Local write latency: NaN ms
1000 Pending flushes: 0
1001 Percent repaired: 100.0
1002 Bloom filter false positives: 0
1003 Bloom filter false ratio: 0.00000
1004 Bloom filter space used: 0
1005 Bloom filter off heap memory used: 0
1006 Index summary off heap memory used: 0
1007 Compression metadata off heap memory used: 0
1008 Compacted partition minimum bytes: 0
1009 Compacted partition maximum bytes: 0
1010 Compacted partition mean bytes: 0
1011 Average live cells per slice (last five minutes): NaN
1012 Maximum live cells per slice (last five minutes): 0
1013 Average tombstones per slice (last five minutes): NaN
1014 Maximum tombstones per slice (last five minutes): 0
1015 Dropped Mutations: 0
1016
1017 Table: views_builds_in_progress
1018 SSTable count: 1
1019 Space used (live): 5037
1020 Space used (total): 5037
1021 Space used by snapshots (total): 0
1022 Off heap memory used (total): 33
1023 SSTable Compression Ratio: 1.1666666666666667
1024 Number of partitions (estimate): 1
1025 Memtable cell count: 0
1026 Memtable data size: 0
1027 Memtable off heap memory used: 0
1028 Memtable switch count: 1
1029 Local read count: 1
1030 Local read latency: NaN ms
1031 Local write count: 9
1032 Local write latency: NaN ms
1033 Pending flushes: 0
1034 Percent repaired: 0.0
1035 Bloom filter false positives: 0
1036 Bloom filter false ratio: 0.00000
1037 Bloom filter space used: 16
1038 Bloom filter off heap memory used: 8
1039 Index summary off heap memory used: 17
1040 Compression metadata off heap memory used: 8
1041 Compacted partition minimum bytes: 36
1042 Compacted partition maximum bytes: 42
1043 Compacted partition mean bytes: 42
1044 Average live cells per slice (last five minutes): NaN
1045 Maximum live cells per slice (last five minutes): 0
1046 Average tombstones per slice (last five minutes): NaN
1047 Maximum tombstones per slice (last five minutes): 0
1048 Dropped Mutations: 0
1049
1050----------------
1051Keyspace : system_distributed
1052 Read Count: 0
1053 Read Latency: NaN ms
1054 Write Count: 2
1055 Write Latency: 0.1505 ms
1056 Pending Flushes: 0
1057 Table: parent_repair_history
1058 SSTable count: 0
1059 Space used (live): 0
1060 Space used (total): 0
1061 Space used by snapshots (total): 0
1062 Off heap memory used (total): 0
1063 SSTable Compression Ratio: -1.0
1064 Number of partitions (estimate): 0
1065 Memtable cell count: 0
1066 Memtable data size: 0
1067 Memtable off heap memory used: 0
1068 Memtable switch count: 0
1069 Local read count: 0
1070 Local read latency: NaN ms
1071 Local write count: 0
1072 Local write latency: NaN ms
1073 Pending flushes: 0
1074 Percent repaired: 100.0
1075 Bloom filter false positives: 0
1076 Bloom filter false ratio: 0.00000
1077 Bloom filter space used: 0
1078 Bloom filter off heap memory used: 0
1079 Index summary off heap memory used: 0
1080 Compression metadata off heap memory used: 0
1081 Compacted partition minimum bytes: 0
1082 Compacted partition maximum bytes: 0
1083 Compacted partition mean bytes: 0
1084 Average live cells per slice (last five minutes): NaN
1085 Maximum live cells per slice (last five minutes): 0
1086 Average tombstones per slice (last five minutes): NaN
1087 Maximum tombstones per slice (last five minutes): 0
1088 Dropped Mutations: 0
1089
1090 Table: repair_history
1091 SSTable count: 0
1092 Space used (live): 0
1093 Space used (total): 0
1094 Space used by snapshots (total): 0
1095 Off heap memory used (total): 0
1096 SSTable Compression Ratio: -1.0
1097 Number of partitions (estimate): 0
1098 Memtable cell count: 0
1099 Memtable data size: 0
1100 Memtable off heap memory used: 0
1101 Memtable switch count: 0
1102 Local read count: 0
1103 Local read latency: NaN ms
1104 Local write count: 0
1105 Local write latency: NaN ms
1106 Pending flushes: 0
1107 Percent repaired: 100.0
1108 Bloom filter false positives: 0
1109 Bloom filter false ratio: 0.00000
1110 Bloom filter space used: 0
1111 Bloom filter off heap memory used: 0
1112 Index summary off heap memory used: 0
1113 Compression metadata off heap memory used: 0
1114 Compacted partition minimum bytes: 0
1115 Compacted partition maximum bytes: 0
1116 Compacted partition mean bytes: 0
1117 Average live cells per slice (last five minutes): NaN
1118 Maximum live cells per slice (last five minutes): 0
1119 Average tombstones per slice (last five minutes): NaN
1120 Maximum tombstones per slice (last five minutes): 0
1121 Dropped Mutations: 0
1122
1123 Table: view_build_status
1124 SSTable count: 0
1125 Space used (live): 0
1126 Space used (total): 0
1127 Space used by snapshots (total): 0
1128 Off heap memory used (total): 0
1129 SSTable Compression Ratio: -1.0
1130 Number of partitions (estimate): 0
1131 Memtable cell count: 2
1132 Memtable data size: 68
1133 Memtable off heap memory used: 0
1134 Memtable switch count: 0
1135 Local read count: 0
1136 Local read latency: NaN ms
1137 Local write count: 2
1138 Local write latency: NaN ms
1139 Pending flushes: 0
1140 Percent repaired: 100.0
1141 Bloom filter false positives: 0
1142 Bloom filter false ratio: 0.00000
1143 Bloom filter space used: 0
1144 Bloom filter off heap memory used: 0
1145 Index summary off heap memory used: 0
1146 Compression metadata off heap memory used: 0
1147 Compacted partition minimum bytes: 0
1148 Compacted partition maximum bytes: 0
1149 Compacted partition mean bytes: 0
1150 Average live cells per slice (last five minutes): NaN
1151 Maximum live cells per slice (last five minutes): 0
1152 Average tombstones per slice (last five minutes): NaN
1153 Maximum tombstones per slice (last five minutes): 0
1154 Dropped Mutations: 0
1155
1156----------------
1157Keyspace : system_schema
1158 Read Count: 738
1159 Read Latency: 0.2935907859078591 ms
1160 Write Count: 97
1161 Write Latency: 0.3326288659793814 ms
1162 Pending Flushes: 0
1163 Table: aggregates
1164 SSTable count: 1
1165 Space used (live): 5065
1166 Space used (total): 5065
1167 Space used by snapshots (total): 0
1168 Off heap memory used (total): 41
1169 SSTable Compression Ratio: 1.0408163265306123
1170 Number of partitions (estimate): 2
1171 Memtable cell count: 0
1172 Memtable data size: 0
1173 Memtable off heap memory used: 0
1174 Memtable switch count: 1
1175 Local read count: 26
1176 Local read latency: NaN ms
1177 Local write count: 2
1178 Local write latency: NaN ms
1179 Pending flushes: 0
1180 Percent repaired: 0.0
1181 Bloom filter false positives: 0
1182 Bloom filter false ratio: 0.00000
1183 Bloom filter space used: 16
1184 Bloom filter off heap memory used: 8
1185 Index summary off heap memory used: 25
1186 Compression metadata off heap memory used: 8
1187 Compacted partition minimum bytes: 21
1188 Compacted partition maximum bytes: 29
1189 Compacted partition mean bytes: 27
1190 Average live cells per slice (last five minutes): NaN
1191 Maximum live cells per slice (last five minutes): 0
1192 Average tombstones per slice (last five minutes): NaN
1193 Maximum tombstones per slice (last five minutes): 0
1194 Dropped Mutations: 0
1195
1196 Table: columns
1197 SSTable count: 2
1198 Space used (live): 17485
1199 Space used (total): 17485
1200 Space used by snapshots (total): 0
1201 Off heap memory used (total): 88
1202 SSTable Compression Ratio: 0.32966085456984096
1203 Number of partitions (estimate): 7
1204 Memtable cell count: 0
1205 Memtable data size: 0
1206 Memtable off heap memory used: 0
1207 Memtable switch count: 17
1208 Local read count: 109
1209 Local read latency: NaN ms
1210 Local write count: 21
1211 Local write latency: NaN ms
1212 Pending flushes: 0
1213 Percent repaired: 0.0
1214 Bloom filter false positives: 0
1215 Bloom filter false ratio: 0.00000
1216 Bloom filter space used: 40
1217 Bloom filter off heap memory used: 24
1218 Index summary off heap memory used: 40
1219 Compression metadata off heap memory used: 24
1220 Compacted partition minimum bytes: 373
1221 Compacted partition maximum bytes: 8239
1222 Compacted partition mean bytes: 2865
1223 Average live cells per slice (last five minutes): NaN
1224 Maximum live cells per slice (last five minutes): 0
1225 Average tombstones per slice (last five minutes): 1.0
1226 Maximum tombstones per slice (last five minutes): 1
1227 Dropped Mutations: 0
1228
1229 Table: dropped_columns
1230 SSTable count: 1
1231 Space used (live): 4979
1232 Space used (total): 4979
1233 Space used by snapshots (total): 0
1234 Off heap memory used (total): 41
1235 SSTable Compression Ratio: 1.0408163265306123
1236 Number of partitions (estimate): 2
1237 Memtable cell count: 0
1238 Memtable data size: 0
1239 Memtable off heap memory used: 0
1240 Memtable switch count: 1
1241 Local read count: 73
1242 Local read latency: NaN ms
1243 Local write count: 2
1244 Local write latency: NaN ms
1245 Pending flushes: 0
1246 Percent repaired: 0.0
1247 Bloom filter false positives: 0
1248 Bloom filter false ratio: 0.00000
1249 Bloom filter space used: 16
1250 Bloom filter off heap memory used: 8
1251 Index summary off heap memory used: 25
1252 Compression metadata off heap memory used: 8
1253 Compacted partition minimum bytes: 21
1254 Compacted partition maximum bytes: 29
1255 Compacted partition mean bytes: 27
1256 Average live cells per slice (last five minutes): 1.0
1257 Maximum live cells per slice (last five minutes): 1
1258 Average tombstones per slice (last five minutes): 1.0
1259 Maximum tombstones per slice (last five minutes): 1
1260 Dropped Mutations: 0
1261
1262 Table: functions
1263 SSTable count: 1
1264 Space used (live): 5065
1265 Space used (total): 5065
1266 Space used by snapshots (total): 0
1267 Off heap memory used (total): 41
1268 SSTable Compression Ratio: 1.0408163265306123
1269 Number of partitions (estimate): 2
1270 Memtable cell count: 0
1271 Memtable data size: 0
1272 Memtable off heap memory used: 0
1273 Memtable switch count: 1
1274 Local read count: 26
1275 Local read latency: NaN ms
1276 Local write count: 2
1277 Local write latency: NaN ms
1278 Pending flushes: 0
1279 Percent repaired: 0.0
1280 Bloom filter false positives: 0
1281 Bloom filter false ratio: 0.00000
1282 Bloom filter space used: 16
1283 Bloom filter off heap memory used: 8
1284 Index summary off heap memory used: 25
1285 Compression metadata off heap memory used: 8
1286 Compacted partition minimum bytes: 21
1287 Compacted partition maximum bytes: 29
1288 Compacted partition mean bytes: 27
1289 Average live cells per slice (last five minutes): NaN
1290 Maximum live cells per slice (last five minutes): 0
1291 Average tombstones per slice (last five minutes): NaN
1292 Maximum tombstones per slice (last five minutes): 0
1293 Dropped Mutations: 0
1294
1295 Table: indexes
1296 SSTable count: 2
1297 Space used (live): 10696
1298 Space used (total): 10696
1299 Space used by snapshots (total): 0
1300 Off heap memory used (total): 82
1301 SSTable Compression Ratio: 0.7963917525773195
1302 Number of partitions (estimate): 3
1303 Memtable cell count: 0
1304 Memtable data size: 0
1305 Memtable off heap memory used: 0
1306 Memtable switch count: 5
1307 Local read count: 108
1308 Local read latency: NaN ms
1309 Local write count: 6
1310 Local write latency: NaN ms
1311 Pending flushes: 0
1312 Percent repaired: 0.0
1313 Bloom filter false positives: 0
1314 Bloom filter false ratio: 0.00000
1315 Bloom filter space used: 32
1316 Bloom filter off heap memory used: 16
1317 Index summary off heap memory used: 42
1318 Compression metadata off heap memory used: 24
1319 Compacted partition minimum bytes: 21
1320 Compacted partition maximum bytes: 258
1321 Compacted partition mean bytes: 103
1322 Average live cells per slice (last five minutes): 1.0
1323 Maximum live cells per slice (last five minutes): 1
1324 Average tombstones per slice (last five minutes): 1.0
1325 Maximum tombstones per slice (last five minutes): 1
1326 Dropped Mutations: 0
1327
1328 Table: keyspaces
1329 SSTable count: 2
1330 Space used (live): 10702
1331 Space used (total): 10702
1332 Space used by snapshots (total): 0
1333 Off heap memory used (total): 88
1334 SSTable Compression Ratio: 0.5
1335 Number of partitions (estimate): 7
1336 Memtable cell count: 0
1337 Memtable data size: 0
1338 Memtable off heap memory used: 0
1339 Memtable switch count: 26
1340 Local read count: 56
1341 Local read latency: NaN ms
1342 Local write count: 30
1343 Local write latency: NaN ms
1344 Pending flushes: 0
1345 Percent repaired: 0.0
1346 Bloom filter false positives: 0
1347 Bloom filter false ratio: 0.00000
1348 Bloom filter space used: 40
1349 Bloom filter off heap memory used: 24
1350 Index summary off heap memory used: 40
1351 Compression metadata off heap memory used: 24
1352 Compacted partition minimum bytes: 87
1353 Compacted partition maximum bytes: 149
1354 Compacted partition mean bytes: 125
1355 Average live cells per slice (last five minutes): NaN
1356 Maximum live cells per slice (last five minutes): 0
1357 Average tombstones per slice (last five minutes): NaN
1358 Maximum tombstones per slice (last five minutes): 0
1359 Dropped Mutations: 0
1360
1361 Table: tables
1362 SSTable count: 2
1363 Space used (live): 16476
1364 Space used (total): 16476
1365 Space used by snapshots (total): 0
1366 Off heap memory used (total): 88
1367 SSTable Compression Ratio: 0.17461217337525126
1368 Number of partitions (estimate): 7
1369 Memtable cell count: 0
1370 Memtable data size: 0
1371 Memtable off heap memory used: 0
1372 Memtable switch count: 20
1373 Local read count: 137
1374 Local read latency: NaN ms
1375 Local write count: 24
1376 Local write latency: NaN ms
1377 Pending flushes: 0
1378 Percent repaired: 0.0
1379 Bloom filter false positives: 0
1380 Bloom filter false ratio: 0.00000
1381 Bloom filter space used: 40
1382 Bloom filter off heap memory used: 24
1383 Index summary off heap memory used: 40
1384 Compression metadata off heap memory used: 24
1385 Compacted partition minimum bytes: 373
1386 Compacted partition maximum bytes: 8239
1387 Compacted partition mean bytes: 2639
1388 Average live cells per slice (last five minutes): 1.0
1389 Maximum live cells per slice (last five minutes): 1
1390 Average tombstones per slice (last five minutes): 1.0
1391 Maximum tombstones per slice (last five minutes): 1
1392 Dropped Mutations: 0
1393
1394 Table: triggers
1395 SSTable count: 1
1396 Space used (live): 4979
1397 Space used (total): 4979
1398 Space used by snapshots (total): 0
1399 Off heap memory used (total): 41
1400 SSTable Compression Ratio: 1.0408163265306123
1401 Number of partitions (estimate): 2
1402 Memtable cell count: 0
1403 Memtable data size: 0
1404 Memtable off heap memory used: 0
1405 Memtable switch count: 1
1406 Local read count: 108
1407 Local read latency: NaN ms
1408 Local write count: 2
1409 Local write latency: NaN ms
1410 Pending flushes: 0
1411 Percent repaired: 0.0
1412 Bloom filter false positives: 0
1413 Bloom filter false ratio: 0.00000
1414 Bloom filter space used: 16
1415 Bloom filter off heap memory used: 8
1416 Index summary off heap memory used: 25
1417 Compression metadata off heap memory used: 8
1418 Compacted partition minimum bytes: 21
1419 Compacted partition maximum bytes: 29
1420 Compacted partition mean bytes: 27
1421 Average live cells per slice (last five minutes): 1.0
1422 Maximum live cells per slice (last five minutes): 1
1423 Average tombstones per slice (last five minutes): 1.0
1424 Maximum tombstones per slice (last five minutes): 1
1425 Dropped Mutations: 0
1426
1427 Table: types
1428 SSTable count: 1
1429 Space used (live): 5485
1430 Space used (total): 5485
1431 Space used by snapshots (total): 0
1432 Off heap memory used (total): 49
1433 SSTable Compression Ratio: 0.6181384248210023
1434 Number of partitions (estimate): 4
1435 Memtable cell count: 0
1436 Memtable data size: 0
1437 Memtable off heap memory used: 0
1438 Memtable switch count: 4
1439 Local read count: 32
1440 Local read latency: NaN ms
1441 Local write count: 5
1442 Local write latency: NaN ms
1443 Pending flushes: 0
1444 Percent repaired: 0.0
1445 Bloom filter false positives: 0
1446 Bloom filter false ratio: 0.00000
1447 Bloom filter space used: 16
1448 Bloom filter off heap memory used: 8
1449 Index summary off heap memory used: 25
1450 Compression metadata off heap memory used: 16
1451 Compacted partition minimum bytes: 21
1452 Compacted partition maximum bytes: 258
1453 Compacted partition mean bytes: 109
1454 Average live cells per slice (last five minutes): NaN
1455 Maximum live cells per slice (last five minutes): 0
1456 Average tombstones per slice (last five minutes): NaN
1457 Maximum tombstones per slice (last five minutes): 0
1458 Dropped Mutations: 0
1459
1460 Table: views
1461 SSTable count: 2
1462 Space used (live): 11867
1463 Space used (total): 11867
1464 Space used by snapshots (total): 0
1465 Off heap memory used (total): 74
1466 SSTable Compression Ratio: 0.8598484848484849
1467 Number of partitions (estimate): 3
1468 Memtable cell count: 0
1469 Memtable data size: 0
1470 Memtable off heap memory used: 0
1471 Memtable switch count: 2
1472 Local read count: 63
1473 Local read latency: NaN ms
1474 Local write count: 3
1475 Local write latency: NaN ms
1476 Pending flushes: 0
1477 Percent repaired: 0.0
1478 Bloom filter false positives: 0
1479 Bloom filter false ratio: 0.00000
1480 Bloom filter space used: 32
1481 Bloom filter off heap memory used: 16
1482 Index summary off heap memory used: 42
1483 Compression metadata off heap memory used: 16
1484 Compacted partition minimum bytes: 21
1485 Compacted partition maximum bytes: 535
1486 Compacted partition mean bytes: 196
1487 Average live cells per slice (last five minutes): NaN
1488 Maximum live cells per slice (last five minutes): 0
1489 Average tombstones per slice (last five minutes): NaN
1490 Maximum tombstones per slice (last five minutes): 0
1491 Dropped Mutations: 0
1492
1493----------------
1494Keyspace : ecole
1495 Read Count: 38
1496 Read Latency: 1.1028684210526316 ms
1497 Write Count: 69
1498 Write Latency: 0.7872898550724637 ms
1499 Pending Flushes: 0
1500 Table (index): cours.enseignement_idx
1501 SSTable count: 1
1502 Space used (live): 5087
1503 Space used (total): 5087
1504 Space used by snapshots (total): 0
1505 Off heap memory used (total): 40
1506 SSTable Compression Ratio: 0.5663716814159292
1507 Number of partitions (estimate): 6
1508 Memtable cell count: 0
1509 Memtable data size: 0
1510 Memtable off heap memory used: 0
1511 Memtable switch count: 1
1512 Local read count: 0
1513 Local read latency: NaN ms
1514 Local write count: 7
1515 Local write latency: NaN ms
1516 Pending flushes: 0
1517 Percent repaired: 0.0
1518 Bloom filter false positives: 0
1519 Bloom filter false ratio: 0.00000
1520 Bloom filter space used: 24
1521 Bloom filter off heap memory used: 16
1522 Index summary off heap memory used: 16
1523 Compression metadata off heap memory used: 8
1524 Compacted partition minimum bytes: 30
1525 Compacted partition maximum bytes: 60
1526 Compacted partition mean bytes: 40
1527 Average live cells per slice (last five minutes): NaN
1528 Maximum live cells per slice (last five minutes): 0
1529 Average tombstones per slice (last five minutes): NaN
1530 Maximum tombstones per slice (last five minutes): 0
1531 Dropped Mutations: 0
1532
1533 Table: cours
1534 SSTable count: 1
1535 Space used (live): 5520
1536 Space used (total): 5520
1537 Space used by snapshots (total): 0
1538 Off heap memory used (total): 40
1539 SSTable Compression Ratio: 0.7135135135135136
1540 Number of partitions (estimate): 7
1541 Memtable cell count: 0
1542 Memtable data size: 0
1543 Memtable off heap memory used: 0
1544 Memtable switch count: 1
1545 Local read count: 14
1546 Local read latency: NaN ms
1547 Local write count: 7
1548 Local write latency: NaN ms
1549 Pending flushes: 0
1550 Percent repaired: 0.0
1551 Bloom filter false positives: 0
1552 Bloom filter false ratio: 0.00000
1553 Bloom filter space used: 24
1554 Bloom filter off heap memory used: 16
1555 Index summary off heap memory used: 16
1556 Compression metadata off heap memory used: 8
1557 Compacted partition minimum bytes: 61
1558 Compacted partition maximum bytes: 103
1559 Compacted partition mean bytes: 87
1560 Average live cells per slice (last five minutes): 1.0
1561 Maximum live cells per slice (last five minutes): 1
1562 Average tombstones per slice (last five minutes): 1.0
1563 Maximum tombstones per slice (last five minutes): 1
1564 Dropped Mutations: 0
1565
1566 Table: cours_niveau
1567 SSTable count: 0
1568 Space used (live): 0
1569 Space used (total): 0
1570 Space used by snapshots (total): 0
1571 Off heap memory used (total): 0
1572 SSTable Compression Ratio: -1.0
1573 Number of partitions (estimate): 6
1574 Memtable cell count: 7
1575 Memtable data size: 978
1576 Memtable off heap memory used: 0
1577 Memtable switch count: 0
1578 Local read count: 0
1579 Local read latency: NaN ms
1580 Local write count: 7
1581 Local write latency: NaN ms
1582 Pending flushes: 0
1583 Percent repaired: 100.0
1584 Bloom filter false positives: 0
1585 Bloom filter false ratio: 0.00000
1586 Bloom filter space used: 0
1587 Bloom filter off heap memory used: 0
1588 Index summary off heap memory used: 0
1589 Compression metadata off heap memory used: 0
1590 Compacted partition minimum bytes: 0
1591 Compacted partition maximum bytes: 0
1592 Compacted partition mean bytes: 0
1593 Average live cells per slice (last five minutes): NaN
1594 Maximum live cells per slice (last five minutes): 0
1595 Average tombstones per slice (last five minutes): NaN
1596 Maximum tombstones per slice (last five minutes): 0
1597 Dropped Mutations: 0
1598
1599 Table (index): coursenseignant.niveau_idx
1600 SSTable count: 1
1601 Space used (live): 4996
1602 Space used (total): 4996
1603 Space used by snapshots (total): 0
1604 Off heap memory used (total): 30
1605 SSTable Compression Ratio: 0.7191780821917808
1606 Number of partitions (estimate): 2
1607 Memtable cell count: 0
1608 Memtable data size: 0
1609 Memtable off heap memory used: 0
1610 Memtable switch count: 1
1611 Local read count: 0
1612 Local read latency: NaN ms
1613 Local write count: 7
1614 Local write latency: NaN ms
1615 Pending flushes: 0
1616 Percent repaired: 0.0
1617 Bloom filter false positives: 0
1618 Bloom filter false ratio: 0.00000
1619 Bloom filter space used: 16
1620 Bloom filter off heap memory used: 8
1621 Index summary off heap memory used: 14
1622 Compression metadata off heap memory used: 8
1623 Compacted partition minimum bytes: 61
1624 Compacted partition maximum bytes: 86
1625 Compacted partition mean bytes: 79
1626 Average live cells per slice (last five minutes): NaN
1627 Maximum live cells per slice (last five minutes): 0
1628 Average tombstones per slice (last five minutes): NaN
1629 Maximum tombstones per slice (last five minutes): 0
1630 Dropped Mutations: 0
1631
1632 Table (index): coursenseignant.status_idx
1633 SSTable count: 1
1634 Space used (live): 5876
1635 Space used (total): 5876
1636 Space used by snapshots (total): 0
1637 Off heap memory used (total): 79
1638 SSTable Compression Ratio: 0.6347438752783965
1639 Number of partitions (estimate): 6
1640 Memtable cell count: 0
1641 Memtable data size: 0
1642 Memtable off heap memory used: 0
1643 Memtable switch count: 1
1644 Local read count: 0
1645 Local read latency: NaN ms
1646 Local write count: 7
1647 Local write latency: NaN ms
1648 Pending flushes: 0
1649 Percent repaired: 0.0
1650 Bloom filter false positives: 0
1651 Bloom filter false ratio: 0.00000
1652 Bloom filter space used: 24
1653 Bloom filter off heap memory used: 16
1654 Index summary off heap memory used: 55
1655 Compression metadata off heap memory used: 8
1656 Compacted partition minimum bytes: 61
1657 Compacted partition maximum bytes: 103
1658 Compacted partition mean bytes: 82
1659 Average live cells per slice (last five minutes): NaN
1660 Maximum live cells per slice (last five minutes): 0
1661 Average tombstones per slice (last five minutes): NaN
1662 Maximum tombstones per slice (last five minutes): 0
1663 Dropped Mutations: 0
1664
1665 Table: coursenseignant
1666 SSTable count: 1
1667 Space used (live): 5988
1668 Space used (total): 5988
1669 Space used by snapshots (total): 0
1670 Off heap memory used (total): 40
1671 SSTable Compression Ratio: 0.6717827626918536
1672 Number of partitions (estimate): 7
1673 Memtable cell count: 0
1674 Memtable data size: 0
1675 Memtable off heap memory used: 0
1676 Memtable switch count: 2
1677 Local read count: 14
1678 Local read latency: NaN ms
1679 Local write count: 7
1680 Local write latency: NaN ms
1681 Pending flushes: 0
1682 Percent repaired: 0.0
1683 Bloom filter false positives: 0
1684 Bloom filter false ratio: 0.00000
1685 Bloom filter space used: 24
1686 Bloom filter off heap memory used: 16
1687 Index summary off heap memory used: 16
1688 Compression metadata off heap memory used: 8
1689 Compacted partition minimum bytes: 104
1690 Compacted partition maximum bytes: 149
1691 Compacted partition mean bytes: 132
1692 Average live cells per slice (last five minutes): NaN
1693 Maximum live cells per slice (last five minutes): 0
1694 Average tombstones per slice (last five minutes): NaN
1695 Maximum tombstones per slice (last five minutes): 0
1696 Dropped Mutations: 0
1697
1698 Table: enseignant
1699 SSTable count: 1
1700 Space used (live): 5358
1701 Space used (total): 5358
1702 Space used by snapshots (total): 0
1703 Off heap memory used (total): 40
1704 SSTable Compression Ratio: 0.6565040650406504
1705 Number of partitions (estimate): 9
1706 Memtable cell count: 0
1707 Memtable data size: 0
1708 Memtable off heap memory used: 0
1709 Memtable switch count: 1
1710 Local read count: 1
1711 Local read latency: NaN ms
1712 Local write count: 9
1713 Local write latency: NaN ms
1714 Pending flushes: 0
1715 Percent repaired: 0.0
1716 Bloom filter false positives: 0
1717 Bloom filter false ratio: 0.00000
1718 Bloom filter space used: 24
1719 Bloom filter off heap memory used: 16
1720 Index summary off heap memory used: 16
1721 Compression metadata off heap memory used: 8
1722 Compacted partition minimum bytes: 51
1723 Compacted partition maximum bytes: 72
1724 Compacted partition mean bytes: 62
1725 Average live cells per slice (last five minutes): NaN
1726 Maximum live cells per slice (last five minutes): 0
1727 Average tombstones per slice (last five minutes): NaN
1728 Maximum tombstones per slice (last five minutes): 0
1729 Dropped Mutations: 0
1730
1731 Table (index): enseignantcours.statuts_idx
1732 SSTable count: 1
1733 Space used (live): 5125
1734 Space used (total): 5125
1735 Space used by snapshots (total): 0
1736 Off heap memory used (total): 39
1737 SSTable Compression Ratio: 0.6475409836065574
1738 Number of partitions (estimate): 4
1739 Memtable cell count: 0
1740 Memtable data size: 0
1741 Memtable off heap memory used: 0
1742 Memtable switch count: 1
1743 Local read count: 0
1744 Local read latency: NaN ms
1745 Local write count: 9
1746 Local write latency: NaN ms
1747 Pending flushes: 0
1748 Percent repaired: 0.0
1749 Bloom filter false positives: 0
1750 Bloom filter false ratio: 0.00000
1751 Bloom filter space used: 16
1752 Bloom filter off heap memory used: 8
1753 Index summary off heap memory used: 23
1754 Compression metadata off heap memory used: 8
1755 Compacted partition minimum bytes: 36
1756 Compacted partition maximum bytes: 103
1757 Compacted partition mean bytes: 65
1758 Average live cells per slice (last five minutes): NaN
1759 Maximum live cells per slice (last five minutes): 0
1760 Average tombstones per slice (last five minutes): NaN
1761 Maximum tombstones per slice (last five minutes): 0
1762 Dropped Mutations: 0
1763
1764 Table: enseignantcours
1765 SSTable count: 1
1766 Space used (live): 6264
1767 Space used (total): 6264
1768 Space used by snapshots (total): 0
1769 Off heap memory used (total): 40
1770 SSTable Compression Ratio: 0.680648236415634
1771 Number of partitions (estimate): 9
1772 Memtable cell count: 0
1773 Memtable data size: 0
1774 Memtable off heap memory used: 0
1775 Memtable switch count: 1
1776 Local read count: 9
1777 Local read latency: NaN ms
1778 Local write count: 9
1779 Local write latency: NaN ms
1780 Pending flushes: 0
1781 Percent repaired: 0.0
1782 Bloom filter false positives: 0
1783 Bloom filter false ratio: 0.00000
1784 Bloom filter space used: 24
1785 Bloom filter off heap memory used: 16
1786 Index summary off heap memory used: 16
1787 Compression metadata off heap memory used: 8
1788 Compacted partition minimum bytes: 61
1789 Compacted partition maximum bytes: 258
1790 Compacted partition mean bytes: 129
1791 Average live cells per slice (last five minutes): NaN
1792 Maximum live cells per slice (last five minutes): 0
1793 Average tombstones per slice (last five minutes): NaN
1794 Maximum tombstones per slice (last five minutes): 0
1795 Dropped Mutations: 0
1796
1797 Table: ftfra_parameters
1798 SSTable count: 0
1799 Space used (live): 0
1800 Space used (total): 0
1801 Space used by snapshots (total): 0
1802 Off heap memory used (total): 0
1803 SSTable Compression Ratio: -1.0
1804 Number of partitions (estimate): 0
1805 Memtable cell count: 0
1806 Memtable data size: 0
1807 Memtable off heap memory used: 0
1808 Memtable switch count: 0
1809 Local read count: 0
1810 Local read latency: NaN ms
1811 Local write count: 0
1812 Local write latency: NaN ms
1813 Pending flushes: 0
1814 Percent repaired: 100.0
1815 Bloom filter false positives: 0
1816 Bloom filter false ratio: 0.00000
1817 Bloom filter space used: 0
1818 Bloom filter off heap memory used: 0
1819 Index summary off heap memory used: 0
1820 Compression metadata off heap memory used: 0
1821 Compacted partition minimum bytes: 0
1822 Compacted partition maximum bytes: 0
1823 Compacted partition mean bytes: 0
1824 Average live cells per slice (last five minutes): NaN
1825 Maximum live cells per slice (last five minutes): 0
1826 Average tombstones per slice (last five minutes): NaN
1827 Maximum tombstones per slice (last five minutes): 0
1828 Dropped Mutations: 0
1829
1830----------------
1831Keyspace : system_auth
1832 Read Count: 2
1833 Read Latency: 0.752 ms
1834 Write Count: 1
1835 Write Latency: 0.17 ms
1836 Pending Flushes: 0
1837 Table: resource_role_permissons_index
1838 SSTable count: 0
1839 Space used (live): 0
1840 Space used (total): 0
1841 Space used by snapshots (total): 0
1842 Off heap memory used (total): 0
1843 SSTable Compression Ratio: -1.0
1844 Number of partitions (estimate): 0
1845 Memtable cell count: 0
1846 Memtable data size: 0
1847 Memtable off heap memory used: 0
1848 Memtable switch count: 0
1849 Local read count: 0
1850 Local read latency: NaN ms
1851 Local write count: 0
1852 Local write latency: NaN ms
1853 Pending flushes: 0
1854 Percent repaired: 100.0
1855 Bloom filter false positives: 0
1856 Bloom filter false ratio: 0.00000
1857 Bloom filter space used: 0
1858 Bloom filter off heap memory used: 0
1859 Index summary off heap memory used: 0
1860 Compression metadata off heap memory used: 0
1861 Compacted partition minimum bytes: 0
1862 Compacted partition maximum bytes: 0
1863 Compacted partition mean bytes: 0
1864 Average live cells per slice (last five minutes): NaN
1865 Maximum live cells per slice (last five minutes): 0
1866 Average tombstones per slice (last five minutes): NaN
1867 Maximum tombstones per slice (last five minutes): 0
1868 Dropped Mutations: 0
1869
1870 Table: role_members
1871 SSTable count: 0
1872 Space used (live): 0
1873 Space used (total): 0
1874 Space used by snapshots (total): 0
1875 Off heap memory used (total): 0
1876 SSTable Compression Ratio: -1.0
1877 Number of partitions (estimate): 0
1878 Memtable cell count: 0
1879 Memtable data size: 0
1880 Memtable off heap memory used: 0
1881 Memtable switch count: 0
1882 Local read count: 0
1883 Local read latency: NaN ms
1884 Local write count: 0
1885 Local write latency: NaN ms
1886 Pending flushes: 0
1887 Percent repaired: 100.0
1888 Bloom filter false positives: 0
1889 Bloom filter false ratio: 0.00000
1890 Bloom filter space used: 0
1891 Bloom filter off heap memory used: 0
1892 Index summary off heap memory used: 0
1893 Compression metadata off heap memory used: 0
1894 Compacted partition minimum bytes: 0
1895 Compacted partition maximum bytes: 0
1896 Compacted partition mean bytes: 0
1897 Average live cells per slice (last five minutes): NaN
1898 Maximum live cells per slice (last five minutes): 0
1899 Average tombstones per slice (last five minutes): NaN
1900 Maximum tombstones per slice (last five minutes): 0
1901 Dropped Mutations: 0
1902
1903 Table: role_permissions
1904 SSTable count: 0
1905 Space used (live): 0
1906 Space used (total): 0
1907 Space used by snapshots (total): 0
1908 Off heap memory used (total): 0
1909 SSTable Compression Ratio: -1.0
1910 Number of partitions (estimate): 0
1911 Memtable cell count: 0
1912 Memtable data size: 0
1913 Memtable off heap memory used: 0
1914 Memtable switch count: 0
1915 Local read count: 0
1916 Local read latency: NaN ms
1917 Local write count: 0
1918 Local write latency: NaN ms
1919 Pending flushes: 0
1920 Percent repaired: 100.0
1921 Bloom filter false positives: 0
1922 Bloom filter false ratio: 0.00000
1923 Bloom filter space used: 0
1924 Bloom filter off heap memory used: 0
1925 Index summary off heap memory used: 0
1926 Compression metadata off heap memory used: 0
1927 Compacted partition minimum bytes: 0
1928 Compacted partition maximum bytes: 0
1929 Compacted partition mean bytes: 0
1930 Average live cells per slice (last five minutes): NaN
1931 Maximum live cells per slice (last five minutes): 0
1932 Average tombstones per slice (last five minutes): NaN
1933 Maximum tombstones per slice (last five minutes): 0
1934 Dropped Mutations: 0
1935
1936 Table: roles
1937 SSTable count: 1
1938 Space used (live): 5070
1939 Space used (total): 5070
1940 Space used by snapshots (total): 0
1941 Off heap memory used (total): 37
1942 SSTable Compression Ratio: 1.0851063829787233
1943 Number of partitions (estimate): 1
1944 Memtable cell count: 0
1945 Memtable data size: 0
1946 Memtable off heap memory used: 0
1947 Memtable switch count: 1
1948 Local read count: 2
1949 Local read latency: NaN ms
1950 Local write count: 1
1951 Local write latency: NaN ms
1952 Pending flushes: 0
1953 Percent repaired: 0.0
1954 Bloom filter false positives: 0
1955 Bloom filter false ratio: 0.00000
1956 Bloom filter space used: 16
1957 Bloom filter off heap memory used: 8
1958 Index summary off heap memory used: 21
1959 Compression metadata off heap memory used: 8
1960 Compacted partition minimum bytes: 87
1961 Compacted partition maximum bytes: 103
1962 Compacted partition mean bytes: 103
1963 Average live cells per slice (last five minutes): NaN
1964 Maximum live cells per slice (last five minutes): 0
1965 Average tombstones per slice (last five minutes): NaN
1966 Maximum tombstones per slice (last five minutes): 0
1967 Dropped Mutations: 0
1968
1969----------------
1970
1971florian@florian-VirtualBox:~$ nodetool tpstats
1972Pool Name Active Pending Completed Blocked All time blocked
1973ReadStage 0 0 348 0 0
1974MiscStage 0 0 0 0 0
1975CompactionExecutor 0 0 9631 0 0
1976MutationStage 0 0 46 0 0
1977MemtableReclaimMemory 0 0 131 0 0
1978PendingRangeCalculator 0 0 1 0 0
1979GossipStage 0 0 0 0 0
1980SecondaryIndexManagement 0 0 4 0 0
1981HintsDispatcher 0 0 0 0 0
1982RequestResponseStage 0 0 0 0 0
1983Native-Transport-Requests 0 0 1332 0 0
1984ReadRepairStage 0 0 0 0 0
1985CounterMutationStage 0 0 0 0 0
1986MigrationStage 0 0 26 0 0
1987MemtablePostFlush 0 0 318 0 0
1988PerDiskMemtableFlushWriter_0 0 0 125 0 0
1989ValidationExecutor 0 0 0 0 0
1990Sampler 0 0 0 0 0
1991MemtableFlushWriter 0 0 126 0 0
1992InternalResponseStage 0 0 0 0 0
1993ViewMutationStage 0 0 0 0 0
1994AntiEntropyStage 0 0 0 0 0
1995CacheCleanupExecutor 0 0 0 0 0
1996
1997Message type Dropped
1998READ 0
1999RANGE_SLICE 0
2000_TRACE 0
2001HINT 0
2002MUTATION 0
2003COUNTER_MUTATION 0
2004BATCH_STORE 0
2005BATCH_REMOVE 0
2006REQUEST_RESPONSE 0
2007PAGED_RANGE 0
2008READ_REPAIR 0
2009
2010florian@florian-VirtualBox:~$ nodetool snapshot ecole
2011Requested creating snapshot(s) for [ecole] with snapshot name [1574259378546] and options {skipFlush=false}
2012Snapshot directory: 1574259378546
2013
2014florian@florian-VirtualBox:~$ nodetool refrech ecole
2015nodetool: Found unexpected parameters: [refrech, ecole]
2016See 'nodetool help' or 'nodetool help <command>'.
2017
2018florian@florian-VirtualBox:~$ nodetool repair -seq ecole
2019[2019-11-20 16:27:09,576] Starting repair command #1 (37bcb000-0baa-11ea-9c2a-6332bff616a6), repairing keyspace ecole with repair options (parallelism: sequential, primary range: false, incremental: true, job threads: 1, ColumnFamilies: [], dataCenters: [], hosts: [], # of ranges: 256, pull repair: false)
2020[2019-11-20 16:27:09,676] Repair completed successfully
2021[2019-11-20 16:27:09,679] Repair command #1 finished in 0 seconds