June 18, 2013

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

June 8, 2006 By 14 Comments

MySQL Server has tons of variables which may be adjusted to change behavior or for performance purposes. They are documented in the…_key_write Delay updating indexes for MyISAM tables. Good for performance but tables will be badly corrupted on crash. delayed_insert…_len, ft_query_expansion_limit, ft_stopword_file FullText search related variables. As FullText currently works with MyISAM tables these are MyISAM…

Filed Under: Insight for DBAs Tagged With: ,

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

…: a) full text b) attributes Speaking in MySQL terms, Full text columns are always indexed …I would emphasize – while it is a neat performance optimization for highly selective attributes, this is … is orders of magnitude better than using a fulltext key. That being said, for highly selective columns…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

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 … I did not mention it as it is not exactly performance related feature :) Also if you’re looking to do full… much faster than build in FullText search. The integration is not as seemless as with build in FullText search but still pretty…

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… 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…

Filed Under: Insight for DBAs 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 would liek to switch to something “better… help. Running the table under Innodb and having an extar fulltext ISAM table. This way normal reads that don’t use…

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… that to retrieve just one column from mysql over DBI/DBD there is a performance difference of 51,155 fetches for the…

Filed Under: Benchmarks, Events and Announcements

Comment: Cache Performance Comparison

August 10, 2006 By 74 Comments

… offtopic from 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…

Filed Under: Insight for Developers Tagged With:

Post: Duplicate indexes and redundant indexes

August 17, 2006 By 38 Comments

… be used in the queries. This is wrong and hurts MySQL Performance. It is enough to create PRIMARY KEY and it will… the same column(s) – perfect example is BTREE index and FULLTEXT index, while other combinations may also make sense. Note: Order… used by other queries. There is currently no tool in MySQL distribution which will help you to check your schema for…

Filed Under: Insight for DBAs Tagged With:

Comment: Full text search for all MySQL Storage Engines

July 2, 2006 By 37 Comments

…. I’ve seen in many cases LIKE being faster than MySQL full text search in my tests. Speaking about Wildcards – as… can find all word_id matching to the mask and perform the search. I would suggest to write request on sphinx… full text search system with MySQL as plugin (not hack with storage engine) – for this to happen fulltext search interface would need…

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts
Newer Posts »