Hosts with tables that are compressed on the .frm file but InnoDB thinks they are Compact
templatelinks tables are being fixed at T301848 so feel free to ignore those if they show up here.
- s1 not affected
- s2 not affected
- s3, tables:
- dbstore1007.eqiad.wmnet:3313 (steward.pagelinks)
- db2074.codfw.wmnet:3306 (hundreds of wikis for pagelinks)
- db1179.eqiad.wmnet:3306 (hundreds of wikis for pagelinks)
- db1175.eqiad.wmnet:3306 (hundreds of wikis for pagelinks)
- db1166.eqiad.wmnet:3306 (hundreds of wikis for pagelinks and templatelinks)
- db1123.eqiad.wmnet:3306 (hundreds of wikis for pagelinks)
- s4 not affected
- s5 not affected
- s6 not affected
- s7, tables: templatelinks pagelinks
- db2077.codfw.wmnet
- s8 not affected
Get tables and wikis: select table_schema,table_name FROM information_schema.tables where CREATE_OPTIONS like '%COMPRESSED%' and ENGINE='InnoDB' and ROW_FORMAT <> 'COMPRESSED';
Fix tables: BE AWARE IF BINLOG NEEDS TO BE DISABLED OR NOT alter table XXXX engine=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, force;