GlobalUserPage is tripping dbperformance.log because of User / CentralAuth cache misses
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Legoktm
	Mar 11 2015, 10:14 PM

Description

User.php line 375 calls User->loadFromDatabase()
User.php line 342 calls User->loadFromId()
User.php line 1937 calls User->load()
GlobalUserPage.body.php line 119 calls User->getId()
GlobalUserPage.hooks.php line 76 calls GlobalUserPage::shouldDisplayGlobalPage()
Hooks.php line 209 calls GlobalUserPageHooks::onTitleIsAlwaysKnown()
Title.php line 4264 calls Hooks::run()
Title.php line 4305 calls Title->isAlwaysKnown()
SkinTemplate.php line 700 calls Title->isKnown()

CentralAuthUser.php line 205 calls CentralAuthUser::getCentralDB()
CentralAuthUser.php line 403 calls CentralAuthUser->loadState()
CentralAuthUser.php line 461 calls CentralAuthUser->getId()
CentralAuthUser.php line 2780 calls CentralAuthUser->exists()
CentralAuthHooks.php line 1926 calls CentralAuthUser->attachedOn()
CentralAuthHooks.php line 1911 calls CentralAuthHooks::isUserTheSameOn()
Hooks.php line 209 calls CentralAuthHooks::onLoadGlobalUserPage()
GlobalFunctions.php line 4013 calls Hooks::run()
GlobalUserPage.body.php line 136 calls wfRunHooks()
GlobalUserPage.hooks.php line 76 calls GlobalUserPage::shouldDisplayGlobalPage()
Hooks.php line 209 calls GlobalUserPageHooks::onTitleIsAlwaysKnown()
Title.php line 4264 calls Hooks::run()
Title.php line 4305 calls Title->isAlwaysKnown()

Details

	Subject	Repo	Branch	Lines +/-
	Avoid master queries on parse due to User object loading	mediawiki/extensions/GlobalUserPage	master	+1 -0

Customize query in gerrit

Related Objects

Mentioned In: T101348: GlobalUserPageHooks::onTitleIsAlwaysKnown notably slows down Title::isKnown() calls
T88445: MediaWiki active/active datacenter investigation and work (tracking)
rEGUP7da7fef16332: Avoid master queries on parse due to User object loading
rMEXTae21e2fc4696: Updated mediawiki/extensions Project: mediawiki/extensions/GlobalUserPage…

Event Timeline

Legoktm created this task.Mar 11 2015, 10:14 PM

Legoktm raised the priority of this task from to Needs Triage.

Legoktm updated the task description. (Show Details)

Legoktm added a project: GlobalUserPage.

Legoktm added subscribers: Legoktm, aaron.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 11 2015, 10:14 PM

[11:00:13] <autismcat> legoktm: ideally functions that get User objects for parsing, special pages lists, and most stuff could just use a slave (the cache could be checked thought not backfilled)
[11:00:35] <autismcat> for now, the main User for the request should keep the cache/master logic to avoid weirdness though

Legoktm added projects: MediaWiki-General, MediaWiki-extensions-CentralAuth.Mar 13 2015, 6:14 PM

Legoktm set Security to None.

Change 199176 had a related patch set uploaded (by Aaron Schulz):
Avoid master queries on parse due to User object loading

https://gerrit.wikimedia.org/r/199176

gerritbot added a project: Patch-For-Review.Mar 24 2015, 12:40 AM

Change 199176 merged by jenkins-bot:
Avoid master queries on parse due to User object loading

https://gerrit.wikimedia.org/r/199176

aaron mentioned this in rMEXTae21e2fc4696: Updated mediawiki/extensions Project: mediawiki/extensions/GlobalUserPage….Mar 24 2015, 7:25 PM

aaron mentioned this in rEGUP7da7fef16332: Avoid master queries on parse due to User object loading.Mar 24 2015, 7:44 PM

Catrope mentioned this in T88445: MediaWiki active/active datacenter investigation and work (tracking).Oct 15 2015, 5:16 AM

Krinkle edited projects, added MediaWiki-libs-Rdbms; removed MediaWiki-General.Mar 19 2016, 12:33 AM

The few log backtraces left are on POSTs to articles treated with POST-nonwrite expectations (a separate small issue).

MarcoAurelio moved this task from Backlog to Done on the MediaWiki-extensions-CentralAuth board.Dec 15 2016, 4:20 PM

Krinkle mentioned this in T101348: GlobalUserPageHooks::onTitleIsAlwaysKnown notably slows down Title::isKnown() calls.Jun 7 2022, 3:58 PM

GlobalUserPage is tripping dbperformance.log because of User / CentralAuth cache missesClosed, ResolvedPublicActions

Description

Details

Related Objects

Event Timeline

GlobalUserPage is tripping dbperformance.log because of User / CentralAuth cache misses
Closed, ResolvedPublic
Actions