… – unlike MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL… only number of rows it needs to reach the LIMIT Sphinx mysql> select forum_id as f from sptest order by author… full text search applications when exact number is not important. Sphinx mysql> select max(forum_id) as m,author_id as a…
Page: Presentations
May 3, 2006 By
… presentations for your company or group. Sphinx search engine for RDBMS Egypt, December 2007 Presentation about Sphinx, the tasks it solves, internals and… search engines such as lucene,sphinx,tbgsearch,sienna, mnogosearch and perform benchmarks. Download Note: Following presentations were done while I was MySQL employee…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
….) His session will be about benchmarks of replication alternatives for MySQL. Hasn’t this been done before, and is it really… you don’t know about Sphinx’s capabilities. Many people think of Sphinx as a great search engine, but it’s much more… MySQL — and that’s just for performing this task on a single server, not to mention a cluster of servers. Well, Sphinx…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
Where does real power of MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows… with MySQL, it is not easy to do however as there is no interface. We had the same problem with Sphinx – Sphinx can run sorting and group by operations much faster than MySQL can and it can do…
Post: Full text search for all MySQL Storage Engines
June 26, 2006 By 37 Comments
… limited only to MyISAM search engine as well as has few other limits. Today Sphinx Search plugin for MySQL was released which now provides fast and easy to use full text search solution for all storage engines… you do not feel like patching MySQL or use MySQL 5.1 beta to use sphinx as MySQL Storage Engine you can still use it…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
… engine implementation. In this part it is standard LAMPS application. I guess you know what LAMP is and S Stands for Sphinx – Full Text Search Engine which we love to use where large scale… you can use it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other…
Post: Sphinx Technologies launches Sphinx Support
March 24, 2009 By 1 Comment
…Sphinx Technologies, a company behind Sphinx Full Text Search Engine launched Sphinx Support Packages which I think is a great value for everyone using Sphinx…for accounting people. The Support approach was closely modeled from MySQL Support of the early days – simple service lever differentiation …
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… you do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert all tables at… results it can work pretty well. Use Sphinx or other external full text search engine This is what we use a lot… eliminates the need to have MyISAM table anywhere. We use Sphinx in a lot of cases as it is very easy…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This presentation will talk about architecture of BoardReader.com which indexes over billion of forum posts. Transactional Storage Engines…
Post: Presentations from OpenSQLCamp Published
December 1, 2008 By Leave a Comment
… published presentations from OpenSQLCamp at Percona Presentation pages Percona MySQL Patches is a great presentation to see Percona Patches …together. Sphinx full-text search engine is presentation about Sphinx Search Engine talking a bit about architecture, performance and new features in Sphinx 0….
