Announcement

Collapse
No announcement yet.

Some really slow queries after upgrade to 3.8.7 pl2

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Zachery
    replied
    Upgrade from what? That looks like a search.

    Leave a comment:


  • wacnstac
    started a topic Some really slow queries after upgrade to 3.8.7 pl2

    Some really slow queries after upgrade to 3.8.7 pl2

    For example:

    # Time: 110220 20:34:06
    # [email protected]: user_name @ localhost []
    # Query_time: 21 Lock_time: 0 Rows_sent: 0 Rows_examined: 64142281
    INSERT INTO postindex_temp369947
    (wordid, postid, intitle, score)
    SELECT wordid, CASE postid WHEN 3554797 THEN 3554811

    What would cause such an ridiculous query?

Related Topics

Collapse

Working...
X