https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
tobias.gritschac...@wikimedia.de changed:
What|Removed |Added
Status|PATCH_TO_REVIEW |RESOLVED
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
tobias.gritschac...@wikimedia.de changed:
What|Removed |Added
Status|RESOLVED|VERIFIED
--
You are
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #14 from Gerrit Notification Bot ---
Change 99660 merged by jenkins-bot:
(bug 45529) use composite indexes on wb_terms.
https://gerrit.wikimedia.org/r/99660
--
You are receiving this mail because:
You are on the CC list for the b
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #13 from Sean Pringle ---
FTR, correction for my comment #10: I said:
"Note that I left term_language in terms_search despite the partitions because
getMatchingIDs query still benefits from ICP when term_search_key is used with
a p
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #12 from Daniel Kinzler ---
> Partitions aren't suitable for tables.sql as we still say we support MySQL
> 5.0+, but I think it's worthwhile for this particular table on WMF production
> slaves.
Note that this is for the Wikibase e
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #11 from Daniel Kinzler ---
(In reply to comment #10)
> Pulled from db1021 with the old wb_% indexes after a few hours of activity:
Thank you for the thorough analysis and the helpful suggestions! I don't
understand mysql's interna
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #10 from Sean Pringle ---
Pulled from db1021 with the old wb_% indexes after a few hours of activity:
+--++-++
| TABLE_SCHEMA | TABLE_NAME | INDEX_NAME | ROWS_READ |
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #9 from Gerrit Notification Bot ---
Change 99660 had a related patch set uploaded by Daniel Kinzler:
(bug 45529) use composite indexes on wb_terms.
https://gerrit.wikimedia.org/r/99660
--
You are receiving this mail because:
You
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Gerrit Notification Bot changed:
What|Removed |Added
Status|ASSIGNED|PATCH_TO_REVIEW
--
You are
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #8 from Daniel Kinzler ---
(In reply to comment #3)
> It looks like there are four common select query types in production:
>
> 1) /* Wikibase\TermSqlIndex::getTermsOfEntity */ select term_language,
> term_type, term_text from `wb_
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Daniel Kinzler changed:
What|Removed |Added
Status|NEW |ASSIGNED
--
You are receiving this m
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Daniel Kinzler changed:
What|Removed |Added
Whiteboard|backlog |backlog, termsearch
--
You are recei
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Addshore changed:
What|Removed |Added
CC||addshorew...@gmail.com
Whiteboard|
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Addshore changed:
What|Removed |Added
Blocks||44529
--
You are receiving this mail becau
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #7 from Sean Pringle ---
While this is still in limbo, to keep production alive, last week I added this
temporary index:
KEY `tmp1` (`term_language`,`term_type`,`term_entity_type`,`term_search_key`)
This query form (2 in comment #
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Daniel Kinzler changed:
What|Removed |Added
Severity|normal |major
--- Comment #6 from Daniel Kinz
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
denny vrandecic changed:
What|Removed |Added
Severity|major |normal
--
You are receiving this ma
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Max Semenik changed:
What|Removed |Added
CC||maxsem.w...@gmail.com
Severity
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
denny vrandecic changed:
What|Removed |Added
Priority|Unprioritized |High
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #4 from Daniel Kinzler ---
Thanks for the analysis Asher!
> If the combination ( term_entity_type, term_entity_id ) is guaranteed to be
> unique, and it will be used to delete rows, define this index as unique to
> minimize locking
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Andre Klapper changed:
What|Removed |Added
Keywords||performance
--
You are receiving this
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #3 from Asher Feldman ---
(In reply to comment #0)
> Since only a single index will be used for any given query, this is not
> helpful, and results in inefficient searches.
This isn't strictly true. Since the select queries in pr
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #2 from Daniel Kinzler ---
> What is the wb_terms table? I need a human-readable one line description
> (for non wikibase users) which will accompany it on the dumps page.
wb_terms associates labels, aliases and description in a
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Ariel T. Glenn changed:
What|Removed |Added
CC||ar...@wikimedia.org
--- Comment #1 fr
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Bawolff (Brian Wolff) changed:
What|Removed |Added
CC||bawolff...@gmail.com
--
You a
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Sam Reed (reedy) changed:
What|Removed |Added
Severity|normal |enhancement
--
You are receiving t
https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
Daniel Kinzler changed:
What|Removed |Added
CC||afeld...@wikimedia.org,
27 matches
Mail list logo
