top s3 wikis by compressed size
ActivePublic
Actions

Authored by jcrespo on Jun 27 2019, 7:30 AM.

Tags

None

Referenced Files

	F29654565: raw.txt
	Jun 27 2019, 7:31 AM

	F29654564: raw.txt
	Jun 27 2019, 7:30 AM

Subscribers

None

	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)

Event Timeline

jcrespo created this paste.Jun 27 2019, 7:30 AM

jcrespo edited the content of this paste. (Show Details)

Marostegui mentioned this in T226950: Move more wikis from s3 to s5.Jul 1 2019, 5:35 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)

top s3 wikis by compressed sizeActivePublicActions

Event Timeline

top s3 wikis by compressed size
ActivePublic
Actions