s5 shrinkage
ActivePublic
Actions

Authored by jcrespo on Sep 12 2023, 6:55 AM.

Tags

None

Referenced Files

	F37709158: s5 shrinkage
	Sep 12 2023, 6:55 AM

Subscribers

None

	60.6 GB -17.1 % The previous backup had a size of 73.1 GB, a change larger than 15.0%

	SELECT A.file_path, A.file_name, A.size AS size_job_24644, B.size AS size_job_24532, ABS(CONVERT(B.size, SIGNED) - CONVERT(A.size, SIGNED)) AS difference FROM backup_files A JOIN backup_files B ON A.file_path = B.file_path AND A.file_name = B.file_name WHERE A.backup_id = 24644 AND B.backup_id = 24532 ORDER BY ABS(CONVERT(B.size, SIGNED) - CONVERT(A.size, SIGNED)) DESC;
	+-----------+--------------------------------------------------------------------+----------------+----------------+-------------+
	\| file_path \| file_name \| size_job_24644 \| size_job_24532 \| difference \|
	+-----------+--------------------------------------------------------------------+----------------+----------------+-------------+
	\| \| enwikivoyage.text.sql.gz \| 25572484 \| 13293264709 \| 13267692225 \|
	\| \| srwiki.text.00000.sql.gz \| 146137702 \| 523072282 \| 376934580 \|
	\| \| srwiki.pagelinks.00002.sql.gz \| 386543283 \| 47511167 \| 339032116 \|
	\| \| srwiki.pagelinks.00001.sql.gz \| 89139164 \| 407944461 \| 318805297 \|
	\| \| srwiki.pagelinks.00004.sql.gz \| 163009393 \| 7428990 \| 155580403 \|
	\| \| srwiki.pagelinks.00003.sql.gz \| 295102300 \| 435915150 \| 140812850 \|
	\| \| srwiki.pagelinks.00006.sql.gz \| 6395750 \| 72717793 \| 66322043 \|
	\| \| cebwiki.pagelinks.00001.sql.gz \| 97749617 \| 159523114 \| 61773497 \|
	\| \| cebwiki.pagelinks.00000.sql.gz \| 78722837 \| 135510023 \| 56787186 \|
	\| \| cebwiki.pagelinks.00002.sql.gz \| 94801973 \| 135987031 \| 41185058 \|
	\| \| dewiki.pagelinks.00005.sql.gz \| 177175970 \| 206829135 \| 29653165 \|
	\| \| dewiki.pagelinks.00007.sql.gz \| 209846893 \| 238486636 \| 28639743 \|
	\| \| dewiki.pagelinks.00004.sql.gz \| 161210478 \| 184727298 \| 23516820 \|
	\| \| shwiki.text.00000.sql.gz \| 231635661 \| 250933808 \| 19298147 \|
	\| \| dewiki.pagelinks.00003.sql.gz \| 148543816 \| 164570440 \| 16026624 \|
	\| \| avkwiki.pagelinks.sql.gz \| 37420331 \| 24425552 \| 12994779 \|
	\| \| srwiki.pagelinks.00000.sql.gz \| 104387875 \| 116989267 \| 12601392 \|
	\| \| shwiki.pagelinks.00004.sql.gz \| 205376863 \| 194221263 \| 11155600 \|
	\| \| dewiki.pagelinks.00002.sql.gz \| 151702204 \| 162711118 \| 11008914 \|
	\| \| dewiki.pagelinks.00000.sql.gz \| 297047372 \| 307993226 \| 10945854 \|
	\| \| dewiki.flaggedtemplates.00013.sql.gz \| 344555254 \| 335818950 \| 8736304 \|
	\| \| dewiki.pagelinks.00006.sql.gz \| 190624536 \| 199321243 \| 8696707 \|
	\| \| mgwiktionary.pagelinks.sql.gz \| 71330801 \| 64337665 \| 6993136 \|
	\| \| shwiki.pagelinks.00002.sql.gz \| 206741724 \| 201782736 \| 4958988 \|
	\| \| cebwiki.linter.sql.gz \| 17244155 \| 12405914 \| 4838241 \|
	\| \| srwiki.wbc_entity_usage.sql.gz \| 25953159 \| 21463042 \| 4490117 \|
	\| \| shwiki.pagelinks.00000.sql.gz \| 110844563 \| 106517642 \| 4326921 \|
	\| \| dewiki.pagelinks.00001.sql.gz \| 152694778 \| 156977203 \| 4282425 \|
	\| \| dewiki.flaggedtemplates.00014.sql.gz \| 1102625021 \| 1099755514 \| 2869507 \|
	\| \| dewiki.pagelinks.00008.sql.gz \| 214925189 \| 212297190 \| 2627999 \|
	\| \| dewiki.cu_private_event.sql.gz \| 12712018 \| 10162127 \| 2549891 \|
	\| \| shwiki.recentchanges.sql.gz \| 8557064 \| 6322301 \| 2234763 \|
	\| \| shwiki.content.00000.sql.gz \| 1210705538 \| 1208541338 \| 2164200 \|

Event Timeline

jcrespo created this paste.Sep 12 2023, 6:55 AM

	60.6 GB -17.1 % The previous backup had a size of 73.1 GB, a change larger than 15.0%

	SELECT A.file_path, A.file_name, A.size AS size_job_24644, B.size AS size_job_24532, ABS(CONVERT(B.size, SIGNED) - CONVERT(A.size, SIGNED)) AS difference FROM backup_files A JOIN backup_files B ON A.file_path = B.file_path AND A.file_name = B.file_name WHERE A.backup_id = 24644 AND B.backup_id = 24532 ORDER BY ABS(CONVERT(B.size, SIGNED) - CONVERT(A.size, SIGNED)) DESC;
	+-----------+--------------------------------------------------------------------+----------------+----------------+-------------+
	\| file_path \| file_name \| size_job_24644 \| size_job_24532 \| difference \|
	+-----------+--------------------------------------------------------------------+----------------+----------------+-------------+
	\| \| enwikivoyage.text.sql.gz \| 25572484 \| 13293264709 \| 13267692225 \|
	\| \| srwiki.text.00000.sql.gz \| 146137702 \| 523072282 \| 376934580 \|
	\| \| srwiki.pagelinks.00002.sql.gz \| 386543283 \| 47511167 \| 339032116 \|
	\| \| srwiki.pagelinks.00001.sql.gz \| 89139164 \| 407944461 \| 318805297 \|
	\| \| srwiki.pagelinks.00004.sql.gz \| 163009393 \| 7428990 \| 155580403 \|
	\| \| srwiki.pagelinks.00003.sql.gz \| 295102300 \| 435915150 \| 140812850 \|
	\| \| srwiki.pagelinks.00006.sql.gz \| 6395750 \| 72717793 \| 66322043 \|
	\| \| cebwiki.pagelinks.00001.sql.gz \| 97749617 \| 159523114 \| 61773497 \|
	\| \| cebwiki.pagelinks.00000.sql.gz \| 78722837 \| 135510023 \| 56787186 \|
	\| \| cebwiki.pagelinks.00002.sql.gz \| 94801973 \| 135987031 \| 41185058 \|
	\| \| dewiki.pagelinks.00005.sql.gz \| 177175970 \| 206829135 \| 29653165 \|
	\| \| dewiki.pagelinks.00007.sql.gz \| 209846893 \| 238486636 \| 28639743 \|
	\| \| dewiki.pagelinks.00004.sql.gz \| 161210478 \| 184727298 \| 23516820 \|
	\| \| shwiki.text.00000.sql.gz \| 231635661 \| 250933808 \| 19298147 \|
	\| \| dewiki.pagelinks.00003.sql.gz \| 148543816 \| 164570440 \| 16026624 \|
	\| \| avkwiki.pagelinks.sql.gz \| 37420331 \| 24425552 \| 12994779 \|
	\| \| srwiki.pagelinks.00000.sql.gz \| 104387875 \| 116989267 \| 12601392 \|
	\| \| shwiki.pagelinks.00004.sql.gz \| 205376863 \| 194221263 \| 11155600 \|
	\| \| dewiki.pagelinks.00002.sql.gz \| 151702204 \| 162711118 \| 11008914 \|
	\| \| dewiki.pagelinks.00000.sql.gz \| 297047372 \| 307993226 \| 10945854 \|
	\| \| dewiki.flaggedtemplates.00013.sql.gz \| 344555254 \| 335818950 \| 8736304 \|
	\| \| dewiki.pagelinks.00006.sql.gz \| 190624536 \| 199321243 \| 8696707 \|
	\| \| mgwiktionary.pagelinks.sql.gz \| 71330801 \| 64337665 \| 6993136 \|
	\| \| shwiki.pagelinks.00002.sql.gz \| 206741724 \| 201782736 \| 4958988 \|
	\| \| cebwiki.linter.sql.gz \| 17244155 \| 12405914 \| 4838241 \|
	\| \| srwiki.wbc_entity_usage.sql.gz \| 25953159 \| 21463042 \| 4490117 \|
	\| \| shwiki.pagelinks.00000.sql.gz \| 110844563 \| 106517642 \| 4326921 \|
	\| \| dewiki.pagelinks.00001.sql.gz \| 152694778 \| 156977203 \| 4282425 \|
	\| \| dewiki.flaggedtemplates.00014.sql.gz \| 1102625021 \| 1099755514 \| 2869507 \|
	\| \| dewiki.pagelinks.00008.sql.gz \| 214925189 \| 212297190 \| 2627999 \|
	\| \| dewiki.cu_private_event.sql.gz \| 12712018 \| 10162127 \| 2549891 \|
	\| \| shwiki.recentchanges.sql.gz \| 8557064 \| 6322301 \| 2234763 \|
	\| \| shwiki.content.00000.sql.gz \| 1210705538 \| 1208541338 \| 2164200 \|

s5 shrinkageActivePublicActions

Event Timeline

s5 shrinkage
ActivePublic
Actions