May 25, 2012

Comment: EuroOSCON 2006 - High Performance FullText Search

… to find a replacement of mysql fulltext for the forum at http://www.tbg.nu In my case the problem with mysql fulltext were that… irrelevant in this case :-) All the three reasons above made mysql fulltext to virtually puke when a client performed a search which… word. I assume the reason for that is that the mysql fulltext internally will first find all hits for each word (since…

Comment: Full text search for all MySQL Storage Engines

… have been for the past months experimenting with various fulltext engines since the mysql fulltext has it limitations specially when used in boolean…, does the implementation of sphinx as plugin for mysql 5.1 mean that mysqls own fulltext engine will/might be replaced shortly by sphinx ?

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

… for in memory tables. So first MySQL versions did not bother naming variables …_expansion_limit, ft_stopword_file FullText search related variables. As FullText currently works with MyISAM …_cache_division_limit Key Cache/Key Buffer replacement algorithm configuration variables. Obviously only apply …

Comment: Full text search for all MySQL Storage Engines

…the possibility of having mysql use sphinx as its native fulltext engine ? First, I think there’s some work do in … replacement to MySQL‘s own FT. Second, even when that’s done, including Sphinx into MySQL would depend on its owners – that it, MySQL