Wikireplicas hosts are approaching 90% usage on /srv:
===== NODE GROUP ===== (1) labsdb1010.eqiad.wmnet ----- OUTPUT of 'df -hT /srv' ----- Filesystem Type Size Used Avail Use% Mounted on /dev/mapper/tank-data xfs 12T 10T 1.7T 87% /srv ===== NODE GROUP ===== (1) labsdb1009.eqiad.wmnet ----- OUTPUT of 'df -hT /srv' ----- Filesystem Type Size Used Avail Use% Mounted on /dev/mapper/tank-data xfs 12T 10T 1.7T 86% /srv ===== NODE GROUP ===== (1) labsdb1012.eqiad.wmnet ----- OUTPUT of 'df -hT /srv' ----- Filesystem Type Size Used Avail Use% Mounted on /dev/mapper/tank-data xfs 14T 11T 3.9T 73% /srv ===== NODE GROUP ===== (1) labsdb1011.eqiad.wmnet ----- OUTPUT of 'df -hT /srv' ----- Filesystem Type Size Used Avail Use% Mounted on /dev/mapper/tank-data xfs 12T 11T 1.6T 87% /srv
I just did a quick check on enwiki and wikidata and there are indeed tables that need to be compressed (specially those that are temporary but also quite big), so I assume it is the case for most of the wikis
1 | +--------------+--------------------------------------------------+------------+ |
---|---|
2 | | table_schema | table_name | row_format | |
3 | +--------------+--------------------------------------------------+------------+ |
4 | | enwiki | abuse_filter | Compressed | |
5 | | enwiki | abuse_filter_action | Compressed | |
6 | | enwiki | abuse_filter_history | Compressed | |
7 | | enwiki | abuse_filter_log | Compressed | |
8 | | enwiki | actor | Compact | |
9 | | enwiki | archive | Compressed | |
10 | | enwiki | babel | Compressed | |
11 | | enwiki | betafeatures_user_counts | Compressed | |
12 | | enwiki | bv2011_edits | Compressed | |
13 | | enwiki | bv2013_edits | Compressed | |
14 | | enwiki | bv2015_edits | Compressed | |
15 | | enwiki | bv2017_edits | Compact | |
16 | | enwiki | category | Compressed | |
17 | | enwiki | categorylinks | Compact | |
18 | | enwiki | change_tag | Compressed | |
19 | | enwiki | change_tag_def | Compact | |
20 | | enwiki | comment | Compact | |
21 | | enwiki | content | Compact | |
22 | | enwiki | content_models | Compact | |
23 | | enwiki | externallinks | Compressed | |
24 | | enwiki | filearchive | Compressed | |
25 | | enwiki | flaggedimages | Compressed | |
26 | | enwiki | flaggedpage_config | Compressed | |
27 | | enwiki | flaggedpage_pending | Compressed | |
28 | | enwiki | flaggedpages | Compressed | |
29 | | enwiki | flaggedrevs | Compressed | |
30 | | enwiki | flaggedrevs_promote | Compressed | |
31 | | enwiki | flaggedrevs_statistics | Compressed | |
32 | | enwiki | flaggedrevs_stats | Compressed | |
33 | | enwiki | flaggedrevs_stats2 | Compressed | |
34 | | enwiki | flaggedrevs_tracking | Compressed | |
35 | | enwiki | flaggedtemplates | Compressed | |
36 | | enwiki | geo_tags | Compressed | |
37 | | enwiki | global_block_whitelist | Compressed | |
38 | | enwiki | image | Compressed | |
39 | | enwiki | imagelinks | Compact | |
40 | | enwiki | interwiki | Compressed | |
41 | | enwiki | ip_changes | Compact | |
42 | | enwiki | ipblocks | Compressed | |
43 | | enwiki | ipblocks_restrictions | Compact | |
44 | | enwiki | iwlinks | Compact | |
45 | | enwiki | l10n_cache | Compressed | |
46 | | enwiki | langlinks | Compact | |
47 | | enwiki | linter | Compact | |
48 | | enwiki | logging | Compressed | |
49 | | enwiki | math | Compact | |
50 | | enwiki | mathoid | Compressed | |
51 | | enwiki | module_deps | Compact | |
52 | | enwiki | oldimage | Compressed | |
53 | | enwiki | ores_classification | Compact | |
54 | | enwiki | ores_model | Compressed | |
55 | | enwiki | page | Compressed | |
56 | | enwiki | page_assessments | Compressed | |
57 | | enwiki | page_assessments_projects | Compact | |
58 | | enwiki | page_props | Compressed | |
59 | | enwiki | page_restrictions | Compressed | |
60 | | enwiki | pagelinks | Compact | |
61 | | enwiki | pagetriage_log | Compressed | |
62 | | enwiki | pagetriage_page | Compressed | |
63 | | enwiki | pagetriage_page_tags | Compressed | |
64 | | enwiki | pagetriage_tags | Compressed | |
65 | | enwiki | pif_edits | Compressed | |
66 | | enwiki | protected_titles | Compressed | |
67 | | enwiki | recentchanges | Compressed | |
68 | | enwiki | redirect | Compressed | |
69 | | enwiki | revision | Compressed | |
70 | | enwiki | revision_actor_temp | Compact | |
71 | | enwiki | revision_comment_temp | Compact | |
72 | | enwiki | searchindex | Compact | |
73 | | enwiki | site_identifiers | Compressed | |
74 | | enwiki | site_stats | Compressed | |
75 | | enwiki | sites | Compressed | |
76 | | enwiki | slot_roles | Compact | |
77 | | enwiki | slots | Compact | |
78 | | enwiki | templatelinks | Compact | |
79 | | enwiki | transcode | Compressed | |
80 | | enwiki | updatelog | Compressed | |
81 | | enwiki | user | Compressed | |
82 | | enwiki | user_former_groups | Compact | |
83 | | enwiki | user_groups | Compressed | |
84 | | enwiki | user_properties | Compressed | |
85 | | enwiki | wbc_entity_usage | Compressed | |
86 | | enwiki | wikilove_log | Compressed | |
87 | | wikidatawiki | abuse_filter | Compressed | |
88 | | wikidatawiki | abuse_filter_action | Compressed | |
89 | | wikidatawiki | abuse_filter_history | Compressed | |
90 | | wikidatawiki | abuse_filter_log | Compressed | |
91 | | wikidatawiki | actor | Compact | |
92 | | wikidatawiki | archive | Compressed | |
93 | | wikidatawiki | babel | Compressed | |
94 | | wikidatawiki | betafeatures_user_counts | Compressed | |
95 | | wikidatawiki | bv2013_edits | Compressed | |
96 | | wikidatawiki | bv2015_edits | Compressed | |
97 | | wikidatawiki | bv2017_edits | Compressed | |
98 | | wikidatawiki | category | Compressed | |
99 | | wikidatawiki | categorylinks | Compressed | |
100 | | wikidatawiki | change_tag | Compressed | |
101 | | wikidatawiki | change_tag_def | Compact | |
102 | | wikidatawiki | comment | Compact | |
103 | | wikidatawiki | config | Compressed | |
104 | | wikidatawiki | content | Compact | |
105 | | wikidatawiki | content_models | Compact | |
106 | | wikidatawiki | externallinks | Compressed | |
107 | | wikidatawiki | filearchive | Compressed | |
108 | | wikidatawiki | geo_tags | Compressed | |
109 | | wikidatawiki | global_block_whitelist | Compressed | |
110 | | wikidatawiki | globalblocks | Compressed | |
111 | | wikidatawiki | image | Compressed | |
112 | | wikidatawiki | imagelinks | Compressed | |
113 | | wikidatawiki | interwiki | Compressed | |
114 | | wikidatawiki | ip_changes | Compact | |
115 | | wikidatawiki | ipblocks | Compressed | |
116 | | wikidatawiki | ipblocks_restrictions | Compact | |
117 | | wikidatawiki | iwlinks | Compressed | |
118 | | wikidatawiki | l10n_cache | Compressed | |
119 | | wikidatawiki | langlinks | Compressed | |
120 | | wikidatawiki | linter | Compressed | |
121 | | wikidatawiki | logging | Compressed | |
122 | | wikidatawiki | math | Compressed | |
123 | | wikidatawiki | mathoid | Compressed | |
124 | | wikidatawiki | module_deps | Compressed | |
125 | | wikidatawiki | oldimage | Compressed | |
126 | | wikidatawiki | ores_classification | Compressed | |
127 | | wikidatawiki | ores_model | Compressed | |
128 | | wikidatawiki | page | Compressed | |
129 | | wikidatawiki | page_props | Compressed | |
130 | | wikidatawiki | page_restrictions | Compressed | |
131 | | wikidatawiki | pagelinks | Compact | |
132 | | wikidatawiki | protected_titles | Compressed | |
133 | | wikidatawiki | recentchanges | Compressed | |
134 | | wikidatawiki | redirect | Compressed | |
135 | | wikidatawiki | revision | Compressed | |
136 | | wikidatawiki | revision_actor_temp | Compact | |
137 | | wikidatawiki | revision_comment_temp | Compact | |
138 | | wikidatawiki | revtag | Compressed | |
139 | | wikidatawiki | searchindex | Compressed | |
140 | | wikidatawiki | site_identifiers | Compressed | |
141 | | wikidatawiki | site_stats | Compressed | |
142 | | wikidatawiki | sites | Compressed | |
143 | | wikidatawiki | slot_roles | Compact | |
144 | | wikidatawiki | slots | Compact | |
145 | | wikidatawiki | templatelinks | Compact | |
146 | | wikidatawiki | transcode | Compressed | |
147 | | wikidatawiki | translate_groupreviews | Compressed | |
148 | | wikidatawiki | translate_groupstats | Compressed | |
149 | | wikidatawiki | translate_messageindex | Compressed | |
150 | | wikidatawiki | translate_metadata | Compressed | |
151 | | wikidatawiki | translate_reviews | Compressed | |
152 | | wikidatawiki | translate_sections | Compressed | |
153 | | wikidatawiki | updatelog | Compressed | |
154 | | wikidatawiki | user | Compressed | |
155 | | wikidatawiki | user_former_groups | Compressed | |
156 | | wikidatawiki | user_groups | Compressed | |
157 | | wikidatawiki | user_properties | Compressed | |
158 | | wikidatawiki | wb_changes | Compressed | |
159 | | wikidatawiki | wb_changes_dispatch | Compressed | |
160 | | wikidatawiki | wb_changes_subscription | Compressed | |
161 | | wikidatawiki | wb_id_counters | Compressed | |
162 | | wikidatawiki | wb_items_per_site | Compressed | |
163 | | wikidatawiki | wb_property_info | Compressed | |
164 | | wikidatawiki | wb_terms | Compressed | |
165 | | wikidatawiki | wbc_entity_usage | Compressed | |
166 | | wikidatawiki | wbqc_constraints | Compressed | |
167 | | wikidatawiki | wbs_propertypairs | Compressed | |
168 | | wikidatawiki | wikimedia_editor_tasks_entity_description_exists | Compact | |
169 | +--------------+--------------------------------------------------+------------+ |
I think at the same time we we can just defragment all the tables, as I think they've not been defragmented since these hosts were set up around 2 years ago
Status:
- labsdb1009
- T222978#5364460
- labsdb1010
- T222978#5395308
- labsdb1011
- T222978#5305810
- labsdb1012
- T222978#5246257