1934616 - Add comment to SQL that is generated by buglist.cgi to add userid, query string, and user agent

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: Search, enhancement)

Description

[David Lawrence [:dkl]]

To help pin-pointing where some long running MySQL queries are coming from, we can add comment strings to the SQL statements that will show up in the long running query logs. The extra information will be helpful in finding out where/who they are coming from and we can work with them to find more efficient ways of getting the data they need like bespoke API calls using the Search API support we have.

Comment 1

[BMO Github Automation]

Attachment: [mozilla-bteam/bmo] Bug 1934616 - Add comment to SQL that is generated by buglist.cgi to add userid, query string, and user agent (#2373)

Comment 2

[David Lawrence [:dkl]]

Merged
https://github.com/mozilla-bteam/bmo/commit/70544f7a38e2bd3f14f7c518e3b983e7901e3c10