we should calculate MySQL index cardinality regularly

RESOLVED FIXED

Status

RESOLVED FIXED
15 years ago
4 years ago

People

(Reporter: myk, Assigned: justdave)

Tracking

Details

(Reporter)

Description

15 years ago
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
Reassigning to default owner/qa on endico's open bugs so I don't have to watch
her to get mail on them.
Assignee: endico → myk
QA Contact: myk → 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.
Assignee: myk → server-ops
QA Contact: justdave → justin
Assignee: server-ops → 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.
Status: NEW → RESOLVED
Last Resolved: 13 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.