jvogt
Good maintenance for the actual db is periodically running ANALYZE/OPTIMIZE commands on the tables, optimizing MySQL itself by the various config options (they have really good optimization guides in their docs), and stuff like tracking usage and such to see if you need more resources dedicated to it.
If you have cron setup it already purges orphaned files, old sessions, etc. automatically so you don’t need to worry about that.
For the system it’s just simply manual deletion at this time. We do have a big archiving feature planned on the roadmap so hopefully that’ll include automation and routines and stuff.
Cheers.