page and revision on s6 changes
ActivePublic
Actions

Authored by jcrespo on Jun 17 2020, 2:38 PM.

Tags

None

Referenced Files

	F31869391: raw.txt
	Jun 17 2020, 2:38 PM

Subscribers

None

	root@db2093.codfw.wmnet[zarcillo]> select file_path, file_name, size FROM backup_files where backup_id=6320 and file_name IN ('page.ibd', 'revision.ibd');
	+-----------+--------------+-------------+
	\| file_path \| file_name \| size \|
	+-----------+--------------+-------------+
	\| frwiki \| page.ibd \| 1681915904 \|
	\| frwiki \| revision.ibd \| 38897975296 \|
	\| jawiki \| page.ibd \| 574619648 \|
	\| jawiki \| revision.ibd \| 18299748352 \|
	\| ruwiki \| page.ibd \| 1069547520 \|
	\| ruwiki \| revision.ibd \| 23731372032 \|
	+-----------+--------------+-------------+
	6 rows in set (0.04 sec)

	root@db2093.codfw.wmnet[zarcillo]> select file_path, file_name, size FROM backup_files where backup_id=6370 and file_name IN ('page.ibd', 'revision.ibd');
	+-----------+--------------+-------------+
	\| file_path \| file_name \| size \|
	+-----------+--------------+-------------+
	\| frwiki \| page.ibd \| 1681915904 \|
	\| frwiki \| revision.ibd \| 21881683968 \|
	\| jawiki \| page.ibd \| 574619648 \|
	\| jawiki \| revision.ibd \| 10141827072 \|
	\| ruwiki \| page.ibd \| 1069547520 \|
	\| ruwiki \| revision.ibd \| 13123977216 \|
	+-----------+--------------+-------------+
	6 rows in set (0.04 sec)

Event Timeline

jcrespo created this paste.Jun 17 2020, 2:38 PM

root@db2093.codfw.wmnet[zarcillo]> select file_path, file_name, size FROM backup_files where backup_id=6320 order by size desc limit 20;
+-----------+-------------------------+-------------+
| file_path | file_name               | size        |
+-----------+-------------------------+-------------+
| ruwiki    | flaggedtemplates.ibd    | 61471719424 |
| frwiki    | revision.ibd            | 38897975296 |
| frwiki    | pagelinks.ibd           | 38856032256 |
| ruwiki    | flaggedimages.ibd       | 27195867136 |
| ruwiki    | pagelinks.ibd           | 26692550656 |
| ruwiki    | revision.ibd            | 23731372032 |
| frwiki    | templatelinks.ibd       | 20367540224 |
| ruwiki    | logging.ibd             | 18475909120 |
| jawiki    | revision.ibd            | 18299748352 |
| jawiki    | pagelinks.ibd           | 17137926144 |
| frwiki    | revision_actor_temp.ibd | 15934160896 |
| frwiki    | categorylinks.ibd       | 13933477888 |
| frwiki    | text.ibd                | 13325303808 |
| ruwiki    | templatelinks.ibd       | 13010731008 |
| frwiki    | externallinks.ibd       | 11316232192 |
| ruwiki    | revision_actor_temp.ibd |  9659482112 |
| frwiki    | content.ibd             |  9432989696 |
| ruwiki    | externallinks.ibd       |  9240051712 |
| ruwiki    | categorylinks.ibd       |  7923040256 |
| jawiki    | revision_actor_temp.ibd |  7688159232 |
+-----------+-------------------------+-------------+
20 rows in set (0.04 sec)

root@db2093.codfw.wmnet[zarcillo]> select file_path, file_name, size FROM backup_files where backup_id=6370 order by size desc limit 20; 
+-----------+-------------------------+-------------+
| file_path | file_name               | size        |
+-----------+-------------------------+-------------+
| ruwiki    | flaggedtemplates.ibd    | 61530439680 |
| frwiki    | pagelinks.ibd           | 38864420864 |
| ruwiki    | flaggedimages.ibd       | 27216838656 |
| ruwiki    | pagelinks.ibd           | 26721910784 |
| frwiki    | revision.ibd            | 21881683968 |
| frwiki    | templatelinks.ibd       | 20380123136 |
| ruwiki    | logging.ibd             | 18475909120 |
| jawiki    | pagelinks.ibd           | 17142120448 |
| frwiki    | revision_actor_temp.ibd | 15938355200 |
| frwiki    | categorylinks.ibd       | 13933477888 |
| frwiki    | text.ibd                | 13333692416 |
| ruwiki    | revision.ibd            | 13123977216 |
| ruwiki    | templatelinks.ibd       | 13019119616 |
| frwiki    | externallinks.ibd       | 11316232192 |
| jawiki    | revision.ibd            | 10141827072 |
| ruwiki    | revision_actor_temp.ibd |  9663676416 |
| frwiki    | content.ibd             |  9437184000 |
| ruwiki    | externallinks.ibd       |  9244246016 |
| ruwiki    | categorylinks.ibd       |  7927234560 |
| jawiki    | revision_actor_temp.ibd |  7688159232 |
+-----------+-------------------------+-------------+
20 rows in set (0.03 sec)

page and revision on s6 changesActivePublicActions

Event Timeline

page and revision on s6 changes
ActivePublic
Actions