In T205865 we realized that compressed tables sped up our dispatch queries to wb_changes_dispatch.
In the interest of keeping WMF production the same everywhere we should also do this on testwikidatawiki
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Addshore | T85414 wikibase: synchronize schema on production with what is created on install | |||
| Resolved | Marostegui | T207359 compress wb_changes_dispatch on testwikidatawiki |
Event Timeline
Comment Actions
For the record, this table only has 4 rows, so it can probably done directly on the master with replication (once we are out of the woods with s8)
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2018-10-23T06:02:09Z] <marostegui> Deploy schema change on s3 - T207359
Comment Actions
This has now been done:
root@neodymium:/home/marostegui# ./section s3 | while read host port; do echo $host:$port; mysql.py -h$host:$port testwikidatawiki -e "show create table wb_changes_dispatch\G" | grep ENGINE;done labsdb1011.eqiad.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 labsdb1010.eqiad.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 labsdb1009.eqiad.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 dbstore2002.codfw.wmnet:3313 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 dbstore1002.eqiad.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 /* `compression`='tokudb_zlib' */ db2094.codfw.wmnet:3313 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db2074.codfw.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db2057.codfw.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db2050.codfw.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db2043.codfw.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db2036.codfw.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db1124.eqiad.wmnet:3313 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db1123.eqiad.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db1095.eqiad.wmnet:3313 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db1078.eqiad.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db1077.eqiad.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 db1075.eqiad.wmnet:3306 ) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8