May 25, 2012

Post: MySQL Performance Blog now uses Sphinx for Site Search

… something on MySQL Performance Blog. Today we have published new search functionality for our site which is based on Sphinx. We have developed it as WordPress plugin which will be available as open source… MySQL Performance Blog more useful for you. UPDATE: For those looking to download plugin code it is here: https://launchpad.net/wp-sphinx-plugin

Comment: Full text search for all MySQL Storage Engines

… search requires “proper” dictionary to be implemented in sphinx. Currently (0.9.6) sphinx just uses crc32() to get word_id from… perform the search. I would suggest to write request on sphinx Forum. Andrew is very considerable to user requests in defining… few months. Now speaking about using Sphinx or other full text search system with MySQL as plugin (not hack with storage engine) – for…

Comment: Full text search for all MySQL Storage Engines

Apachez, > 14. Vadim: Darn, what are the odds that mysql will use sphinx as its native fulltext index instead of todays version/edition ? Hehe, sphinx plugin requires sphinx daemon and authour of daemon is Andrew. Andrew will ask big money if someone wants to buy sphinx :)

Post: Full text search for all MySQL Storage Engines

… engine as well as has few other limits. Today Sphinx Search plugin for MySQL was released which now provides fast and easy to… and distributed searching. A while ago I already wrote about Sphinx Search Egine, comparing it to built in FullText search and… you do not feel like patching MySQL or use MySQL 5.1 beta to use sphinx as MySQL Storage Engine you can still use…

Post: Top 5 Wishes for MySQL

… as plugins. Two aspects why I’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL but… get much more stats from MySQL and it would be great if we could write these as plugins instead of patches. 2. Be Scalable I’d like to see MySQL Scaling to large amount…

Comment: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December

… successfully compiled SphinxSE plugin using Percona Server 5.5.16. However, we encountered a bug when the mysql option skip-name-resolve was used. Fortunately, there’s a workaround. Right now we are rolling 5.5 with sphinx plugin

Comment: Full text search for all MySQL Storage Engines

Sure but since sphinx exists as a plugin these companies can still use sphinx but as a plugin. Since Andrew himself has been writing here, any comment from you Andrew regarding the possibility of having mysql use sphinx as…

Comment: Full text search for all MySQL Storage Engines

…). Sphinx is really promising specially now when it will be available as a direct plugin for mysql (I assume this means that the sphinx index can be created directly from within mysql just as with mysql own… Also, does the implementation of sphinx as plugin for mysql 5.1 mean that mysqls own fulltext engine will/might be replaced shortly by sphinx ?

Comment: MySQL and plugin binaries

… kind of includes us with Sphinx Storage Engines) and avoid surprises as Innodb got with their plugin release. I think what would be important is to involve vendors in QA process. Innodb should have working with MySQL to ensure their plugin at least builts with MySQL 5.1.24 (I’m not…

Comment: Full text search for all MySQL Storage Engines

Apachez, I doubt MySQL will include Sphinx storage engine in 5.1 GA or even in 5.2. Unfortunately sphinx index cannot be created directly from within mysql, MySQL pluginable architecture does not allow that yet.