How do I discover consistency level performance?

Use tracing to discover what the consistency level is set to, and how it affects performance.

Before changing the consistency level on read and write operations, discover how your CQL commands are performing using the TRACING command in CQL. Using cqlsh, you can vary the consistency level and trace read and write operations. The tracing output includes latency times for the operations.

The CQL documentation includes an example comparing consistency levels.

Tip: For more information on tracing data, see this post on the DataStax Support Blog, which explains in detail how to locate data on disk.