Slow Queries

#805209
  • Resolved Anonymous
    Rank Math free

    This query: SELECT post_id, meta_value FROM IHAVEHIDDENTHIS_postmeta WHERE meta_value LIKE ‘%:\”s-66449f84ae207%’ LIMIT 0, 1

    causes this trace:
    #0 /wp-content/plugins/seo-by-rank-math/includes/admin/database/class-query-builder.php(104): wpdb->get_row()
    #1 /wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-db.php(189): RankMath\Admin\Database\Query_Builder->one()
    #2 /wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-snippet-shortcode.php(421): RankMath\Schema\DB::get_schema_by_shortcode_id()
    #3 /wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-snippet-shortcode.php(99): RankMath\Schema\Snippet_Shortcode->get_schema_data()
    #4 /wp-includes/shortcodes.php(433): RankMath\Schema\Snippet_Shortcode->rich_snippet()
    #5 (): do_shortcode_tag()
    #6 /wp-includes/shortcodes.php(273): preg_replace_callback()
    #7 /wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-snippet-shortcode.php(399): do_shortcode()
    #8 /wp-includes/class-wp-hook.php(324): RankMath\Schema\Snippet_Shortcode->output_schema_in_content()
    #9 /wp-includes/plugin.php(205): WP_Hook->apply_filters()
    #10 /wp-content/themesxxxxxxxx/partials/single-car-listing/car-main.php(69): apply_filters()
    #11 /wp-includes/template.php(812): require()
    #12 /wp-includes/template.php(745): load_template()
    #13 /wp-includes/general-template.php(206): locate_template()
    #14 /wp-content/themes/xxx/single-listings.php(55): get_template_part()
    #15 /wp-content/themes/xxx/listings/single.php(4): require_once()
    #16 /wp-includes/template-loader.php(106): include()
    #17 /wp-blog-header.php(19): require_once()
    #18 /index.php(17): require()

    and the query took 2.7 seconds to run. This is for every product page and we have thousands. The CPU is spiking and causing issues.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Anonymous
    Rank Math free

    I have checked the server memory settings etc and they are well above the standards that you require

    Anonymous
    Rank Math free

    And when I turn off the RMath schema support, this issue goes away. I would like to use the schema functionality but not at the cost of the server falling over

    Hello,

    Thank you for contacting us and sorry for any inconvenience that might have been caused due to that.

    We might need to take a closer look at the settings. Please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section.

    Please do take a complete backup of your website before sharing the information with us.

    Sensitive Data Section

    It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

    https://wordpress.org/plugins/temporary-login-without-password/

    You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

    https://wordpress.org/plugins/wp-security-audit-log/

    Looking forward to helping you.

    Thank you.

    Anonymous
    Rank Math free

    Hi
    I have managed to track down some code that was indirectly causing this. Thank you for your help!

    Hello,

    We are glad that you have found the culprit of this issue, and it is already resolved.

    Please feel free to reach out to us again in case you need any other assistance.

    We are here to help.

    Thank you.

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this ticket.