Support » Plugin: Optimize Database after Deleting Revisions » oembed – times out 504 error – other options?

  • Resolved lgpref

    (@lgpref)



    Thanks for a useful plugin! We’re doing some in-depth clearing of our venerable WP site, and I tried to use the “oembed cache” option, but the gateway timed out (504 error). It turns out that the analysis turns up over 5000 _oembed items in the postmeta table. The items seems to be duplicated over and over again (1000 links would be a more rational number considering our content.)
    Other advice you offered (https://wordpress.org/support/topic/gateway-timeout-504/) 2 years ago regarding huge sites was interesting, but ours is not that large. The plugin works fine with all the other functions in your plugin, only “oembed cache” makes it fail with a gateway time out.

    Do you have suggestions of how to troubleshoot this issue with oembeds? I’ve looked for more information on optimizing oembeds manually, but it’s a bit over my head so far. What am I missing? Thanks for your advice.

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

Viewing 1 replies (of 1 total)
  • Plugin Author cageehv

    (@cageehv)

    Hey lgpref,

    Thanks for the kudos!

    To be honest: I have no idea why you hit that 504 error…
    Probably because the huge number of items.

    Does the site has a lot of visits a day?
    That could explain the vast amount of oEmbeds.

    These oEmbed items take a lot of database space.

    Maybe you should delete them manually once and then run my plugin frequently.

    Go to PHPMyAdmin, choose SQL and use the following query:

    DELETE FROM wp_postmeta
    WHERE meta_key LIKE ‘_oembed_%’

    Note: replace ‘wp_postmeta‘ with your own prefixed table name.

    Good luck!

    peace,
    Rolf

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.