Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

OSTicket Database Maintenance

Is there any DB maintenance that is recommended to be performed?
We have been running OSTicket for just over a year now. Thanks

Comments

  • I like to run optimize every week, the tables get a bit of overhead, especially if you're storing attachments in the database, and doubly so if you have a large volume of tickets.

    Otherwise it seems to like keeping old data around, the logs and message headers etc can get large, but not overly. We've over half a million tickets and had to move to filesystem storage for attachments, just for performance, now the whole database can fit in ram again and it's happy.

    I have a plugin to archive old tickets, it's still in beta, but you can help test it if you want.
    https://github.com/clonemeagain/osticket-plugin-archiver
  • How do I optimise DB? Not a big MySQL user.
  • These guys have about 50 different ways of saying either use a script or the mysqlcheck command:

    https://stackoverflow.com/questions/5474662/mysql-optimize-all-tables

    I use the latter via cron early Sunday morning, when we're least likely to have new tickets.
  • Thanks Grizly - somehwere to go and research.
Sign In or Register to comment.