Code: Select all
SELECT DISTINCT st.id, st.tn, st.create_time
FROM ticket st INNER JOIN article art ON st.id = art.ticket_id
LEFT JOIN article_search_index ArticleFulltext ON art.id = ArticleFulltext.article_id
INNER JOIN queue sq ON sq.id = st.queue_id
WHERE 1=1 AND sq.group_id IN (1,10,11,12,13,14,15,16,17,2,3,4,5,6,7,8)
AND (((ArticleFulltext.article_value LIKE '%words searched for%' OR st.title LIKE '%words searched for%' ) ))
ORDER BY st.create_time DESC LIMIT 2000;
I don't think it's in issue with "fulltextIndexRebuild" and I do have the setting ArticleStorageFS
Using:
znuny 6.5.1
MariaDB 10.2.38
Ram: 64GB
SSD-disk.
24 vCPU
Tickets: 190 000