Query very slow postmeta queries?

  • Resolved georgecampos

    (@georgecampos)


    4 years ago

    I dont know why. I have a lot of query apparently from, line 1248 (I guess)
    plugins/seriously-simple-podcasting/php/classes/controllers/class-frontend-controller.php

    Queries in “Sending Data” state, using SHOW PROCESSLIST mysql:
    https://drive.google.com/file/d/19Bh_7RvAfGGWiK86ooz61Aqd9KwicWXp/view?usp=sharing

    | 18256 | dbxxx | x.x.x.x:40244 | xxx_2021 | Query | 10 | Sending data | SELECT post_id FROM xxx_postmeta WHERE meta_key = ‘_wp_attached_file’ AND meta_value = ‘2019/11/MO | 0.000 |

    This′s overload my database with a lot of query and freeze my website a lot of time.

    Anyone know whats wrong?
    My wp Version 5.3.2 and plugin Seriously Simple Podcasting Version 2.5.3

    Thank you so much.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Craig Hewitt

    (@podcastmotor)

    HI @georgecampos thanks for the message (and the kind words in your review). We’re looking into this now and will circle back here once we have any more info on what we uncover with this issue. In the meantime, if we can do anything else please let us know.

    Thread Starter georgecampos

    (@georgecampos)

    Hi Craig, thanks. If I do anything for help, please tell me.

    I think this is began in the last version 2.5.3. But, I will monitoring my database all the time, looking for identify the problem. And if this′s happening because the SSP plugin (

    I use wp-supercache, and Query Monitor, WP Crontrol to try identify the problem.

    Thank you again,

    Plugin Author Craig Hewitt

    (@podcastmotor)

    Hi @georgecampos we have a beta release version of the plugin that includes some updates that ought to resolve this issue. Could I ask you to email us directly at [email protected] so we can arrange to send the beta version to you to test on your site?

    Thread Starter georgecampos

    (@georgecampos)

    Hi Craig, thank you for your feedback. I will send you the email. Regards.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Query very slow postmeta queries?’ is closed to new replies.