Quote:
Originally Posted by JSWolf
Would the -wal file be 0 when the main database is not going to be corrupt on a USB connect or will it always be of some size after you've been using the Kobo?
|
The size of the -wal file depends on writing to the database. When it is first opened, the Write Ahead Logging file will start at 0 bytes. In contrast the SHared Memory file starts at 32KB and seldom grows larger. When the last connection to a database closes, that connection does one last checkpoint and then deletes the WAL and SHM file, to clean up the disk. If you see those files when USB connected, it tells you the database was not properly closed. The -wal file will not grow endlessly, the default is 1000 pages or ~4MB though there are several situations in which the file will grow past that.