… main data in Innodb but build a “shadow” MyISAM table which is used for full text search. In certain cases you can just use MySQL triggers to maintain such table, in other cases this would…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… Craigslist GumTree is powered by MySQL but unlike craigslist it looks like they are shy in tuning their MySQL Full Text Search index configuration and setting… is frequently not the case with MySQL Full Text Search which both will skip to frequent keywords in natural language search and because it is using…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
… using Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we’re using this combination to build search against over 1… word positions in the index, while we do not need them in this case as we’re doing kind of “boolean full text search“. Plus… using fake full text search to retrieve all posts from given web site or forum from the global sphinx index. So in general we…
Post: Full text search for all MySQL Storage Engines
June 26, 2006 By 37 Comments
… build 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 was released which now provides fast and easy to use full text search solution for all storage…
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
… somewhere in US or Western Europe. I hope we’ll see something like it in 2012. Another thought – with Innodb Full Text Search coming up in MySQL… be the main thing on smaller collections but its various full text search features.
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… can use to get 20% off of registration at the MySQL conference in April: mys11pkb. If you click the image to the… (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building on Strengths, Learning…
Post: Meet MySQL Performance Blog guys on MySQL Users Conference
April 14, 2008 By Leave a Comment
…. Alexey had to stay because he could not get Visa in time and Maciek is staying to be able to reliably… of sessions we have: Sphinx: High Performance Full Text Search for MySQL (Andrew) EXPLAIN Demystified (Baron) The MySQL Query Cache (Baron) Investigating Innodb Scalability Limits…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… for index process. With Sphinx which talks directly to the MySQL database we can get some 10.000 of documents indexed… in profile search is rather simple full text search features are required. As ordering is not done by relevance what is required is simple boolean full text search…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… test I was not interesting in the full text search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of other queries, not using Full Text Search. [root@r27 sp]# mysql –host 127…
Comment: Full text search for all MySQL Storage Engines
July 2, 2006 By 37 Comments
… in many cases LIKE being faster than MySQL full text search in my tests. Speaking about Wildcards – as I know it is on the way. Wildcard search requires “proper” dictionary to be implemented in…
