From d59d90bb1f86934f0effc0b92c3d062eb41cdcb6 Mon Sep 17 00:00:00 2001 From: Igor Canadi Date: Fri, 12 Jun 2015 14:31:53 -0700 Subject: db_bench periodically writes QPS to CSV file Summary: This is part of an effort to better understand and optimize RocksDB stalls under high load. I added a feature to db_bench to periodically write QPS to CSV files. That way we can nicely see how our QPS changes in time (especially when DB is stalled) and can do a better job of evaluating our stall system (i.e. we want the QPS to be as constant as possible, as opposed to having bunch of stalls) Cool part of CSV files is that we can easily graph them -- there are a bunch of tools available. Test Plan: Ran ./db_bench --report_interval_seconds=10 --benchmarks=fillrandom --num=10000000 and observed this in report.csv: secs_elapsed,interval_qps 10,2725860 20,1980480 30,1863456 40,1454359 50,1460389 Reviewers: sdong, MarkCallaghan, rven, yhchiang Reviewed By: yhchiang Subscribers: dhruba, leveldb Differential Revision: https://reviews.facebook.net/D40047 --- HISTORY.md | 1 + 1 file changed, 1 insertion(+) (limited to 'HISTORY.md') diff --git a/HISTORY.md b/HISTORY.md index 7f8efa535..0a0b60891 100644 --- a/HISTORY.md +++ b/HISTORY.md @@ -2,6 +2,7 @@ ### New Features * Added experimental support for optimistic transactions. See include/rocksdb/utilities/optimistic_transaction.h for more info. +* Added a new way to report QPS from db_bench (check out --report_file and --report_interval_seconds) ### Public API changes * EventListener::OnFlushCompleted() now passes FlushJobInfo instead of a list of parameters. -- cgit v1.2.3-70-g09d2