search index storage

  • Resolved saintssqpncom

    (@saintssqpncom)


    11 years, 2 months ago

    after having used Better Search for a while, there was an upgrade that appeared to store all search data in the options table of my site which caused it to balloon to a point that the site became un-usable. should that happen? is there a way to prevent it? for several reasons, i have move the site the a new host, but am hesitant to re-install Better Search if this problem is going to repeat.

    thanks, much.

    -terry

    https://ww.wp.xz.cn/plugins/better-search/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Ajay

    (@ajay)

    11 years, 2 months ago

    Hi,

    The current release used WordPress Transients to cache the search results for queries and speed up subsequent searches for the terms without the additional complex query. These are set to expire every hour.

    You’ll find this at: https://plugins.trac.ww.wp.xz.cn/browser/better-search/trunk/better-search.php#L1004

    Do you normally have a lot of different searches every hour?

    Thread Starter saintssqpncom

    (@saintssqpncom)

    11 years, 2 months ago

    not like this. the options table eventually reached 7gb. they were apparently never deleted. i like the way the plugin worked, but fear to repeat the problem on the new site.

    Plugin Author Ajay

    (@ajay)

    11 years, 2 months ago

    That’s quite an interesting point that you’ve raised. I’ve relied on WordPress’ transients, but seems like an inherent problem of not losing them. Have you been able to trace the issue to the transients?

    I’ll add a new cronjob within the plugin in the next version to clean up the transients on a regular basis. You might also want to try using the below plugin until then.

    https://ww.wp.xz.cn/plugins/delete-expired-transients/

    The other option is to edit the plugin code as above to remove the setting of the transients. More specifically uncomment out the set_transients line: https://plugins.trac.ww.wp.xz.cn/browser/better-search/trunk/better-search.php#L1010

    Thread Starter saintssqpncom

    (@saintssqpncom)

    11 years, 2 months ago

    i was not aware that was how wp handled such things, so while i knew the file continued to grow, i had no idea why. having read some of the other threads about the use of that table, it makes perfect sense now.

    there’s no way to do any forensics on the matter now. my partners had, for a while, wanted to change hosting services, and spin off each of the sub-domains at our site to it’s one domain. the move was a bloody nightmare as the old server seemed like it was actually fighting us, but we’re all on our own now.

    i have installed the delete-expired-transients plugin since it looks like it would help fix any related quirks, and have re-activated better search. give me a day or two to monitor behaviour and results, and will advise.

    thanks for the response.

    Plugin Author Ajay

    (@ajay)

    11 years, 2 months ago

    Thanks for the update. Do let me know how it goes. But, seeing the issues with transients, I’ll definitely put the cron job to clean up the entries as one of the things to add to the plugin.

    Plugin Author Ajay

    (@ajay)

    11 years, 1 month ago

    Instead of a cron job, I’ve implemented a button that will delete any transients set by the plugin. You’ll find this at the bottom of the settings page.

    You’ll find this in v2.0.0 which was released today.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘search index storage’ is closed to new replies.