sql stuck at ‘Sending Data’ status for SQL_CALC_FOUND_ROWS query

  • ivanpilien

    (@ivanpilien)


    2 years, 9 months ago

    Hi!

    When accessing a page that runs SQL_CALC_FOUND_ROWS query, the query gets stuck at ‘Sending Data’ status and the sql processes gets cluttered.

    Any help would be appreciated!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Kartik Shukla

    (@kartiks16)

    2 years, 9 months ago

    Hello,

    Try installing the Query Monitor plugin and you can trace the source of the query having the SQL_CALC_FOUND_ROWS.

    Maybe that can help.

    Thanks.

    Thread Starter ivanpilien

    (@ivanpilien)

    2 years, 9 months ago

    Hi @kartiks16,

    We tried installing the plugin, and found out its in the wordpress core that’s running the query. I tried applying the method I found here (the one with pagination) but with no avail. The query that replaced the SQL_CALC_FOUND_ROWS also gets stuck in ‘Sending Data’ query status.

    I also tried removing the SQL_CALC_FOUND_ROWS instead of replacing it, but the site broke (it does not show products anymore).

    Kartik Shukla

    (@kartiks16)

    2 years, 9 months ago

    Hello,

    Not sure if there is any sort of conflict, the last thing that is coming to my mind is if you can switch to the default theme and disable all the plugins and enable them one by one.

    If that doesn’t help you may need some help who can technically review the code or your site and help you.

    Thanks.

    Thread Starter ivanpilien

    (@ivanpilien)

    2 years, 9 months ago

    Hi @kartiks16

    We tried stripping the website to its bare components too, but that didn’t work also since the SQL_CALC_FOUND_ROWS query is coming from the wordpress core functions.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘sql stuck at ‘Sending Data’ status for SQL_CALC_FOUND_ROWS query’ is closed to new replies.