[Resolved] Database Autoload Bloat

Home Forums Support Database Autoload Bloat

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #1031001
    Jonathan

    Hi,

    I have a odd issue. Doing some performance checks and I noticed I have two files that are the at the top of my wp-options table where autoload=yes that relate to generatepress. It looks like the changelog was dumped into the wp-options table?

    This is my autoload table top two offenders:

    +———————————-+——–+
    | name | value |
    +———————————-+——–+
    | autoloaded data in MiB | 937 |
    | autoloaded data count | 1096 |
    | 7ec154c0b43111c822ab259cc5e3bda9 | 142534 |
    | 9b4b9278ab03eed62e9ded0113d4678e | 128390 |

    See the brief output from the file called 7ec154c0b43111c822ab259cc5e3bda9:

    array (
      'timeout' => 1548700559,
      'value' => '{"new_version":"1.7.7","stable_version":"1.7.7","name":"GP Premium","slug":"gp-premium","url":"https:\\/\\/generatepress.com\\/downloads\\/gp-premium\\/?changelog=1","last_updated":"2019-01-03 10:00:44","homepage":"https:\\/\\/generatepress.com\\/downloads\\/gp-premium\\/","package":"","download_link":"","sections":{"description":"<p>GP Premium is one powerful plugin that includes all of our awesome add-ons, which you can turn on and off as needed.<\\/p>\\n","changelog":"<p><strong>(12\\/17\\/2018) - 1.7.7<\\/strong><\\/p>\\n<ul>\\n<li>Sites: Fix failed content import in specific PHP 

    Can I delete the file as I can’t see it being of use?

    thanks

    Jonathan

    #1031435
    Tom
    Lead Developer
    Lead Developer

    Hi there,

    That’s strange – what’s the name of the row? Looks like something from our updater became stuck in the database.

    #1037933
    Jonathan

    I couldn’t tell you as I did it through wp-cli but I have disabled the autoload and brought down the size of the autoload.

    Jonathan

    #1038331
    Tom
    Lead Developer
    Lead Developer
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.