June 19, 2013

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

… a poor Sphinx search performance I find our customers face is misuse of search filters. In this article I will cover how Sphinx attributes…? 287 records returned in 155ms. Doing the same thing in MySQL, assuming user_id is indexed and in cache, would take… queries without full text search keywords, having them full text indexed is a very good way to improve such Sphinx search query performance.

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

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… SQL and 20 on Sphinx). Also Sphinx does the relevance sorting by default, adding relevance sorting to the MySQL queries would make them… would merge the delta index with the main index periodically. Sphinx Search also supports a supplementary in-memory RT index type that… found? No, only the documents included in the Sphinx Search indexes will be returned by Sphinx Search queries. Mike W. also asked: Q: What…

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

Post: Community events around Percona Live MySQL Conference and Expo 2012

March 26, 2012 By 1 Comment

… should not miss: Pythian is stepping in to organize traditional MySQL Community Dinner event during Tutorial Day of the conference (April… first Sphinx Search Day hosted by Sphinx Technologies (April 13) All these events are free to attend (registration needed) whenever you’re attending MySQL…

Filed Under: Events and Announcements, MySQL

Post: Sphinx: Going Beyond full text search

July 23, 2007 By 18 Comments

… projects using Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we’re using this combination to build search against… many search URLS, such as “dev.mysql.com/download/mysql-5.1.html” would match “mysql.com”, “dev.mysql.com”, “dev.mysql.com/download/” and “dev.mysql…

Filed Under: Insight for Developers Tagged With: ,

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue … what we are trying to achieve here. Sphinx has the ability to do distributed search out of the box – it was designed to scale out that way very early on. If your sphinx index…

Filed Under: MySQL Tagged With: , , ,

Post: Using Sphinx as MySQL data retrieval accelerator

October 30, 2006 By 25 Comments

… thread couple of days ago: Basically someone is using sphinx to perform search simply on attributes (date, group etc) and get sorted… filter by attributes or sort sphinx does not use indexes – indexes are only used for full text search matching, but it is… databases which may be slower than MySQL. MySQL Make it so one would not need to use sphinx to get great performance for…

Filed Under: Insight for Developers Tagged With: ,

Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December

November 17, 2011 By 6 Comments

… it were MySQL Server with more advanced connectors which issue such commands when they set up connection. Sphinx Team also announced Sphinx Users… in 2012. Another thought – with Innodb Full Text Search coming up in MySQL 5.6 and Claimed to be faster than MyISAM… Sphinx not because it is faster – speed might not be the main thing on smaller collections but its various full text search…

Filed Under: Cloud and NoSQL, MySQL

Post: BoardReader - Forum Search Engine

November 29, 2006 By 13 Comments

… is and S Stands for Sphinx – Full Text Search Engine which we love to use where large scale search is needed. At this… it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search forums from that domain. For example you can use this link to search our MySQL Performance Forums Second…

Filed Under: Events and Announcements Tagged With:

Post: Full text search for all MySQL Storage Engines

June 26, 2006 By 37 Comments

… 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…, including boolean search and distributed searching. A while ago I already wrote about Sphinx Search Egine, comparing it to built in FullText search and Mnogosearch…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Full Text Search in Action

February 7, 2008 By 9 Comments

… shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi A6 will…. Looking at alternative solution, which we’re often using with MySQL – Sphinx Search we still tend to use stop word list for performance… with sphinx because it uses word position based ranking not just frequency based ranking by default which means if you’re searching…

Filed Under: Insight for Developers Tagged With:
« Older Posts