May 24, 2012

Post: Full text search for all MySQL Storage Engines

June 26, 2006 By 37 Comments

… in full text search is currently limited only to MyISAM search engine as well as has few other limits. Today Sphinx Search plugin for MySQL…engines. This version also adds a lot of other new features, including boolean search and distributed searching. A while ago I already wrote about Sphinx Search…

Filed Under: Insight for DBAs Tagged With: ,

Post: Power of MySQL Storage Engines

March 5, 2007 By 3 Comments

…search engine . As MySQL 5.1 and plugable storage engine interface matures I hope we’ll see more storage engines…. We had the same problem with Sphinx – Sphinx can run sorting and group by …of rows in result set and LIMIT implementation – these can optimized but not by use of MySQL Storage Engine…

Filed Under: Insight for DBAs Tagged With: , , ,

Post: Talking MySQL to Sphinx

April 19, 2009 By 4 Comments

… search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of… the tests I used the table from the forum search engine, leaving just bunch of ids in it, removing everything else: CREATE TABLE… number of rows it needs to reach the LIMIT Sphinx mysql> select forum_id as f from sptest order by author_id desc limit…

Filed Under: Insight for Developers Tagged With:

Post: FaceBook Search, Search for social networks

August 12, 2007 By 4 Comments

…think this is serious limitation. But anyway if you do boolean search without phrase …and understanding of search engine externals. Simple filtering/sorting though is often supported by search engine directly…adding features to the Sphinx to accommodate special needs of some applications. As you…

Filed Under: Events and Announcements Tagged With: ,

Post: Sphinx Technologies launches Sphinx Support

March 24, 2009 By 1 Comment

…couple of weeks ago Sphinx Technologies, a company behind Sphinx Full Text Search Engine launched Sphinx Support Packages which I think is a great …Sphinx Support so how are these different ? Support from Sphinx Technologies is based on traditional support model with limit (or no limits) on number of…

Filed Under: Events and Announcements Tagged With:

Comment: Full text search for all MySQL Storage Engines

June 27, 2006 By 37 Comments

…engine ?). However I found some issues with the standalone testversions which ended up with that I created my own fulltext search engine…of sphinx as plugin for mysql 5.1 mean that mysqls own fulltext engine will/might be replaced shortly by sphinx…

Filed Under: Insight for DBAs Tagged With: ,

Comment: Full text search for all MySQL Storage Engines

June 28, 2006 By 37 Comments

… with 500.000 items of each word to process, group by, order by and so forth until the engine can spit out… (limit each word internally to 2000 hits): 1.66 seconds Sphinx: 16.31 seconds Vectorbased search: 0.06 seconds On xp3200+ windowsbox: Vectorbased search: 0.01 seconds I dont know how sphinx stores data internally but hopefully something of…

Filed Under: Insight for DBAs Tagged With: ,

Comment: EuroOSCON 2006 - High Performance FullText Search

September 23, 2006 By 4 Comments

… was not to build a complete standalone search engine solution but to find a replacement of mysql fulltext for the forum at http… my site). However sphinx had some limitations such as no support for wildcards, no liveupdates and when a new sphinx version were released… how large the difference would be if I created a search engine written only in perl with mysql as backend for the…

Filed Under: Events and Announcements Tagged With: ,

Post: MySQL Consulting - Being on your own

February 20, 2007 By 7 Comments

…Sales before, while I acted a lot as Sales Engineer. It turns out however selling is not that …most of these places as we have to deal with all kinds of problems and we may have very limited …work on Sphinx Search as well as bunch of MySQL related scripts. As a summary we have 70+ hours of work per…

Filed Under: Events and Announcements Tagged With:

Post: Using Flexviews - part two, change data capture

March 25, 2011 By 11 Comments

… Maintain materialized views with Flexviews (the primary purpose of FlexCDC). Feed search engines like Sphinx or Solr only the rows that change. Feed third…has limited trigger support, some of which is the cause of the aforementioned problems. The biggest problem, at least from standpoint of how …

Filed Under: Insight for DBAs, Insight for Developers, MySQL