[Resolved] Increased mysql queries when upgraded from 1.09 to 1.15.3.1

ayesjm

I recently migrated from v1.09 to v1.15.3.1 since upgrading i am having long mysql queries and high cpu. i am currently running centos 7 with php 7.4.23 and osticket 15.3.1. i am running mysql 5.7.16the high cpu is related to mysql. we've been running osticket for years and im sure the database size is not helping. is there any truncation or optimization that can be run? any help would be much appreciated.

ayesjm

osTicket Version v1.15.3.1 (65ca4e6) — Up to date
Web Server Software Apache/2.4.6 (CentOS) PHP/7.4.23
MySQL Version 5.7.16
PHP Version 7.4.23

ayesjm

i am seeming multiple of these queries running

SELECT A1.id, A1.title, A1.body, A1.format FROM ostick_thread_entry A1
LEFT JOIN ostick__search A2 ON (A1.id = A2.object_id AND A2.object_type='H')
WHERE A2.object_id IS NULL AND (A1.poster <> 'SYSTEM')
AND (IFNULL(LENGTH(A1.title), 0) + IFNULL(LENGTH(A1.body), 0) > 0)
ORDER BY A1.id DESC LIMIT 500

ntozier

What table format is your mysql using for your osTicket database tables?

The devs have recommended converting all tables to InnoDB to improve performance.

ayesjm

I ended up upgrading mysql from 5.7.16 to version 8. Once this was done, the high cpu spikes stopped.

ntozier

Thanks for posting your solution. Would you like me to mark this thread as resolved and close it?

ayesjm

yes you can mark this as resolved.

thanks