… would make MySQL Multiple Queries API more usable ? Allow to run queries in parallel – The great benefit of knowning all queries at once is… search query only once while having multiple results aggregation routers building the stream from that result set. We however use Sphinx for… in MySQL any time soon – this would require very significant optimizer and execution engine changes to optimize for set of queries and…
Post: MySQL Performance Blog now uses Sphinx for Site Search
February 15, 2008 By 52 Comments
… something on MySQL Performance Blog. Today we have published new search functionality for our site which is based on Sphinx. We have… results be relevance of freshness. You can also use query standard Sphinx query language to search phrases or Search MyISAM in post title… for fun and for SEO. Hope this addition will make MySQL Performance Blog more useful for you. UPDATE: For those looking…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
…. Looking at alternative solution, which we’re often using with MySQL – Sphinx Search we still tend to use stop word list for… in new versions you can set the time limit on query execution it is rather safe to search a very complex… time. From Relevance standpoint “stop words” rarely cause problems with sphinx because it uses word position based ranking not just frequency…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… released Sphinx version 0.9.9-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes… know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of other queries, not… native Sphinx API implemented – everyone seems to be able to talk to MySQL these days. Now on performance – for given class of queries Sphinx…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
… we included Sphinx chapter in High Performance MySQL book – check out Appendix C. This should be the best printed material about Sphinx out there, though as of now Sphinx… mode than the previous “EXTENDED” one that originally introduced a query language. It can be 10-30% faster when it comes…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
…’ve already wrote a few times about various projects using Sphinx with MySQL for scalable Full Text Search applications. For example on… 1.5TB of data handling hundreds of thousands of search queries per day. The count of forum posts being large, is… parallel processing using sphinx pretty good solution for many data crunching needs especially when lack of parallel abilities in MySQL makes its…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
… following thread couple of days ago: Basically someone is using sphinx to perform search simply on attributes (date, group etc) and… option to retrieve by filters only with no full text query. Sphinx should not be replacement for Database Server but for many… 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: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
…should be helpful to MySQL Community and which are not offered by MySQL, Oracle and …bit. We had to recover data using query log, corrupted binary log and dig into…Sphinx. We can support your production Sphinx installation help you with development or organize custom feature development for Sphinx…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… the things you don’t know about Sphinx’s capabilities. Many people think of Sphinx as a great search engine, but it… 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: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
…to implement any significant changes to schema or queries. In general cross storage engine replication is not…search. In certain cases you can just use MySQL triggers to maintain such table, in other …search results it can work pretty well. Use Sphinx or other external full text search engine This…
