Slow site due to many aws_search_term_ rows in wp_options table autoload

  • Resolved paulluxford

    (@paulluxford)


    3 years, 7 months ago

    Hi there

    I noticed a real slow down on my site recently and I asked the host (WPEngine) what it could be and they said the following:

    “”You have a very high level of autoloaded data
    Right now you have 19,878,212 bytes of autoloaded whereas we want that to be under 800k for good performance””

    I did a query on the database and I am seeing a lot of rows for aws_search_term_ terms. I guess they would be the cached search terms. Here is a sample screenshot of what I am seeing > https://prnt.sc/uh47y7

    I have cleared the cache in the settings page and also turned off the caching search queries but the database has not been cleared.

    What would be the best way to clear those rows from the wp_options table?

    Thanks for your help.

    Best Regards
    Paul

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author ILLID

    (@mihail-barinov)

    3 years, 7 months ago

    Hi,

    It is strange because the plugin doesn’t store cached queries inside wp_options table.
    It did this a long time ago ( maybe a few years ) but then this was fixed in the next plugin versions. Maybe you have some old plugin version? If so, then please update to the latest one.

    Regards

    Thread Starter paulluxford

    (@paulluxford)

    3 years, 7 months ago

    Thanks Illid

    I am running the latest version of the plugin. I did see in the changelog that you did patch the plugin to stop the queries hitting the options table, so it must just be legacy data.

    Do you think it would be safe for me to drop those tables manually? I might do it on staging first.

    Plugin Author ILLID

    (@mihail-barinov)

    3 years, 7 months ago

    You just need to delete from table wp_option all rows that has option_name starts with aws_search_term_. This is save and will solve your issue.

    Regards

    Plugin Author ILLID

    (@mihail-barinov)

    3 years, 7 months ago

    MySQL query can look like

    DELETE FROM wp_options WHERE option_name LIKE 'aws_search_term_%'

    Thread Starter paulluxford

    (@paulluxford)

    3 years, 7 months ago

    Awesome, thanks so much Illid

    Best Regards

    Paul

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Slow site due to many aws_search_term_ rows in wp_options table autoload’ is closed to new replies.