Marostegui added a comment. |
The index has been dropped from all codfw.
I am optimizing a non-compressed slave to see if the gain is worth the time. As we have seen that probably for a compressed one is not.
root@neodymium:/home/marostegui/git/software/dbtools# cat s5.hosts | grep codfw | while read host port; do echo $host:$port; mysql --skip-ssl wikidatawiki -h$host -P$port -e "show create table wb_terms\G" | grep wb_terms_language; done dbstore2001.codfw.wmnet:3315 db2089.codfw.wmnet:3315 db2086.codfw.wmnet:3315 db2085.codfw.wmnet:3315 db2084.codfw.wmnet:3315 db2083.codfw.wmnet:3306 db2082.codfw.wmnet:3306 db2081.codfw.wmnet:3306 db2080.codfw.wmnet:3306 db2079.codfw.wmnet:3306 db2075.codfw.wmnet:3306 db2038.codfw.wmnet:3306 db2045.codfw.wmnet:3306 db2052.codfw.wmnet:3306 db2059.codfw.wmnet:3306 db2066.codfw.wmnet:3306 db2023.codfw.wmnet:3306
This is the non-compressed status:
root@db2052:~# ls -lh /srv/sqldata/wikidatawiki/wb_terms.ibd -rw-rw---- 1 mysql mysql 718G Nov 13 07:32 /srv/sqldata/wikidatawiki/wb_terms.ibd
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui
Cc: Lydia_Pintscher, Stashbot, Ladsgroup, daniel, Marostegui, Aklapper, hoo, Lahi, GoranSMilovanovic, QZanden, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
Cc: Lydia_Pintscher, Stashbot, Ladsgroup, daniel, Marostegui, Aklapper, hoo, Lahi, GoranSMilovanovic, QZanden, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs