root@dbstore1001:~$ mysql --socket=/run/mysqld/mysqld.s1.sock -BN information_schema -e "select table_name FROM tables WHERE table_schema='enwiki' and engine='InnoDB' and row_format <> 'Compressed' and (data_length + index_length) < (5 * 1024 * 1024 * 1024) ORDER BY data_length + index_length DESC" | while read table; do mysql --socket=/run/mysqld/mysqld.s1.sock enwiki -e "ALTER TABLE $table row_format=Compressed"; done
ERROR 1062 (23000) at line 1: Duplicate entry '1047393233' for key 'ts_rc_id'
ERROR 1062 (23000) at line 1: Duplicate entry 'Q30325899-T-44294723' for key 'eu_entity_id'
root@dbstore1001:~$ mysql --socket=/run/mysqld/mysqld.s1.sock -BN information_schema -e "select table_name FROM tables WHERE table_schema='enwiki' and engine='InnoDB' and row_format <> 'Compressed' and (data_length + index_length) < (5 * 1024 * 1024 * 1024) ORDER BY data_length + index_length DESC"
tag_summary
wbc_entity_usage
root@dbstore1001:~$ mysql --socket=/run/mysqld/mysqld.s1.sock -BN information_schema -e "select table_name FROM tables WHERE table_schema='enwiki' and engine='InnoDB' and row_format <> 'Compressed' and (data_length + index_length) < (5 * 1024 * 1024 * 1024) ORDER BY data_length + index_length DESC" | while read table; do mysql --socket=/run/mysqld/mysqld.s1.sock enwiki -e "ALTER TABLE $table row_format=Compressed"; done
ERROR 1062 (23000) at line 1: Duplicate entry '1047431902' for key 'ts_rc_id'
root@dbstore1001:~$ mysql --socket=/run/mysqld/mysqld.s1.sock -BN information_schema -e "select table_name FROM tables WHERE table_schema='enwiki' and engine='InnoDB' and row_format <> 'Compressed' and (data_length + index_length) < (5 * 1024 * 1024 * 1024) ORDER BY data_length + index_length DESC" | while read table; do mysql --socket=/run/mysqld/mysqld.s1.sock enwiki -e "ALTER TABLE $table row_format=Compressed"; done
ERROR 1062 (23000) at line 1: Duplicate entry '1047454714' for key 'ts_rc_id'