Hi,
I have a simple keyspace:
<Keyspace Name="reef-test">
<ColumnFamily Name ="Meas" CompareWith="LongType" />
<ReplicaPlacementStrategy>org.apache.cassandra.locator.RackUnawareStrategy</ReplicaPlacementStrategy>
<ReplicationFactor>1</ReplicationFactor>
<EndPointSnitch>org.apache.cassandra.locator.EndPointSnitch</EndPointSnitch>
</Keyspace>
We're using it as a data historian. Many rows of measurments, measurement
history is in the columns by milliseconds since UNIX epoch. The single node
never has a problem writing, but even with low volume it will frequently
timeout while reading:
Read timed out
org.apache.thrift.transport.TTransportException:
java.net.SocketTimeoutException: Read timed out
at
org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:128)
at org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
at
org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:314)
at
org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:262)
at
org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:192)
at
org.apache.cassandra.thrift.Cassandra$Client.recv_multiget_slice(Cassandra.java:477)
at
org.apache.cassandra.thrift.Cassandra$Client.multiget_slice(Cassandra.java:458)
What settings should I be tuning to avoid this? Usually the latency is
quite low, but once in every 10 queries or so it's completely of the
chart.
thanks,
Adam