My site won’t load/server says it’s this plugin

Hello,

Plugin was working great even after I changed results from 100 to 2000, following your instructions. But later, my entire site wouldn’t load and my server support told me this (copied and pasted):

“This is happening because your website is loading over 50MB of data from the wp_options table on every page view, as you have several options set to autoload. All those options start with “aws_search_term”, which comes from the advanced-woo-search plugin.

We strongly recommend that you let us disable this plugin and remove those options from your database, otherwise I am afraid your website will not come back online.”

I asked them to proceed but told them this was probably because I changed results from 100 to 2000 but they didn’t think so (copied/pasted):

“I think this has nothing to do with you setting the results page from ‘100’ to ‘2000’. It would be best to coordinate with the plugin support team to confirm if this is indeed the case.
Anyway, I proceeded with removing these autoloaded options and the site is back up and running now.

You will see the sudden drop of memory footprint right after we did the change here:
126Mb 286.380ms pid=3298 27.93% – – 30/Sep/2017:20:05:27 -0700 “GET /index.php” 500 /var/www/glitzformals.com/index.php
126Mb 406.838ms pid=3357 39.33% – – 30/Sep/2017:20:05:34 -0700 “GET /index.php” 500 /var/www/glitzformals.com/index.php
2Mb 53.589ms pid=3379 74.64% – – 30/Sep/2017:20:05:35 -0700 “GET /index.php” 500 /var/www/glitzformals.com/index.php
2Mb 13.373ms pid=3379 74.78% – – 30/Sep/2017:20:05:38 -0700 “GET /index.php” 500 /var/www/glitzformals.com/index.php

The site is now using less memory and is now up and running. Please check and confirm from your end.”

When I woke the next day, the plugin was still active (I thought they were removing it) and the site was working great, so I thanked them and thought the issue was resolved.

But then again yesterday, my site wouldn’t load unless “refresh” was hit once or twice. I contacted support again and here’s what they said (copied and pasted):

“Things are back to how it was before.

Your search plugin is once again clogging the database with autoloaded variables. I am afraid there is not much we can do if you don’t disable this plugin or find a way for the plugin to clear the variables it saves and clogs the database.

We have cleared the database of these variables and the site is back up and running. You will see the difference of how much memory your site consumes before and after it was cleared here:

Before:
128Mb 406.279ms pid=15438 49.23% – – 03/Oct/2017:17:42:55 -0700 “GET /index.php” 500 /var/www/glitzformals.com/index.php
128Mb 226.411ms pid=15440 66.25% – – 03/Oct/2017:17:42:55 -0700 “POST /index.php?wc-ajax=get_refreshed_fragments” 500 /var/www/glitzformals.com/index.php
116Mb 1269.144ms pid=15438 16.55% – – 03/Oct/2017:17:42:58 -0700 “GET /index.php” 200 /var/www/glitzformals.com/index.php
116Mb 3205.883ms pid=15440 10.92% – – 03/Oct/2017:17:42:58 -0700 “POST /wp-cron.php?doing_wp_cron=1507077778.5242419242858886718750” 200 /var/www/glitzformals.com/wp-cron.php

After:
10Mb 190.177ms pid=16284 84.13% – – 03/Oct/2017:17:45:03 -0700 “GET /index.php?sp_accelerator_cache” 200 /var/www/glitzformals.com/index.php
2Mb 46.227ms pid=16340 64.90% – – 03/Oct/2017:17:45:15 -0700 “GET /wp-login.php?redirect_to=http%3A%2F%2Fglitzformals.com%2Fwp-admin%2F&reauth=1” 200 /var/www/glitzformals.com/wp-login.php
2Mb 53.671ms pid=16340 74.53% – – 03/Oct/2017:17:45:19 -0700 “POST /wp-login.php” 302 /var/www/glitzformals.com/wp-login.php
10Mb 191.267ms pid=16340 83.65% – – 03/Oct/2017:17:45:19 -0700 “GET /wp-admin/index.php” 200 /var/www/glitzformals.com/wp-admin/index.php”

When I asked if they had any advice since I need this functionality, they said I should ask you (copied/pasted):

“As we mentioned before, you will need to coordinate with the plugin’s support team and tell them what happened.

With the way this plugin is behaving, no server can run it unless the server has unlimited memory or if the plugin was configured differently on their sites.

This is not a server issue but an issue with the plugin which we have little experience with since we did not personally developed it.”

I don’t understand most of the above but I hope it helps you help me and perhaps others reading.

Thank you very much.

The page I need help with: [log in to see the link]