Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Component/s: docs.moodle.org
-
Labels:None
Description
Not critical, but it would be great to check/repair/optimize the docs_XX databases weekly.
Using the script + email notification used in other servers (moodle.org, tracker...) will be enough.
Ciao 
Activity
- All
- Comments
- History
- Activity
- Source
- Test Sessions
Hi Jordan,
assigning this to you. Not critical at all.
That server (docs.moodle.org) is running 20 (aprox) MySQL databases.
And we have one cool shell script (see /opt/bin/mysql_analyze.sh in other hosts like server8) able to optimize ONE database.
The idea is to create one script, call it /opt/bin/mysql_analyze_docs.sh, that weekly will optimize some (20/7) databases (by using the existing /opt/bin/mysql_analyze.sh internally) and by calculating what DBs to optimize automatically. And then put it in the crontab, sending output to some users (see how the simple one is working in server8).
Just in case you want/have time to play with something.
Ciao