… Full Text Search indexes which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert all tables at once. In some cases full text search is used…” MyISAM table which is used for full text search. In certain cases you can just use MySQL triggers to maintain such table, in other…
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
… are shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi A6 will give… 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… for SQL databases rather than full text search applications. Group By was added to Sphinx so we could search number of matches per day…
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 was released which now provides fast and easy to use full text search solution for all storage…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… (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: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… (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: 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… 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. Also FaceBook search does…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… 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…
Page: Consulting for MySQL
July 31, 2006 By
… ? We can help. Full Text Search applications. Need help with implementing Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search indexing or help you with selecting and customizing alternative Open Source full text…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
… on crawler in this project only on database Backend and full text search engine implementation. In this part it is standard LAMPS application… and S Stands for Sphinx – Full Text Search Engine which we love to use where large scale search is needed. At this point we… it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search forums from…
