Last modified: 2013-11-05 09:10:43 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T57802, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 55802 - Batch database title requests in rt_testing server to improve performance
Batch database title requests in rt_testing server to improve performance
Status: RESOLVED FIXED
Product: Parsoid
Classification: Unclassified
tests (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Marc Ordinas i Llopis
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2013-10-16 18:20 UTC by Marc Ordinas i Llopis
Modified: 2013-11-05 09:10 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Marc Ordinas i Llopis 2013-10-16 18:20:32 UTC 
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).
Comment 1 Marc Ordinas i Llopis 2013-10-16 18:21:14 UTC 
Additional information at https://gerrit.wikimedia.org/r/#/c/89491/ .
Comment 2 Gerrit Notification Bot 2013-10-30 19:43:43 UTC 
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
Comment 3 Gerrit Notification Bot 2013-10-31 19:49:05 UTC 
Change 92758 merged by jenkins-bot:
Bug 55802: Batch database title requests in rt-testing server

https://gerrit.wikimedia.org/r/92758
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links