Very log query Time with digitalpoint sphinx

Discussion in 'MySQL' started by michael24179, Mar 10, 2016.

0
  1. #1
    Good morning.

    I have problem with my vbulletin sql. I have install digitalpoint sphinx and i have very log query time. I don't know how i make fix this problem. 

    # Time: 160311  8:00:15
# User@Host: debian-sys-maint[debian-sys-maint] @  [192.168.10.1]  Id: 441924
# Query_time: 9.101344  Lock_time: 0.000113 Rows_sent: 6959018  Rows_examined: 7808108
SET timestamp=1457679615;
SELECT post.postid AS doc_id, tagcontent.tagid FROM digitalpoint_sphinx_delta AS digitalpoint_sphinx_delta RIGHT JOIN tagcontent AS tagcontent ON(tagcontent.contentid = digitalpoint_sphinx_delta.primaryid) LEFT JOIN post AS post ON(tagcontent.contentid = post.threadid) WHERE digitalpoint_sphinx_delta.contenttypeid = (SELECT contenttypeid FROM contenttype AS contenttype WHERE class = 'Thread') AND primaryid BETWEEN 300057 AND 400056;
    Code (markup):

     
    michael24179, Mar 10, 2016 IP