Page MenuHomePhabricator
Paste P5960

User created databases on labsdb100[13].eqiad.wmnet
ActivePublic

Authored by bd808 on Sep 5 2017, 5:53 PM.
SELECT
SUBSTRING_INDEX(table_schema, '_', 1) as tool
, count(1) as tables
FROM information_schema.TABLES
WHERE table_schema regexp '^[psu][0-9]'
GROUP BY tool
ORDER BY tables desc;
-- labsdb1001.eqiad.wmnet
+--------------+--------+
| tool | tables |
+--------------+--------+
| s51187 | 355 |
| p50380g50497 | 159 |
| p50380g50491 | 105 |
| u2815 | 79 |
| s51111 | 73 |
| p50380g50692 | 54 |
| p50380g50512 | 49 |
| s52365 | 49 |
| u3532 | 46 |
| u4817 | 35 |
| p50380g50816 | 30 |
| s51454 | 26 |
| p50380g50728 | 21 |
| p50380g50921 | 21 |
| u12219 | 18 |
| p50380g50494 | 17 |
| s51362 | 16 |
| s51127 | 14 |
| p50380g50551 | 12 |
| s51892 | 11 |
| u3617 | 9 |
| s52690 | 8 |
| s53311 | 8 |
| s52467 | 7 |
| u2041 | 7 |
| s51755 | 6 |
| s51154 | 6 |
| s53381 | 6 |
| s51698 | 5 |
| p50380g50553 | 5 |
| s52490 | 5 |
| u3533 | 4 |
| s51329 | 4 |
| p50380g50900 | 4 |
| s52037 | 4 |
| u2402 | 4 |
| u2248 | 4 |
| u11049 | 3 |
| u3356 | 3 |
| u3945 | 3 |
| u4301 | 2 |
| u2043 | 2 |
| u3949 | 2 |
| s51306 | 2 |
| u3290 | 2 |
| u3570 | 2 |
| p50380g40014 | 1 |
| s51058 | 1 |
| u2117 | 1 |
| s51172 | 1 |
| s53012 | 1 |
| u2843 | 1 |
| u10276 | 1 |
| s51055 | 1 |
| s52744 | 1 |
| s52107 | 1 |
| u2745 | 1 |
| s51223 | 1 |
| s51417 | 1 |
| u2029 | 1 |
| u4974 | 1 |
| p50380g50592 | 1 |
| s51206 | 1 |
| s52524 | 1 |
| s53151 | 1 |
| u3214 | 1 |
| p50380g50838 | 1 |
| s51073 | 1 |
| s53024 | 1 |
| u3182 | 1 |
| p50380g50824 | 1 |
| s51334 | 1 |
+--------------+--------+
72 rows in set (1.09 sec)
-- labsdb1003.eqiad.wmnet
+--------------+--------+
| tool | tables |
+--------------+--------+
| s51187 | 688 |
| s51117 | 343 |
| p50380g50497 | 261 |
| p50380g50921 | 138 |
| u2815 | 89 |
| s51362 | 86 |
| p50380g50491 | 73 |
| s51111 | 72 |
| p50380g50769 | 39 |
| s52107 | 35 |
| u3710 | 33 |
| s51892 | 33 |
| s52861 | 25 |
| u4529 | 20 |
| p50380g50729 | 9 |
| p50380g50553 | 8 |
| p50380g50692 | 7 |
| s51072 | 5 |
| s51580 | 4 |
| s52957 | 3 |
| p50380g50552 | 3 |
| s53311 | 3 |
| s51206 | 2 |
| u2170 | 2 |
| s51447 | 2 |
| u3949 | 2 |
| s51430 | 1 |
| s53012 | 1 |
| s51392 | 1 |
| u3617 | 1 |
| s51837 | 1 |
| u2718 | 1 |
| s52690 | 1 |
| s52524 | 1 |
| s51172 | 1 |
+--------------+--------+
35 rows in set (1.36 sec)

Event Timeline

bd808 edited the content of this paste. (Show Details)
bd808 changed the title of this paste from untitled to User created databases on labsdb100[13].eqiad.wmnet.Sep 7 2017, 1:15 AM
bd808 updated the paste's language from autodetect to sql.