This table should get compressed on those hosts where it is not:
root@cumin1001:/home/marostegui# ./section x1 | while read host port; do echo $host:$port; mysql.py -h$host:$port wikishared -e "show create table cx_corpora\G" | grep -i ROW;done dbstore1005.eqiad.wmnet:3320 *************************** 1. row *************************** ) ENGINE=InnoDB AUTO_INCREMENT=21600013 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED db2131.codfw.wmnet:3306 *************************** 1. row *************************** db2115.codfw.wmnet:3306 *************************** 1. row *************************** db2101.codfw.wmnet:3320 *************************** 1. row *************************** ) ENGINE=InnoDB AUTO_INCREMENT=21600013 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED db2096.codfw.wmnet:3306 *************************** 1. row *************************** db1140.eqiad.wmnet:3320 *************************** 1. row *************************** ) ENGINE=InnoDB AUTO_INCREMENT=21600013 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED db1137.eqiad.wmnet:3306 *************************** 1. row *************************** ) ENGINE=InnoDB AUTO_INCREMENT=21600013 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED db1127.eqiad.wmnet:3306 *************************** 1. row *************************** ) ENGINE=InnoDB AUTO_INCREMENT=21600013 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED db1120.eqiad.wmnet:3306 *************************** 1. row ***************************
Progress on the hosts that need compression:
- db2131
- db2115
- db2096
- db1140
- db1120 (master)