Skip to content

Instantly share code, notes, and snippets.

@jeffjirsa

jeffjirsa/gist:5c0f63395269a85cdcb2

Created April 17, 2015 22:48
Show Gist options
  • Save jeffjirsa/5c0f63395269a85cdcb2 to your computer and use it in GitHub Desktop.
Save jeffjirsa/5c0f63395269a85cdcb2 to your computer and use it in GitHub Desktop.
Download ZIP
Testing cassandra-9181 with 2.0.14
Raw
gistfile1.txt
bash-3.2# ccm node1 cqlsh
Connected to snapshot at 127.0.0.1:9160.
[cqlsh 4.1.1 | Cassandra 2.0.14-SNAPSHOT | CQL spec 3.1.1 | Thrift protocol 19.39.0]
Use HELP for help.
cqlsh> tracing on
Now tracing requests.
cqlsh> select * from test2.text_table where p='1634' and value=1634;
(0 rows)
Tracing session: d2fd2810-e553-11e4-bcc0-8ff7b1eb6f10
activity | timestamp | source | source_elapsed
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+-----------+----------------
execute_cql3_query | 15:48:11,283 | 127.0.0.1 | 0
Parsing select * from test2.text_table where p='1634' and value=1634 LIMIT 10000; | 15:48:11,284 | 127.0.0.1 | 673
Preparing statement | 15:48:11,285 | 127.0.0.1 | 1383
Determining replicas to query | 15:48:11,289 | 127.0.0.1 | 5846
Enqueuing request to /127.0.0.3 | 15:48:11,291 | 127.0.0.1 | 7225
Sending message to /127.0.0.3 | 15:48:11,291 | 127.0.0.1 | 7423
Message received from /127.0.0.1 | 15:48:11,302 | 127.0.0.3 | 82
Candidate index mean cardinalities are CompositesIndexOnRegular{columnDefs=[ColumnDefinition{name=76616c7565, validator=org.apache.cassandra.db.marshal.Int32Type, type=REGULAR, componentIndex=1, indexName=failure, indexType=COMPOSITES}]}:0. Scanning with text_table.failure. | 15:48:11,305 | 127.0.0.3 | 2461
Executing indexed scan for [1634, 1634] | 15:48:11,305 | 127.0.0.3 | 2554
Candidate index mean cardinalities are CompositesIndexOnRegular{columnDefs=[ColumnDefinition{name=76616c7565, validator=org.apache.cassandra.db.marshal.Int32Type, type=REGULAR, componentIndex=1, indexName=failure, indexType=COMPOSITES}]}:0. Scanning with text_table.failure. | 15:48:11,305 | 127.0.0.3 | 2708
Executing single-partition query on text_table.failure | 15:48:11,306 | 127.0.0.3 | 3376
Acquiring sstable references | 15:48:11,306 | 127.0.0.3 | 3394
Merging memtable tombstones | 15:48:11,306 | 127.0.0.3 | 3440
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones | 15:48:11,306 | 127.0.0.3 | 3494
Message received from /127.0.0.3 | 15:48:11,307 | 127.0.0.1 | 23349
Processing response from /127.0.0.3 | 15:48:11,307 | 127.0.0.1 | 23569
Request complete | 15:48:11,306 | 127.0.0.1 | 23915
cqlsh> select * from test2.text_table where value=1635;
(0 rows)
Tracing session: d5d4d920-e553-11e4-bcc0-8ff7b1eb6f10
activity | timestamp | source | source_elapsed
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+-----------+----------------
execute_cql3_query | 15:48:16,050 | 127.0.0.1 | 0
Parsing select * from test2.text_table where value=1635 LIMIT 10000; | 15:48:16,050 | 127.0.0.1 | 80
Preparing statement | 15:48:16,050 | 127.0.0.1 | 205
Determining replicas to query | 15:48:16,051 | 127.0.0.1 | 445
Enqueuing request to /127.0.0.2 | 15:48:16,051 | 127.0.0.1 | 809
Sending message to /127.0.0.2 | 15:48:16,052 | 127.0.0.1 | 1620
Message received from /127.0.0.1 | 15:48:16,061 | 127.0.0.2 | 47
Candidate index mean cardinalities are CompositesIndexOnRegular{columnDefs=[ColumnDefinition{name=76616c7565, validator=org.apache.cassandra.db.marshal.Int32Type, type=REGULAR, componentIndex=1, indexName=failure, indexType=COMPOSITES}]}:0. Scanning with text_table.failure. | 15:48:16,063 | 127.0.0.2 | 2063
Executing indexed scan for [min(-9223372036854775808), max(-3074457345618258603)] | 15:48:16,064 | 127.0.0.2 | 2193
Candidate index mean cardinalities are CompositesIndexOnRegular{columnDefs=[ColumnDefinition{name=76616c7565, validator=org.apache.cassandra.db.marshal.Int32Type, type=REGULAR, componentIndex=1, indexName=failure, indexType=COMPOSITES}]}:0. Scanning with text_table.failure. | 15:48:16,064 | 127.0.0.2 | 2360
Executing single-partition query on text_table.failure | 15:48:16,064 | 127.0.0.2 | 2722
Acquiring sstable references | 15:48:16,064 | 127.0.0.2 | 2735
Merging memtable tombstones | 15:48:16,064 | 127.0.0.2 | 2766
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones | 15:48:16,064 | 127.0.0.2 | 2801
Scanned 0 rows and matched 0 | 15:48:16,064 | 127.0.0.2 | 2921
Enqueuing response to /127.0.0.1 | 15:48:16,064 | 127.0.0.2 | 2951
Sending message to /127.0.0.1 | 15:48:16,064 | 127.0.0.2 | 3096
Message received from /127.0.0.2 | 15:48:16,065 | 127.0.0.1 | 14371
Processing response from /127.0.0.2 | 15:48:16,065 | 127.0.0.1 | 14455
Enqueuing request to /127.0.0.3 | 15:48:16,065 | 127.0.0.1 | 14666
Sending message to /127.0.0.3 | 15:48:16,065 | 127.0.0.1 | 14804
Message received from /127.0.0.1 | 15:48:16,066 | 127.0.0.3 | 39
Candidate index mean cardinalities are CompositesIndexOnRegular{columnDefs=[ColumnDefinition{name=76616c7565, validator=org.apache.cassandra.db.marshal.Int32Type, type=REGULAR, componentIndex=1, indexName=failure, indexType=COMPOSITES}]}:0. Scanning with text_table.failure. | 15:48:16,066 | 127.0.0.3 | 396
Executing indexed scan for (max(-3074457345618258603), max(3074457345618258602)] | 15:48:16,066 | 127.0.0.3 | 551
Candidate index mean cardinalities are CompositesIndexOnRegular{columnDefs=[ColumnDefinition{name=76616c7565, validator=org.apache.cassandra.db.marshal.Int32Type, type=REGULAR, componentIndex=1, indexName=failure, indexType=COMPOSITES}]}:0. Scanning with text_table.failure. | 15:48:16,066 | 127.0.0.3 | 688
Executing single-partition query on text_table.failure | 15:48:16,066 | 127.0.0.3 | 751
Acquiring sstable references | 15:48:16,066 | 127.0.0.3 | 765
Merging memtable tombstones | 15:48:16,066 | 127.0.0.3 | 801
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones | 15:48:16,066 | 127.0.0.3 | 867
Scanned 0 rows and matched 0 | 15:48:16,067 | 127.0.0.3 | 1072
Message received from /127.0.0.3 | 15:48:16,067 | 127.0.0.1 | 16997
Enqueuing response to /127.0.0.1 | 15:48:16,067 | 127.0.0.3 | 1101
Sending message to /127.0.0.1 | 15:48:16,067 | 127.0.0.3 | 1421
Processing response from /127.0.0.3 | 15:48:16,068 | 127.0.0.1 | 17227
Candidate index mean cardinalities are CompositesIndexOnRegular{columnDefs=[ColumnDefinition{name=76616c7565, validator=org.apache.cassandra.db.marshal.Int32Type, type=REGULAR, componentIndex=1, indexName=failure, indexType=COMPOSITES}]}:0. Scanning with text_table.failure. | 15:48:16,160 | 127.0.0.1 | 109852
Executing indexed scan for (max(3074457345618258602), min(-9223372036854775808)] | 15:48:16,160 | 127.0.0.1 | 110005
Candidate index mean cardinalities are CompositesIndexOnRegular{columnDefs=[ColumnDefinition{name=76616c7565, validator=org.apache.cassandra.db.marshal.Int32Type, type=REGULAR, componentIndex=1, indexName=failure, indexType=COMPOSITES}]}:0. Scanning with text_table.failure. | 15:48:16,160 | 127.0.0.1 | 110192
Executing single-partition query on text_table.failure | 15:48:16,161 | 127.0.0.1 | 110764
Acquiring sstable references | 15:48:16,161 | 127.0.0.1 | 110778
Merging memtable tombstones | 15:48:16,161 | 127.0.0.1 | 110826
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones | 15:48:16,161 | 127.0.0.1 | 110884
Scanned 0 rows and matched 0 | 15:48:16,161 | 127.0.0.1 | 110984
Request complete | 15:48:16,161 | 127.0.0.1 | 111295
cqlsh>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment