View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 5956 | Composr | General / Uncategorised | public | 2024-09-21 01:30 | 2024-09-21 01:32 |
| Reporter | PDStig | Assigned To | Guest | ||
| Priority | normal | Severity | feature | ||
| Status | new | Resolution | open | ||
| Summary | 5956: Add a scheduler hook (or a staff checklist reminder) to optimise MySQL databases every week | ||||
| 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. | ||||
| 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. | ||||
| Tags | Roadmap: Over the horizon | ||||
| Attach Tags | |||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
