217412 - we should calculate MySQL index cardinality regularly

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Myk Melez [:myk] [@mykmelez]]

MySQL index cardinality influences how well queries perform and should be
calculated regularly according to the MySQL documentation:

http://www.mysql.com/doc/en/EXPLAIN.html
http://www.mysql.com/doc/en/ANALYZE_TABLE.html

Comment 1

[Dave Miller [:justdave]]

Reassigning to default owner/qa on endico's open bugs so I don't have to watch
her to get mail on them.

Comment 2

[Dave Miller [:justdave]]

Myk used to be the default assignee for this component.  Reassigning all remaining open bugs owned by him that he doesn't appear actively involved in to the default assignee/qa for later reassignment.

Comment 3

[Dave Miller [:justdave]]

This appears to have been set up on or around November 10th on mrdb01 (for Bugzilla, which is the database that gets nailed by it all the time).

There's a cron job in /etc/cron.weekly that does it.