table sizes

ActivePublic

Actions

root@db1115.eqiad.wmnet[zarcillo]> select IF(LOCATE('eqiad', source), 'eqiad', 'codfw') as dc, section, round (total_size / 1024/1024/1024 * 100)/100 as GB FROM backups where start_date > now() - interval 23 hour ORDER BY total_size DESC;
+-------+---------+-----------+
| dc    | section | GB        |
+-------+---------+-----------+
| eqiad | s8      | 1450.8400 |
| codfw | s8      | 1150.2200 |
| eqiad | s4      |  994.5700 |
| codfw | s4      |  969.4600 |
| eqiad | s1      |  896.9300 |
| eqiad | s2      |  805.2100 |
| eqiad | s7      |  801.9200 |
| eqiad | s3      |  800.4600 |
| codfw | s3      |  713.2600 |
| codfw | s5      |  608.6100 |
| codfw | x1      |  110.6500 |
| eqiad | x1      |   95.5100 |
| codfw | s1      |      NULL |
+-------+---------+-----------+
13 rows in set (0.00 sec)

root@db1115.eqiad.wmnet[zarcillo]> select file_path, file_name, round(size/1024/1024/1024 * 100)/100 as GB FROM backup_files where backup_id=1311 order by size desc LIMIT 20;                                                                  +--------------+------------------------------------------------------+----------+
| file_path    | file_name                                            | GB       |
+--------------+------------------------------------------------------+----------+
| wikidatawiki | wb_terms.ibd                                         | 475.8500 |
| wikidatawiki | revision.ibd                                         | 188.8200 |
| wikidatawiki | revision_actor_temp.ibd                              | 161.7200 |
| wikidatawiki | pagelinks.ibd                                        | 155.5300 |
| wikidatawiki | slots.ibd                                            |  87.2900 |
| wikidatawiki | content.ibd                                          |  86.7900 |
| wikidatawiki | revision_comment_temp.ibd                            |  51.8000 |
| wikidatawiki | comment.ibd                                          |  45.0700 |
| wikidatawiki | change_tag.ibd                                       |  42.6300 |
| wikidatawiki | text.ibd                                             |  36.4000 |
| wikidatawiki | cu_changes.ibd                                       |  20.6700 |
| wikidatawiki | page_props.ibd                                       |  15.8800 |
| wikidatawiki | wb_items_per_site.ibd                                |  12.0900 |
| wikidatawiki | externallinks.ibd                                    |  10.4100 |
| wikidatawiki | recentchanges.ibd                                    |   8.5500 |
| wikidatawiki | page.ibd                                             |   6.7300 |
| wikidatawiki | wikimedia_editor_tasks_entity_description_exists.ibd |   6.2200 |
| wikidatawiki | wb_changes_subscription.ibd                          |   5.2400 |
| wikidatawiki | __wmf_checksums.ibd                                  |   4.7200 |
| wikidatawiki | watchlist.ibd                                        |   4.3500 |
+--------------+------------------------------------------------------+----------+
20 rows in set (0.00 sec)

root@db1115.eqiad.wmnet[zarcillo]> select file_path, file_name, round(size/1024/1024/1024 * 100)/100 as GB FROM backup_files where backup_id=1316 order by size desc LIMIT 20; 
+--------------+-----------------------------+----------+
| file_path    | file_name                   | GB       |
+--------------+-----------------------------+----------+
| wikidatawiki | wb_terms.ibd                | 475.3400 |
| wikidatawiki | revision.ibd                | 188.8600 |
| wikidatawiki | revision_actor_temp.ibd     |  77.0800 |
|              | ibdata1                     |  66.6500 |
| wikidatawiki | pagelinks.ibd               |  58.3400 |
| wikidatawiki | content.ibd                 |  45.8400 |
| wikidatawiki | text.ibd                    |  36.4100 |
| wikidatawiki | slots.ibd                   |  33.4800 |
| wikidatawiki | revision_comment_temp.ibd   |  27.7100 |
| wikidatawiki | cu_changes.ibd              |  20.7100 |
| wikidatawiki | comment.ibd                 |  19.9700 |
| wikidatawiki | change_tag.ibd              |  19.2000 |
| wikidatawiki | page_props.ibd              |  15.8500 |
| wikidatawiki | externallinks.ibd           |  10.6900 |
| wikidatawiki | recentchanges.ibd           |   8.4000 |
| wikidatawiki | page.ibd                    |   6.7500 |
| wikidatawiki | wb_items_per_site.ibd       |   6.4000 |
| wikidatawiki | wb_changes_subscription.ibd |   5.2300 |
| wikidatawiki | __wmf_checksums.ibd         |   4.7200 |
| wikidatawiki | watchlist.ibd               |   4.3800 |
+--------------+-----------------------------+----------+
20 rows in set (0.00 sec)