Does Wikimedia use InnoDB, Maria or something else as the database engine for its MariaDB servers?
- d.
https://www.mediawiki.org/wiki/Special:Version shows Wikimedia may be using 5.5.30-MariaDB-mariadb1~precise-log
https://github.com/wikimedia/operations-puppet most probably contains the technical details somewhere.
On Wed, Oct 16, 2013 at 8:53 PM, David Gerard dgerard@gmail.com wrote:
Does Wikimedia use InnoDB, Maria or something else as the database engine for its MariaDB servers?
- d.
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
On 16 October 2013 20:06, Siebrand Mazeland (WMF) smazeland@wikimedia.org wrote:
https://www.mediawiki.org/wiki/Special:Version shows Wikimedia may be using 5.5.30-MariaDB-mariadb1~precise-log
Mmm. I thought that was just saying what the DB was announcing itself as, not what the engine was.
https://github.com/wikimedia/operations-puppet most probably contains the technical details somewhere.
It depends what the DBs were created as. This may not in fact be in Puppet.
- d.
I see I misread your question. Sorry about that...
The answer is most likely somewhere in http://noc.wikimedia.org/conf/
On Wed, Oct 16, 2013 at 9:07 PM, David Gerard dgerard@gmail.com wrote:
On 16 October 2013 20:06, Siebrand Mazeland (WMF) smazeland@wikimedia.org wrote:
https://www.mediawiki.org/wiki/Special:Version shows Wikimedia may be
using
5.5.30-MariaDB-mariadb1~precise-log
Mmm. I thought that was just saying what the DB was announcing itself as, not what the engine was.
https://github.com/wikimedia/operations-puppet most probably contains
the
technical details somewhere.
It depends what the DBs were created as. This may not in fact be in Puppet.
- d.
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
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?
InnoDB, mostly. For example:
[enwiki]> SELECT count(*) as num_tables, engine from information_schema.tables where table_schema = 'enwiki' group by engine; +------------+--------+ | num_tables | engine | +------------+--------+ | 166 | InnoDB | | 2 | MEMORY | +------------+--------+ 2 rows in set (0.00 sec)
-Chad
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...
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?
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
wikitech-l@lists.wikimedia.org