June 19, 2013

Comment: My Innodb Feature wishes

May 5, 2006 By 30 Comments

Yes… FullText Search would be nice. I however would see MySQL to implement full text search on the top level and make interface all… as it is not exactly performance related feature :) Also if you’re looking to do full text search with Innodb you may… much faster than build in FullText search. The integration is not as seemless as with build in FullText search but still pretty simple compared…

Filed Under: Insight for Developers Tagged With:

Post: Webinar for Full Text Search Throwdown

August 21, 2012 By 1 Comment

…-nonsense performance comparison of solutions for full text indexing for MySQL applications, including: LIKE predicates and regular expressions MyISAM FULLTEXT indexes InnoDB FULLTEXT indexes Apache Solr Sphinx Search Trigraphs I’ll compare the performance…

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Comment: Beware of MyISAM Key Cache mutex contention

January 12, 2010 By 10 Comments

… that improving performance probably increased the concurrency!) I put under monitoring all the parameters I could think of, and mysql processes showed… for fulltext search, so no InnoDB possible for now. My question is, is it possible that it is only related to a MySQL… opinion? What do you think of Sphinx to substitute the fulltext search on MyISAM table? Peter, I owe you a beer, big…

Filed Under: Insight for DBAs Tagged With: ,

Comment: Full text search for all MySQL Storage Engines

July 2, 2006 By 37 Comments

… can find all word_id matching to the mask and perform the search. I would suggest to write request on sphinx Forum… or other full text search system with 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 behind it. Currently it…

Filed Under: Insight for DBAs Tagged With: ,

Comment: Cache Performance Comparison

August 10, 2006 By 74 Comments

… Cache Performance Comparison discussion but anyway, We’re now working on FullText Search Engine comparison for MySQL and test MySQL Build in Full Text Search, Siena, Sphinx, Lucene indexing Wikipedia database and performing appropriate queries…

Filed Under: Insight for Developers Tagged With:

Comment: Full text search for all MySQL Storage Engines

February 28, 2007 By 37 Comments

…MySQL 5.1 as storage engine? Can you please explain this in detail? I’m currently using MyISAM becasue of the fulltext… complicated (long) search + insert + many parallel small selects gives terrible performance with MyISAM. I… extar fulltext ISAM table. This way normal reads that don’t use FT search…

Filed Under: Insight for DBAs Tagged With: ,

Comment: MySQL wins C'T Database Contest

August 30, 2006 By 27 Comments

… are mysql results as low as 137 opm in this benchmark). I can just use a recent personal experience from the fulltext engine I am building (in perl with mysql as backend) where it in the beginning (2-3 months ago) had a performance… at http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld017.htm shows that to retrieve just one column from mysql over…

Filed Under: Benchmarks, Events and Announcements
Newer Posts »