nodetool compactionhistory
Prints history of compaction.
Prints the history of compaction.
Synopsis
nodetool [connection_options] compactionhistory [-F (json | yaml)]
| Syntax conventions | Description |
|---|---|
| UPPERCASE | Literal keyword. |
| Lowercase | Not literal. |
Italics |
Variable value. Replace with a valid option or user-defined value. |
[ ] |
Optional. Square brackets ( [ ] ) surround optional command
arguments. Do not type the square brackets. |
( ) |
Group. Parentheses ( ( ) ) identify a group to choose from. Do
not type the parentheses. |
| |
Or. A vertical bar ( | ) separates alternative elements. Type
any one of the elements. Do not type the vertical bar. |
... |
Repeatable. An ellipsis ( ... ) indicates that you can repeat
the syntax element as often as required. |
'Literal string' |
Single quotation ( ' ) marks must surround literal strings in
CQL statements. Use single quotation marks to preserve upper case. |
{ key:value } |
Map collection. Braces ( { } ) enclose map collections or key
value pairs. A colon separates the key and the value. |
<datatype1,datatype2> |
Set, list, map, or tuple. Angle brackets ( < > ) enclose
data types in a set, list, map, or tuple. Separate the data types with a comma.
|
cql_statement; |
End CQL statement. A semicolon ( ; ) terminates all CQL
statements. |
[ -- ] |
Separate the command line options from the command arguments with two hyphens (
-- ). This syntax is useful when arguments might be mistaken for
command line options. |
' <schema> ... </schema>
' |
Search CQL only: Single quotation marks ( ' ) surround an entire
XML schema declaration. |
@xml_entity='xml_entity_type' |
Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files. |
Definition
The short form and long form parameters are comma-separated.
Connection options
- -h, --host hostname
- The hostname or IP address of a remote node or nodes. When omitted, the default is the local machine.
- -p, --port jmx_port
- The JMX port number.
- -pw, --password jmxpassword
- The JMX password for authenticating with secure JMX. If a password is not provided, you are prompted to enter one.
- -pwf, --password-file jmx_password_filepath
- The filepath to the file that stores JMX authentication credentials.
- -u, --username jmx_username
- The user name for authenticating with secure JMX.
Command arguments
- -F, --format json | yaml
- The format for the output. The default is plain text. The following wait latencies (in ms) are included in the following order: 50%, 75%, 95%, 98%, 99%, Min, and Max.
Examples
To view the compaction history
nodetool compactionhistory
The output of compaction history is seven columns wide. The
first three columns show the id, keyspace name, and table name of the compacted
SSTable.
Compaction History:
id keyspace_name table_name
d06f7080-07a5-11e4-9b36-abc3a0ec9088 system schema_columnfamilies
d198ae40-07a5-11e4-9b36-abc3a0ec9088 libdata users
0381bc30-07b0-11e4-9b36-abc3a0ec9088 Keyspace1 Standard1
74eb69b0-0621-11e4-9b36-abc3a0ec9088 system local
e35dd980-07ae-11e4-9b36-abc3a0ec9088 system compactions_in_progress
8d5cf160-07ae-11e4-9b36-abc3a0ec9088 system compactions_in_progress
ba376020-07af-11e4-9b36-abc3a0ec9088 Keyspace1 Standard1
d18cc760-07a5-11e4-9b36-abc3a0ec9088 libdata libout
64009bf0-07a4-11e4-9b36-abc3a0ec9088 libdata libout
d04700f0-07a5-11e4-9b36-abc3a0ec9088 system sstable_activity
c2a97370-07a9-11e4-9b36-abc3a0ec9088 libdata users
cb928a80-07ae-11e4-9b36-abc3a0ec9088 Keyspace1 Standard1
cd8d1540-079e-11e4-9b36-abc3a0ec9088 system schema_columns
62ced2b0-07a4-11e4-9b36-abc3a0ec9088 system schema_keyspaces
d19cccf0-07a5-11e4-9b36-abc3a0ec9088 system compactions_in_progress
640bbf80-07a4-11e4-9b36-abc3a0ec9088 libdata users
6cd54e60-07ae-11e4-9b36-abc3a0ec9088 Keyspace1 Standard1
c29241f0-07a9-11e4-9b36-abc3a0ec9088 libdata libout
c2a30ad0-07a9-11e4-9b36-abc3a0ec9088 system compactions_in_progress
e3a6d920-079d-11e4-9b36-abc3a0ec9088 system schema_keyspaces
62c55cd0-07a4-11e4-9b36-abc3a0ec9088 system schema_columnfamilies
62b07540-07a4-11e4-9b36-abc3a0ec9088 system schema_columns
cdd038c0-079e-11e4-9b36-abc3a0ec9088 system schema_keyspaces
b797af00-07af-11e4-9b36-abc3a0ec9088 Keyspace1 Standard1
8c918b10-07ae-11e4-9b36-abc3a0ec9088 Keyspace1 Standard1
377d73f0-07ae-11e4-9b36-abc3a0ec9088 system compactions_in_progress
62b9c410-07a4-11e4-9b36-abc3a0ec9088 system local
d0566a40-07a5-11e4-9b36-abc3a0ec9088 system schema_columns
ba637930-07af-11e4-9b36-abc3a0ec9088 system compactions_in_progress
cdbc1480-079e-11e4-9b36-abc3a0ec9088 system schema_columnfamilies
e3456f80-07ae-11e4-9b36-abc3a0ec9088 Keyspace1 Standard1
d086f020-07a5-11e4-9b36-abc3a0ec9088 system schema_keyspaces
d06118a0-07a5-11e4-9b36-abc3a0ec9088 system local
cdaafd80-079e-11e4-9b36-abc3a0ec9088 system local
640fde30-07a4-11e4-9b36-abc3a0ec9088 system compactions_in_progress
37638350-07ae-11e4-9b36-abc3a0ec9088 Keyspace1 Standard1
. . . compacted_at bytes_in bytes_out rows_merged
. . . 1404936947592 8096 7211 {1:3, 3:1}
. . . 1404936949540 144 144 {1:1}
. . . 1404941328243 1305838191 1305838191 {1:4647111}
. . . 1404770149323 5864 5701 {4:1}
. . . 1404940844824 573 148 {1:1, 2:2}
. . . 1404940700534 576 155 {1:1, 2:2}
. . . 1404941205282 766331398 766331398 {1:2727158}
. . . 1404936949462 8901649 8901649 {1:9315}
. . . 1404936336175 8900821 8900821 {1:9315}
. . . 1404936947327 223 108 {1:3, 2:1}
. . . 1404938642471 144 144 {1:1}
. . . 1404940804904 383020422 383020422 {1:1363062}
. . . 1404933936276 4889 4177 {1:4}
. . . 1404936334171 441 281 {1:3, 2:1}
. . . 1404936949567 379 79 {2:2}
. . . 1404936336248 144 144 {1:1}
. . . 1404940645958 307520780 307520780 {1:1094380}
. . . 1404938642319 8901649 8901649 {1:9315}
. . . 1404938642429 416 165 {1:3, 2:1}
. . . 1404933543858 692 281 {1:3, 2:1}
. . . 1404936334109 7760 7186 {1:3, 2:1}
. . . 1404936333972 4860 4724 {1:2, 2:1}
. . . 1404933936715 441 281 {1:3, 2:1}
. . . 1404941200880 1269180898 1003196133 {1:2623528, 2:946565}
. . . 1404940699201 297639696 297639696 {1:1059216}
. . . 1404940556463 592 148 {1:2, 2:2}
. . . 1404936334033 5760 5680 {2:1}
. . . 1404936947428 8413 5316 {1:2, 3:1}
. . . 1404941205571 429 42 {2:2}
. . . 1404933936584 7994 6789 {1:4}
. . . 1404940844664 306699417 306699417 {1:1091457}
. . . 1404936947746 601 281 {1:3, 3:1}
. . . 1404936947498 5840 5680 {3:1}
. . . 1404933936472 5861 5680 {3:1}
. . . 1404936336275 378 80 {2:2}
. . . 1404940556293 302170540 281000000 {1:924660, 2:75340}