OSticket slow responses

tws101 · Nov 9, 2018

Current Version 1.10.4

The DB is over 1.8 Gigs in size with ticket count well over 100K....

The system is running very slow, even when doing an operation that does not require an email. Just the act of deleting an old ticket can cause it to hang for 2 minutes, bulk deleting causes it to hang for 10+ minutes.

How can I bulk delete old tickets and clean up my database?

***I tried using two of these auto ticket closer and deleters but after clicking install plugin I had an error 500 until I deleted the plugin.

Update a highlight 50 and delete all at once in the UI has seized it up for over an hour... I am considering rebooting the server as it still have not recovered yet.

ramrajone · Nov 9, 2018

tws101
Take a look at this link, it may help you out: https://github.com/osTicket/osTicket/issues/4309

tws101 · Nov 12, 2018

Thank you, I will look into that...

Is there a delete command I can run via SQL my admin that will allow me to reduce the database size, and then optimize the database...

I can delete all tickets over 1 year old, If I can delete everything over a year old it would reduce the size by about 75%... The issue is currently the UI crash when I try to delete the old tickets.

ntozier · Nov 20, 2018

You might want to take a look at this 3rd party plugin:
https://github.com/clonemeagain/osticket-plugin-archiver

I believe that it does what you are looking for. As a side note since this is a 3rd party plugin you would need to get support from its author if it doesn't work right.

OSticket slow responses

Ttws101

ramrajone

Ttws101

ntozier