Page MenuHomePhabricator
Paste P15523

largest watchlist tables
ActivePublic

Authored by jcrespo on Apr 26 2021, 12:29 PM.
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)