test/startup.c

   1 /*
   2 ** 2021-01-01
   3 **
   4 ** The author disclaims copyright to this source code.  In place of
   5 ** a legal notice, here is a blessing:
   6 **
   7 **    May you do good and not evil.
   8 **    May you find forgiveness for yourself and forgive others.
   9 **    May you share freely, never taking more than you give.
  10 **
  11 *************************************************************************
  12 **
  13 ** This file implements a program used to measure the start-up performance
  14 ** of SQLite.
  15 **
  16 ** To use:
  17 **
  18 **     ./startup init
  19 **     valgrind --tool=cachegrind ./startup run
  20 **
  21 **
  22 ** The "./startup init" command creates the test database file named
  23 ** "startup.db".  The performance test is run by the "./startup run"
  24 ** command.  That command does nothing but open the database file and
  25 ** parse the entire schema.
  26 */
  27 #include <stdio.h>
  28 #include <unistd.h>
  29 #include <string.h>
  30 #include <stdlib.h>
  31 #include <ctype.h>
  32 #include "sqlite3.h"
  33
  34 static const char zHelp[] =
  35   "Usage: %s COMMAND\n"
  36   "Commands:\n"
  37   "  init                Initialized the startup.db database file\n"
  38   "  run                 Run the startup performance test\n"
  39   "Options:\n"
  40   "  --dbname NAME       Set the name of the test database file\n"
  41   "  --heap SZ MIN       Memory allocator uses SZ bytes & min allocation MIN\n"
  42   "  --stats             Show statistics at the end\n"
  43 /* TBD
  44   "  --journal M         Set the journal_mode to M\n"
  45   "  --lookaside N SZ    Configure lookaside for N slots of SZ bytes each\n"
  46   "  --mmap SZ           MMAP the first SZ bytes of the database file\n"
  47   "  --multithread       Set multithreaded mode\n"
  48   "  --nomemstat         Disable memory statistics\n"
  49   "  --pagesize N        Set the page size to N\n"
  50   "  --pcache N SZ       Configure N pages of pagecache each of size SZ bytes\n"
  51   "  --serialized        Set serialized threading mode\n"
  52   "  --singlethread      Set single-threaded mode - disables all mutexing\n"
  53   "  --utf16be           Set text encoding to UTF-16BE\n"
  54   "  --utf16le           Set text encoding to UTF-16LE\n"
  55   "  --utf8              Set text encoding to UTF-8\n"
  56 */
  57 ;
  58
  59 static void usage(const char *argv0){
  60   printf(zHelp, argv0);
  61   exit(1);
  62 }
  63
  64 /*
  65 ** The test schema is derived from the Fossil repository for SQLite itself.
  66 ** The schema covers the repository, the local checkout database, and
  67 ** the global configuration database.
  68 */
  69 static const char zTestSchema[] =
  70   "CREATE TABLE repo_blob(\n"
  71   "  rid INTEGER PRIMARY KEY,\n"
  72   "  rcvid INTEGER,\n"
  73   "  size INTEGER,\n"
  74   "  uuid TEXT UNIQUE NOT NULL,\n"
  75   "  content BLOB,\n"
  76   "  CHECK( length(uuid)>=40 AND rid>0 )\n"
  77   ");\n"
  78   "CREATE TABLE repo_delta(\n"
  79   "  rid INTEGER PRIMARY KEY,\n"
  80   "  srcid INTEGER NOT NULL REFERENCES blob\n"
  81   ");\n"
  82   "CREATE TABLE repo_rcvfrom(\n"
  83   "  rcvid INTEGER PRIMARY KEY,\n"
  84   "  uid INTEGER REFERENCES user,\n"
  85   "  mtime DATETIME,\n"
  86   "  nonce TEXT UNIQUE,\n"
  87   "  ipaddr TEXT\n"
  88   ");\n"
  89   "CREATE TABLE repo_private(rid INTEGER PRIMARY KEY);\n"
  90   "CREATE TABLE repo_accesslog(\n"
  91   "  uname TEXT,\n"
  92   "  ipaddr TEXT,\n"
  93   "  success BOOLEAN,\n"
  94   "  mtime TIMESTAMP);\n"
  95   "CREATE TABLE repo_user(\n"
  96   "  uid INTEGER PRIMARY KEY,\n"
  97   "  login TEXT UNIQUE,\n"
  98   "  pw TEXT,\n"
  99   "  cap TEXT,\n"
 100   "  cookie TEXT,\n"
 101   "  ipaddr TEXT,\n"
 102   "  cexpire DATETIME,\n"
 103   "  info TEXT,\n"
 104   "  mtime DATE,\n"
 105   "  photo BLOB\n"
 106   ");\n"
 107   "CREATE TABLE repo_reportfmt(\n"
 108   "   rn INTEGER PRIMARY KEY,\n"
 109   "   owner TEXT,\n"
 110   "   title TEXT UNIQUE,\n"
 111   "   mtime INTEGER,\n"
 112   "   cols TEXT,\n"
 113   "   sqlcode TEXT\n"
 114   ");\n"
 115   "CREATE TABLE repo_sqlite_stat2(tbl,idx,sampleno,sample);\n"
 116   "CREATE TABLE repo_sqlite_stat1(tbl,idx,stat);\n"
 117   "CREATE TABLE repo_sqlite_stat3(tbl,idx,neq,nlt,ndlt,sample);\n"
 118   "CREATE TABLE repo_config(\n"
 119   "  name TEXT PRIMARY KEY NOT NULL,\n"
 120   "  value CLOB, mtime INTEGER,\n"
 121   "  CHECK( typeof(name)='text' AND length(name)>=1 )\n"
 122   ") WITHOUT ROWID;\n"
 123   "CREATE TABLE repo_shun(uuid PRIMARY KEY,\n"
 124   "  mtime INTEGER,\n"
 125   "  scom TEXT) WITHOUT ROWID;\n"
 126   "CREATE TABLE repo_concealed(\n"
 127   "  hash TEXT PRIMARY KEY,\n"
 128   "  content TEXT\n"
 129   ", mtime INTEGER) WITHOUT ROWID;\n"
 130   "CREATE TABLE repo_admin_log(\n"
 131   " id INTEGER PRIMARY KEY,\n"
 132   " time INTEGER, -- Seconds since 1970\n"
 133   " page TEXT,    -- path of page\n"
 134   " who TEXT,     -- User who made the change\n"
 135   "  what TEXT     -- What changed\n"
 136   ");\n"
 137   "CREATE TABLE repo_unversioned(\n"
 138   "  name TEXT PRIMARY KEY,\n"
 139   "  rcvid INTEGER,\n"
 140   "  mtime DATETIME,\n"
 141   "  hash TEXT,\n"
 142   "  sz INTEGER,\n"
 143   "  encoding INT,\n"
 144   "  content BLOB\n"
 145   ") WITHOUT ROWID;\n"
 146   "CREATE TABLE repo_subscriber(\n"
 147   "  subscriberId INTEGER PRIMARY KEY,\n"
 148   "  subscriberCode BLOB DEFAULT (randomblob(32)) UNIQUE,\n"
 149   "  semail TEXT UNIQUE COLLATE nocase,\n"
 150   "  suname TEXT,\n"
 151   "  sverified BOOLEAN DEFAULT true,\n"
 152   "  sdonotcall BOOLEAN,\n"
 153   "  sdigest BOOLEAN,\n"
 154   "  ssub TEXT,\n"
 155   "  sctime INTDATE,\n"
 156   "  mtime INTDATE,\n"
 157   "  smip TEXT\n"
 158   ");\n"
 159   "CREATE TABLE repo_pending_alert(\n"
 160   "  eventid TEXT PRIMARY KEY,\n"
 161   "  sentSep BOOLEAN DEFAULT false,\n"
 162   "  sentDigest BOOLEAN DEFAULT false\n"
 163   ", sentMod BOOLEAN DEFAULT false) WITHOUT ROWID;\n"
 164   "CREATE INDEX repo_delta_i1 ON repo_delta(srcid);\n"
 165   "CREATE INDEX repo_blob_rcvid ON repo_blob(rcvid);\n"
 166   "CREATE INDEX repo_subscriberUname\n"
 167   "  ON repo_subscriber(suname) WHERE suname IS NOT NULL;\n"
 168   "CREATE VIEW repo_artifact(rid,rcvid,size,atype,srcid,hash,content) AS\n"
 169   "     SELECT blob.rid,rcvid,size,1,srcid,uuid,content\n"
 170   "       FROM repo_blob LEFT JOIN repo_delta ON (blob.rid=delta.rid);\n"
 171   "CREATE TABLE repo_filename(\n"
 172   "  fnid INTEGER PRIMARY KEY,\n"
 173   "  name TEXT UNIQUE\n"
 174   ");\n"
 175   "CREATE TABLE repo_mlink(\n"
 176   "  mid INTEGER,\n"
 177   "  fid INTEGER,\n"
 178   "  pmid INTEGER,\n"
 179   "  pid INTEGER,\n"
 180   "  fnid INTEGER REFERENCES filename,\n"
 181   "  pfnid INTEGER,\n"
 182   "  mperm INTEGER,\n"
 183   "  isaux BOOLEAN DEFAULT 0\n"
 184   ");\n"
 185   "CREATE INDEX repo_mlink_i1 ON repo_mlink(mid);\n"
 186   "CREATE INDEX repo_mlink_i2 ON repo_mlink(fnid);\n"
 187   "CREATE INDEX repo_mlink_i3 ON repo_mlink(fid);\n"
 188   "CREATE INDEX repo_mlink_i4 ON repo_mlink(pid);\n"
 189   "CREATE TABLE repo_plink(\n"
 190   "  pid INTEGER REFERENCES blob,\n"
 191   "  cid INTEGER REFERENCES blob,\n"
 192   "  isprim BOOLEAN,\n"
 193   "  mtime DATETIME,\n"
 194   "  baseid INTEGER REFERENCES blob,\n"
 195   "  UNIQUE(pid, cid)\n"
 196   ");\n"
 197   "CREATE INDEX repo_plink_i2 ON repo_plink(cid,pid);\n"
 198   "CREATE TABLE repo_leaf(rid INTEGER PRIMARY KEY);\n"
 199   "CREATE TABLE repo_event(\n"
 200   "  type TEXT,\n"
 201   "  mtime DATETIME,\n"
 202   "  objid INTEGER PRIMARY KEY,\n"
 203   "  tagid INTEGER,\n"
 204   "  uid INTEGER REFERENCES user,\n"
 205   "  bgcolor TEXT,\n"
 206   "  euser TEXT,\n"
 207   "  user TEXT,\n"
 208   "  ecomment TEXT,\n"
 209   "  comment TEXT,\n"
 210   "  brief TEXT,\n"
 211   "  omtime DATETIME\n"
 212   ");\n"
 213   "CREATE INDEX repo_event_i1 ON repo_event(mtime);\n"
 214   "CREATE TABLE repo_phantom(\n"
 215   "  rid INTEGER PRIMARY KEY\n"
 216   ");\n"
 217   "CREATE TABLE repo_orphan(\n"
 218   "  rid INTEGER PRIMARY KEY,\n"
 219   "  baseline INTEGER\n"
 220   ");\n"
 221   "CREATE INDEX repo_orphan_baseline ON repo_orphan(baseline);\n"
 222   "CREATE TABLE repo_unclustered(\n"
 223   "  rid INTEGER PRIMARY KEY\n"
 224   ");\n"
 225   "CREATE TABLE repo_unsent(\n"
 226   "  rid INTEGER PRIMARY KEY\n"
 227   ");\n"
 228   "CREATE TABLE repo_tag(\n"
 229   "  tagid INTEGER PRIMARY KEY,\n"
 230   "  tagname TEXT UNIQUE\n"
 231   ");\n"
 232   "CREATE TABLE repo_tagxref(\n"
 233   "  tagid INTEGER REFERENCES tag,\n"
 234   "  tagtype INTEGER,\n"
 235   "  srcid INTEGER REFERENCES blob,\n"
 236   "  origid INTEGER REFERENCES blob,\n"
 237   "  value TEXT,\n"
 238   "  mtime TIMESTAMP,\n"
 239   "  rid INTEGER REFERENCE blob,\n"
 240   "  UNIQUE(rid, tagid)\n"
 241   ");\n"
 242   "CREATE INDEX repo_tagxref_i1 ON repo_tagxref(tagid, mtime);\n"
 243   "CREATE TABLE repo_backlink(\n"
 244   "  target TEXT,\n"
 245   "  srctype INT,\n"
 246   "  srcid INT,\n"
 247   "  mtime TIMESTAMP,\n"
 248   "  UNIQUE(target, srctype, srcid)\n"
 249   ");\n"
 250   "CREATE INDEX repo_backlink_src ON repo_backlink(srcid, srctype);\n"
 251   "CREATE TABLE repo_attachment(\n"
 252   "  attachid INTEGER PRIMARY KEY,\n"
 253   "  isLatest BOOLEAN DEFAULT 0,\n"
 254   "  mtime TIMESTAMP,\n"
 255   "  src TEXT,\n"
 256   "  target TEXT,\n"
 257   "  filename TEXT,\n"
 258   "  comment TEXT,\n"
 259   "  user TEXT\n"
 260   ");\n"
 261   "CREATE INDEX repo_attachment_idx1\n"
 262   " ON repo_attachment(target, filename, mtime);\n"
 263   "CREATE INDEX repo_attachment_idx2 ON repo_attachment(src);\n"
 264   "CREATE TABLE repo_cherrypick(\n"
 265   "  parentid INT,\n"
 266   "  childid INT,\n"
 267   "  isExclude BOOLEAN DEFAULT false,\n"
 268   "  PRIMARY KEY(parentid, childid)\n"
 269   ") WITHOUT ROWID;\n"
 270   "CREATE INDEX repo_cherrypick_cid ON repo_cherrypick(childid);\n"
 271   "CREATE TABLE repo_ticket(\n"
 272   "  -- Do not change any column that begins with tkt_\n"
 273   "  tkt_id INTEGER PRIMARY KEY,\n"
 274   "  tkt_uuid TEXT UNIQUE,\n"
 275   "  tkt_mtime DATE,\n"
 276   "  tkt_ctime DATE,\n"
 277   "  -- Add as many fields as required below this line\n"
 278   "  type TEXT,\n"
 279   "  status TEXT,\n"
 280   "  subsystem TEXT,\n"
 281   "  priority TEXT,\n"
 282   "  severity TEXT,\n"
 283   "  foundin TEXT,\n"
 284   "  private_contact TEXT,\n"
 285   "  resolution TEXT,\n"
 286   "  title TEXT,\n"
 287   "  comment TEXT\n"
 288   ");\n"
 289   "CREATE TABLE repo_ticketchng(\n"
 290   "  -- Do not change any column that begins with tkt_\n"
 291   "  tkt_id INTEGER REFERENCES ticket,\n"
 292   "  tkt_rid INTEGER REFERENCES blob,\n"
 293   "  tkt_mtime DATE,\n"
 294   "  -- Add as many fields as required below this line\n"
 295   "  login TEXT,\n"
 296   "  username TEXT,\n"
 297   "  mimetype TEXT,\n"
 298   "  icomment TEXT\n"
 299   ");\n"
 300   "CREATE INDEX repo_ticketchng_idx1 ON repo_ticketchng(tkt_id, tkt_mtime);\n"
 301   "CREATE TRIGGER repo_alert_trigger1\n"
 302   "AFTER INSERT ON repo_event BEGIN\n"
 303   "  INSERT INTO repo_pending_alert(eventid)\n"
 304   "    SELECT printf('%.1c%d',new.type,new.objid) WHERE true\n"
 305   "    ON CONFLICT(eventId) DO NOTHING;\n"
 306   "END;\n"
 307   "CREATE TABLE repo_vcache(\n"
 308   "  vid INTEGER,         -- check-in ID\n"
 309   "  fname TEXT,          -- filename\n"
 310   "  rid INTEGER,         -- artifact ID\n"
 311   "  PRIMARY KEY(vid,fname)\n"
 312   ") WITHOUT ROWID;\n"
 313   "CREATE TABLE localdb_vvar(\n"
 314   "  name TEXT PRIMARY KEY NOT NULL,\n"
 315   "  value CLOB,\n"
 316   "  CHECK( typeof(name)='text' AND length(name)>=1 )\n"
 317   ");\n"
 318   "CREATE TABLE localdb_vfile(\n"
 319   "  id INTEGER PRIMARY KEY,\n"
 320   "  vid INTEGER REFERENCES blob,\n"
 321   "  chnged INT DEFAULT 0,\n"
 322   "  deleted BOOLEAN DEFAULT 0,\n"
 323   "  isexe BOOLEAN,\n"
 324   "  islink BOOLEAN,\n"
 325   "  rid INTEGER,\n"
 326   "  mrid INTEGER,\n"
 327   "  mtime INTEGER,\n"
 328   "  pathname TEXT,\n"
 329   "  origname TEXT, mhash,\n"
 330   "  UNIQUE(pathname,vid)\n"
 331   ");\n"
 332   "CREATE TABLE localdb_sqlite_stat1(tbl,idx,stat);\n"
 333   "CREATE TABLE localdb_vcache(\n"
 334   "  vid INTEGER,         -- check-in ID\n"
 335   "  fname TEXT,          -- filename\n"
 336   "  rid INTEGER,         -- artifact ID\n"
 337   "  PRIMARY KEY(vid,fname)\n"
 338   ") WITHOUT ROWID;\n"
 339   "CREATE TABLE localdb_stash(\n"
 340   "  stashid INTEGER PRIMARY KEY,\n"
 341   "  vid INTEGER,\n"
 342   "  hash TEXT,\n"
 343   "  comment TEXT,\n"
 344   "  ctime TIMESTAMP\n"
 345   ");\n"
 346   "CREATE TABLE localdb_stashfile(\n"
 347   "  stashid INTEGER REFERENCES stash,\n"
 348   "  isAdded BOOLEAN,\n"
 349   "  isRemoved BOOLEAN,\n"
 350   "  isExec BOOLEAN,\n"
 351   "  isLink BOOLEAN,\n"
 352   "  rid INTEGER,\n"
 353   "  hash TEXT,\n"
 354   "  origname TEXT,\n"
 355   "  newname TEXT,\n"
 356   "  delta BLOB,\n"
 357   "  PRIMARY KEY(newname, stashid)\n"
 358   ");\n"
 359   "CREATE TABLE localdb_vmerge(\n"
 360   "  id INTEGER REFERENCES vfile,\n"
 361   "  merge INTEGER,\n"
 362   "  mhash TEXT\n"
 363   ");\n"
 364   "CREATE UNIQUE INDEX localdb_vmergex1 ON localdb_vmerge(id,mhash);\n"
 365   "CREATE TRIGGER localdb_vmerge_ck1 AFTER INSERT ON localdb_vmerge\n"
 366   "WHEN new.mhash IS NULL BEGIN\n"
 367   "  SELECT raise(FAIL,\n"
 368   "  'trying to update a newer checkout with an older version of Fossil');\n"
 369   "END;\n"
 370   "CREATE TABLE configdb_global_config(\n"
 371   "  name TEXT PRIMARY KEY,\n"
 372   "  value TEXT\n"
 373   ");\n"
 374   "CREATE TABLE configdb_sqlite_stat1(tbl,idx,stat);\n"
 375 ;
 376
 377 #ifdef __linux__
 378 #include <sys/types.h>
 379 #include <unistd.h>
 380
 381 /*
 382 ** Attempt to display I/O stats on Linux using /proc/PID/io
 383 */
 384 static void displayLinuxIoStats(FILE *out){
 385   FILE *in;
 386   char z[200];
 387   sqlite3_snprintf(sizeof(z), z, "/proc/%d/io", getpid());
 388   in = fopen(z, "rb");
 389   if( in==0 ) return;
 390   while( fgets(z, sizeof(z), in)!=0 ){
 391     static const struct {
 392       const char *zPattern;
 393       const char *zDesc;
 394     } aTrans[] = {
 395       { "rchar: ",                  "Bytes received by read():" },
 396       { "wchar: ",                  "Bytes sent to write():"    },
 397       { "syscr: ",                  "Read() system calls:"      },
 398       { "syscw: ",                  "Write() system calls:"     },
 399       { "read_bytes: ",             "Bytes rcvd from storage:"  },
 400       { "write_bytes: ",            "Bytes sent to storage:"    },
 401       { "cancelled_write_bytes: ",  "Cancelled write bytes:"    },
 402     };
 403     int i;
 404     for(i=0; i<sizeof(aTrans)/sizeof(aTrans[0]); i++){
 405       int n = (int)strlen(aTrans[i].zPattern);
 406       if( strncmp(aTrans[i].zPattern, z, n)==0 ){
 407         fprintf(out, "-- %-28s %s", aTrans[i].zDesc, &z[n]);
 408         break;
 409       }
 410     }
 411   }
 412   fclose(in);
 413 }
 414 #endif
 415
 416 /*
 417 ** Return the value of a hexadecimal digit.  Return -1 if the input
 418 ** is not a hex digit.
 419 */
 420 static int hexDigitValue(char c){
 421   if( c>='0' && c<='9' ) return c - '0';
 422   if( c>='a' && c<='f' ) return c - 'a' + 10;
 423   if( c>='A' && c<='F' ) return c - 'A' + 10;
 424   return -1;
 425 }
 426
 427 /*
 428 ** Interpret zArg as an integer value, possibly with suffixes.
 429 */
 430 static int integerValue(const char *zArg){
 431   sqlite3_int64 v = 0;
 432   static const struct { char *zSuffix; int iMult; } aMult[] = {
 433     { "KiB", 1024 },
 434     { "MiB", 1024*1024 },
 435     { "GiB", 1024*1024*1024 },
 436     { "KB",  1000 },
 437     { "MB",  1000000 },
 438     { "GB",  1000000000 },
 439     { "K",   1000 },
 440     { "M",   1000000 },
 441     { "G",   1000000000 },
 442   };
 443   int i;
 444   int isNeg = 0;
 445   if( zArg[0]=='-' ){
 446     isNeg = 1;
 447     zArg++;
 448   }else if( zArg[0]=='+' ){
 449     zArg++;
 450   }
 451   if( zArg[0]=='0' && zArg[1]=='x' ){
 452     int x;
 453     zArg += 2;
 454     while( (x = hexDigitValue(zArg[0]))>=0 ){
 455       v = (v<<4) + x;
 456       zArg++;
 457     }
 458   }else{
 459     while( isdigit(zArg[0]) ){
 460       v = v*10 + zArg[0] - '0';
 461       zArg++;
 462     }
 463   }
 464   for(i=0; i<sizeof(aMult)/sizeof(aMult[0]); i++){
 465     if( sqlite3_stricmp(aMult[i].zSuffix, zArg)==0 ){
 466       v *= aMult[i].iMult;
 467       break;
 468     }
 469   }
 470   if( v>0x7fffffff ){
 471     printf("ERROR: parameter too large - max 2147483648\n");
 472     exit(1);
 473   }
 474   return (int)(isNeg? -v : v);
 475 }
 476
 477
 478 int main(int argc, char **argv){
 479   const char *zCmd = 0;
 480   int i;
 481   int bAutovac = 0;
 482   int showStats = 0;
 483   const char *zDbName = "./startup.db";
 484   int nHeap = 0;
 485   int mnHeap = 0;
 486
 487   for(i=1; i<argc; i++){
 488     const char *z = argv[i];
 489     if( z[0]!='-' ){
 490       if( zCmd ){
 491         usage(argv[0]);
 492       }
 493       zCmd = z;
 494       continue;
 495     }
 496     if( z[1]=='-' ) z++;
 497     if( strcmp(z, "-autovacuum")==0 ){
 498       bAutovac = 1;
 499     }else
 500     if( strcmp(z, "-dbname")==0 ){
 501       if( i==argc-1 ){
 502         printf("ERROR: missing argument on \"%s\"\n", argv[0]);
 503         exit(1);
 504       }
 505       zDbName = argv[++i];
 506     }else
 507     if( strcmp(z,"-heap")==0 ){
 508       if( i>=argc-2 ){
 509         printf("ERROR: missing arguments on %s\n", argv[i]);
 510         exit(1);
 511       }
 512       nHeap = integerValue(argv[i+1]);
 513       mnHeap = integerValue(argv[i+2]);
 514       i += 2;
 515     }else
 516     if( strcmp(z,"-stats")==0 ){
 517        showStats = 1;
 518     }else
 519     {
 520       printf("ERROR: unknown option \"%s\"\n", argv[i]);
 521       usage(argv[0]);
 522     }
 523   }
 524   if( zCmd==0 ){
 525     printf("ERROR: no COMMAND specified\n");
 526     usage(argv[0]);
 527   }
 528   if( strcmp(zCmd, "run")==0 ){
 529     sqlite3 *db;
 530     int rc;
 531     char *zErr = 0;
 532     void *pHeap = 0;
 533     if( nHeap>0 ){
 534       pHeap = malloc( nHeap );
 535       if( pHeap==0 ){
 536         printf("ERROR: cannot allocate %d-byte heap\n", nHeap);
 537         exit(1);
 538       }
 539       rc = sqlite3_config(SQLITE_CONFIG_HEAP, pHeap, nHeap, mnHeap);
 540       if( rc ){
 541         printf("ERROR: heap configuration failed: %d\n", rc);
 542         exit(1);
 543       }
 544     }
 545     rc = sqlite3_open(zDbName, &db);
 546     if( rc ){
 547       printf("SQLite error: %s\n", sqlite3_errmsg(db));
 548     }else{
 549       sqlite3_exec(db, "PRAGMA synchronous", 0, 0, &zErr);
 550     }
 551     if( zErr ){
 552       printf("ERROR: %s\n", zErr);
 553       sqlite3_free(zErr);
 554     }
 555     if( showStats ){
 556       int iCur, iHi;
 557       sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_USED, &iCur, &iHi, 0);
 558       printf("-- Lookaside Slots Used:        %d (max %d)\n", iCur,iHi);
 559       sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_HIT, &iCur, &iHi, 0);
 560       printf("-- Successful lookasides:       %d\n", iHi);
 561       sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE, &iCur,&iHi,0);
 562       printf("-- Lookaside size faults:       %d\n", iHi);
 563       sqlite3_db_status(db, SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL, &iCur,&iHi,0);
 564       printf("-- Lookaside OOM faults:        %d\n", iHi);
 565       sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_USED, &iCur, &iHi, 0);
 566       printf("-- Pager Heap Usage:            %d bytes\n", iCur);
 567       sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_HIT, &iCur, &iHi, 1);
 568       printf("-- Page cache hits:             %d\n", iCur);
 569       sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_MISS, &iCur, &iHi, 1);
 570       printf("-- Page cache misses:           %d\n", iCur);
 571       sqlite3_db_status(db, SQLITE_DBSTATUS_CACHE_WRITE, &iCur, &iHi, 1);
 572       printf("-- Page cache writes:           %d\n", iCur);
 573       sqlite3_db_status(db, SQLITE_DBSTATUS_SCHEMA_USED, &iCur, &iHi, 0);
 574       printf("-- Schema Heap Usage:           %d bytes\n", iCur);
 575       sqlite3_db_status(db, SQLITE_DBSTATUS_STMT_USED, &iCur, &iHi, 0);
 576       printf("-- Statement Heap Usage:        %d bytes\n", iCur);
 577     }
 578     sqlite3_close(db);
 579     free(pHeap);
 580     /* Global memory usage statistics printed after the database connection
 581     ** has closed.  Memory usage should be zero at this point. */
 582     if( showStats ){
 583       int iCur, iHi;
 584       sqlite3_status(SQLITE_STATUS_MEMORY_USED, &iCur, &iHi, 0);
 585       printf("-- Memory Used (bytes):         %d (max %d)\n", iCur,iHi);
 586       sqlite3_status(SQLITE_STATUS_MALLOC_COUNT, &iCur, &iHi, 0);
 587       printf("-- Outstanding Allocations:     %d (max %d)\n", iCur,iHi);
 588       sqlite3_status(SQLITE_STATUS_PAGECACHE_OVERFLOW, &iCur, &iHi, 0);
 589       printf("-- Pcache Overflow Bytes:       %d (max %d)\n", iCur,iHi);
 590       sqlite3_status(SQLITE_STATUS_MALLOC_SIZE, &iCur, &iHi, 0);
 591       printf("-- Largest Allocation:          %d bytes\n",iHi);
 592       sqlite3_status(SQLITE_STATUS_PAGECACHE_SIZE, &iCur, &iHi, 0);
 593       printf("-- Largest Pcache Allocation:   %d bytes\n",iHi);
 594 #ifdef __linux__
 595       displayLinuxIoStats(stdout);
 596 #endif
 597     }
 598     return 0;
 599   }
 600   if( strcmp(zCmd, "init")==0 ){
 601     sqlite3 *db;
 602     char *zAux;
 603     char *zErr = 0;
 604     int rc;
 605     unlink(zDbName);
 606     zAux = sqlite3_mprintf("%s-journal", zDbName);
 607     unlink(zAux);
 608     sqlite3_free(zAux);
 609     zAux = sqlite3_mprintf("%s-wal", zDbName);
 610     unlink(zAux);
 611     sqlite3_free(zAux);
 612     rc = sqlite3_open(zDbName, &db);
 613     if( rc ){
 614       printf("SQLite error: %s\n", sqlite3_errmsg(db));
 615     }else{
 616       sqlite3_exec(db, "BEGIN", 0, 0, 0);
 617       sqlite3_exec(db, zTestSchema, 0, 0, &zErr);
 618       sqlite3_exec(db, "COMMIT", 0, 0, 0);
 619     }
 620     if( zErr ){
 621       printf("ERROR: %s\n", zErr);
 622       sqlite3_free(zErr);
 623     }
 624     sqlite3_close(db);
 625     return 0;
 626
 627   }
 628 }