I'm upgrading from MediaWiki 1.29.1 to 1.34.0. My wiki uses SQLite.
I noticed that 1.34.0 includes the following new settings when it generates LocalSettings.php (as created for a new, test wiki). I tried adding them to my upgraded wiki's LocalSettings, but this led to the creation of some new, empty databases, and errors when the expected tables couldn't be found.
$wgLocalisationCacheConf['storeServer'] = [
'type' => 'sqlite',
'dbname' => "{$wgDBname}_l10n_cache",
'tablePrefix' => '',''
'variables' => [ 'synchronous' => 'NORMAL' ],
'dbDirectory' => $wgSQLiteDataDir,
'trxMode' => 'IMMEDIATE',
'flags' => 0
];
$wgJobTypeConf['default'] = [
'class' => 'JobQueueDB',
'claimTTL' => 3600,
'server' => [
'type' => 'sqlite',
'dbname' => "{$wgDBname}_jobqueue",
'tablePrefix' => '',''
'variables' => [ 'synchronous' => 'NORMAL' ],
'dbDirectory' => $wgSQLiteDataDir,
'trxMode' => 'IMMEDIATE',
'flags' => 0
]
];
Questions:
- What is the purpose of these declarations? I suspect it's a performance optimization. Am I right? Is it the kind of optimization that matters to a wiki with only a handful of users?
- Is there a recommended way to create and populate these databases if I decide I want to make use of them?