Hi all,

I'm using osticket for years and very happy with my conf is

we are now experiencing performance issues with ticket counts in queues
i activated slow_requests log in mysql to know about,

we are about 40 agents

i tried so many tweaks like Kevin said in a post : commented the try catch in class.search.php wich reduced the time by half in most cases ( from more than 25 sec to less than 12 in most ) but in peak it goes to more than 20 sec with cpu at 100%

tried to export database to other powerful server, my workstation etc and tried different versions of mysql / mariaDB, migrated tables to InnoDB but got the same result

Do you have any ideas

    BReflex

    1. Upgrade to a supported version. Your version is no longer supported and really outdated. It's also missing latest optimizations, bug fixes, security fixes, etc.
    2. Upgrade the prerequisites including PHP and MySQL/MariaDB to ensure you are using the latest with latest optimizations.
    3. If you're no DBA, I'd highly recommend using MySQL 8.0+ as it has way better performance out of the box vs MariaDB. MariaDB will run super fast but you gotta tune it, etc.

    After all that and you still have issues you'd simply need to fine tune (optimize) MySQL, give it more resources, etc. You can also do the code change you referenced after doing all that.

    Cheers.

      Thank you for your reponse

      You are right i must update to latest version i just wanted to try everything before giving up cause it s working very speedy in all other ways apart from this
      will program the upgrade for everything (php, mysql, tuning ) hoping this will resolve the problem

      Write a Reply...