… MySQL build in full text search. I was rather interested to look performance of other queries, not using Full Text Search. [root@r27 sp]# mysql… use index for sort MySQL will be a lot faster. First – Sorting. Sphinx is smart doing sorting because it does not try to sort everything but…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
…Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we’re using this combination to build search against over 1 billion of forum posts totaling over 1.5TB of data handling hundreds of thousands of search queries…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
… Sphinx as in our opinion it is great complement to MySQL when it comes to full text search… feature full search mode than the previous “EXTENDED” one that originally introduced a query language. It …Sphinx, compared to 7.5 seconds using MySQL with best covering index (so no temporary table or sorting…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
… ago: Basically someone is using sphinx to perform search simply on attributes (date, group etc) and get sorted result set and claiming it… to filter by attributes or sort sphinx does not use indexes – indexes are only used for full text search matching, but it is… slower than MySQL. MySQL Make it so one would not need to use sphinx to get great performance for such kind of queries. This…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
…for index process. With Sphinx which talks directly to the MySQL database we can get …and understanding of search engine externals. Simple filtering/sorting though is often supported by search engine … make sure Sphinx can be used efficiently to perform queries going beyond full text search. Such as…
Post: MySQL Performance Blog now uses Sphinx for Site Search
February 15, 2008 By 52 Comments
…sort results be relevance of freshness. You can also use query standard Sphinx query language to search phrases or Search MyISAM in post title. Besides basic search…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… searched for and applies for the datesort criteria which has been used (desc or asc sorting … any other matches which still fulfill the search query because the fulltext engine has on its …words” search the mysql fulltext in boolean mode takes more than 800 seconds on this hardware, sphinx takes …
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
…%” and txt like “% keyword2 %” instead of running MySQL Full text search query would be faster but does …sphinx index. Plus MySQL stores timestamp and groupid for each document which is not needed for full text search itself, only needed if they are used in sorting or matching clause…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… things you don’t know about Sphinx’s capabilities. Many people think of Sphinx as a great search engine, but it’s much… nightmare of temp tables and filesorts and multiple queries and all sorts of things in MySQL — and that’s just for performing this task on a single server, not to mention a cluster of servers. Well, Sphinx…
Post: Using index for ORDER BY vs restricting number of rows.
February 16, 2007 By 7 Comments
… this case MySQL needs to sort a lot of rows to display only few. If we force index as in second query explain… these two example queries is about 100 times so it may be quite serious. To fix this issue MySQL would need to… slow for complex searches which generate a lot of rows. Another interesting technique is to use sphinx search to accelerate sorting and retrieval which…
