Monthly Archives: May 2014

happy bmo push day!

the following changes have been pushed to bugzilla.mozilla.org:

  • [1013953] Update the researchers.html.tmpl page to link to mhoye automated sanitized database dumps
  • [993223] Notify Review Board when a bug is made confidential
  • [1003950] automatically disable accounts based on the number of comments tagged as “abusive”
  • [1014374] concatenate and slightly minify css files
  • [1013760] Add “secure mail” metadata to email headers
  • [1009216] Add link to a wiki page describing common whiteboard tags
  • [1015290] Fix typo on Reps Mentorship Form
  • [1003386] Create new “Mozilla Foundation Operations” product
  • [1013788] it’s possible to get bugzilla to redirect to any url by setting the content-type of an attachment after uploading it

discuss these changes on mozilla.tools.bmo.

happy bmo push day!

the following changes have been pushed to bugzilla.mozilla.org:

  • [1010751] Add “Bugzilla@Mozilla” to the From header, so email clients don’t just display “bugzilla-daemon@mozilla.org”
  • [1009215] add support for support.mozilla.org links to see_also
  • [504461] Allow everyone to make bugs security-sensitive retroactively
  • [1009017] users are unable to log in if their password needs to be re-encrypted and their password does not match the current complexity rule

 

note: 1010751 changes the “from” header in email bugzilla.mozilla.org sends from:

From: bugzilla-daemon@mozilla.org

to:

From: "Bugzilla@Mozilla" <bugzilla-daemon@mozilla.org>

it’s possible this change may impact mail filters which current perform an exact match on the from field.

 

discuss these changes on mozilla.tools.bmo.

 

happy bmo push day!

the following changes have been pushed to bugzilla.mozilla.org:

  • [787101] Make the Mozillian field mandatory on the Reps application form
  • [1006972] remove google analytics from bugzilla.mozilla.org
  • [1007493] Allow non login git commits to be linked
  • [992767] allow memcached to cache bugzilla configuration information
  • [1005158] Request for new Bugzilla Product ‘Mozilla Foundation’ with a ‘Metrics’ component
  • [1003852] Digest::SHA 5.82 and newer always croak on wide characters, preventing users with Unicode passwords from logging in
  • [995000] Please create an Automation Request Form in Bugzilla

discuss these changes on mozilla.tools.bmo.

a tale of bugzilla performance

a high-level goal across multiple teams this year is to improve bugzilla.mozilla.org’s performance, specifically focusing on the time it takes to load a bug (show_bug.cgi).

towards this end, in q1 2014 i focused primarily on two things: implementing a framework for bugzilla to use memcached, and deep instrumentation of bmo in our production environment to help identify areas which require optimisation and could leverage memcached.

i’ll talk more about memcached in a later blog post.  today i’ll talk about a single little query.

the data gathered quickly identified a single query used to determine a user’s group membership was by far the slowest query, averaging more than 200 ms to complete, and was executed on every page:

SELECT DISTINCT groups.id 
  FROM groups, 
       user_group_map, 
       group_group_map 
 WHERE user_group_map.user_id = 3881 
       AND (
           (user_group_map.isbless = 1 AND groups.id=user_group_map.group_id)
           OR (groups.id = group_group_map.grantor_id
               AND group_group_map.grant_type = 1
               AND group_group_map.member_id IN (20,19,10,9,94,23,49,2,119,..))
       )

in bug 993894 i rewrote this query to:

SELECT DISTINCT group_id
  FROM user_group_map
 WHERE user_id = 3881
       AND isbless = 1
UNION
SELECT DISTINCT grantor_id
  FROM group_group_map
 WHERE grant_type = 1
       AND member_id IN (20,19,10,9,94,23,49,2,119,..)

which executes almost instantly.

the yellow bar on the following graph shows when this fix was deployed to bugzilla.mozilla.org:

bug993894

happy bmo push day!

the following changes have been pushed to bugzilla.mozilla.org:

  • [1004229] “TypeError: lastCommentDiv.parentNode is null” from inline history when the last comment is a ‘duplicate’ comment
  • [999331] searching attachment data is very slow due to an unbounded select
  • [1005959] remove old timing code from show_bug
  • [1006290] reviewboard url detection should support http:// as well as https://

discuss these changes on mozilla.tools.bmo.

Follow

Get every new post delivered to your Inbox.

Join 87 other followers