Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P5960
User created databases on labsdb100[13].eqiad.wmnet
Active
Public
Actions
Authored by
bd808
on Sep 5 2017, 5:53 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
Data-Services
Referenced Files
F9343937:
Sep 5 2017, 6:12 PM
2017-09-05 18:12:58 (UTC+0)
F9343348:
Sep 5 2017, 5:53 PM
2017-09-05 17:53:26 (UTC+0)
F9343347:
Sep 5 2017, 5:53 PM
2017-09-05 17:53:01 (UTC+0)
Subscribers
None
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
created this paste.
Sep 5 2017, 5:53 PM
2017-09-05 17:53:01 (UTC+0)
bd808
edited the content of this paste.
(Show Details)
bd808
added a project:
Data-Services
.
Sep 5 2017, 5:55 PM
2017-09-05 17:55:44 (UTC+0)
bd808
edited the content of this paste.
(Show Details)
Sep 5 2017, 6:12 PM
2017-09-05 18:12:58 (UTC+0)
bd808
changed the title of this paste from untitled to
User created databases on labsdb100[13].eqiad.wmnet
.
Sep 7 2017, 1:15 AM
2017-09-07 01:15:36 (UTC+0)
bd808
updated the paste's language from
autodetect
to
sql
.
bd808
mentioned this in
T175096: Identify tools hosting databases on labsdb100[13] and notify maintainers
.
Sep 7 2017, 5:23 PM
2017-09-07 17:23:58 (UTC+0)
Log In to Comment