New pathhistory setting for the history database directory

Julien ÉLIE julien at trigofacile.com
Thu Jul 16 21:13:12 UTC 2026


Hi all,

In tomorrow's snapshot (inn-CURRENT-20260717.tar.gz), there will be the possibility to set pathhistory in inn.conf for the directory of the history database.
This is a great contribution from Kevin Bowling.

You may want to have your history database in a dedicated partition, so feel free to migrate your history files to a new directory (while INN is not running) and set pathhistory in inn.conf to that directory.
One advantage is to set the following parameter appropriately:

hissqlitepagesize
     The SQLite page size in bytes, applied when the database is  created
     (it  cannot  be  changed  afterwards without rebuilding).  Must be a
     power of two between 512 and 65536.  The default is "4096", matching
     the common filesystem block size so that a random single-row  insert
     or point lookup on the random-MD5 keys touches exactly one block (no
     read-modify-write).   For  best  results, the page size should match
     the underlying storage  block  size:  on  ZFS,  create  a  dedicated
     history  dataset  with  "recordsize=4k"  and  point  the pathhistory
     parameter at it.  A small page on a  coarse-recordsize  ZFS  dataset
     (the  128k  default)  forces read-modify-write on every random write
     and will perform worse, not better.

-- 
Julien ÉLIE

« À l'école, en algèbre, j'étais du genre Einstein. Mais plutôt Franck
   qu'Albert. » (Philippe Geluck)



More information about the inn-workers mailing list