On 12/08/10 19:21, Jesse McConnell wrote: > out of curiosity are you shooting for incrementing these counters 10k > times a second for sustained periods of time?
Jesse, Our traffic pattern varies between 5.5k and 10k connections/hits per second. We currently process the hits and log to MySQL (partitioned DBs). We're looking into the possibility of using cassandra. I don't think we'll be sending each hit to the DB individually, ie. 10k hits/sec won't correspond to 10k updates/sec, but I imagine the counter updates will be fairly high volume. We'll bottom that out in our initial testing. R.
