Tengo el problema de que la pagina web de OJS se cae, y al ver el motor de base de datos que se encuentra en otro servidor aparte veo el proceso de CPU alto y es relacionado a la base de datos del OJS
Observo estos query que quedan colgados y pienso que son los que saturan
select count(*) as aggregate from submissions as s left join publications as po on s.current_publication_id = po.publication_id where s.context_id in (2) and s.status in (3) and (exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘nanotecnología’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘nanotecnología’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join `author