… 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: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… 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: 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…
Comment: Full text search for all MySQL Storage Engines
July 2, 2006 By 37 Comments
… 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… Sphinx or other full text search system with MySQL as plugin (not hack with storage engine) – for this to happen fulltext search interface would need…
Comment: ORDER BY ... LIMIT Performance Optimization
September 2, 2006 By 93 Comments
… I did not speak about full text search indexes here but about BTREE ones. If do full text search using natural language search you do not need… fact it is one of major weaknesses of build in MySQL Full Text search – inability to efficiently combine it with sorting by anything else… relevance. For example if I would want to run boolean full text search for our dating example and sort by date registered or…
