On Wed, Oct 16, 2013 at 1:53 PM, Brian Wolff bawolff@gmail.com wrote:
On 2013-10-16 4:33 PM, "S Page" spage@wikimedia.org wrote:
On Wed, Oct 16, 2013 at 11:53 AM, David Gerard dgerard@gmail.com
wrote:
Does Wikimedia use InnoDB, Maria or something else as the database engine for its MariaDB servers?
mediawiki-config (where most of http://noc.wikimedia.org/conf/ comes from) gives no indication that we override it, so AFAICT the MediaWiki default in includes/DefaultSettings.php line 1541 $wgDBTableOptions = 'ENGINE=InnoDB'; applies.
WMF uses puppet to configure servers, so actual DB config settings come from puppet manifests and roles, such as <
http://git.wikimedia.org/blob/operations%2Fpuppet.git/18f719ef3d297878e198a8...
-- =S Page WMF Features engineer _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Otoh, our db tables probably weren't created by the mw installer, so I feel that $wgDBTableOptions probably doesn't have that much of an effect.
-bawolff
P.s. out of curiosity, which tables are "memory" tables?
It does, as most tables are created/updated via sql.php, which handles the variable substitution.
As far as memory tables: hitcounter & profiling, neither of which is used.
-Chad