June 19, 2013

Post: Using Sphinx as MySQL data retrieval accelerator

…: Basically someone is using sphinx to perform search simply on attributes (date, group etc) and get sorted result set and claiming it is… resolve order by. Funny enough to filter by attributes or sort sphinx does not use indexes – indexes are only used for full… document are traversed and priority queue sorting is performed to generate 1.000 best matching results. Quite impressive Yeah I know it…

Post: MySQL Performance Blog now uses Sphinx for Site Search

… new search functionality for our site which is based on Sphinx. We have developed it as WordPress plugin which will be… if you would like to sort results be relevance of freshness. You can also use query standard Sphinx query language to search phrases… download plugin code it is here: https://launchpad.net/wp-sphinx-plugin/+download

Post: Talking MySQL to Sphinx

… index for sort MySQL will be a lot faster. First – Sorting. Sphinx is smart doing sorting because it does not try to sort everything but… (17.91 sec) As you can see Sphinx adds couple of extra columns to result set even if you have not asked… note the result set difference – Sphinx finds no rows and creates no groups while MySQL reports NULL group as a result. SphinxQL at…

Post: Sphinx: Going Beyond full text search

… list of “keywords” on the fly. As results we now can pull up results even for youtube.com for fractions of the… make index built sorted by timestamp which would allow to same on sorting which is now still happening. Using Sphinx such non-traditional… site or forum from the global sphinx index. So in general we find parallel processing using sphinx pretty good solution for many…

Post: Sphinx search performance optimization: attribute-based filters

… time a keyword matches a document, Sphinx needs to resolve an appropriate document and evaluate the result. If your keywords match all… be much much faster. Attributes on the other hand are sort of like unindexed MySQL columns. They are the extra details… reduce the number of results matched significantly. But not the amount of time it takes to do that: sphinx> select * from catalog…

Post: Sphinx 0.9.8 is released just in time for OSCON 2008

… I’d be happy to share a couple of benchmarks results for the new version. First is about “EXTENDED2″ matching mode…, for example when you’re sorting by price, you can just disable ranking. Another interesting point is Sphinx grouping performance. For example… index (so no temporary table or sorting is needed for group by). Note that with Sphinx you can easily run the process…

Comment: Using Sphinx as MySQL data retrieval accelerator

… deliver you top 1000 matching results. You for example may see the matches returned on top if sorting done by relevance would… not guaranty you these are matches best by relevance. Finally sphinx does NOT store number of matches for “the” word it… may not be always smart to do but as it sorts result set anyway it is limited overhead. “The” is just simiple…

Post: What would make MySQL Multiple Queries Usable ?

… for example while performing search we also want to get result search result set, as well as same set grouped by site… only once while having multiple results aggregation routers building the stream from that result set. We however use Sphinx for this kind of… only clicks from AdSense) and when get the grouped and sorted result set – for example pages with most clicks on them. Even…

Post: Full Text Search Webinar Questions Followup

… rows on SQL and 20 on Sphinx). Also Sphinx does the relevance sorting by default, adding relevance sorting to the MySQL queries would make them even slower, I’m sure. Indeed, the result set of 20 rows from SphinxQL queries is merely the default.  And sorting by relevance must have…

Comment: Full text search for all MySQL Storage Engines

… with SPH_SORT_DATE_DESC/SPH_SORT_DATE_ASC. Regarding relevance the problem is that the result should be (in my case) sorted by date and not by relevance. If you sort by relevance and… you can see the profile for sphinx to process the 10 most common word query, sphinx spends 16 seconds in the cpu…