Percona's MySQL & InnoDB performance and scalability blog
Sphinx for searching Memcached for caching MongoDB for analytics Can anyone compare the Lucene and sphinx performance?
… each with hundreds of thousands of records, for we use sphinx based on attributes, but memory consumption is exaggerated, so we…
Hi Robert, – you don’t actually need to merge sphinx indexes – it does that on the fly. If you are …
… still want to take advantage of otherwise superb Sphinx performance. The Problem While Sphinx is great for full text search, you can… to do a full scan: sphinx> select * from catalog; … 20 rows in set (0.70 sec) sphinx> show meta; +—————+———-+ | Variable_name | Value…(‘@userkey userkey_50′); … 20 rows in set (0.00 sec) sphinx> show meta; +—————+————+ | Variable_name | Value | +—————+————+ | total | 287 | | total_found | 287…
… MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support is currently in its early preview stage… purposes as well as so Sphinx can be accessed from languages which doe not have native Sphinx API implemented – everyone seems to… disk temporary table which will make Sphinx much faster and few others. The true gain from Sphinx however comes from its ability…
My friends at Sphinx Technologies have finally released new beta of Sphinx – Sphinx 2.0.2. It includes about 6 months of development… will see very solid Stable Sphinx 2.0 within next 3 to 6 months. In fact Sphinx 2.0.3-rc is… which issue such commands when they set up connection. Sphinx Team also announced Sphinx Users Conference in St. Petersburg, Russia on December…
A couple of weeks ago Sphinx Technologies, a company behind Sphinx Full Text Search Engine launched Sphinx Support Packages which I think is a great value for everyone using Sphinx in… note at Percona we also have Sphinx Support so how are these different ? Support from Sphinx Technologies is based on traditional support…
… should be the best printed material about Sphinx out there, though as of now Sphinx has surely grown into the size to… price, you can just disable ranking. Another interesting point is Sphinx grouping performance. For example on the same 15M document collection…. Anyways I’m excited of this new Sphinx milestone, and if you’re using Sphinx, be sure to try this new release…
…’ve already wrote a few times about various projects using Sphinx with MySQL for scalable Full Text Search applications. For example… to same on sorting which is now still happening. Using Sphinx such non-traditional way required implementing some features more traditional… site or forum from the global sphinx index. So in general we find parallel processing using sphinx pretty good solution for many…
…, let me explain what we are trying to achieve here. Sphinx has the ability to do distributed search out of the… nature. This is however easy to check – look at your Sphinx query log and look at the number of results matched… your data looks like. Finishing line I always loved how Sphinx scales out easily with as many machines you need and…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.