Does akonadi manage index or free space optimization (sqlite command ANALYZE or PRAGRMA optimize) ?
akonadictl tells me, vacuum command is for sqlite backend not available …
Have I do such things direct with the sqlite database file ?
Does akonadi manage index or free space optimization (sqlite command ANALYZE or PRAGRMA optimize) ?
akonadictl tells me, vacuum command is for sqlite backend not available …
Have I do such things direct with the sqlite database file ?
usually better not to poke the live sqlite file while Akonadi is running. stop it first:
akonadictl stop
```
then if you really want maintenance, `ANALYZE` is the safer one. vacuum is the thing akonadictl refuses for a reason (locks / corruption risk on a busy mail DB).
for me id run `akonadictl fsck` after start and only touch the db file if that still looks bad. take a copy of the sqlite file before any PRAGMA stuff.
That’s for sure.