Codfw media backup status
ActivePublic
Actions

Authored by jcrespo on Jun 17 2024, 10:12 AM.

Tags

Referenced Files

	F55402627: Codfw media backup status
	Jun 17 2024, 10:12 AM

Subscribers

ABran-WMF

	cumin2024@db2183.codfw.wmnet[mediabackups]> select backup_status, count(*) FROM files GROUP by backup_status;
	+---------------+-----------+
	\| backup_status \| count(*) \|
	+---------------+-----------+
	\| 1 \| 178 \|
	\| 3 \| 130210347 \|
	\| 4 \| 99437 \|
	\| 5 \| 3962963 \|
	+---------------+-----------+
	4 rows in set (24.827 sec)

Event Timeline

@ABran-WMF As you can see, codfw health status is much better (I queried it just before restarting it) ^

jcrespo added a project: media-backups.Jun 17 2024, 10:14 AM

This is the API request I filed: T267365

And this is the wiki distribution:

cumin2024@db2183.codfw.wmnet[mediabackups]> select wiki, count(*) FROM files GROUP by wiki ORDER BY count(*) DESC;
+------+-----------+
| wiki | count(*)  |
+------+-----------+
|  392 | 123455443 | <--- commonswiki
|  454 |   4924170 | <--- enwiki
|  424 |    689819 | <--- dewiki
|  935 |    562213 |
|  636 |    397122 |
|  517 |    238420 |
| 1195 |    218098 |
| 1110 |    210008 |
|  926 |    199929 |
|  566 |    173689 |
|  490 |    168047 |
|  610 |    163865 |
|  647 |    151500 |
| 1086 |    147770 |
|  280 |    128203 |
|  593 |    120568 |
|  901 |    112141 |
|  500 |    108611 |
| 1064 |    101314 |
...

taking that paste in note, thanks! :)

Codfw media backup statusActivePublicActions

Event Timeline

Codfw media backup status
ActivePublic
Actions