Page MenuHomePhabricator
Paste P8660

top s3 wikis by compressed size
ActivePublic

Authored by jcrespo on Jun 27 2019, 7:30 AM.
root@db1115.eqiad.wmnet[zarcillo]> select SUBSTRING_INDEX(file_name, '.', 1) as db, sum(size) as size FROM backup_files WHERE backup_id = 1862 and file_name not like '%-schema-create.sql.gz' GROUP BY db ORDER BY size desc LIMIT 20;
+---------------+------------+
| db | size |
+---------------+------------+
| mediawikiwiki | 4539665654 |
| loginwiki | 2829553543 |
| plwiktionary | 2358407852 |
| ruwiktionary | 2355786729 |
| frwikisource | 2315194029 |
| dewiktionary | 2192119974 |
| enwikisource | 1933894489 |
| dawiki | 1818772589 |
| sourceswiki | 1795213418 |
| dewikivoyage | 1495157942 |
| skwiki | 1449949778 |
| euwiki | 1377163347 |
| elwiki | 1371151371 |
| bewiki | 1303039764 |
| enwikinews | 1267055352 |
| simplewiki | 1266661189 |
| specieswiki | 1241517305 |
| ruwikisource | 1218843714 |
| hywiki | 1213727020 |
| slwiki | 1212863732 |
+---------------+------------+
20 rows in set (0.20 sec)
root@db1115.eqiad.wmnet[zarcillo]> select SUBSTRING_INDEX(file_name, '.', 1) as db, sum(size) as size FROM backup_files WHERE backup_id = 1866 and file_name not like '%-schema-create.sql.gz' GROUP BY db ORDER BY size desc LIMIT 20;
+---------------+------------+
| db | size |
+---------------+------------+
| mediawikiwiki | 4539656355 |
| loginwiki | 2829590706 |
| plwiktionary | 2358419554 |
| ruwiktionary | 2355797164 |
| frwikisource | 2315213285 |
| dewiktionary | 2204128063 |
| enwikisource | 1933912943 |
| dawiki | 1818751991 |
| sourceswiki | 1795214102 |
| dewikivoyage | 1495165313 |
| skwiki | 1449944125 |
| elwiki | 1371124258 |
| euwiki | 1371034939 |
| bewiki | 1303054008 |
| enwikinews | 1267056284 |
| simplewiki | 1266639862 |
| hywiki | 1247715009 |
| specieswiki | 1241538353 |
| ruwikisource | 1218846265 |
| slwiki | 1212866336 |
+---------------+------------+
20 rows in set (0.21 sec)