https://bugzilla.wikimedia.org/show_bug.cgi?id=52928
--- Comment #3 from Sean Pringle <[email protected]> --- Actually, I shouldn't have said 'all wikis', just 'most wikis'. I have a sandbox mysqld on terbium with various metadata pulled daily from information_schema on all the database hosts. CREATE TABLE `db_tables` ( `host_id` int(10) unsigned NOT NULL, `db` varchar(32) NOT NULL, `name` varchar(32) NOT NULL, `engine` varchar(16) DEFAULT NULL, `version` varchar(10) DEFAULT NULL, `format` varchar(10) DEFAULT NULL, `rows` bigint(20) unsigned DEFAULT NULL, `data_len` bigint(20) unsigned DEFAULT NULL, `index_len` bigint(20) unsigned DEFAULT NULL, `auto_inc` bigint(20) unsigned DEFAULT NULL, UNIQUE KEY `host_id` (`host_id`,`db`,`name`) ); select distinct t.db as dbs_with_links from db_tables t where t.name = 'links' order by db; +------------------+ | dbs_with_links | +------------------+ | aawiki | | abwiki | | afwiki | | akwiki | | alswiki | | amwiki | | angwiki | | anwiki | | arcwiki | | arwiki | | astwiki | | aswiki | | avwiki | | aywiki | | azwiki | | bawiki | | be_x_oldwiki | | bgwiki | | bhwiki | | biwiki | | bmwiki | | bnwiki | | bowiki | | brwiki | | bswiki | | cawiki | | cebwiki | | cewiki | | chowiki | | chrwiki | | chwiki | | chywiki | | closed_zh_twwiki | | cowiki | | crwiki | | csbwiki | | cswiki | | cvwiki | | cywiki | | dawiki | | dewiki | | dkwiki | | dvwiki | | dzwiki | | eewiki | | elwiki | | enwiki | | eowiki | | eswiki | | etwiki | | euwiki | | fawiki | | ffwiki | | fiu_vrowiki | | fiwiki | | fjwiki | | fowiki | | frwiki | | furwiki | | fywiki | | gawiki | | gdwiki | | glwiki | | gnwiki | | gotwiki | | guwiki | | gvwiki | | hawiki | | hawwiki | | hewiki | | hiwiki | | howiki | | hrwiki | | htwiki | | huwiki | | hywiki | | hzwiki | | iawiki | | idwiki | | iewiki | | igwiki | | iiwiki | | ikwiki | | iowiki | | iswiki | | itwiki | | iuwiki | | jawiki | | jbowiki | | jvwiki | | kawiki | | kgwiki | | kiwiki | | kjwiki | | kkwiki | | klwiki | | kmwiki | | knwiki | | kowiki | | krwiki | | kswiki | | kuwiki | | kvwiki | | kwwiki | | kywiki | | lawiki | | lbwiki | | lgwiki | | liwiki | | lnwiki | | lowiki | | ltwiki | | lvwiki | | mediawikiwiki | | metawiki | | mgwiki | | mhwiki | | miwiki | | mkwiki | | mlwiki | | mnwiki | | mowiki | | mrwiki | | mswiki | | mtwiki | | muswiki | | mywiki | | nahwiki | | nawiki | | ndswiki | | newiki | | ngwiki | | nlwiki | | nnwiki | | nowiki | | nvwiki | | nywiki | | ocwiki | | omwiki | | orwiki | | oswiki | | pamwiki | | pawiki | | piwiki | | plwiki | | pswiki | | ptwiki | | quwiki | | rel13testwiki | | rmwiki | | rnwiki | | roa_rupwiki | | rowiki | | ruwiki | | rwwiki | | sawiki | | scnwiki | | scowiki | | scwiki | | sdwiki | | sewiki | | sgwiki | | shwiki | | simplewiki | | siwiki | | skwiki | | slwiki | | smwiki | | snwiki | | sowiki | | sqwiki | | srwiki | | sswiki | | stwiki | | suwiki | | svwiki | | swwiki | | tawiki | | tewiki | | tgwiki | | thwiki | | tiwiki | | tkwiki | | tlhwiki | | tlwiki | | tnwiki | | tokiponawiki | | towiki | | tpiwiki | | trwiki | | tswiki | | ttwiki | | tumwiki | | twwiki | | tywiki | | ugwiki | | ukwiki | | urwiki | | uzwiki | | vewiki | | viwiki | | vowiki | | wawiki | | wowiki | | xhwiki | | yiwiki | | yowiki | | zawiki | | zhwiki | | zh_cnwiki | | zh_min_nanwiki | | zuwiki | +------------------+ 212 rows in set (0.26 sec) -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
