So... After 1.30.0-wmf.17 is everywhere, our #dba can drop the other two primary indexes that were blocked on a code change
```lang=sql
ALTER TABLE /*_*/pagelinks DROP INDEX /*i*/pl_from;
ALTER TABLE /*_*/templatelinks DROP INDEX /*i*/tl_from;
```
Index removal:
[x] s1
[x] s2
[] s3
[x] s4
[x] s5
[x] s6
[x] s7
Table defragmentation:
* s1
[x] db2016.codfw.wmnet
[x] db2034.codfw.wmnet
[x] db2042.codfw.wmnet
[x] db2055.codfw.wmnet
[x] db2062.codfw.wmnet
[x] db2069.codfw.wmnet
[x] db2070.codfw.wmnet
[x] db2071.codfw.wmnet
[x] db2072.codfw.wmnet
[x] dbstore2002.codfw.wmnet
[x] db2048.codfw.wmnet
[x] labsdb1003.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] labsdb1001.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] labsdb1009.eqiad.wmnet
[x] labsdb1010.eqiad.wmnet
[] labsdb1011.eqiad.wmnet
[] db1095.eqiad.wmnet
[x] dbstore1001.eqiad.wmnet (not altered)
[x] dbstore1002.eqiad.wmnet (not altered)
[x] db1080.eqiad.wmnet
[x] db1083.eqiad.wmnet
[x] db1089.eqiad.wmnet
[x] db1073.eqiad.wmnet
[x] db1066.eqiad.wmnet
[] db1065.eqiad.wmnet
[x] db1055.eqiad.wmnet
[x] db1051.eqiad.wmnet
[x] db1047.eqiad.wmnet (will not alter, at least until it gets replaced by a more powerful host)
[x] db1067.eqiad.wmnet
[] db1052.eqiad.wmnet
* s2
[x] dbstore2002.codfw.wmnet
[x] dbstore2001.codfw.wmnet
[x] db2035.codfw.wmnet
[x] db2041.codfw.wmnet
[x] db2049.codfw.wmnet
[x] db2056.codfw.wmnet
[x] db2063.codfw.wmnet
[x] db2064.codfw.wmnet
[x] db2017.codfw.wmnet
[x] labsdb1009.eqiad.wmnet
[x] labsdb1010.eqiad.wmnet
[] labsdb1011.eqiad.wmnet
[x] db1102.eqiad.wmnet
[x] labsdb1003.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] labsdb1001.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] dbstore1002.eqiad.wmnet (not altered)
[x] dbstore1001.eqiad.wmnet (not altered)
[] db1021.eqiad.wmnet
[] db1036.eqiad.wmnet
[x] db1047.eqiad.wmnet (not altered)
[] db1060.eqiad.wmnet
[x] db1074.eqiad.wmnet
[x] db1076.eqiad.wmnet
[x] db1090.eqiad.wmnet
[x] db1101.eqiad.wmnet
[] db1054.eqiad.wmnet
* s3 (probably not worth it)
* s4
[x] dbstore2002.codfw.wmnet
[x] db2073.codfw.wmnet
[x] db2065.codfw.wmnet
[x] db2058.codfw.wmnet
[x] db2044.codfw.wmnet
[x] db2037.codfw.wmnet
[x] db2019.codfw.wmnet
[x] db2051.codfw.wmnet
[x] labsdb1003.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] labsdb1001.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] db1102.eqiad.wmnet
[x] labsdb1009.eqiad.wmnet
[x] labsdb1010.eqiad.wmnet
[] labsdb1011.eqiad.wmnet
[x] dbstore1001.eqiad.wmnet (not altered)
[x] dbstore1002.eqiad.wmnet (not altered)
[x] db1053.eqiad.wmnet
[x] db1056.eqiad.wmnet
[x] db1064.eqiad.wmnet
[x] db1081.eqiad.wmnet
[x] db1084.eqiad.wmnet
[x] db1091.eqiad.wmnet
[x] db1097.eqiad.wmnet
[] db1068.eqiad.wmnet
* s5
[x] dbstore2001.codfw.wmnet
[x] db2079.codfw.wmnet
[x] db2075.codfw.wmnet
[x] db2038.codfw.wmnet
[x] db2045.codfw.wmnet
[x] db2052.codfw.wmnet
[x] db2059.codfw.wmnet
[x] db2066.codfw.wmnet
[x] db2023.codfw.wmnet
[x] labsdb1003.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] labsdb1001.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] labsdb1009.eqiad.wmnet
[x] labsdb1010.eqiad.wmnet
[x] labsdb1011.eqiad.wmnet
[x] db1095.eqiad.wmnet
[x] dbstore1001.eqiad.wmnet (not altered)
[x] dbstore1002.eqiad.wmnet (not altered)
[x] db1070.eqiad.wmnet
[x] db1071.eqiad.wmnet
[x] db1082.eqiad.wmnet
[x] db1087.eqiad.wmnet
[x] db1092.eqiad.wmnet
[x] db1096.eqiad.wmnet
[x] db1099.eqiad.wmnet
[x] db1100.eqiad.wmnet
[x] db1104.eqiad.wmnet
[x] db1105.eqiad.wmnet
[x] db1106.eqiad.wmnet
[] db1063.eqiad.wmnet
* s6
[x] dbstore2001.codfw.wmnet
[x] db2076.codfw.wmnet
[x] db2039.codfw.wmnet
[x] db2046.codfw.wmnet
[x] db2053.codfw.wmnet
[x] db2060.codfw.wmnet
[x] db2067.codfw.wmnet
[x] db2028.codfw.wmnet
[x] labsdb1009.eqiad.wmnet
[x] labsdb1010.eqiad.wmnet
[x] labsdb1011.eqiad.wmnet
[x] db1102.eqiad.wmnet
[x] labsdb1003.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] labsdb1001.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] dbstore1001.eqiad.wmnet (not altered)
[x] dbstore1002.eqiad.wmnet (not altered)
[] db1030.eqiad.wmnet
[x] db1050.eqiad.wmnet
[x] db1085.eqiad.wmnet
[x] db1088.eqiad.wmnet
[x] db1093.eqiad.wmnet
[x] db1098.eqiad.wmnet
[] db1061.eqiad.wmnet
* s7
[x] dbstore2001.codfw.wmnet
[x] db2077.codfw.wmnet
[x] db2040.codfw.wmnet
[x] db2047.codfw.wmnet
[x] db2054.codfw.wmnet
[x] db2061.codfw.wmnet
[x] db2068.codfw.wmnet
[x] db2029.codfw.wmnet
[x] labsdb1003.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] labsdb1001.eqiad.wmnet (will not alter, see: T174509#3668778)
[x] labsdb1009.eqiad.wmnet
[x] labsdb1010.eqiad.wmnet
[] labsdb1011.eqiad.wmnet
[x] db1102.eqiad.wmnet
[x] dbstore1001.eqiad.wmnet (not altered)
[x] dbstore1002.eqiad.wmnet (not altered)
[x] db1034.eqiad.wmnet
[x] db1039.eqiad.wmnet
[x] db1069.eqiad.wmnet
[x] db1079.eqiad.wmnet
[x] db1086.eqiad.wmnet
[x] db1094.eqiad.wmnet
[] db1062.eqiad.wmnet