Database Reference
In-Depth Information
use "Keyspace1" ;
select count(*) from "Standard1" limit 10000000;
Figure 8-4
shows the result.
Figure 8-4.
A cql query to find the total number of records in the Standard1 column family created via the stress tool
Reader can use the
describe table
command to describe the default columns
and their data types. Here the default column size is 5 and all are of type blob.
Similar to other default values, it is also possible to overwrite column count, size,
family type, thread count, and random row key generation. Let's examine the sample
output by running
insert
only for 20 and 30 threads, respectively.
With 20 threads
$CASSANDRA_HOME/tools/bin/cassandra-stress -d localhost
-p 9160 -o insert -t 20 -r -S 50 -U UTF8Type -y Standard
Averages from the middle 80% of values:
interval_op_rate : 16657
interval_key_rate : 16657
latency median : 2.8
latency 95th percentile : 11.5
latency 99.9th percentile : 646.7
Total operation time : 00:01:01
END
Figure 8-5
shows a JConsole overview chart of CPU usage, heap, and other re-
source utilization with 20 threads.
