• Hello, i am using visual+ theme from last weak, i have a website with medium traffic, last day i enable mysql slow query log for debug purpose and today log is full with slow queries, all slow queries are logged when the user search on site.

    # Time: 150426  9:54:33
    # Query_time: 1.064776  Lock_time: 0.000372 Rows_sent: 0  Rows_examined: 18816
    SET timestamp=1430024073;
    SELECT SQL_CALC_FOUND_ROWS  ***_posts.ID FROM ***_posts  WHERE 1=1  AND (((***_posts.post_title LIKE '%search_term%

    and so on …

    i am using mysql query cache, set to 64MB and using xcache for php and object+db cache set to 64MB’s
    my DB engine is innodb.
    any help will be extremely liked.
    Thanks

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Search queries are slow’ is closed to new replies.