June 19, 2013

Comment: MySQL Performance Blog now uses Sphinx for Site Search

Test for fulltext search with Sphinx : Địt con mẹ…Không biết Sphinx có tìm kiếm được cái này không nhỉ ?

Comment: Getting use of Slave in MySQL Replication

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.

Comment: Duplicate indexes and redundant indexes

Roland, First I only spoke about BTREE/TTREE indexes. FullText search indexes are different. RTREE should also be the same but …

Comment: Full text search for all MySQL Storage Engines

How about Senna ? Senna is a fulltext search engine embedded in MySQL 4.0, 4.1, 5.0. http://qwik.jp/senna/

Comment: My Innodb Feature wishes

1. MySQL to open interface fulltext search and innoDB implement it. 2. Descending indexes. 3. Better index usage on range queries.

Comment: EuroOSCON 2006 - High Performance FullText Search

… mysql fulltext for the forum at http://www.tbg.nu In my case the problem with mysql fulltext were that my searches performed: * Using boolean search. * No stopword-list. * Sorting hits by date… the three reasons above made mysql fulltext to virtually puke when a client performed a search which contained several commonly existing word…

Comment: Full text search for all MySQL Storage Engines

… there exist any other matches which still fulfill the search query because the fulltext engine has on its own made up what… my case to decrease the storage needed (which some other fulltext engines “cheats” with) but in my case that cannot be…, but when it comes to “10 most common words” search the mysql fulltext in boolean mode takes more than 800 seconds on…

Comment: Full text search for all MySQL Storage Engines

…. Regarding the 150k example it was more of how the fulltext engine internally needs to process all those hits specially for… temporary table (otherwise someone should explain to me why mysqls fulltext takes more than 800seconds for this 10 most common word… was way faster than mysqls own fulltext it still took 16 seconds for the “heavy” search) and that is why I started…

Comment: MySQL Full Text Search in Action

…_text|alternative_complement_text i need to search against each individually, or against main paired…1) fulltext(main),fulltext(first),fulltext(alternative),fulltext(main,first),fulltext(main,alternative) or 2) —————fulltext(first),fulltext(alternative),fulltext(main,first),fulltext(main,…

Comment: Full text search for all MySQL Storage Engines

… in detail? I’m currently using MyISAM becasue of the fulltext index for two forums. Size is 2 Million records and… 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…