[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-25 Thread eprodromou
eprodromou removed a project: Platform Engineering. eprodromou added a comment. This seems like we're just waiting for the upgrades to happen, so there's not a real job for PET to do. Re-tag us if there's more than is obvious here. TASK DETAIL https://phabricator.wikimedia.org/T254688

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-25 Thread Reedy
Reedy added projects: Performance Issue, MediaWiki-Special-pages. TASK DETAIL https://phabricator.wikimedia.org/T254688 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Marostegui, Reedy Cc: aaron, daniel, Lydia_Pintscher, Ladsgroup, Addshore,

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-25 Thread Marostegui
Marostegui claimed this task. Marostegui added a subscriber: aaron. Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board. TASK DETAIL https://phabricator.wikimedia.org/T254688 WORKBOARD https://phabricator.wikimedia.org/project/board/1060/ EMAIL

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-25 Thread Marostegui
Marostegui added a parent task: T250666: Upgrade WMF database-and-backup-related hosts to buster. TASK DETAIL https://phabricator.wikimedia.org/T254688 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: aaron, Marostegui Cc: daniel, Lydia_Pintscher,

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-25 Thread Marostegui
Marostegui added a project: DBA. Marostegui changed the task status from "Open" to "Stalled". Marostegui added a comment. From what I can see the optimizer is chosen either `PRIMARY` or `page_len` depending on the version and the query speeds entirely depends on the MariaDB version as well:

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-24 Thread daniel
daniel added a comment. In T254688#6406171 , @Lydia_Pintscher wrote: > Ok thanks. That special page is rather important for Wikidata and turning it off completely is not an option I fear. My idea was to turn of the "indirect links"

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-24 Thread Lydia_Pintscher
Lydia_Pintscher added a comment. In T254688#6405467 , @daniel wrote: > In T254688#6395860 , @Lydia_Pintscher wrote: > >> Hard to tell without the context of when this is happening

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-24 Thread daniel
daniel added a comment. In T254688#6405484 , @Marostegui wrote: > The only workaround we've found is sadly, using `FORCE`, `USE` or `IGNORE INDEX` on the queries to bypass those issues. Sometimes issues get fixed by running an

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-24 Thread Marostegui
Marostegui added a project: mariadb-optimizer-bug. Marostegui added a comment. Unfortunately hard to tell, but the optimizer behaves differently when there is lots of data and sometimes it does silly things :-(. We have seen over the years, especially with massive tables. The only

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-24 Thread daniel
daniel added a comment. In T254688#6395860 , @Lydia_Pintscher wrote: > Hard to tell without the context of when this is happening for users. Does anyone know? The query in question is generated by

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-24 Thread Marostegui
Marostegui added a comment. In T254688#6394904 , @daniel wrote: > Back to the inbox for triage. This isn't actionable as it is. We'd probably have to design a new schema for representing the relevant info in the DB to make this work.

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-19 Thread Lydia_Pintscher
Lydia_Pintscher added a comment. Hard to tell without the context of when this is happening for users. Does anyone know? TASK DETAIL https://phabricator.wikimedia.org/T254688 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: aaron, Lydia_Pintscher

[Wikidata-bugs] [Maniphest] T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing

2020-08-18 Thread daniel
daniel added subscribers: Lydia_Pintscher, daniel. daniel edited projects, added Platform Engineering; removed Platform Team Workboards (Clinic Duty Team). daniel added a comment. Back to the inbox for triage. This isn't actionable as it is. We'd probably have to design a new schema for