Tasks By Project

Project: mariadb-optimizer-bug

Switch to Active Tasks 18 Phabricator task(s).

Phabricator Link	Wiki Link	Status	Priority	Projects	Subtasks	Parent Tasks
T221458	T221458: Special:Log on commons -- entire web request took longer than 60 seconds and timed out	resolved	Unbreak Now! (pink)	mariadb-optimizer-bug (Worked around in code) DBA (In progress) Wikimedia-Rdbms (Untriaged) Platform Team Workboards (Done with CPT) SRE (Backlog) Performance Issue MW-1.34-notes (1.34.0-wmf.3; 2019-04-30) Wikimedia-production-error (Apr 2019 / 1.33.wmf.25+) MediaWiki-Logevents (Backlog)
T221511	T221511: Possible full scan query ApiQueryUserContribs::execute for revision_actor_temp table on commonswiki	resolved	Needs Triage (violet)	Wikimedia-Rdbms (Untriaged) MW-1.34-notes (1.34.0-wmf.3; 2019-04-30) Platform Team Workboards (Done with CPT) Performance Issue mariadb-optimizer-bug (Worked around in code)
T223151	T223151: Review special replica partitioning of certain tables by `xx_user`	resolved	Medium (orange)	mariadb-optimizer-bug (Fixed in a higher optimizer version) Platform Engineering (Tracking/Watching) DBA (In progress) MW-1.34-notes (1.34.0-wmf.24; 2019-09-24) Performance Issue	T233625: Change PK and remove partitions from the logging table T239453: Remove partitions from revision table	T233579: Tracking task for mariadb optimizer misbehaviours
T224017	T224017: Slow query ApiQueryRevisions on enwiki	resolved	High (red)	Platform Engineering (Needs Cleaning - Security, stability, performance, and scalability (TEC1)) Platform Team Workboards (Done with CPT) MW-1.34-notes (1.34.0-wmf.7; 2019-05-28) Wikimedia-Rdbms (Untriaged) DBA (In progress) mariadb-optimizer-bug (Worked around in code) User-Marostegui (Watching)
T231196	T231196: $wgActorTableSchemaMigrationStage = SCHEMA_COMPAT_NEW; brings down translatewiki.net	resolved	Needs Triage (violet)	MediaWiki-General Platform Team Workboards (Clinic Duty Team) (Done) MW-1.34-notes (1.34.0-wmf.21; 2019-09-03) mariadb-optimizer-bug (Worked around in code) affects-translatewiki.net (Backlog)
T236376	T236376: SELECT /* Title::getFirstRevision */ sometimes using page_user_timestamp index instead of page_timestamp	resolved	Medium (orange)	mariadb-optimizer-bug (Currently not fixed) DBA (Pending comment) Platform Team Workboards (Clinic Duty Team) (Discussing)
T237026	T237026: Page creation log cannot be viewed from oldest records, Fatal: "execution time limit of 60 seconds was exceeded"	resolved	Needs Triage (violet)	DBA (In progress) MW-1.35-notes (1.35.0-wmf.8; 2019-11-26) mariadb-optimizer-bug (Worked around in code) MediaWiki-Logevents (Backlog) Platform Team Workboards (Clinic Duty Team) (Done) Wikimedia-production-error (Nov2019/1.35.wmf.5+) Performance Issue
T238378	T238378: Bot edit count endpoint is timing out	resolved	High (red)	Platform Team Workboards (Green) (Done) mariadb-optimizer-bug (Worked around in code) Platform Team Initiatives (MW REST API in PHP) MW-1.35-notes (1.35.0-wmf.8; 2019-11-26) MediaWiki-REST-API (Backlog)
T240418	T240418: Slow query on arwiki for ApiQueryUserContribs::execute	resolved	Needs Triage (violet)	Performance Issue Platform Team Workboards (Clinic Duty Team) (Discussing) mariadb-optimizer-bug (Currently not fixed)
T244254	T244254: ApiQueryExtLinksUsage::run needs tuning	resolved	Needs Triage (violet)	Platform Team Workboards (Clinic Duty Team) (Waiting for Review) MW-1.35-notes (1.35.0-wmf.19; 2020-02-11) MediaWiki-API (Needs Review) mariadb-optimizer-bug (Worked around in code) Performance Issue
T244533	T244533: Slow query taking up to 60 seconds to run IndexPager::buildQueryInfo (NewFilesPager)	resolved	Needs Triage (violet)	MW-1.35-notes (1.35.0-wmf.19; 2020-02-11) Commons (Incoming) MediaWiki-Special-pages (Multimedia-related) Performance Issue mariadb-optimizer-bug (Worked around in code) Platform Team Workboards (Clinic Duty Team) (Waiting for Review)
T245492	T245492: Slow query: IndexPager::buildQueryInfo (MediaWiki\Linter\LintErrorsPager)	open	Needs Triage (violet)	MediaWiki-extensions-Linter (Backlog) Performance Issue mariadb-optimizer-bug (Currently not fixed)
T245807	T245807: ApiQueryRecentChanges chooses a different plan on 10.4	resolved	Medium (orange)	Platform Engineering (Inbox) DBA (In progress) mariadb-optimizer-bug (Fixed in a higher optimizer version)		T242702: Test MariaDB 10.4 in production
T245989	T245989: RecentChanges query API fails with timeout when asking for 5 RC redirects in on Wikidata	open	Medium (orange)	Pywikibot-tests (CI test failures) Platform Team Workboards (Clinic Duty Team) (Later) Wikidata (incoming) MediaWiki-API (Needs details or plan) Pywikibot (Backlog) mariadb-optimizer-bug (Currently not fixed)
T246069	T246069: Slow query on 10.4: SpecialRecentChanges::doMainQuery	open	Medium (orange)	DBA (Blocked) Upstream (Reported Upstream) mariadb-optimizer-bug (Currently not fixed)		T250666: Upgrade WMF database-and-backup-related hosts to buster
T254688	T254688: SpecialWhatLinksHere::showIndirectLinks on wikidatawiki needs optimizing	resolved	Medium (orange)	wdwb-tech (External Realm) Performance Issue DBA (Blocked) MediaWiki-Special-pages (Special:WhatLinksHere) MW-1.36-notes (1.36.0-wmf.36; 2021-03-23) MW-1.35-notes mariadb-optimizer-bug (Fixed in a higher optimizer version) Wikidata (incoming)		T250666: Upgrade WMF database-and-backup-related hosts to buster
T258236	T258236: Special:Export WikiExporter::dumpPages query needs optimization	open	Medium (orange)	Platform Team Workboards (Clinic Duty Team) (Later) mariadb-optimizer-bug (Currently not fixed) User-ArielGlenn (Short-term backlog) MediaWiki-Core-Snapshots (Backlog)
T71222	T71222: list=logevents slow for users with last log action long time ago	resolved	Medium (orange)	DBA (Blocked external/Not db team) User-Marostegui (Watching) MW-1.33-notes (1.33.0-wmf.22; 2019-03-19) mariadb-optimizer-bug (Worked around in code) Performance Issue MediaWiki-API (Done)		T233579: Tracking task for mariadb optimizer misbehaviours