posted on January 13th, 2012 by Vlad in Conferences
If you want to know more about Sphinx performance or looking to offload your heavy loaded production DB from Full-text and non-full-text queries we are welcome you to meet Sphinx at FOSDEM conference in Brussels, Belgium on the first weekend this February!
Vladimir Fedorkov, Director of Professional Services at Sphinx will present talks in MySQL and Friends Devroom and will open Sphinx Performance Top Secrets.
For our European users this is also a good time to arrange onsite performance and tuning – we will not charge you for most travel expenses around these dates. Please contact us for details and mention promotional code FOSDEMSPH for the discount.
Looking forward to meet you in Brussels!
No Comments »
posted on November 18th, 2011 by shodan in General
Things break, servers crash, software has bugs, water is wet, so to keep the sky blue and clear we need backups. While backing up a disk index in Sphinx is basically a matter of copying files around, properly backing up RT is a little bit more complicated. (But only a little bit.) Read on to find out how binlogs, periodic flushes, and two newly added 2.0.2-beta features (FLUSH RTINDEX and ATTACH INDEX) can all work together for backup/recovery.
Read the rest of this entry »
No Comments »
posted on November 11th, 2011 by Vlad in performance
Let me step back from sphinx performance and highlight first how Sphinx uses memory.
There are two different ways to store data in Sphinx (we call it indexes): on-disk and Real-Time index. Lets start with good old on-disk indexes.
Basically Sphinx on-disk index is simply a set of files generated by indexer during indexing process. All of them, except .spd and .spp are kept in memory for performance reasons. Read the rest of this entry »
No Comments »
posted on October 27th, 2011 by Vlad in performance
As you might know Sphinx team are focused not only on full-text search improvements like blended characters support we introduced in 2.0.1-beta, we also cares about performance improvements. And one of the main questions on performance – how do you measure single query speed especially in scalable, distributed environment.
Read the rest of this entry »
7 Comments »
posted on October 19th, 2011 by shodan in General
One of the application of distributed indexes in Sphinx is parallelizing queries across many CPU cores even when running on a single server. There’s a well known trick to have an agent line (or three) pointing to the very same master searchd instance. Only problem with that approach is, every query entails a bunch of one-off TCP connections, extra forks, and other redundant internal work. Which is okay when you’re serving a few heavy queries but might spin over 50% of your CPU in system time doing those works when you’re doing many quick ones.
Now that’s a problem, but starting with 1.10-beta, there is a solution, called dist_threads directive. So if you’re still doing that agent=localhost trick, and suffering from TCP stack pressure and/or seeing way too much system time in top(1) or vmstat(8), do read on, you are eligible. (As a collateral, if you’re still on anything pre-2.0.1, you should seriously consider upgrading, too.)
Read the rest of this entry »
1 Comment »
posted on September 21st, 2011 by rich in Conferences, General, training
As a result of positive response we received from our 2010 Sphinx Conference in Moscow, we decided to take the show on road! Thus the Sphinx Road Show scheduled for Europe in late November 2011.
Read the rest of this entry »
No Comments »
posted on September 10th, 2011 by rich in Conferences, General, training
Andrew Aksyonoff the founder of Sphinx is a featured speaker at Percona Live London, Oct. 24-25th 2011. In addition to his talk on Increasing Performance of MySQL Queries with Sphinx, we are considering a tutorial or training session on Sphinx. But before we commit to a tutorial at Percona Live London, we would like to gauge the interest in attending from YOU. Read the rest of this entry »
1 Comment »
posted on June 11th, 2011 by Vlad in Conferences, training
On Saturday, Jun 18th meet Andrew Aksyonoff, Sphinx founder in Kyiv, Ukraine on an extensive 8-hour Sphinx workshop. The workshop will be given in Russian and covers Sphinx quite extensively, from the initial 1-click installation to search cluster setup and tuning.
If you are looking for Sphinx workshop in your location or private training class for your company employees please contact us
2 Comments »
posted on May 9th, 2011 by rich in Conferences
The Sphinx Team will be in the New York, NY aka ‘The Big Apple’ the last week of May. We are sponsoring and speaking at Percona Live on the 26th of May, as well as presenting at the New York PHP Community Meetup on the 24th of May.
Read the rest of this entry »
No Comments »
posted on April 22nd, 2011 by shodan in General
When it rains, it pours… Do expect a full-blown news entry with the new features overview and other nitty gritty details a little while later (when we add more binary packages, and figure out how to mention both the book and the new release), but a new version of Sphinx, tagged 2.0.1-beta, is just out, you can grab it now. If you’re running any of the previous ones, I strongly recommend to check this one out. For the purpose of reporting bugs and getting 2.0.2-release in a month, if nothing else. Oh, and the book actually documents 2.0.1-beta too. How’s that for a combo?
22 Comments »
