Event Timeline
Comment Actions
size of backups (compressed)
root@db1115.eqiad.wmnet[zarcillo]> select substring_index(substring_index(substring_index(file_name, '.', 2), '.', -1), '-', 1) as `table`, sum(size) as size FROM backup_files where backup_id = 747 and file_name NOT IN ('metadata', 'wikidatawiki-schema-create.sql.gz') GROUP BY `table` ORDER BY size DESC LIMIT 20;
+-------------------------+-------------+
| table | size |
+-------------------------+-------------+
| revision | 38462709159 |
| content | 27273617624 |
| wb_terms | 20915618812 |
| revision_actor_temp | 6959057227 |
| slots | 5868178679 |
| comment | 5439987344 |
| text | 4928554201 |
| pagelinks | 3806579248 |
| revision_comment_temp | 3685676534 |
| cu_changes | 2272141614 |
| change_tag | 2235827026 |
| page | 1627134193 |
| page_props | 1273474164 |
| wb_items_per_site | 1147032450 |
| recentchanges | 768951120 |
| externallinks | 512882359 |
| wb_changes_subscription | 493416151 |
| __wmf_checksums | 483339960 |
| archive | 397376121 |
| watchlist | 310476788 |
+-------------------------+-------------+
20 rows in set (0.00 sec)