Hello, I have fulltext search implemented with sphinx and mysql 5.6.15.
The problem is that after upgrade, I started to get these large queries in mysql when using simple search: # Time: 140725 13:15:31 # User@Host: rt_user[rt_user] @ localhost [] Id: 26 # Query_time: 10.390028 Lock_time: 0.000276 Rows_sent: 1 Rows_examined: 910059 SET timestamp=1406283331; SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions Transactions_1 ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) LEFT JOIN Attachments Attachments_2 ON ( Attachments_2.TransactionId = Transactions_1.id ) LEFT JOIN AttachmentsIndex AttachmentsIndex_3 ON ( AttachmentsIndex_3.id = Attachments_2.id ) WHERE (main.IsMerged IS NULL) AND (main.Status != 'deleted') AND (main.Type = 'ticket') AND ( ( ( main.Subject LIKE '%*word*%' OR ( AttachmentsIndex_3.query = '*word*;limit=10000;maxmatches=10000' AND Attachments_2.Filename IS NULL ) ) ) ); Is there any way that I could make the simple search use the sphinx engine by default for all the queries? Or any way to revert it? I also mention that the content search is still working with sphinx as before, if I write fulltext:word I can find the query in the RT_ROOT/var/sphinx/query.log [Wed Jun 25 16:41:45.057 2014] 0.002 sec 0.002 sec [all/0/rel 3 (0,10000)] [rt,rtdelta] word [Wed Jun 25 16:41:45.191 2014] 0.002 sec 0.002 sec [all/0/rel 3 (0,10000)] [rt,rtdelta] word [Wed Jun 25 16:41:58.256 2014] 0.002 sec 0.002 sec [all/0/rel 3 (0,10000)] [rt,rtdelta] word [Wed Jun 25 16:42:36.063 2014] 0.002 sec 0.002 sec [all/0/rel 3 (0,10000)] [rt,rtdelta] word Thank you!
-- RT Training - Boston, September 9-10 http://bestpractical.com/training
