Hi all.
i have a vds. features: 8gb ram 200gb disk (ssd) on ubuntu 18.04, mariadb 10x, php 7.2.x+nginx, 100mbit stable port speed.
opcache, memcached, apcu, gzip, wikimedia file cache function is active.
i have a 5gb innodb data.
Memcached, gzip, cache is active in the mediawiki setting file.
Elasticasearch installed on my server. Elastica, AdvancedSearch, extensions are also active on my website.
But when I search any articles, it comes too late. page loading too late.
The word I wrote in the search box is quickly questioned immediately. but when you click on the article, the page is too late, the server responds very slowly.
I made some my.cnf edits. example; innodb_buffer_pool_size= 5G and the other some improvements..
But the result hasn't changed a lot, after querying the article in the database the page is coming too slow.
The instant user in the system is up to 15-20. Daily number of visitors 500-600.
Why is that? I don't think it should be this slow.
Can we fix this? or where do we find the problem?
Thank you in advance for your help.
Note: I could not find a solution to my problem from similar topics. Sorry.
Regards