Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P15523
largest watchlist tables
Active
Public
Actions
Authored by
jcrespo
on Apr 26 2021, 12:29 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F34428589: largest watchlist tables
Apr 26 2021, 12:29 PM
2021-04-26 12:29:33 (UTC+0)
Subscribers
None
root@db1159.eqiad.wmnet[dbbackups]> select max(size), file_path FROM backup_files where file_name like '%watchlist%' and backup_id > 9000 GROUP BY file_path ORDER BY max(size) desc limit 10;
+-------------+--------------+
| max(size) | file_path |
+-------------+--------------+
| 43645927424 | enwiki |
| 38474350592 | commonswiki |
| 11064573952 | wikidatawiki |
| 7017070592 | dewiki |
| 5356126208 | ruwiki |
| 5280628736 | frwiki |
| 5045747712 | metawiki |
| 4823449600 | ruwikinews |
| 4156555264 | eswiki |
| 3955228672 | arwiki |
+-------------+--------------+
10 rows in set (24.510 sec)
Event Timeline
jcrespo
created this paste.
Apr 26 2021, 12:29 PM
2021-04-26 12:29:33 (UTC+0)
Log In to Comment