… 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… to have stale data in search results it can work pretty well. Use Sphinx or other external full text search engine This is what we use a lot especially if performance of full text search is an issue to…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
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 engines. This version…
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. I… is 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…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… which talks directly to the MySQL database we can get …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…of search engine externals. Simple filtering/sorting though is often supported by search engine…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… 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…. For the tests I used the table from the forum search engine, leaving just bunch of ids in it, removing everything else…
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… MySQL as plugin (not hack with storage engine) – for this to happen fulltext search interface would need to be rewritten to support multiple full text search engines…
Page: Consulting for MySQL
July 31, 2006 By
… versions to old ones. Storage engine development assistance If you’re developing MySQL Storage Engine, Appliance or Extensions 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 …
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…see that. Searching Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx… posts. Transactional Storage Engines Performance We’re looking at performance at Open Source Transactional Storage engine MySQL – Innodb, Falcon, SolidDB…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… done Sales before, while I acted a lot as Sales Engineer. It turns out however selling is not that hard at… does MySQL Related work – it is very hard to find people with good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching… and performance optimization of full text search applications, especially after we brought Andrew Aksyonoff to the team. Projects Leaving MySQL we wanted not only…
Post: Presentations from OpenSQLCamp Published
December 1, 2008 By Leave a Comment
…published presentations from OpenSQLCamp at Percona Presentation pages Percona MySQL Patches is a great presentation to see Percona …they can improve performance all together. Sphinx full-text search engine is presentation about Sphinx Search Engine talking a bit about architecture, performance and…
