#5956 - Add a scheduler hook (or a staff checklist reminder) to optimise MySQL databases every week

  • By
  • Added
  • 7 views
Identifier #5956
Issue type Feature request or suggestion
Title Add a scheduler hook (or a staff checklist reminder) to optimise MySQL databases every week
Status Open
Tags

Roadmap: Over the horizon (custom)

Handling member Deleted
Addon General / Uncategorised
Description It is highly recommended to regularly optimise MySQL databases especially MyISAM tables (which Composr still uses).

Webmasters may often forget to run optimise on their tables on a regular basis. So let's help with that by offering a scheduler hook to do that (but only if running MySQL).

Main pro: Keeps the database running optimal, and webmasters don't need reminders to do it

Main con: It is a fatal operation; should anything happen to interrupt an optimise, the table gets corrupted. So it's best optimise is done with supervision.
Steps to reproduce

Additional information Possible alternatives:

a) The scheduler hook is disabled by default (we support that now), so it must be manually enabled if a webmaster wants automatic optimise.
b) Instead of a scheduler hook, we just make a staff checklist item to remind webmasters to run it.
c) A health check hook analyses MySQL performance and suggests when to run it.
Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated