OS ticket system is very slow

zoku

A complaint I get a lot and have seen myself is the OS ticket system's general slowness. It can take anywhere from 15 seconds to over a minute for tickets to load. Over a minute when closing or deleting a ticket to get back to the main dashboard. We just upgraded PHP last week with little improvement, and I know we have one update for the ticket system, but this issue has been going on for months, so I doubt we will see any major improvement, but I plan to install the update this weekend. Any help would be appreciated.

ramrajone

zoku
I don't think it's osTicket it would be your server resources you have given to your osTicket server, take a look at what's using most CPU, Memory, disk I/O
look at logs to see if you see anything getting stuck in the process

zoku

That's what I thought at first, but not seeing any high usage for anything, and logs look fine, but I will recheck everything.

ramrajone

zoku
Have restarted the server or web service? If not, do so it may clear up if anything got stuck

zoku

ramrajone Sadly have done that kind of at a loss as to what the issue is. Hopefully, logs show something soon.

ntozier

@zoku you are not running the latest version, and I do not see that you have specified your server hardware, or MySQL speed tuning that you have done.

remalia

In your PHP ini config try setting memory_limit to -1
This will help a lot.
Also you might need better tuning in your PHP ini and your my.cnf of your mysql settings.

KevinTheJedi

@zoku

Login to the database and make sure all of your tables are using the InnoDB engine and not the MyISAM engine. If they are using MyISAM then convert all of them to InnoDB.

Cheers.