Last modified: 2014-03-20 21:27:16 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 T60021, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 58021 - Extremely slow database connection to tools-db
Extremely slow database connection to tools-db
Status: RESOLVED FIXED
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Marc A. Pelletier
: performance
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-12-05 06:50 UTC by bgwhite
Modified: 2014-03-20 21:27 UTC (History)
3 users (show)

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


Attachments

Description bgwhite 2013-12-05 06:50:56 UTC
For three days now, the database (tools-db) has been extremely slow.  The past two days, I and other have really noticed the slowness between 6z-12z.  Web pages would return with unable to connect to the database.

I've been watching it more closely the past 12 hours.  Every time it gets real slow and when I remember to look, Icinga has been reporting load average above 2.5.  The higher the load average, the slower it gets.  It has also been reporting that it is out of memory all day.  With programs using memory as a "cache" and releasing it when needed (ie NFS), not sure how accurate that is.

It is not a problem with the webserver.  Non database web page work just fine.  Programs, with database access on the queue, are also extremely slow.  Programs that normally take three hours are taking eight hours.
Comment 1 Marc A. Pelletier 2013-12-05 13:46:41 UTC
Indeed, tools-db was meant as a temporary measure (it is a VM, which sucks for a database) and is a bit underpowered for the current load.

The good news is that the Labs move to Ashburn also means dedicated hardware for tools-db, which should help a great deal.
Comment 2 Tim Landscheidt 2014-03-20 21:27:16 UTC
Assuming this has been fixed by the move to eqiad.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links