[Resolved] Database Autoload Bloat

[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

[Tom]

Hi there,

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

[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

[Tom]

Glad you got it sorted 🙂

[Author]

Posts