0005956: Add a scheduler hook (or a staff checklist reminder) to optimise MySQL databases every week

ID	Project	Category	View Status	Date Submitted	Last Update

0005956	Composr	[All Projects] General / Uncategorised	public	2024-09-21 01:30	2024-09-21 01:32

Reporter	Patrick Schmalstig	Assigned To
Severity	Feature-request
Status	non-assigned	Resolution	open
Product Version
Fixed in Version

Summary	0005956: 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

Time estimation (hours)
Sponsorship open

Date Modified	Username	Field	Change
2024-09-21 01:30	Patrick Schmalstig	New Issue
2024-09-21 01:30	Patrick Schmalstig	Tag Attached: Roadmap: Over the horizon
2024-09-21 01:31	Patrick Schmalstig	Description Updated	View Revisions
2024-09-21 01:32	Patrick Schmalstig	Additional Information Updated	View Revisions