xref: /aosp_15_r20/external/leveldb/benchmarks/db_bench_sqlite3.cc (revision 9507f98c5f32dee4b5f9e4a38cd499f3ff5c4490)
1*9507f98cSAndroid Build Coastguard Worker // Copyright (c) 2011 The LevelDB Authors. All rights reserved.
2*9507f98cSAndroid Build Coastguard Worker // Use of this source code is governed by a BSD-style license that can be
3*9507f98cSAndroid Build Coastguard Worker // found in the LICENSE file. See the AUTHORS file for names of contributors.
4*9507f98cSAndroid Build Coastguard Worker 
5*9507f98cSAndroid Build Coastguard Worker #include <sqlite3.h>
6*9507f98cSAndroid Build Coastguard Worker 
7*9507f98cSAndroid Build Coastguard Worker #include <cstdio>
8*9507f98cSAndroid Build Coastguard Worker #include <cstdlib>
9*9507f98cSAndroid Build Coastguard Worker 
10*9507f98cSAndroid Build Coastguard Worker #include "util/histogram.h"
11*9507f98cSAndroid Build Coastguard Worker #include "util/random.h"
12*9507f98cSAndroid Build Coastguard Worker #include "util/testutil.h"
13*9507f98cSAndroid Build Coastguard Worker 
14*9507f98cSAndroid Build Coastguard Worker // Comma-separated list of operations to run in the specified order
15*9507f98cSAndroid Build Coastguard Worker //   Actual benchmarks:
16*9507f98cSAndroid Build Coastguard Worker //
17*9507f98cSAndroid Build Coastguard Worker //   fillseq       -- write N values in sequential key order in async mode
18*9507f98cSAndroid Build Coastguard Worker //   fillseqsync   -- write N/100 values in sequential key order in sync mode
19*9507f98cSAndroid Build Coastguard Worker //   fillseqbatch  -- batch write N values in sequential key order in async mode
20*9507f98cSAndroid Build Coastguard Worker //   fillrandom    -- write N values in random key order in async mode
21*9507f98cSAndroid Build Coastguard Worker //   fillrandsync  -- write N/100 values in random key order in sync mode
22*9507f98cSAndroid Build Coastguard Worker //   fillrandbatch -- batch write N values in sequential key order in async mode
23*9507f98cSAndroid Build Coastguard Worker //   overwrite     -- overwrite N values in random key order in async mode
24*9507f98cSAndroid Build Coastguard Worker //   fillrand100K  -- write N/1000 100K values in random order in async mode
25*9507f98cSAndroid Build Coastguard Worker //   fillseq100K   -- write N/1000 100K values in sequential order in async mode
26*9507f98cSAndroid Build Coastguard Worker //   readseq       -- read N times sequentially
27*9507f98cSAndroid Build Coastguard Worker //   readrandom    -- read N times in random order
28*9507f98cSAndroid Build Coastguard Worker //   readrand100K  -- read N/1000 100K values in sequential order in async mode
29*9507f98cSAndroid Build Coastguard Worker static const char* FLAGS_benchmarks =
30*9507f98cSAndroid Build Coastguard Worker     "fillseq,"
31*9507f98cSAndroid Build Coastguard Worker     "fillseqsync,"
32*9507f98cSAndroid Build Coastguard Worker     "fillseqbatch,"
33*9507f98cSAndroid Build Coastguard Worker     "fillrandom,"
34*9507f98cSAndroid Build Coastguard Worker     "fillrandsync,"
35*9507f98cSAndroid Build Coastguard Worker     "fillrandbatch,"
36*9507f98cSAndroid Build Coastguard Worker     "overwrite,"
37*9507f98cSAndroid Build Coastguard Worker     "overwritebatch,"
38*9507f98cSAndroid Build Coastguard Worker     "readrandom,"
39*9507f98cSAndroid Build Coastguard Worker     "readseq,"
40*9507f98cSAndroid Build Coastguard Worker     "fillrand100K,"
41*9507f98cSAndroid Build Coastguard Worker     "fillseq100K,"
42*9507f98cSAndroid Build Coastguard Worker     "readseq,"
43*9507f98cSAndroid Build Coastguard Worker     "readrand100K,";
44*9507f98cSAndroid Build Coastguard Worker 
45*9507f98cSAndroid Build Coastguard Worker // Number of key/values to place in database
46*9507f98cSAndroid Build Coastguard Worker static int FLAGS_num = 1000000;
47*9507f98cSAndroid Build Coastguard Worker 
48*9507f98cSAndroid Build Coastguard Worker // Number of read operations to do.  If negative, do FLAGS_num reads.
49*9507f98cSAndroid Build Coastguard Worker static int FLAGS_reads = -1;
50*9507f98cSAndroid Build Coastguard Worker 
51*9507f98cSAndroid Build Coastguard Worker // Size of each value
52*9507f98cSAndroid Build Coastguard Worker static int FLAGS_value_size = 100;
53*9507f98cSAndroid Build Coastguard Worker 
54*9507f98cSAndroid Build Coastguard Worker // Print histogram of operation timings
55*9507f98cSAndroid Build Coastguard Worker static bool FLAGS_histogram = false;
56*9507f98cSAndroid Build Coastguard Worker 
57*9507f98cSAndroid Build Coastguard Worker // Arrange to generate values that shrink to this fraction of
58*9507f98cSAndroid Build Coastguard Worker // their original size after compression
59*9507f98cSAndroid Build Coastguard Worker static double FLAGS_compression_ratio = 0.5;
60*9507f98cSAndroid Build Coastguard Worker 
61*9507f98cSAndroid Build Coastguard Worker // Page size. Default 1 KB.
62*9507f98cSAndroid Build Coastguard Worker static int FLAGS_page_size = 1024;
63*9507f98cSAndroid Build Coastguard Worker 
64*9507f98cSAndroid Build Coastguard Worker // Number of pages.
65*9507f98cSAndroid Build Coastguard Worker // Default cache size = FLAGS_page_size * FLAGS_num_pages = 4 MB.
66*9507f98cSAndroid Build Coastguard Worker static int FLAGS_num_pages = 4096;
67*9507f98cSAndroid Build Coastguard Worker 
68*9507f98cSAndroid Build Coastguard Worker // If true, do not destroy the existing database.  If you set this
69*9507f98cSAndroid Build Coastguard Worker // flag and also specify a benchmark that wants a fresh database, that
70*9507f98cSAndroid Build Coastguard Worker // benchmark will fail.
71*9507f98cSAndroid Build Coastguard Worker static bool FLAGS_use_existing_db = false;
72*9507f98cSAndroid Build Coastguard Worker 
73*9507f98cSAndroid Build Coastguard Worker // If true, the SQLite table has ROWIDs.
74*9507f98cSAndroid Build Coastguard Worker static bool FLAGS_use_rowids = false;
75*9507f98cSAndroid Build Coastguard Worker 
76*9507f98cSAndroid Build Coastguard Worker // If true, we allow batch writes to occur
77*9507f98cSAndroid Build Coastguard Worker static bool FLAGS_transaction = true;
78*9507f98cSAndroid Build Coastguard Worker 
79*9507f98cSAndroid Build Coastguard Worker // If true, we enable Write-Ahead Logging
80*9507f98cSAndroid Build Coastguard Worker static bool FLAGS_WAL_enabled = true;
81*9507f98cSAndroid Build Coastguard Worker 
82*9507f98cSAndroid Build Coastguard Worker // Use the db with the following name.
83*9507f98cSAndroid Build Coastguard Worker static const char* FLAGS_db = nullptr;
84*9507f98cSAndroid Build Coastguard Worker 
ExecErrorCheck(int status,char * err_msg)85*9507f98cSAndroid Build Coastguard Worker inline static void ExecErrorCheck(int status, char* err_msg) {
86*9507f98cSAndroid Build Coastguard Worker   if (status != SQLITE_OK) {
87*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stderr, "SQL error: %s\n", err_msg);
88*9507f98cSAndroid Build Coastguard Worker     sqlite3_free(err_msg);
89*9507f98cSAndroid Build Coastguard Worker     std::exit(1);
90*9507f98cSAndroid Build Coastguard Worker   }
91*9507f98cSAndroid Build Coastguard Worker }
92*9507f98cSAndroid Build Coastguard Worker 
StepErrorCheck(int status)93*9507f98cSAndroid Build Coastguard Worker inline static void StepErrorCheck(int status) {
94*9507f98cSAndroid Build Coastguard Worker   if (status != SQLITE_DONE) {
95*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stderr, "SQL step error: status = %d\n", status);
96*9507f98cSAndroid Build Coastguard Worker     std::exit(1);
97*9507f98cSAndroid Build Coastguard Worker   }
98*9507f98cSAndroid Build Coastguard Worker }
99*9507f98cSAndroid Build Coastguard Worker 
ErrorCheck(int status)100*9507f98cSAndroid Build Coastguard Worker inline static void ErrorCheck(int status) {
101*9507f98cSAndroid Build Coastguard Worker   if (status != SQLITE_OK) {
102*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stderr, "sqlite3 error: status = %d\n", status);
103*9507f98cSAndroid Build Coastguard Worker     std::exit(1);
104*9507f98cSAndroid Build Coastguard Worker   }
105*9507f98cSAndroid Build Coastguard Worker }
106*9507f98cSAndroid Build Coastguard Worker 
WalCheckpoint(sqlite3 * db_)107*9507f98cSAndroid Build Coastguard Worker inline static void WalCheckpoint(sqlite3* db_) {
108*9507f98cSAndroid Build Coastguard Worker   // Flush all writes to disk
109*9507f98cSAndroid Build Coastguard Worker   if (FLAGS_WAL_enabled) {
110*9507f98cSAndroid Build Coastguard Worker     sqlite3_wal_checkpoint_v2(db_, nullptr, SQLITE_CHECKPOINT_FULL, nullptr,
111*9507f98cSAndroid Build Coastguard Worker                               nullptr);
112*9507f98cSAndroid Build Coastguard Worker   }
113*9507f98cSAndroid Build Coastguard Worker }
114*9507f98cSAndroid Build Coastguard Worker 
115*9507f98cSAndroid Build Coastguard Worker namespace leveldb {
116*9507f98cSAndroid Build Coastguard Worker 
117*9507f98cSAndroid Build Coastguard Worker // Helper for quickly generating random data.
118*9507f98cSAndroid Build Coastguard Worker namespace {
119*9507f98cSAndroid Build Coastguard Worker class RandomGenerator {
120*9507f98cSAndroid Build Coastguard Worker  private:
121*9507f98cSAndroid Build Coastguard Worker   std::string data_;
122*9507f98cSAndroid Build Coastguard Worker   int pos_;
123*9507f98cSAndroid Build Coastguard Worker 
124*9507f98cSAndroid Build Coastguard Worker  public:
RandomGenerator()125*9507f98cSAndroid Build Coastguard Worker   RandomGenerator() {
126*9507f98cSAndroid Build Coastguard Worker     // We use a limited amount of data over and over again and ensure
127*9507f98cSAndroid Build Coastguard Worker     // that it is larger than the compression window (32KB), and also
128*9507f98cSAndroid Build Coastguard Worker     // large enough to serve all typical value sizes we want to write.
129*9507f98cSAndroid Build Coastguard Worker     Random rnd(301);
130*9507f98cSAndroid Build Coastguard Worker     std::string piece;
131*9507f98cSAndroid Build Coastguard Worker     while (data_.size() < 1048576) {
132*9507f98cSAndroid Build Coastguard Worker       // Add a short fragment that is as compressible as specified
133*9507f98cSAndroid Build Coastguard Worker       // by FLAGS_compression_ratio.
134*9507f98cSAndroid Build Coastguard Worker       test::CompressibleString(&rnd, FLAGS_compression_ratio, 100, &piece);
135*9507f98cSAndroid Build Coastguard Worker       data_.append(piece);
136*9507f98cSAndroid Build Coastguard Worker     }
137*9507f98cSAndroid Build Coastguard Worker     pos_ = 0;
138*9507f98cSAndroid Build Coastguard Worker   }
139*9507f98cSAndroid Build Coastguard Worker 
Generate(int len)140*9507f98cSAndroid Build Coastguard Worker   Slice Generate(int len) {
141*9507f98cSAndroid Build Coastguard Worker     if (pos_ + len > data_.size()) {
142*9507f98cSAndroid Build Coastguard Worker       pos_ = 0;
143*9507f98cSAndroid Build Coastguard Worker       assert(len < data_.size());
144*9507f98cSAndroid Build Coastguard Worker     }
145*9507f98cSAndroid Build Coastguard Worker     pos_ += len;
146*9507f98cSAndroid Build Coastguard Worker     return Slice(data_.data() + pos_ - len, len);
147*9507f98cSAndroid Build Coastguard Worker   }
148*9507f98cSAndroid Build Coastguard Worker };
149*9507f98cSAndroid Build Coastguard Worker 
TrimSpace(Slice s)150*9507f98cSAndroid Build Coastguard Worker static Slice TrimSpace(Slice s) {
151*9507f98cSAndroid Build Coastguard Worker   int start = 0;
152*9507f98cSAndroid Build Coastguard Worker   while (start < s.size() && isspace(s[start])) {
153*9507f98cSAndroid Build Coastguard Worker     start++;
154*9507f98cSAndroid Build Coastguard Worker   }
155*9507f98cSAndroid Build Coastguard Worker   int limit = s.size();
156*9507f98cSAndroid Build Coastguard Worker   while (limit > start && isspace(s[limit - 1])) {
157*9507f98cSAndroid Build Coastguard Worker     limit--;
158*9507f98cSAndroid Build Coastguard Worker   }
159*9507f98cSAndroid Build Coastguard Worker   return Slice(s.data() + start, limit - start);
160*9507f98cSAndroid Build Coastguard Worker }
161*9507f98cSAndroid Build Coastguard Worker 
162*9507f98cSAndroid Build Coastguard Worker }  // namespace
163*9507f98cSAndroid Build Coastguard Worker 
164*9507f98cSAndroid Build Coastguard Worker class Benchmark {
165*9507f98cSAndroid Build Coastguard Worker  private:
166*9507f98cSAndroid Build Coastguard Worker   sqlite3* db_;
167*9507f98cSAndroid Build Coastguard Worker   int db_num_;
168*9507f98cSAndroid Build Coastguard Worker   int num_;
169*9507f98cSAndroid Build Coastguard Worker   int reads_;
170*9507f98cSAndroid Build Coastguard Worker   double start_;
171*9507f98cSAndroid Build Coastguard Worker   double last_op_finish_;
172*9507f98cSAndroid Build Coastguard Worker   int64_t bytes_;
173*9507f98cSAndroid Build Coastguard Worker   std::string message_;
174*9507f98cSAndroid Build Coastguard Worker   Histogram hist_;
175*9507f98cSAndroid Build Coastguard Worker   RandomGenerator gen_;
176*9507f98cSAndroid Build Coastguard Worker   Random rand_;
177*9507f98cSAndroid Build Coastguard Worker 
178*9507f98cSAndroid Build Coastguard Worker   // State kept for progress messages
179*9507f98cSAndroid Build Coastguard Worker   int done_;
180*9507f98cSAndroid Build Coastguard Worker   int next_report_;  // When to report next
181*9507f98cSAndroid Build Coastguard Worker 
PrintHeader()182*9507f98cSAndroid Build Coastguard Worker   void PrintHeader() {
183*9507f98cSAndroid Build Coastguard Worker     const int kKeySize = 16;
184*9507f98cSAndroid Build Coastguard Worker     PrintEnvironment();
185*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stdout, "Keys:       %d bytes each\n", kKeySize);
186*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stdout, "Values:     %d bytes each\n", FLAGS_value_size);
187*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stdout, "Entries:    %d\n", num_);
188*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stdout, "RawSize:    %.1f MB (estimated)\n",
189*9507f98cSAndroid Build Coastguard Worker                  ((static_cast<int64_t>(kKeySize + FLAGS_value_size) * num_) /
190*9507f98cSAndroid Build Coastguard Worker                   1048576.0));
191*9507f98cSAndroid Build Coastguard Worker     PrintWarnings();
192*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stdout, "------------------------------------------------\n");
193*9507f98cSAndroid Build Coastguard Worker   }
194*9507f98cSAndroid Build Coastguard Worker 
PrintWarnings()195*9507f98cSAndroid Build Coastguard Worker   void PrintWarnings() {
196*9507f98cSAndroid Build Coastguard Worker #if defined(__GNUC__) && !defined(__OPTIMIZE__)
197*9507f98cSAndroid Build Coastguard Worker     std::fprintf(
198*9507f98cSAndroid Build Coastguard Worker         stdout,
199*9507f98cSAndroid Build Coastguard Worker         "WARNING: Optimization is disabled: benchmarks unnecessarily slow\n");
200*9507f98cSAndroid Build Coastguard Worker #endif
201*9507f98cSAndroid Build Coastguard Worker #ifndef NDEBUG
202*9507f98cSAndroid Build Coastguard Worker     std::fprintf(
203*9507f98cSAndroid Build Coastguard Worker         stdout,
204*9507f98cSAndroid Build Coastguard Worker         "WARNING: Assertions are enabled; benchmarks unnecessarily slow\n");
205*9507f98cSAndroid Build Coastguard Worker #endif
206*9507f98cSAndroid Build Coastguard Worker   }
207*9507f98cSAndroid Build Coastguard Worker 
PrintEnvironment()208*9507f98cSAndroid Build Coastguard Worker   void PrintEnvironment() {
209*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stderr, "SQLite:     version %s\n", SQLITE_VERSION);
210*9507f98cSAndroid Build Coastguard Worker 
211*9507f98cSAndroid Build Coastguard Worker #if defined(__linux)
212*9507f98cSAndroid Build Coastguard Worker     time_t now = time(nullptr);
213*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stderr, "Date:       %s",
214*9507f98cSAndroid Build Coastguard Worker                  ctime(&now));  // ctime() adds newline
215*9507f98cSAndroid Build Coastguard Worker 
216*9507f98cSAndroid Build Coastguard Worker     FILE* cpuinfo = std::fopen("/proc/cpuinfo", "r");
217*9507f98cSAndroid Build Coastguard Worker     if (cpuinfo != nullptr) {
218*9507f98cSAndroid Build Coastguard Worker       char line[1000];
219*9507f98cSAndroid Build Coastguard Worker       int num_cpus = 0;
220*9507f98cSAndroid Build Coastguard Worker       std::string cpu_type;
221*9507f98cSAndroid Build Coastguard Worker       std::string cache_size;
222*9507f98cSAndroid Build Coastguard Worker       while (fgets(line, sizeof(line), cpuinfo) != nullptr) {
223*9507f98cSAndroid Build Coastguard Worker         const char* sep = strchr(line, ':');
224*9507f98cSAndroid Build Coastguard Worker         if (sep == nullptr) {
225*9507f98cSAndroid Build Coastguard Worker           continue;
226*9507f98cSAndroid Build Coastguard Worker         }
227*9507f98cSAndroid Build Coastguard Worker         Slice key = TrimSpace(Slice(line, sep - 1 - line));
228*9507f98cSAndroid Build Coastguard Worker         Slice val = TrimSpace(Slice(sep + 1));
229*9507f98cSAndroid Build Coastguard Worker         if (key == "model name") {
230*9507f98cSAndroid Build Coastguard Worker           ++num_cpus;
231*9507f98cSAndroid Build Coastguard Worker           cpu_type = val.ToString();
232*9507f98cSAndroid Build Coastguard Worker         } else if (key == "cache size") {
233*9507f98cSAndroid Build Coastguard Worker           cache_size = val.ToString();
234*9507f98cSAndroid Build Coastguard Worker         }
235*9507f98cSAndroid Build Coastguard Worker       }
236*9507f98cSAndroid Build Coastguard Worker       std::fclose(cpuinfo);
237*9507f98cSAndroid Build Coastguard Worker       std::fprintf(stderr, "CPU:        %d * %s\n", num_cpus, cpu_type.c_str());
238*9507f98cSAndroid Build Coastguard Worker       std::fprintf(stderr, "CPUCache:   %s\n", cache_size.c_str());
239*9507f98cSAndroid Build Coastguard Worker     }
240*9507f98cSAndroid Build Coastguard Worker #endif
241*9507f98cSAndroid Build Coastguard Worker   }
242*9507f98cSAndroid Build Coastguard Worker 
Start()243*9507f98cSAndroid Build Coastguard Worker   void Start() {
244*9507f98cSAndroid Build Coastguard Worker     start_ = Env::Default()->NowMicros() * 1e-6;
245*9507f98cSAndroid Build Coastguard Worker     bytes_ = 0;
246*9507f98cSAndroid Build Coastguard Worker     message_.clear();
247*9507f98cSAndroid Build Coastguard Worker     last_op_finish_ = start_;
248*9507f98cSAndroid Build Coastguard Worker     hist_.Clear();
249*9507f98cSAndroid Build Coastguard Worker     done_ = 0;
250*9507f98cSAndroid Build Coastguard Worker     next_report_ = 100;
251*9507f98cSAndroid Build Coastguard Worker   }
252*9507f98cSAndroid Build Coastguard Worker 
FinishedSingleOp()253*9507f98cSAndroid Build Coastguard Worker   void FinishedSingleOp() {
254*9507f98cSAndroid Build Coastguard Worker     if (FLAGS_histogram) {
255*9507f98cSAndroid Build Coastguard Worker       double now = Env::Default()->NowMicros() * 1e-6;
256*9507f98cSAndroid Build Coastguard Worker       double micros = (now - last_op_finish_) * 1e6;
257*9507f98cSAndroid Build Coastguard Worker       hist_.Add(micros);
258*9507f98cSAndroid Build Coastguard Worker       if (micros > 20000) {
259*9507f98cSAndroid Build Coastguard Worker         std::fprintf(stderr, "long op: %.1f micros%30s\r", micros, "");
260*9507f98cSAndroid Build Coastguard Worker         std::fflush(stderr);
261*9507f98cSAndroid Build Coastguard Worker       }
262*9507f98cSAndroid Build Coastguard Worker       last_op_finish_ = now;
263*9507f98cSAndroid Build Coastguard Worker     }
264*9507f98cSAndroid Build Coastguard Worker 
265*9507f98cSAndroid Build Coastguard Worker     done_++;
266*9507f98cSAndroid Build Coastguard Worker     if (done_ >= next_report_) {
267*9507f98cSAndroid Build Coastguard Worker       if (next_report_ < 1000)
268*9507f98cSAndroid Build Coastguard Worker         next_report_ += 100;
269*9507f98cSAndroid Build Coastguard Worker       else if (next_report_ < 5000)
270*9507f98cSAndroid Build Coastguard Worker         next_report_ += 500;
271*9507f98cSAndroid Build Coastguard Worker       else if (next_report_ < 10000)
272*9507f98cSAndroid Build Coastguard Worker         next_report_ += 1000;
273*9507f98cSAndroid Build Coastguard Worker       else if (next_report_ < 50000)
274*9507f98cSAndroid Build Coastguard Worker         next_report_ += 5000;
275*9507f98cSAndroid Build Coastguard Worker       else if (next_report_ < 100000)
276*9507f98cSAndroid Build Coastguard Worker         next_report_ += 10000;
277*9507f98cSAndroid Build Coastguard Worker       else if (next_report_ < 500000)
278*9507f98cSAndroid Build Coastguard Worker         next_report_ += 50000;
279*9507f98cSAndroid Build Coastguard Worker       else
280*9507f98cSAndroid Build Coastguard Worker         next_report_ += 100000;
281*9507f98cSAndroid Build Coastguard Worker       std::fprintf(stderr, "... finished %d ops%30s\r", done_, "");
282*9507f98cSAndroid Build Coastguard Worker       std::fflush(stderr);
283*9507f98cSAndroid Build Coastguard Worker     }
284*9507f98cSAndroid Build Coastguard Worker   }
285*9507f98cSAndroid Build Coastguard Worker 
Stop(const Slice & name)286*9507f98cSAndroid Build Coastguard Worker   void Stop(const Slice& name) {
287*9507f98cSAndroid Build Coastguard Worker     double finish = Env::Default()->NowMicros() * 1e-6;
288*9507f98cSAndroid Build Coastguard Worker 
289*9507f98cSAndroid Build Coastguard Worker     // Pretend at least one op was done in case we are running a benchmark
290*9507f98cSAndroid Build Coastguard Worker     // that does not call FinishedSingleOp().
291*9507f98cSAndroid Build Coastguard Worker     if (done_ < 1) done_ = 1;
292*9507f98cSAndroid Build Coastguard Worker 
293*9507f98cSAndroid Build Coastguard Worker     if (bytes_ > 0) {
294*9507f98cSAndroid Build Coastguard Worker       char rate[100];
295*9507f98cSAndroid Build Coastguard Worker       std::snprintf(rate, sizeof(rate), "%6.1f MB/s",
296*9507f98cSAndroid Build Coastguard Worker                     (bytes_ / 1048576.0) / (finish - start_));
297*9507f98cSAndroid Build Coastguard Worker       if (!message_.empty()) {
298*9507f98cSAndroid Build Coastguard Worker         message_ = std::string(rate) + " " + message_;
299*9507f98cSAndroid Build Coastguard Worker       } else {
300*9507f98cSAndroid Build Coastguard Worker         message_ = rate;
301*9507f98cSAndroid Build Coastguard Worker       }
302*9507f98cSAndroid Build Coastguard Worker     }
303*9507f98cSAndroid Build Coastguard Worker 
304*9507f98cSAndroid Build Coastguard Worker     std::fprintf(stdout, "%-12s : %11.3f micros/op;%s%s\n",
305*9507f98cSAndroid Build Coastguard Worker                  name.ToString().c_str(), (finish - start_) * 1e6 / done_,
306*9507f98cSAndroid Build Coastguard Worker                  (message_.empty() ? "" : " "), message_.c_str());
307*9507f98cSAndroid Build Coastguard Worker     if (FLAGS_histogram) {
308*9507f98cSAndroid Build Coastguard Worker       std::fprintf(stdout, "Microseconds per op:\n%s\n",
309*9507f98cSAndroid Build Coastguard Worker                    hist_.ToString().c_str());
310*9507f98cSAndroid Build Coastguard Worker     }
311*9507f98cSAndroid Build Coastguard Worker     std::fflush(stdout);
312*9507f98cSAndroid Build Coastguard Worker   }
313*9507f98cSAndroid Build Coastguard Worker 
314*9507f98cSAndroid Build Coastguard Worker  public:
315*9507f98cSAndroid Build Coastguard Worker   enum Order { SEQUENTIAL, RANDOM };
316*9507f98cSAndroid Build Coastguard Worker   enum DBState { FRESH, EXISTING };
317*9507f98cSAndroid Build Coastguard Worker 
Benchmark()318*9507f98cSAndroid Build Coastguard Worker   Benchmark()
319*9507f98cSAndroid Build Coastguard Worker       : db_(nullptr),
320*9507f98cSAndroid Build Coastguard Worker         db_num_(0),
321*9507f98cSAndroid Build Coastguard Worker         num_(FLAGS_num),
322*9507f98cSAndroid Build Coastguard Worker         reads_(FLAGS_reads < 0 ? FLAGS_num : FLAGS_reads),
323*9507f98cSAndroid Build Coastguard Worker         bytes_(0),
324*9507f98cSAndroid Build Coastguard Worker         rand_(301) {
325*9507f98cSAndroid Build Coastguard Worker     std::vector<std::string> files;
326*9507f98cSAndroid Build Coastguard Worker     std::string test_dir;
327*9507f98cSAndroid Build Coastguard Worker     Env::Default()->GetTestDirectory(&test_dir);
328*9507f98cSAndroid Build Coastguard Worker     Env::Default()->GetChildren(test_dir, &files);
329*9507f98cSAndroid Build Coastguard Worker     if (!FLAGS_use_existing_db) {
330*9507f98cSAndroid Build Coastguard Worker       for (int i = 0; i < files.size(); i++) {
331*9507f98cSAndroid Build Coastguard Worker         if (Slice(files[i]).starts_with("dbbench_sqlite3")) {
332*9507f98cSAndroid Build Coastguard Worker           std::string file_name(test_dir);
333*9507f98cSAndroid Build Coastguard Worker           file_name += "/";
334*9507f98cSAndroid Build Coastguard Worker           file_name += files[i];
335*9507f98cSAndroid Build Coastguard Worker           Env::Default()->RemoveFile(file_name.c_str());
336*9507f98cSAndroid Build Coastguard Worker         }
337*9507f98cSAndroid Build Coastguard Worker       }
338*9507f98cSAndroid Build Coastguard Worker     }
339*9507f98cSAndroid Build Coastguard Worker   }
340*9507f98cSAndroid Build Coastguard Worker 
~Benchmark()341*9507f98cSAndroid Build Coastguard Worker   ~Benchmark() {
342*9507f98cSAndroid Build Coastguard Worker     int status = sqlite3_close(db_);
343*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
344*9507f98cSAndroid Build Coastguard Worker   }
345*9507f98cSAndroid Build Coastguard Worker 
Run()346*9507f98cSAndroid Build Coastguard Worker   void Run() {
347*9507f98cSAndroid Build Coastguard Worker     PrintHeader();
348*9507f98cSAndroid Build Coastguard Worker     Open();
349*9507f98cSAndroid Build Coastguard Worker 
350*9507f98cSAndroid Build Coastguard Worker     const char* benchmarks = FLAGS_benchmarks;
351*9507f98cSAndroid Build Coastguard Worker     while (benchmarks != nullptr) {
352*9507f98cSAndroid Build Coastguard Worker       const char* sep = strchr(benchmarks, ',');
353*9507f98cSAndroid Build Coastguard Worker       Slice name;
354*9507f98cSAndroid Build Coastguard Worker       if (sep == nullptr) {
355*9507f98cSAndroid Build Coastguard Worker         name = benchmarks;
356*9507f98cSAndroid Build Coastguard Worker         benchmarks = nullptr;
357*9507f98cSAndroid Build Coastguard Worker       } else {
358*9507f98cSAndroid Build Coastguard Worker         name = Slice(benchmarks, sep - benchmarks);
359*9507f98cSAndroid Build Coastguard Worker         benchmarks = sep + 1;
360*9507f98cSAndroid Build Coastguard Worker       }
361*9507f98cSAndroid Build Coastguard Worker 
362*9507f98cSAndroid Build Coastguard Worker       bytes_ = 0;
363*9507f98cSAndroid Build Coastguard Worker       Start();
364*9507f98cSAndroid Build Coastguard Worker 
365*9507f98cSAndroid Build Coastguard Worker       bool known = true;
366*9507f98cSAndroid Build Coastguard Worker       bool write_sync = false;
367*9507f98cSAndroid Build Coastguard Worker       if (name == Slice("fillseq")) {
368*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, SEQUENTIAL, FRESH, num_, FLAGS_value_size, 1);
369*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
370*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("fillseqbatch")) {
371*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, SEQUENTIAL, FRESH, num_, FLAGS_value_size, 1000);
372*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
373*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("fillrandom")) {
374*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, RANDOM, FRESH, num_, FLAGS_value_size, 1);
375*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
376*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("fillrandbatch")) {
377*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, RANDOM, FRESH, num_, FLAGS_value_size, 1000);
378*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
379*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("overwrite")) {
380*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, RANDOM, EXISTING, num_, FLAGS_value_size, 1);
381*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
382*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("overwritebatch")) {
383*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, RANDOM, EXISTING, num_, FLAGS_value_size, 1000);
384*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
385*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("fillrandsync")) {
386*9507f98cSAndroid Build Coastguard Worker         write_sync = true;
387*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, RANDOM, FRESH, num_ / 100, FLAGS_value_size, 1);
388*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
389*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("fillseqsync")) {
390*9507f98cSAndroid Build Coastguard Worker         write_sync = true;
391*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, SEQUENTIAL, FRESH, num_ / 100, FLAGS_value_size, 1);
392*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
393*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("fillrand100K")) {
394*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, RANDOM, FRESH, num_ / 1000, 100 * 1000, 1);
395*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
396*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("fillseq100K")) {
397*9507f98cSAndroid Build Coastguard Worker         Write(write_sync, SEQUENTIAL, FRESH, num_ / 1000, 100 * 1000, 1);
398*9507f98cSAndroid Build Coastguard Worker         WalCheckpoint(db_);
399*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("readseq")) {
400*9507f98cSAndroid Build Coastguard Worker         ReadSequential();
401*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("readrandom")) {
402*9507f98cSAndroid Build Coastguard Worker         Read(RANDOM, 1);
403*9507f98cSAndroid Build Coastguard Worker       } else if (name == Slice("readrand100K")) {
404*9507f98cSAndroid Build Coastguard Worker         int n = reads_;
405*9507f98cSAndroid Build Coastguard Worker         reads_ /= 1000;
406*9507f98cSAndroid Build Coastguard Worker         Read(RANDOM, 1);
407*9507f98cSAndroid Build Coastguard Worker         reads_ = n;
408*9507f98cSAndroid Build Coastguard Worker       } else {
409*9507f98cSAndroid Build Coastguard Worker         known = false;
410*9507f98cSAndroid Build Coastguard Worker         if (name != Slice()) {  // No error message for empty name
411*9507f98cSAndroid Build Coastguard Worker           std::fprintf(stderr, "unknown benchmark '%s'\n",
412*9507f98cSAndroid Build Coastguard Worker                        name.ToString().c_str());
413*9507f98cSAndroid Build Coastguard Worker         }
414*9507f98cSAndroid Build Coastguard Worker       }
415*9507f98cSAndroid Build Coastguard Worker       if (known) {
416*9507f98cSAndroid Build Coastguard Worker         Stop(name);
417*9507f98cSAndroid Build Coastguard Worker       }
418*9507f98cSAndroid Build Coastguard Worker     }
419*9507f98cSAndroid Build Coastguard Worker   }
420*9507f98cSAndroid Build Coastguard Worker 
Open()421*9507f98cSAndroid Build Coastguard Worker   void Open() {
422*9507f98cSAndroid Build Coastguard Worker     assert(db_ == nullptr);
423*9507f98cSAndroid Build Coastguard Worker 
424*9507f98cSAndroid Build Coastguard Worker     int status;
425*9507f98cSAndroid Build Coastguard Worker     char file_name[100];
426*9507f98cSAndroid Build Coastguard Worker     char* err_msg = nullptr;
427*9507f98cSAndroid Build Coastguard Worker     db_num_++;
428*9507f98cSAndroid Build Coastguard Worker 
429*9507f98cSAndroid Build Coastguard Worker     // Open database
430*9507f98cSAndroid Build Coastguard Worker     std::string tmp_dir;
431*9507f98cSAndroid Build Coastguard Worker     Env::Default()->GetTestDirectory(&tmp_dir);
432*9507f98cSAndroid Build Coastguard Worker     std::snprintf(file_name, sizeof(file_name), "%s/dbbench_sqlite3-%d.db",
433*9507f98cSAndroid Build Coastguard Worker                   tmp_dir.c_str(), db_num_);
434*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_open(file_name, &db_);
435*9507f98cSAndroid Build Coastguard Worker     if (status) {
436*9507f98cSAndroid Build Coastguard Worker       std::fprintf(stderr, "open error: %s\n", sqlite3_errmsg(db_));
437*9507f98cSAndroid Build Coastguard Worker       std::exit(1);
438*9507f98cSAndroid Build Coastguard Worker     }
439*9507f98cSAndroid Build Coastguard Worker 
440*9507f98cSAndroid Build Coastguard Worker     // Change SQLite cache size
441*9507f98cSAndroid Build Coastguard Worker     char cache_size[100];
442*9507f98cSAndroid Build Coastguard Worker     std::snprintf(cache_size, sizeof(cache_size), "PRAGMA cache_size = %d",
443*9507f98cSAndroid Build Coastguard Worker                   FLAGS_num_pages);
444*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_exec(db_, cache_size, nullptr, nullptr, &err_msg);
445*9507f98cSAndroid Build Coastguard Worker     ExecErrorCheck(status, err_msg);
446*9507f98cSAndroid Build Coastguard Worker 
447*9507f98cSAndroid Build Coastguard Worker     // FLAGS_page_size is defaulted to 1024
448*9507f98cSAndroid Build Coastguard Worker     if (FLAGS_page_size != 1024) {
449*9507f98cSAndroid Build Coastguard Worker       char page_size[100];
450*9507f98cSAndroid Build Coastguard Worker       std::snprintf(page_size, sizeof(page_size), "PRAGMA page_size = %d",
451*9507f98cSAndroid Build Coastguard Worker                     FLAGS_page_size);
452*9507f98cSAndroid Build Coastguard Worker       status = sqlite3_exec(db_, page_size, nullptr, nullptr, &err_msg);
453*9507f98cSAndroid Build Coastguard Worker       ExecErrorCheck(status, err_msg);
454*9507f98cSAndroid Build Coastguard Worker     }
455*9507f98cSAndroid Build Coastguard Worker 
456*9507f98cSAndroid Build Coastguard Worker     // Change journal mode to WAL if WAL enabled flag is on
457*9507f98cSAndroid Build Coastguard Worker     if (FLAGS_WAL_enabled) {
458*9507f98cSAndroid Build Coastguard Worker       std::string WAL_stmt = "PRAGMA journal_mode = WAL";
459*9507f98cSAndroid Build Coastguard Worker 
460*9507f98cSAndroid Build Coastguard Worker       // LevelDB's default cache size is a combined 4 MB
461*9507f98cSAndroid Build Coastguard Worker       std::string WAL_checkpoint = "PRAGMA wal_autocheckpoint = 4096";
462*9507f98cSAndroid Build Coastguard Worker       status = sqlite3_exec(db_, WAL_stmt.c_str(), nullptr, nullptr, &err_msg);
463*9507f98cSAndroid Build Coastguard Worker       ExecErrorCheck(status, err_msg);
464*9507f98cSAndroid Build Coastguard Worker       status =
465*9507f98cSAndroid Build Coastguard Worker           sqlite3_exec(db_, WAL_checkpoint.c_str(), nullptr, nullptr, &err_msg);
466*9507f98cSAndroid Build Coastguard Worker       ExecErrorCheck(status, err_msg);
467*9507f98cSAndroid Build Coastguard Worker     }
468*9507f98cSAndroid Build Coastguard Worker 
469*9507f98cSAndroid Build Coastguard Worker     // Change locking mode to exclusive and create tables/index for database
470*9507f98cSAndroid Build Coastguard Worker     std::string locking_stmt = "PRAGMA locking_mode = EXCLUSIVE";
471*9507f98cSAndroid Build Coastguard Worker     std::string create_stmt =
472*9507f98cSAndroid Build Coastguard Worker         "CREATE TABLE test (key blob, value blob, PRIMARY KEY(key))";
473*9507f98cSAndroid Build Coastguard Worker     if (!FLAGS_use_rowids) create_stmt += " WITHOUT ROWID";
474*9507f98cSAndroid Build Coastguard Worker     std::string stmt_array[] = {locking_stmt, create_stmt};
475*9507f98cSAndroid Build Coastguard Worker     int stmt_array_length = sizeof(stmt_array) / sizeof(std::string);
476*9507f98cSAndroid Build Coastguard Worker     for (int i = 0; i < stmt_array_length; i++) {
477*9507f98cSAndroid Build Coastguard Worker       status =
478*9507f98cSAndroid Build Coastguard Worker           sqlite3_exec(db_, stmt_array[i].c_str(), nullptr, nullptr, &err_msg);
479*9507f98cSAndroid Build Coastguard Worker       ExecErrorCheck(status, err_msg);
480*9507f98cSAndroid Build Coastguard Worker     }
481*9507f98cSAndroid Build Coastguard Worker   }
482*9507f98cSAndroid Build Coastguard Worker 
Write(bool write_sync,Order order,DBState state,int num_entries,int value_size,int entries_per_batch)483*9507f98cSAndroid Build Coastguard Worker   void Write(bool write_sync, Order order, DBState state, int num_entries,
484*9507f98cSAndroid Build Coastguard Worker              int value_size, int entries_per_batch) {
485*9507f98cSAndroid Build Coastguard Worker     // Create new database if state == FRESH
486*9507f98cSAndroid Build Coastguard Worker     if (state == FRESH) {
487*9507f98cSAndroid Build Coastguard Worker       if (FLAGS_use_existing_db) {
488*9507f98cSAndroid Build Coastguard Worker         message_ = "skipping (--use_existing_db is true)";
489*9507f98cSAndroid Build Coastguard Worker         return;
490*9507f98cSAndroid Build Coastguard Worker       }
491*9507f98cSAndroid Build Coastguard Worker       sqlite3_close(db_);
492*9507f98cSAndroid Build Coastguard Worker       db_ = nullptr;
493*9507f98cSAndroid Build Coastguard Worker       Open();
494*9507f98cSAndroid Build Coastguard Worker       Start();
495*9507f98cSAndroid Build Coastguard Worker     }
496*9507f98cSAndroid Build Coastguard Worker 
497*9507f98cSAndroid Build Coastguard Worker     if (num_entries != num_) {
498*9507f98cSAndroid Build Coastguard Worker       char msg[100];
499*9507f98cSAndroid Build Coastguard Worker       std::snprintf(msg, sizeof(msg), "(%d ops)", num_entries);
500*9507f98cSAndroid Build Coastguard Worker       message_ = msg;
501*9507f98cSAndroid Build Coastguard Worker     }
502*9507f98cSAndroid Build Coastguard Worker 
503*9507f98cSAndroid Build Coastguard Worker     char* err_msg = nullptr;
504*9507f98cSAndroid Build Coastguard Worker     int status;
505*9507f98cSAndroid Build Coastguard Worker 
506*9507f98cSAndroid Build Coastguard Worker     sqlite3_stmt *replace_stmt, *begin_trans_stmt, *end_trans_stmt;
507*9507f98cSAndroid Build Coastguard Worker     std::string replace_str = "REPLACE INTO test (key, value) VALUES (?, ?)";
508*9507f98cSAndroid Build Coastguard Worker     std::string begin_trans_str = "BEGIN TRANSACTION;";
509*9507f98cSAndroid Build Coastguard Worker     std::string end_trans_str = "END TRANSACTION;";
510*9507f98cSAndroid Build Coastguard Worker 
511*9507f98cSAndroid Build Coastguard Worker     // Check for synchronous flag in options
512*9507f98cSAndroid Build Coastguard Worker     std::string sync_stmt =
513*9507f98cSAndroid Build Coastguard Worker         (write_sync) ? "PRAGMA synchronous = FULL" : "PRAGMA synchronous = OFF";
514*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_exec(db_, sync_stmt.c_str(), nullptr, nullptr, &err_msg);
515*9507f98cSAndroid Build Coastguard Worker     ExecErrorCheck(status, err_msg);
516*9507f98cSAndroid Build Coastguard Worker 
517*9507f98cSAndroid Build Coastguard Worker     // Preparing sqlite3 statements
518*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_prepare_v2(db_, replace_str.c_str(), -1, &replace_stmt,
519*9507f98cSAndroid Build Coastguard Worker                                 nullptr);
520*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
521*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_prepare_v2(db_, begin_trans_str.c_str(), -1,
522*9507f98cSAndroid Build Coastguard Worker                                 &begin_trans_stmt, nullptr);
523*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
524*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_prepare_v2(db_, end_trans_str.c_str(), -1, &end_trans_stmt,
525*9507f98cSAndroid Build Coastguard Worker                                 nullptr);
526*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
527*9507f98cSAndroid Build Coastguard Worker 
528*9507f98cSAndroid Build Coastguard Worker     bool transaction = (entries_per_batch > 1);
529*9507f98cSAndroid Build Coastguard Worker     for (int i = 0; i < num_entries; i += entries_per_batch) {
530*9507f98cSAndroid Build Coastguard Worker       // Begin write transaction
531*9507f98cSAndroid Build Coastguard Worker       if (FLAGS_transaction && transaction) {
532*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_step(begin_trans_stmt);
533*9507f98cSAndroid Build Coastguard Worker         StepErrorCheck(status);
534*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_reset(begin_trans_stmt);
535*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
536*9507f98cSAndroid Build Coastguard Worker       }
537*9507f98cSAndroid Build Coastguard Worker 
538*9507f98cSAndroid Build Coastguard Worker       // Create and execute SQL statements
539*9507f98cSAndroid Build Coastguard Worker       for (int j = 0; j < entries_per_batch; j++) {
540*9507f98cSAndroid Build Coastguard Worker         const char* value = gen_.Generate(value_size).data();
541*9507f98cSAndroid Build Coastguard Worker 
542*9507f98cSAndroid Build Coastguard Worker         // Create values for key-value pair
543*9507f98cSAndroid Build Coastguard Worker         const int k =
544*9507f98cSAndroid Build Coastguard Worker             (order == SEQUENTIAL) ? i + j : (rand_.Next() % num_entries);
545*9507f98cSAndroid Build Coastguard Worker         char key[100];
546*9507f98cSAndroid Build Coastguard Worker         std::snprintf(key, sizeof(key), "%016d", k);
547*9507f98cSAndroid Build Coastguard Worker 
548*9507f98cSAndroid Build Coastguard Worker         // Bind KV values into replace_stmt
549*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_bind_blob(replace_stmt, 1, key, 16, SQLITE_STATIC);
550*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
551*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_bind_blob(replace_stmt, 2, value, value_size,
552*9507f98cSAndroid Build Coastguard Worker                                    SQLITE_STATIC);
553*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
554*9507f98cSAndroid Build Coastguard Worker 
555*9507f98cSAndroid Build Coastguard Worker         // Execute replace_stmt
556*9507f98cSAndroid Build Coastguard Worker         bytes_ += value_size + strlen(key);
557*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_step(replace_stmt);
558*9507f98cSAndroid Build Coastguard Worker         StepErrorCheck(status);
559*9507f98cSAndroid Build Coastguard Worker 
560*9507f98cSAndroid Build Coastguard Worker         // Reset SQLite statement for another use
561*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_clear_bindings(replace_stmt);
562*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
563*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_reset(replace_stmt);
564*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
565*9507f98cSAndroid Build Coastguard Worker 
566*9507f98cSAndroid Build Coastguard Worker         FinishedSingleOp();
567*9507f98cSAndroid Build Coastguard Worker       }
568*9507f98cSAndroid Build Coastguard Worker 
569*9507f98cSAndroid Build Coastguard Worker       // End write transaction
570*9507f98cSAndroid Build Coastguard Worker       if (FLAGS_transaction && transaction) {
571*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_step(end_trans_stmt);
572*9507f98cSAndroid Build Coastguard Worker         StepErrorCheck(status);
573*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_reset(end_trans_stmt);
574*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
575*9507f98cSAndroid Build Coastguard Worker       }
576*9507f98cSAndroid Build Coastguard Worker     }
577*9507f98cSAndroid Build Coastguard Worker 
578*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_finalize(replace_stmt);
579*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
580*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_finalize(begin_trans_stmt);
581*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
582*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_finalize(end_trans_stmt);
583*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
584*9507f98cSAndroid Build Coastguard Worker   }
585*9507f98cSAndroid Build Coastguard Worker 
Read(Order order,int entries_per_batch)586*9507f98cSAndroid Build Coastguard Worker   void Read(Order order, int entries_per_batch) {
587*9507f98cSAndroid Build Coastguard Worker     int status;
588*9507f98cSAndroid Build Coastguard Worker     sqlite3_stmt *read_stmt, *begin_trans_stmt, *end_trans_stmt;
589*9507f98cSAndroid Build Coastguard Worker 
590*9507f98cSAndroid Build Coastguard Worker     std::string read_str = "SELECT * FROM test WHERE key = ?";
591*9507f98cSAndroid Build Coastguard Worker     std::string begin_trans_str = "BEGIN TRANSACTION;";
592*9507f98cSAndroid Build Coastguard Worker     std::string end_trans_str = "END TRANSACTION;";
593*9507f98cSAndroid Build Coastguard Worker 
594*9507f98cSAndroid Build Coastguard Worker     // Preparing sqlite3 statements
595*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_prepare_v2(db_, begin_trans_str.c_str(), -1,
596*9507f98cSAndroid Build Coastguard Worker                                 &begin_trans_stmt, nullptr);
597*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
598*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_prepare_v2(db_, end_trans_str.c_str(), -1, &end_trans_stmt,
599*9507f98cSAndroid Build Coastguard Worker                                 nullptr);
600*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
601*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_prepare_v2(db_, read_str.c_str(), -1, &read_stmt, nullptr);
602*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
603*9507f98cSAndroid Build Coastguard Worker 
604*9507f98cSAndroid Build Coastguard Worker     bool transaction = (entries_per_batch > 1);
605*9507f98cSAndroid Build Coastguard Worker     for (int i = 0; i < reads_; i += entries_per_batch) {
606*9507f98cSAndroid Build Coastguard Worker       // Begin read transaction
607*9507f98cSAndroid Build Coastguard Worker       if (FLAGS_transaction && transaction) {
608*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_step(begin_trans_stmt);
609*9507f98cSAndroid Build Coastguard Worker         StepErrorCheck(status);
610*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_reset(begin_trans_stmt);
611*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
612*9507f98cSAndroid Build Coastguard Worker       }
613*9507f98cSAndroid Build Coastguard Worker 
614*9507f98cSAndroid Build Coastguard Worker       // Create and execute SQL statements
615*9507f98cSAndroid Build Coastguard Worker       for (int j = 0; j < entries_per_batch; j++) {
616*9507f98cSAndroid Build Coastguard Worker         // Create key value
617*9507f98cSAndroid Build Coastguard Worker         char key[100];
618*9507f98cSAndroid Build Coastguard Worker         int k = (order == SEQUENTIAL) ? i + j : (rand_.Next() % reads_);
619*9507f98cSAndroid Build Coastguard Worker         std::snprintf(key, sizeof(key), "%016d", k);
620*9507f98cSAndroid Build Coastguard Worker 
621*9507f98cSAndroid Build Coastguard Worker         // Bind key value into read_stmt
622*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_bind_blob(read_stmt, 1, key, 16, SQLITE_STATIC);
623*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
624*9507f98cSAndroid Build Coastguard Worker 
625*9507f98cSAndroid Build Coastguard Worker         // Execute read statement
626*9507f98cSAndroid Build Coastguard Worker         while ((status = sqlite3_step(read_stmt)) == SQLITE_ROW) {
627*9507f98cSAndroid Build Coastguard Worker         }
628*9507f98cSAndroid Build Coastguard Worker         StepErrorCheck(status);
629*9507f98cSAndroid Build Coastguard Worker 
630*9507f98cSAndroid Build Coastguard Worker         // Reset SQLite statement for another use
631*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_clear_bindings(read_stmt);
632*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
633*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_reset(read_stmt);
634*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
635*9507f98cSAndroid Build Coastguard Worker         FinishedSingleOp();
636*9507f98cSAndroid Build Coastguard Worker       }
637*9507f98cSAndroid Build Coastguard Worker 
638*9507f98cSAndroid Build Coastguard Worker       // End read transaction
639*9507f98cSAndroid Build Coastguard Worker       if (FLAGS_transaction && transaction) {
640*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_step(end_trans_stmt);
641*9507f98cSAndroid Build Coastguard Worker         StepErrorCheck(status);
642*9507f98cSAndroid Build Coastguard Worker         status = sqlite3_reset(end_trans_stmt);
643*9507f98cSAndroid Build Coastguard Worker         ErrorCheck(status);
644*9507f98cSAndroid Build Coastguard Worker       }
645*9507f98cSAndroid Build Coastguard Worker     }
646*9507f98cSAndroid Build Coastguard Worker 
647*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_finalize(read_stmt);
648*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
649*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_finalize(begin_trans_stmt);
650*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
651*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_finalize(end_trans_stmt);
652*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
653*9507f98cSAndroid Build Coastguard Worker   }
654*9507f98cSAndroid Build Coastguard Worker 
ReadSequential()655*9507f98cSAndroid Build Coastguard Worker   void ReadSequential() {
656*9507f98cSAndroid Build Coastguard Worker     int status;
657*9507f98cSAndroid Build Coastguard Worker     sqlite3_stmt* pStmt;
658*9507f98cSAndroid Build Coastguard Worker     std::string read_str = "SELECT * FROM test ORDER BY key";
659*9507f98cSAndroid Build Coastguard Worker 
660*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_prepare_v2(db_, read_str.c_str(), -1, &pStmt, nullptr);
661*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
662*9507f98cSAndroid Build Coastguard Worker     for (int i = 0; i < reads_ && SQLITE_ROW == sqlite3_step(pStmt); i++) {
663*9507f98cSAndroid Build Coastguard Worker       bytes_ += sqlite3_column_bytes(pStmt, 1) + sqlite3_column_bytes(pStmt, 2);
664*9507f98cSAndroid Build Coastguard Worker       FinishedSingleOp();
665*9507f98cSAndroid Build Coastguard Worker     }
666*9507f98cSAndroid Build Coastguard Worker 
667*9507f98cSAndroid Build Coastguard Worker     status = sqlite3_finalize(pStmt);
668*9507f98cSAndroid Build Coastguard Worker     ErrorCheck(status);
669*9507f98cSAndroid Build Coastguard Worker   }
670*9507f98cSAndroid Build Coastguard Worker };
671*9507f98cSAndroid Build Coastguard Worker 
672*9507f98cSAndroid Build Coastguard Worker }  // namespace leveldb
673*9507f98cSAndroid Build Coastguard Worker 
main(int argc,char ** argv)674*9507f98cSAndroid Build Coastguard Worker int main(int argc, char** argv) {
675*9507f98cSAndroid Build Coastguard Worker   std::string default_db_path;
676*9507f98cSAndroid Build Coastguard Worker   for (int i = 1; i < argc; i++) {
677*9507f98cSAndroid Build Coastguard Worker     double d;
678*9507f98cSAndroid Build Coastguard Worker     int n;
679*9507f98cSAndroid Build Coastguard Worker     char junk;
680*9507f98cSAndroid Build Coastguard Worker     if (leveldb::Slice(argv[i]).starts_with("--benchmarks=")) {
681*9507f98cSAndroid Build Coastguard Worker       FLAGS_benchmarks = argv[i] + strlen("--benchmarks=");
682*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--histogram=%d%c", &n, &junk) == 1 &&
683*9507f98cSAndroid Build Coastguard Worker                (n == 0 || n == 1)) {
684*9507f98cSAndroid Build Coastguard Worker       FLAGS_histogram = n;
685*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--compression_ratio=%lf%c", &d, &junk) == 1) {
686*9507f98cSAndroid Build Coastguard Worker       FLAGS_compression_ratio = d;
687*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--use_existing_db=%d%c", &n, &junk) == 1 &&
688*9507f98cSAndroid Build Coastguard Worker                (n == 0 || n == 1)) {
689*9507f98cSAndroid Build Coastguard Worker       FLAGS_use_existing_db = n;
690*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--use_rowids=%d%c", &n, &junk) == 1 &&
691*9507f98cSAndroid Build Coastguard Worker                (n == 0 || n == 1)) {
692*9507f98cSAndroid Build Coastguard Worker       FLAGS_use_rowids = n;
693*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--num=%d%c", &n, &junk) == 1) {
694*9507f98cSAndroid Build Coastguard Worker       FLAGS_num = n;
695*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--reads=%d%c", &n, &junk) == 1) {
696*9507f98cSAndroid Build Coastguard Worker       FLAGS_reads = n;
697*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--value_size=%d%c", &n, &junk) == 1) {
698*9507f98cSAndroid Build Coastguard Worker       FLAGS_value_size = n;
699*9507f98cSAndroid Build Coastguard Worker     } else if (leveldb::Slice(argv[i]) == leveldb::Slice("--no_transaction")) {
700*9507f98cSAndroid Build Coastguard Worker       FLAGS_transaction = false;
701*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--page_size=%d%c", &n, &junk) == 1) {
702*9507f98cSAndroid Build Coastguard Worker       FLAGS_page_size = n;
703*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--num_pages=%d%c", &n, &junk) == 1) {
704*9507f98cSAndroid Build Coastguard Worker       FLAGS_num_pages = n;
705*9507f98cSAndroid Build Coastguard Worker     } else if (sscanf(argv[i], "--WAL_enabled=%d%c", &n, &junk) == 1 &&
706*9507f98cSAndroid Build Coastguard Worker                (n == 0 || n == 1)) {
707*9507f98cSAndroid Build Coastguard Worker       FLAGS_WAL_enabled = n;
708*9507f98cSAndroid Build Coastguard Worker     } else if (strncmp(argv[i], "--db=", 5) == 0) {
709*9507f98cSAndroid Build Coastguard Worker       FLAGS_db = argv[i] + 5;
710*9507f98cSAndroid Build Coastguard Worker     } else {
711*9507f98cSAndroid Build Coastguard Worker       std::fprintf(stderr, "Invalid flag '%s'\n", argv[i]);
712*9507f98cSAndroid Build Coastguard Worker       std::exit(1);
713*9507f98cSAndroid Build Coastguard Worker     }
714*9507f98cSAndroid Build Coastguard Worker   }
715*9507f98cSAndroid Build Coastguard Worker 
716*9507f98cSAndroid Build Coastguard Worker   // Choose a location for the test database if none given with --db=<path>
717*9507f98cSAndroid Build Coastguard Worker   if (FLAGS_db == nullptr) {
718*9507f98cSAndroid Build Coastguard Worker     leveldb::Env::Default()->GetTestDirectory(&default_db_path);
719*9507f98cSAndroid Build Coastguard Worker     default_db_path += "/dbbench";
720*9507f98cSAndroid Build Coastguard Worker     FLAGS_db = default_db_path.c_str();
721*9507f98cSAndroid Build Coastguard Worker   }
722*9507f98cSAndroid Build Coastguard Worker 
723*9507f98cSAndroid Build Coastguard Worker   leveldb::Benchmark benchmark;
724*9507f98cSAndroid Build Coastguard Worker   benchmark.Run();
725*9507f98cSAndroid Build Coastguard Worker   return 0;
726*9507f98cSAndroid Build Coastguard Worker }
727