/ Check-in [b09e3ea7]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add some extra timestamps to the experimental log output.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | experimentalIoLog
Files: files | file ages | folders
SHA1: b09e3ea7b86ff65d749ff0b6c27e05fd3a5fadb1
User & Date: dan 2015-08-11 13:41:44
Context
2015-08-11
13:41
Add some extra timestamps to the experimental log output. Leaf check-in: b09e3ea7 user: dan tags: experimentalIoLog
10:59
Add a tcl interface for the experimental logging functionality. check-in: e844304d user: dan tags: experimentalIoLog
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/pager.c.

  7094   7094   ** or wal_blocking_checkpoint() API functions.
  7095   7095   **
  7096   7096   ** Parameter eMode is one of SQLITE_CHECKPOINT_PASSIVE, FULL or RESTART.
  7097   7097   */
  7098   7098   int sqlite3PagerCheckpoint(Pager *pPager, int eMode, int *pnLog, int *pnCkpt){
  7099   7099     int rc = SQLITE_OK;
  7100   7100     if( pPager->pWal ){
         7101  +    if( pPager->pLog ){
         7102  +      const char *az[] = { "passive", "full", "restart", "truncate" };
         7103  +      sqlite3ExperimentalLog(pPager->pLog, "start-checkpoint %s TM", az[eMode]);
         7104  +    }
  7101   7105       rc = sqlite3WalCheckpoint(pPager->pWal, eMode,
  7102   7106           (eMode==SQLITE_CHECKPOINT_PASSIVE ? 0 : pPager->xBusyHandler),
  7103   7107           pPager->pBusyHandlerArg,
  7104   7108           pPager->ckptSyncFlags, pPager->pageSize, (u8 *)pPager->pTmpSpace,
  7105   7109           pnLog, pnCkpt
  7106   7110       );
  7107   7111       if( pPager->pLog ){
  7108         -      const char *azType[] = { "passive", "full", "restart", "truncate" };
  7109         -      sqlite3ExperimentalLog(pPager->pLog, "checkpoint %s %d %d",
  7110         -                             azType[eMode], *pnLog, *pnCkpt);
         7112  +      sqlite3ExperimentalLog(pPager->pLog, "end-checkpoint %d %d TM", 
         7113  +          *pnLog, *pnCkpt);
  7111   7114       }
  7112   7115     }
  7113   7116     return rc;
  7114   7117   }
  7115   7118   
  7116   7119   int sqlite3PagerWalCallback(Pager *pPager){
  7117   7120     return sqlite3WalCallback(pPager->pWal);

Changes to src/vdbe.c.

  6523   6523   
  6524   6524     if( db->pLog && p->zSql ){
  6525   6525       char *z = sqlite3DbStrDup(db, p->zSql);
  6526   6526       int ii;
  6527   6527       for(ii=0; z[ii]; ii++){
  6528   6528         if( sqlite3Isspace(z[ii]) ) z[ii] = ' ';
  6529   6529       }
  6530         -    sqlite3ExperimentalLog(db->pLog, "sql {%s}", z);
         6530  +    sqlite3ExperimentalLog(db->pLog, "sql {%s} TM", z);
  6531   6531       sqlite3DbFree(db, z);
  6532   6532     }
  6533   6533   #ifndef SQLITE_OMIT_TRACE
  6534   6534     if( db->xTrace
  6535   6535      && !p->doingRerun
  6536   6536      && (zTrace = (pOp->p4.z ? pOp->p4.z : p->zSql))!=0
  6537   6537     ){