Currious to know what is the average size of your OSticket MySQL database? We are going to be installing OSticket and most of our tickets will have attachments with pictures of the issue being submitted. Should I be concerned about this?
I'm sure everyone will vary greatly however in 3 months I have ~850 attachments totalling 165MB.Even if I was round that up to 1GB a year I'm not in any way worried. Just to be on the safe side however and perhaps for performance reasons also I enabled the "attachments on filesystem"/"Storage-FS" plugin: https://github.com/osTicket/osTicket-pluginsAdditionally I configured however not yet enabled an archiving plugin from here: https://github.com/clonemeagain/osticket-plugin-archiverFinally if you have many attachments I would highly recommend this attachment preview plugin: https://github.com/clonemeagain/attachment_previewIt is a fantastic feature.Cheers.
The two production (live) sites that I administrate are:Production 1: over 11000 tickets and 8684 attachments (stored in db) the export of the DB as of mid last month is 647MB.Production 2: over 2500 tickets no idea on attachments (stored in db) the export of the DB as of mid last month is 15.4MB
My production is running from 07/2014till now over 9500 tickets space used: 483.50 MiB and attachment: 726.65 MiB
Ten months1500 tickets75 MB MySQL dump253M attachments
20 days live, 3000 tickets, 1.1GB db, 935MB are files
Over 2 years more than 30gb database... works great :)
Is there any easy way just to delete old tickets with or without attachments to reduce the Database size?
@nohcho82
Create an Advanced Search, Select All, Delete, Repeat. ๐
Cheers.
KevinTheJedi No, Just tickets delete does not delete attachment from database. I need to reduce the database size. It is currently 2.7GB. I want to reduce the size for better performance or I don't need worry about it?
nohcho82 What kind of performance issue you notice ?
Yes, that was a bug and has since been addressed. You can upgrade to v1.14-rc1 in order to get this functionality but it is not recommended to run in production as it's a Release Candidate. I would wait for v1.14 stable to be released.
KevinTheJedi thanks, I will wait๐