About
All ComboStrap data are stored in a Sqlite Database that you can query online
Databases
Combo
The database schema has the following tables:
- pages - data on pages:
- page_id: the page id
- canonical: the canonical
- analytics: the json analytics data
- … and more
- page_aliases - the page aliases
- page_rules - the page_rules
- page_references - the internal link (known as reference) of a page.
- opts - an internal table that manage the database version don't delete
Depending on your history with our plugins, its name may be:
- combo.sqlite3
- webcomponent.sqlite3 (older)
- 404manager.sqlite3 (older)
Combo Secondary
The secondary database contains data that can be lost without loss of service such as:
- runtime data
- and log
The secondary database contains the following tables:
- redirections_log - the log redirection history
- events_queue - a event queue table used to execute tasks in the background.
- opts - an internal table that manage the database version don't delete
File Location
The database are stored at DOKUWIKI_HOME/data/meta/.
Configuration
If you have a high traffic, we recommend to use the write-ahead log to reduce blocking. By default, Sqlite uses the old traditional journal.
Steps:
- Check the Sqlite version (above 3.7 - 2010)
select sqlite_version();
- Modify the journal to write-ahead log (WAL)
PRAGMA journal_mode=WAL;
- Verify the new journal mode
PRAGMA journal_mode;