I have been having a recurring issue with the SQL server hanging when OS Ticket makes an inquiry (usually merging tickets).
A reboot of MySQL will restore functions but the OS Ticket will hang until this is done.
We have installed the plugin that moves attachments from the database to the file system, and new entries are working from the file system but the database is till 700 MB+. Running there script to copy files to the file system does not make the database any smaller.
Are there any other scripts or steps i can take short of a complete re-set of the database and OS Ticket systems that would shrink the database and resolve the overload/freezing issue on SQL?
Thank you in advance.