Hi @EpsilonAdmin thanks for your prompt response and sorry for my late response.
Unfortunately the site owner didn't approved the re-activation of the plugin. But I will use it on other sites soon.
Thanks for all your efforts!
Hi @EpsilonAdmin ,
I had to rename the table in order to stop the queries. After that I could login and deactivate it.
Does this new functionality relies on CRON? Investigating more, I've identified a CRON job which was supposed to run each 15 minutes, which was running everytime. But I'm not sure if it's related.
We definitely don't have this amount of searches on the site, so maybe this table is creating logs for other queries (it's sad that we don't have the data for this now).
I'll try to re-activate the plugin tomorrow for some time to see how it behave.
We've used the plugin for a few days with drastic performance increase on queries by search.
But a few days ago we started seeing it's table with frequent slow queries. At the moment I was writing, here's the mysql proccess list:
The MySQL queue is simply overwhelmed with all those queries, with some taking a lot of time to process, and making the site down.
I had to deactivate the plugin and I'm waiting the queries to finish in order to have the site back.
Any clue on why we are having so many of those queries?
First, thanks for this plugin, after activating it our server usage dropped to 1/3 !
But, I've detected that some searches still hangs the server. Those are searches that include common words (like "the" or "a" or "an") and multiple words. Looking at the log, I saw that it seems to search separately for each word, causing the issue. I've tried to activate the "AND" Search Logic, but it didn't made any difference, the log still seems to be searching by all words separately.
Can I do something, maybe at code side, to prevent this?
Edit 1: Note that, this behavior only occurs at Front End, using the site search, searching at backend doesn't cause issues. Note that, currently searches on backend aren't being logged, even though the option to replace the search in admin is active.... and I believe it's active, because the search there is really fast.
Edit 2: Is there any further optimization for multiple post type? For example, even after the optimization the same search when limited to 1 single post type take 1.1 second, while looking for 4 different post types, take 9 seconds.