June 18, 2013

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

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

Post: Talking MySQL to Sphinx

April 19, 2009 By 4 Comments

… MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL… and no indexes there defined – Sphinx does not support explicit indexes and it is clear when you can use index for sort MySQL will be… full text search applications when exact number is not important. Sphinx mysql> select max(forum_id) as m,author_id as a…

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

… to Sphinx as if it were MySQL Server with more advanced connectors which issue such commands when they set up connection. Sphinx Team also announced Sphinx Users… like to see some benchmarks comparing it to Sphinx, especially to its Real Time indexes. Some easy to understand feature comparison table…

Filed Under: Cloud and NoSQL, MySQL

Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see

February 12, 2013 By 4 Comments

…) before. MySQL Query Anti-Patterns that can be moved to Sphinx - (Vladimir Fedorkov, PalominoDB) Now that Innodb supports Full-text indexing, I’m interested in other good discussion points about when selecting Sphinx…

Filed Under: Events and Announcements, MySQL, Percona Live Tagged With: , ,

Post: UDF -vs- MySQL Stored Function

September 6, 2010 By 8 Comments

… pushing it to sphinx – MySQL did not have a function to do the thing so I thought I’ll write MySQL Stored Function… really – building the index, which was taking 10 minutes, was now taking 16 minutes. Then we added another MySQL function for different set of attributes and indexing speed went from 16 minutes to 26…

Filed Under: MySQL Tagged With: , ,

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

… Sphinx, columns are basically one of two kinds: a) full text b) attributes Speaking in MySQL terms, Full text columns are always indexed… which looks like talking to MySQL server, but it’s not. It is me talking to Sphinx server. First of all, let… an extra column in a full text index that I can use for filtering: sphinx> select * from catalog where match(‘@userkey userkey…

Filed Under: Insight for Developers, MySQL 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-… matter). Let me put it another way. If your MySQL or Sphinx query takes 10s to run on a machine with a… way very early on. If your sphinx index does not fit to one machine, you would index different parts of it from different…

Filed Under: MySQL Tagged With: , , ,

Post: Sphinx: Going Beyond full text search

July 23, 2007 By 18 Comments

… “dev.mysql.com/download/mysql-5.1.html” would match “mysql.com”, “dev.mysql.com”, “dev.mysql.com/download/” and “dev.mysql.com/download/mysql-5.1… for Sphinx attribute storage). It is especially great as there is still room for optimization – Sphinx stores word positions in the index, while… site or forum from the global sphinx index. So in general we find parallel processing using sphinx pretty good solution for many data…

Filed Under: Insight for Developers Tagged With: ,

Post: Using Sphinx as MySQL data retrieval accelerator

October 30, 2006 By 25 Comments

… efficient indexes so selectivity is done by index and index used to resolve order by. Funny enough to filter by attributes or sort sphinx does not use indexes – indexes are… 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 0.9.8 is released just in time for OSCON 2008

July 20, 2008 By 2 Comments

… we included Sphinx chapter in High Performance MySQL book – check out Appendix C. This should be the best printed material about Sphinx out… 3.6 seconds to do using Sphinx, compared to 7.5 seconds using MySQL with best covering index (so no temporary table or sorting is needed for group by). Note that with Sphinx you…

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