Ladsgroup added a comment.
In T191391#4245229, @jcrespo wrote:
So, to clarify, we can remove all data here and eliminate the extra accounts?
Yup.TASK DETAILhttps://phabricator.wikimedia.org/T191391EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc:
Marostegui added a comment.
Yes, it is marked as not repool on the configTASK DETAILhttps://phabricator.wikimedia.org/T191391EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Ladsgroup, MarosteguiCc: Marostegui, Aklapper, Lucas_Werkmeister_WMDE, Jonas, jcrespo,
jcrespo added a comment.
Don't repool it unless it's back to the old status.
So, to clarify, we can remove all data here and eliminate the extra accounts?TASK DETAILhttps://phabricator.wikimedia.org/T191391EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Ladsg
Ladsgroup added a comment.
I think this part is done, I make some actionables.TASK DETAILhttps://phabricator.wikimedia.org/T191391EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: Aklapper, Lucas_Werkmeister_WMDE, Jonas, jcrespo, Ladsgroup, Lahi, Gq
jcrespo added a comment.
Yes, that is much better.TASK DETAILhttps://phabricator.wikimedia.org/T191391EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Ladsgroup, jcrespoCc: Aklapper, Lucas_Werkmeister_WMDE, Jonas, jcrespo, Ladsgroup, Lahi, Gq86, GoranSMilovanov
Ladsgroup added a comment.
After running the optimize table we have this now:
test_user@db2083.codfw.wmnet(wikidatawiki)>SELECT * from information_schema.TABLES where TABLE_NAME = 'wb_terms'\G;
*** 1. row ***
TABLE_CATALOG: def
TABLE_SCHEMA: wik
Ladsgroup added a comment.
That is very valid. I looked into indexes:
test_user@db2083.codfw.wmnet(wikidatawiki)>show index from wb_terms;
+--++-+--+-+---+-+--++--++-
jcrespo added a comment.
The indexes seem disproportionally large compared to the data. Could the table be split somehow in a 1:1 relationship that could make sense (e.g. index_table with just columns to search and data_table with almost just the primary index).TASK DETAILhttps://phabricator.wikime
Ladsgroup added a comment.
Yeah, Some of my changes are done now. what do you think of this data?
test_user@db2083.codfw.wmnet(wikidatawiki)>SELECT * from information_schema.TABLES where TABLE_NAME = 'wb_terms'\G;
*** 1. row ***
TABLE_CATALOG: def