June 19, 2013

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

… seen in a post by Baron, Sphinx Release 0.9.8 is finally out, just in time for OSCON 2008. Even though… Sphinx as in our opinion it is great complement to MySQL when it comes to full text search tasks and other real time… should be the best printed material about Sphinx out there, though as of now Sphinx has surely grown into the size to…

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

My friends at Sphinx Technologies have finally released new beta of SphinxSphinx 2.0.2. It includes about 6 months of development… would like to see some benchmarks comparing it to Sphinx, especially to its Real Time indexes. Some easy to understand feature comparison table would also be helpful as in many cases people use Sphinx not…

Post: Goal driven performance optimization

… etc. But the real thing is number of times which are stored for request. wall clock time – is the real time it took to generate…/wtime) cpu_ratio, avg(mysql_time/wtime) mysql_ratio ,avg(sphinx_time/wtime) sphinx_ratio, avg((wtime-mysql_time-sphinx_time-utime)/wtime) lost_ratio from performance…

Post: Sphinx search performance optimization: attribute-based filters

… | total_found | 10309972 | | time | 0.700 | +—————+———-+ 3 rows in set (0.00 sec) Note this is a real index used in …| total_found | 1499266 | | time | 0.227 | sphinx> select * from catalog where match(‘ancientkey_0′); | total_found | 8852086 | | time | 1.309 | sphinx> select * from …

Post: Report from OSCON 2008

… booth (Andrew could not come so that was on me). Sphinx both turned out particularly interesting – unlike couple of years ago… to ask what Sphinx is but happy users saying thanks for the product. I also had to explain many times why is… systems if often afterthought. At the same time I go a lot of questions about real time index updates – this is the number…

Post: Top 5 Wishes for MySQL

…. Two aspects why I’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL but… data consistence requirements. But honestly most parts are OK – over time you develop practices and tool set to deal with multiple… with group by over 10.000.000 of rows in real time is one painful thing to do requiring complex application programming…

Comment: MySQL Performance Blog now uses Sphinx for Site Search

Right it uses cron to update indexes which is good enough for the task. Sphinx will support real time updates in the future. It just takes a time to implement it without performance sacrifices.

Page: Presentations

… company or group. Sphinx search engine for RDBMS Egypt, December 2007 Presentation about Sphinx, the tasks …his kind permission. This presentation covers some real world scalability performance problems we’ve discovered…MySQL Benchmark Group was working at the time. Does not have too much meat about …

Post: How Percona does a MySQL Performance Audit

… lot of time on settings and status. It is not where the greatest gains are to be found. The real gold mine is yet to come. After you’ve done it a few times, you can go… (we may suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common case, though, a…

Post: MySQL net_write_timeout vs wait_timeout and protocol notes

time, so increasing net_write_timeout could be the good idea. This for example typical cause of aborted connections while using Sphinx with large data sets and large buffers. While indexing Sphinx performs sorts and flushes buffers… happening inside MySQL client library so you never know when real network read will happen. As net_write_timeout and net…