On Wed, Oct 16, 2013 at 1:53 PM, Brian Wolff <[email protected]> wrote:
> On 2013-10-16 4:33 PM, "S Page" <[email protected]> wrote: > > > > On Wed, Oct 16, 2013 at 11:53 AM, David Gerard <[email protected]> > 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/18f719ef3d297878e198a864f5bb31dd9cb047af/manifests%2Frole%2Fcoredb.pp > > > > > > > -- > > =S Page WMF Features engineer > > _______________________________________________ > > Wikitech-l mailing list > > [email protected] > > 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 _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
