Percona's MySQL & InnoDB performance and scalability blog
… support for full-text search (FTS). And I’ve encountered many customers for whom the prudent move would be a migration to InnoDB, but….INNODB_FT_* tables. In particular, the INNODB_FT_CONFIG table is supposed to “display metadata about the FULLTEXT index and associated processing for an InnoDB…
… stopword table for InnoDB FTS, at least for the moment, this table must use the latin1 character set. mysql: CREATE TABLE innodb_ft_list2… problems for InnoDB, because it’s only a single character and we’ve set innodb_ft_min_token_size to 4. Thus, when InnoDB… MyISAM-style search results, there is at least one potential escape hatch from this rabbit hole. When defining a FULLTEXT KEY, you…
…FullText Search EuroOSCON 2006, Brussels, Belgium, September 2006 This presentation speaks about FullText search techniques for content stored in database focusing on delivering high performance for…
… 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 for…
… to a mix of innodb and myisam could help. Running the table under Innodb and having an extar fulltext ISAM table. This way normal reads that don’t use FT search could run without slowdown from the normal table … A FT search for Inno would propably the easiest…
… with storage engine) – for this to happen fulltext search interface would need to be rewritten to support multiple full text search engines behind it… this would happen sooner or later especially as there is Innodb full text search in works by Innodb team.
…stopword_file FullText search related variables. As FullText currently works with MyISAM tables these are MyISAM related. join_buffer_size Buffer used for joins…SHOW MUTEX STATUS. Was intended to work for all storage engines but currently implemented only for Innodb. tmp_table_size This variable …
… your post: BINGO! I immediately created 10 tailored Key Caches for each of the highest concurrency tables and after 48 hours… the same key_cache and the table is used for fulltext search, so no InnoDB possible for now. My question is, is it possible that… opinion? What do you think of Sphinx to substitute the fulltext search on MyISAM table? Peter, I owe you a beer, big…
A mixed approach is ideal, we personally use all three of these. Another use for a slave is fulltext searching, we have a text table that’s InnoDB on the master and MyISAM on the slave. Though if you can Sphinx is another good approach if you want to skip MyISAM completely.
…own engine was being used natively my MySQL as InnoDB in order to support transactions, row-level …run “ALTER TABLE t1 ADD SPHINXFULLTEXT Ft_News_Search_Message (`NewsMessage`);” instead of having to fiddle … was the main reason for why at least I was using mysql fulltext from beginning instead of …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.