Good Morning,

osTicket Version: v1.15.1 (fe1d1f8)

Web Server Software: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/7.2.34

MySQL Version 10.2.33

PHP Version 7.2.34

Since a couple of days every time we close a ticket we have to wait from 5 to 20 seconds for the "spinning weel" to stop. We have plenty of memory and processors, and our monitoring system didn't detect any overload on the system or slow queries on the Database.

I wonder if @ntozier @KevinTheJedi or some other Osticket guru has some advice for investigating the issue and do a fine tuning of settings for improving the performance.

Thanks in advance

@cgubi

First I would make sure all of your database tables are using the InnoDB engine instead of MyISAM. If any tables are using MyISAM then we'd suggest converting them to InnoDB. We've recently did this for an instance with a ton of data and it improved overall performance quite a bit.

Next, I would start var_dump()ing in include/ajax.ticket.php in the setTicketStatus() function to see where it's hanging up exactly.

Cheers.

17 days later

Thanks @KevinTheJedi,

I checked on the DB and a query for the tables using Myisam gives an empty result:

The same query filtering Innodb tables returns all the tables of Osticket:

Concerning the dumping of variable in the setTicketStatus() function, which variables should I dump exactly, and how?

There are any other logs on the machine that I could examine, like apache logs?

Thanks in advance for your support.

6 months later
Write a Reply...