how to resolve this query

  • laksdeen

    (@laksdeen)


    13 years ago

    hi,

    i have one critical problem while query execution.
    ——————————————————————-
    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts. |
    ——————————————————————-

    My server is fully down stage while above the query automatiocally executing in server.

    Please solve this issue. i was verified some forums question in our website and other website also, still now i did not getting fixed the issue

    i hopeful. Please help me?

Viewing 1 replies (of 1 total)
  • Thread Starter laksdeen

    (@laksdeen)

    Hi all,

    The following query executing several times, i gave only few execution lines, it execution number of lines, My server is down stage while executing the below query so please help me?

    | 25874 | newsrepo_wrdp1 | localhost | newsrepo_wrdp1 | Query | 0 | Locked | SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_ |
    | 25875 | newsrepo_wrdp1 | localhost | newsrepo_wrdp1 | Query | 10 | Sorting result | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |
    | 25877 | newsrepo_wrdp1 | localhost | newsrepo_wrdp1 | Query | 9 | Sorting result | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |

    waiting for your answer with hopeful

    Thank you,

Viewing 1 replies (of 1 total)
  • The topic ‘how to resolve this query’ is closed to new replies.

Tags