Long query found

  • Resolved janak Kaneriya

    (@janak007)


    6 years, 1 month ago

    Hi,

    The latest version has something which causing our site down.

    I had a close look at the queries which sent by the plugin and I found this:

    # Query_time: 13.891906 Lock_time: 0.000086 Rows_sent: 4 Rows_examined: 4894864
    # Rows_affected: 0
    # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
    # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
    SET timestamp=1537192135;
    SELECT pm.meta_id, pm.post_id FROM wp_postmeta AS pm WHERE pm.meta_value LIKE ‘%F8E9ADCC-845A-49A8-870A-798B415EDD7F.jpeg’;

    I have a big postmeta table that’s why it’s halting our database.

    Please help me with this.

    Thanks in advance

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Michael Torbert

    (@hallsofmontezuma)

    WordPress Virtuoso

    You can contact us at https://semperplugins.com/contact/ and we’ll be happy to look into this.
    Use this forum thread’s URL in the License Key field.

    Thread Starter janak Kaneriya

    (@janak007)

    Hi,

    Thanks for your response.

    I am marking this topic as an unresolved until I get that actually resolved.

    Adding a query on your page.

    Once my query will be resolved I will mark it resolved and leave a review about the experience about your support system.

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Long query found’ is closed to new replies.