the db has reached 2.5 GB with 120 thousand tickets, is there a way to delete all 2018 through the database table? the attachments are on Amazon s3 so they shouldn't be a problem.
You can release your database with finding the tickets and content through database but try setting this plugin once https://github.com/clonemeagain/osticket-plugin-archiver and it can do the job for you all the time.
already tried, it collapses everything, the site collapses, if you cancel the cancellation of 80 tickets every 2 hours
what are the tables to empty of the db?
I removed 22,000 tickets from the operator panel, but the size of the database does not change. Why?
What setup you are running? os ver, php etc.
You should optimize your tables in MySQL. I think MySQL keeps the deleted space "reserved" for furthing using. If you optimize your tables it will free the reserved space.
How did you remove the tickets from the operator panel?
yes, I deleted all from the operator panel. how do I optimize the mysql tables?
I would point you to the MySQL documentation. https://dev.mysql.com/doc/en/optimize-table.html