Hello everyone,
I hope you're all doing well. I'm currently facing a challenging performance issue after migrating to a newer version of OSTicket (1.17.4) and integrating all tickets from the previous version. Namely that the old version runs on the production server without any problems
The problem I'm encountering is a significant slowdown in loading the tickets page (others pages loads correctly). Despite having no active tickets in the database, the page takes an unusually long time to load.
Here are the steps I've taken so far to troubleshoot the issue:
I have verified that all tables are using both InnoDB and Dynamic engines, ensuring they are optimized for performance.
I've checked the SQL query logs to identify any queries that might be timing out or causing delays. However, no specific query stands out as a clear culprit for the slow page loading.
I've used nmon to monitor the performance of the Apache server. What's perplexing is that the CPU usage occasionally spikes up to 100%, causing the server to crash. This occurs even though several other applications are running on the same server without any issues.
Despite these efforts, I haven't been able to pinpoint the exact cause of the slowdown and server crashes. I've considered the possibility that the sheer volume of tickets integrated from the previous version might be contributing to the problem, but the issue persists even when there are no active tickets in the system.
Has anyone else encountered a similar problem or can provide insights into what might be causing this issue? I would greatly appreciate any suggestions, advice, or additional steps I could take to further diagnose and resolve this issue.
Thank you in advance for your time and assistance.
