From db784ada9f9d16e3f3799dd2e0bd75509eaff61f Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Thu, 14 Mar 2019 00:56:40 -0700 Subject: [PATCH] Set synchronous = NORMAL for cache tables in Sqlite installer In local testing, this makes SqlBagOStuff::set 17x faster. Change-Id: I54d0d4f009ca1289485b89a1dcab46ffb31d8f11 --- includes/installer/SqliteInstaller.php | 2 ++ 1 file changed, 2 insertions(+) diff --git a/includes/installer/SqliteInstaller.php b/includes/installer/SqliteInstaller.php index 9de1fea23d..fa0d2a507a 100644 --- a/includes/installer/SqliteInstaller.php +++ b/includes/installer/SqliteInstaller.php @@ -386,6 +386,7 @@ EOT; 'type' => 'sqlite', 'dbname' => 'wikicache', 'tablePrefix' => '', + 'variables' => [ 'synchronous' => 'NORMAL' ], 'dbDirectory' => \$wgSQLiteDataDir, 'trxMode' => 'IMMEDIATE', 'flags' => 0 @@ -395,6 +396,7 @@ EOT; 'type' => 'sqlite', 'dbname' => \"{\$wgDBname}_l10n_cache\", 'tablePrefix' => '', + 'variables' => [ 'synchronous' => 'NORMAL' ], 'dbDirectory' => \$wgSQLiteDataDir, 'trxMode' => 'IMMEDIATE', 'flags' => 0 -- 2.20.1