Page MenuHomePhabricator
Files F9343347

No One
Actions

Authored By
bd808
Sep 5 2017, 5:53 PM
Size
9 KB
Referenced Files
None
Subscribers
None

View Options

SELECT
table_schema
, count(1) as tables
FROM information_schema.TABLES
WHERE table_schema regexp '^[psu][0-9]'
GROUP BY table_schema;
-- labsdb1001.eqiad.wmnet
+---------------------------------------+--------+
| table_schema | tables |
+---------------------------------------+--------+
| p50380g40014__test | 1 |
| p50380g50491_common | 11 |
| p50380g50491_inconsistent_redirects | 2 |
| p50380g50491_oddlinks | 2 |
| p50380g50491_rlrl_enwiki | 27 |
| p50380g50491_unlikely | 5 |
| p50380g50491__rlrl_enwiki_p | 24 |
| p50380g50491__rlrl_ptwiki_p | 22 |
| p50380g50491__unlikely_enwiki_p | 7 |
| p50380g50491__unlikely_ptwiki_p | 5 |
| p50380g50494_data | 17 |
| p50380g50497__wikidb_commonswiki | 50 |
| p50380g50497__wikidb_enwiki | 50 |
| p50380g50497__wikidb_zhwiki | 59 |
| p50380g50512__ | 49 |
| p50380g50551__UTRS | 12 |
| p50380g50553__ilc | 5 |
| p50380g50592__interwikis_p | 1 |
| p50380g50692__DPL_p | 54 |
| p50380g50728__hostbot_p | 21 |
| p50380g50816__pop_stats | 30 |
| p50380g50824__contributionsurveyor | 1 |
| p50380g50838__geophotoreq | 1 |
| p50380g50900_testdb | 4 |
| p50380g50921__ghel_p | 18 |
| p50380g50921__wma_p | 3 |
| s51055__AnomieBOT | 1 |
| s51058__dat | 1 |
| s51073__toolserver | 1 |
| s51111__common_p | 13 |
| s51111__inconsistent_redirects_p | 2 |
| s51111__oddlinks_p | 2 |
| s51111__rlrl_enwiki_p | 24 |
| s51111__rlrl_ptwiki_p | 22 |
| s51111__unlikely_enwiki_p | 5 |
| s51111__unlikely_ptwiki_p | 5 |
| s51127__dewiki_Bilderwunsch_p | 2 |
| s51127__dewiki_new | 5 |
| s51127__stats_p | 1 |
| s51127__temp_transient | 5 |
| s51127__toolserverdb | 1 |
| s51154__catscan2 | 6 |
| s51172__user | 1 |
| s51187__xtools_tmp | 357 |
| s51206__ptwikis_p | 1 |
| s51223__lists_p | 1 |
| s51306__copyright_p | 2 |
| s51329__afc_statistics | 4 |
| s51334__enwiki_first_page_revisions_p | 1 |
| s51362__erwin85 | 16 |
| s51417__artplusfem_nyc_2015_moma | 1 |
| s51454__CategoryWatchlistBot | 6 |
| s51454__CleanupWorklistBot | 5 |
| s51454__TemplateParamBot_p | 9 |
| s51454__wikidata | 6 |
| s51698__yetkin2 | 5 |
| s51755__tmp | 6 |
| s51892_toolserverdb | 5 |
| s51892_toolserverdb_p | 6 |
| s52037_yicheng | 4 |
| s52107_reports | 1 |
| s52365__devtestwiki | 49 |
| s52467__hashtags | 7 |
| s52490__hashtags_p | 5 |
| s52524__rwtest | 1 |
| s52690__ | 5 |
| s52690__p | 3 |
| s52744__tif | 1 |
| s53012__fikarummet_p | 1 |
| s53024__sandbox_p | 1 |
| s53151__spamwatch_test | 1 |
| s53311__wikidata_usage_and_views_p | 8 |
| s53381__extra | 6 |
| u10276__tmp | 1 |
| u11049__Revision_2015JanFeb | 3 |
| u12219__wikied_p | 18 |
| u2029__quarry | 1 |
| u2041_test | 1 |
| u2041__botvbot_p | 3 |
| u2041__ores_p | 1 |
| u2041__thr_p | 2 |
| u2043__infocycle | 2 |
| u2117_test | 1 |
| u2248__AnomieBOT | 1 |
| u2248__tmp | 3 |
| u2402__p | 4 |
| u2745_analysis | 1 |
| u2815__ | 4 |
| u2815__p | 40 |
| u2815__piwik | 31 |
| u2815__test | 3 |
| u2815__toolserver_s4b | 1 |
| u2843__tmp | 1 |
| u3182__wp10_p | 1 |
| u3214_testdb | 1 |
| u3290__2012categories | 1 |
| u3290__2013categories | 1 |
| u3356__ | 3 |
| u3532__ | 46 |
| u3533_edit_req_db | 1 |
| u3533_g13_database | 2 |
| u3533_onlyuser | 1 |
| u3570_test | 2 |
| u3617__tmp | 9 |
| u3945__staeiou | 3 |
| u3949__tmp | 2 |
| u4301_robertb | 2 |
| u4817__afcresearch | 35 |
| u4974__ores_tmp_p | 1 |
+---------------------------------------+--------+
109 rows in set (1.08 sec)
-- labsdb1003.eqiad.wmnet
+---------------------------------------+--------+
| table_schema | tables |
+---------------------------------------+--------+
| p50380g50491_common | 1 |
| p50380g50491__rlrl_cawiki_p | 22 |
| p50380g50491__rlrl_frwiki_p | 23 |
| p50380g50491__rlrl_lvwiki_p | 22 |
| p50380g50491__unlikely_lvwiki_p | 5 |
| p50380g50497__wikidb_arwiki | 57 |
| p50380g50497__wikidb_mediawikiwiki | 49 |
| p50380g50497__wikidb_testwikidatawiki | 49 |
| p50380g50497__wikidb_wikidatawiki | 57 |
| p50380g50497__wikidb_zhwikisource | 49 |
| p50380g50552__inflections | 3 |
| p50380g50553__ilc | 6 |
| p50380g50553__ilc_s7 | 2 |
| p50380g50692__DPL_p | 7 |
| p50380g50729__grantsbot | 9 |
| p50380g50769__wvs2 | 35 |
| p50380g50769__wvs2ds | 4 |
| p50380g50921__ghel_p | 70 |
| p50380g50921__ghel_p_s3 | 54 |
| p50380g50921__ghel_p_s7 | 5 |
| p50380g50921__wma_p | 3 |
| p50380g50921__wma_p_s3 | 3 |
| p50380g50921__wma_p_s7 | 3 |
| s51072__dwl_p | 5 |
| s51111__common_p | 1 |
| s51111__rlrl_cawiki_p | 22 |
| s51111__rlrl_frwiki_p | 22 |
| s51111__rlrl_lvwiki_p | 22 |
| s51111__unlikely_lvwiki_p | 5 |
| s51117__wikidb_dawiki | 49 |
| s51117__wikidb_eswiki | 49 |
| s51117__wikidb_frwiki | 49 |
| s51117__wikidb_jawiki | 49 |
| s51117__wikidb_kowiki | 49 |
| s51117__wikidb_ruwiki | 49 |
| s51117__wikidb_zh_yuewiki | 49 |
| s51172__tasks | 1 |
| s51187__xtools_tmp | 662 |
| s51187__xtools_tmp_s3 | 10 |
| s51187__xtools_tmp_s7 | 16 |
| s51206__pt | 2 |
| s51362__erwin85 | 62 |
| s51362__erwin85_s3 | 22 |
| s51362__erwin85_s7 | 2 |
| s51392__coord | 1 |
| s51430__bswiki_first_page_revisions_p | 1 |
| s51447__cawiki | 2 |
| s51580__hroest | 4 |
| s51837__MerlBot | 1 |
| s51892_toolserverdb | 5 |
| s51892_toolserverdb_p | 6 |
| s51892_toolserverdb_p_s3 | 6 |
| s51892_toolserverdb_p_s7 | 6 |
| s51892_toolserverdb_s3 | 5 |
| s51892_toolserverdb_s7 | 5 |
| s52107_lime | 34 |
| s52107_tools | 1 |
| s52524__rwtest | 1 |
| s52690__p | 1 |
| s52861__bwAPI_p | 1 |
| s52861__fnbot | 3 |
| s52861__request | 13 |
| s52861__secWatch | 7 |
| s52861__thanks_de | 1 |
| s52957__wdcat | 3 |
| s53012__fikarummet_p | 1 |
| s53311__wikidata | 3 |
| u2170__meta_p | 2 |
| u2718__bswiki_first_page_revisions_p | 1 |
| u2815__ | 2 |
| u2815__p | 87 |
| u3617__tmp | 1 |
| u3710__stats | 33 |
| u3949__tmp | 2 |
| u4529_srwiki | 20 |
+---------------------------------------+--------+

File Metadata

Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
4910523
Default Alt Text
(9 KB)

Event Timeline

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL