Hi James, I don't know how to get the below statistics data and calculate the access times (read/write in ms) in your previous mails. Can you explain a little? Iike to work on it also.
CD On Thu, Apr 1, 2010 at 4:15 AM, Jonathan Ellis <jbel...@gmail.com> wrote: > On Wed, Mar 31, 2010 at 6:21 PM, James Golick <jamesgol...@gmail.com> > wrote: > > Keyspace: ActivityFeed > > Read Count: 699443 > > Read Latency: 16.11017477192566 ms. > > > Column Family: Events > > Read Count: 232378 > > Read Latency: 0.396 ms. > > Row cache capacity: 500000 > > Row cache size: 62768 > > Row cache hit rate: 0.007716049382716049 > > This says that > > - recent queries to Events are much faster than the lifetime average > for your Keyspace > - even though you have almost no row cache hits (~1700 out of 232000 > reads) > > Not sure what to make of that, tbh. If it were me I would try to > reproduce on a test machine w/o all that pesky live traffic confusing > things. > > -Jonathan >
