…) DEFAULT NULL, `c` char(20) DEFAULT NULL, KEY `i` (`i`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 mysql> select * from t; +——+——–+ | i | c… | | 8 | repls | +——+——-+ Now go back to session1 and try to search the row with the value “andy”: session1> select * from t…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
… is because we were quite busy, mainly building BoardReader.com – Search Engine which indexes tens of thousands of forums from all over… in this project only on database Backend and full text search engine implementation. In this part it is standard LAMPS application. I… S Stands for Sphinx – Full Text Search Engine which we love to use where large scale search is needed. At this point we…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… it in the search engine – which can get things really efficient but can require significant coding and understanding of search engine externals. Simple filtering/sorting though is often supported by search engine directly and it is good…
Post: Full text search for all MySQL Storage Engines
June 26, 2006 By 37 Comments
… 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 also adds a lot of other new features, including boolean search and distributed searching. A…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… MySQL storage engines is you do not have to convert all tables at once. In some cases full text search is used… 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…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… will not be easy to figure out which storage engine or storage engine mix is best match for you. Believe me people… storage engines out where to read sensor data, talk to memcache or external search engine . As MySQL 5.1 and plugable storage engine interface matures I hope we’ll see more storage engines which are…
Post: Yahoo Search Suggestions for MySQL
August 16, 2007 By 5 Comments
… if you go to Yahoo.com and type MySQL to Search field it gives you suggestions for MySQL, which are: * loading… administrator download * mysql front download It may not be best search suggestions but it is cool to see our blog name… of the list. Too bad few Geeks use Yahoo for search so most of our search engine traffic comes from Google.
Page: Presentations
May 3, 2006 By
… also give internal presentations for your company or group. Sphinx search engine for RDBMS Egypt, December 2007 Presentation about Sphinx, the tasks… text search functionality using real medium size text collection – Wikipedia Articles dump, when we compare it to other opensource full text search search engines…
Comment: Cache Performance Comparison
August 10, 2006 By 73 Comments
The search engine uses chunked bitvectors where each chunk is 10kbit (1250 bytes … they dont have any chunk in common the search is halted and the engine reports “0 hits”. Currently it is only indexing…. The engine itself is currently available at http://www.tbg.nu/cgi-bin/news_search.cgi and works like google (AND search) with…
