Delete expired post_meta transients after disabling cache

[Laconicsky]

Hi,

@ihor

In this post you recommend:

I have over 100k thousand rows in my post_meta table so would like to remove the expired ones so that the hourly hive press hook can run successfully to expire my jobs correctly.

Please can you tell me where the code snippet should be added? Is it in the wp-config.php file?

[ihor]

Hi,

You can add code snippets via the Code Snippets plugin or to the child theme’s functions.php file. Please note that disabling cache will not resolve the cleanup issue as it also relies on the hourly cron job (as well as the listing expiration and other routines in HivePress core), if it fails then the cache cleanup will not run. If this issue is not resolved, you’d have to cleanup the database table with SQL query, after adding the code snippet that disables built-in cache.

Hope this helps

[Laconicsky]

Thank you.

I’ve cleaned up the expired transients from the post_meta table already.

So now if I add the code it will stop future expired transients from building up in the post_meta table?

[Laconicsky]

And a follow up question - is this how it should look in Code Snippets?

[ihor]

Yes, if you add the code snippets this way then new transients will not be created

[Laconicsky]

Thanks Ihor - appreciate you helping even after it being so many years after I bought the template