Page MenuHomePhabricator

Batch database title requests in rt_testing server to improve performance
Closed, ResolvedPublic

Description

The rt_testing server requests a new title from the database each time a client asks for one, wrapping the request in a transaction to ensure no other client gets the same title. This creates a lot of contention on the MySQL server due to a high amount of rolledback transactions.

A better way to do this would be to request titles from the database in batches (of 50 was proposed).


Version: unspecified
Severity: normal

Details

Reference
bz55802

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:40 AM
bzimport added a project: Parsoid-Tests.
bzimport set Reference to bz55802.

Change 92758 had a related patch set uploaded by Marcoil:
Bug 55802: Batch database title requests in rt-testing server

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

Change 92758 merged by jenkins-bot:
Bug 55802: Batch database title requests in rt-testing server

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