Queries increasing MySQL Usage

  • Resolved emathe

    (@emathe)


    4 years ago

    Hello, we are having an issue where our directory goes down every month or so. Our host has told us it is the directory plugin. It seems that the query string “?wpbdp_view” from your search filter is sending data by first reviewing/reading all the posts and that causes the longer query to stuck all the other queries in a queue.

    [09/May/2022:08:01:37 -0500] “GET /business-directory/?wpbdp_view=search&kw=Property+and+lawn+maintenance+ HTTP/1.0” 500 296 “https://www.domain.com/business-directory/wpbdp_category/lawn-maintenance/”;; “Mozilla/5.0 (iPhone; CPU iPhone OS 15_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Mobile/15E148 Safari/604.1” “-” 301

    I can provide a more detailed error report, but I do not even know where to start fixing this. I used the shortcode for the search fields on the site.

    • This topic was modified 4 years ago by emathe.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Garret L

    (@garret1996)

    4 years ago

    Hi @emathe

    Thank you for reaching out about this. I’m Garret from the customer success team and I’m sorry to hear that you’re having a problem here. I’ll be happy to help!

    Let me pass this to our developer to take a look at. This is likely something we can improve if it’s coming from our end.

    I will update you as soon as I hear back from our developer about this.

    We do apologize for any inconvenience in the meantime.

    Best,

    Plugin Support Garret L

    (@garret1996)

    4 years ago

    Hey @emathe

    Would you mind contacting our premium support so our team can take a closer look here? https://businessdirectoryplugin.com/contact/

    Hope to hear from you soon.

    Best,

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

The topic ‘Queries increasing MySQL Usage’ is closed to new replies.

  • 2 replies
  • 2 participants
  • Last reply from: Garret L
  • Last activity: 4 years ago
  • Status: resolved