[x2ind]

That did it, thanks so much once again!
Chris

[x2ind]

We are upgraded to the highest on Apache 4, php 7.2 and the maria DB is at the highest level as well.

[x2ind]

Oh yes, I can certainly open a new one.. No problem, it is a different issue.

[x2ind]

One last questions and I think we are very good to go.
Because we are using the index table, we have it setup to cron everyday, and re-index the added products.
At the time for which this happens our server hangs (approximately 5:30 to 6pm CST) until it is reboot. I have noticed this over a 4-5 day period.. We have checked error logs, and performance analytics and it seems to tax the SQL processes quite a bit, but I never have any problems with it during a manual build of the index. The only way I was able to reference it to the index cron job is by turning the process off and waiting for the day to roll over at which point everything is fine, and we are now on day 4 with no issues.

Hope that makes sense. Happy holidays!

[x2ind]

Great Job Ernest, you have provided superior support.. We are working on a number of additional sites which will most certainly use this search.

Chris

• This reply was modified 7 years, 5 months ago by x2ind.

[x2ind]

That fixed it perfectly.. Should we even bother to adjust the numbers? It is running almost instantaneous..

[x2ind]

Also wanted to note that since we turned off the index in the general options the search is working great, and it is still fast.. is there a chance that it is still using the index, as before the index was created it was extremely slow to query..

Thanks again,

[x2ind]

the pool size currently is almost 1 million..

To be exact:
Items Indexed: 9427 | Items not indexed: 0 | Total keywords: 812184

[x2ind]

I have now reverted back to the regular engine and everything works as it should.. There must be some sort of keyword density issue with the index, as it seems it will only read 5 words into the title? I only did a small amount of digging.. Let me know what you come up with.

Thanks,

[x2ind]

I am thinking this has something to do with the keyword pool size? Can you confirm.. our database is 10k items right now and may grow another 5k, but want to ensure this will not become a problem.

[x2ind]

So I have checked everything and even rebuilt the index, it was running a cron job 2 times a day which I have moved to 1 time at this point. It is a very odd issue. So to explain I am going to use the product “2009-2013 NISSAN FRONTIER PLUG AND PLAY AIR SUSPENSION KIT”..
If we ignore the years and just type either “nissan frontier air kit” or “frontier air kit” you would hope this would show up but it does not. Instead only one other product shows up, which are still relevant. we also have “2009-2013 NISSAN FRONTIER COMPLETE AIR SUSPENSION KIT” which does not show up using the term “frontier air suspension kit” you must use “frontier complete” and even then it is down the list a bit. Let me know what you think. No all the products are this difficult, but we have certainly noticed a few…

Thanks again for your help!!

[x2ind]

This worked perfectly!! Thank you so much for your assistance with this..
Your search plugin is amazing! GREAT WORK!

Chris

[x2ind]

you will not reply thought you were just on helping sully.

[x2ind]

I would love some support, but would also like to know why the FTP login credentials warned me of the quota of 2gb being exceeded in just a few minutes?

Thank you,

[x2ind]

I disabled the logins, due to the ftp login triggering a 2 gig quota issue. Can you explain?

[Author]

Posts