[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
[eclipse.org-committers] Bugzilla slowness
|
Greetings committers,
Bugzilla has been sluggish lately.
For better database performance, we run two database servers. Because of
a database error last week, the slave db is now out of sync with the
master, and we're only using the master. Depending on the complexity of
the searches and reports that users run throughout the day, Bugzilla
will continue to be occasionally sluggish until I can sync the servers
back up.
Syncing the servers takes about 30 minutes. During this time, I need
exclusive access to *all* the databases so that the slave is identical
to the master; therefore, I can't just sync up anytime I want to.
I apologize for the inconvenience this causes. I'll do my best to
resync the servers as soon as possible so that we can avoid further
frustration. However, although the db servers being out-of-sync is a
rarity, this sluggishness will manifest itself each and every time the
slave db server is offline. It's a Bugzilla/MySQL limitation that I can
only circumvent with a slave server.
Denis
For the tech-heads, here is more background:
Bugzilla's MySQL database uses a storage engine (MyISAM) that only
supports table locking (instead of row locking, via InnoDB). This means
when someone runs a complex search or report, they lock several tables
sometimes for up to 2 minutes. Meanwhile, you have to wait for your bug
page to appear, or for your commit to be saved.
And because Bugzilla's querying and reporting is quite flexible, anyone
can perform a complex search that ties up the tables like this. Knowing
this, it's really easy anyone to "attack" Bugzilla and make it painfully
slow for everyone.
Bugzilla doesn't currently support any other storage engine, such as
InnoDB, as it will break lots of search functionality.
This Mozilla.org bug can provide more insight:
https://bugzilla.mozilla.org/show_bug.cgi?id=287169
D.
--
Eclipse WebMaster - webmaster@xxxxxxxxxxx
Questions? Consult the WebMaster FAQ at
http://wiki.eclipse.org/index.php/Webmaster_FAQ
View my status at http://wiki.eclipse.org/index.php/WebMaster
