Tag - Sphinx

MySQL & Sphinx: Register now for Nov. 20 Webinar

Sphinx is a free, open-source search server that integrates nicely with MySQL. It provides a fast, scalable, and pluggable search framework. The Sphinx engine possesses a variety of tools enabling you to customize how searching/indexing interacts with or becomes a part of your environment.
Join me and Sphinx Search CEO/CTO Andrew Aksyonoff, the founder and creative […]

Read more

What technologies are you running alongside MySQL?

In many environments MySQL is not the only technology used to store in-process data.
Quite frequently, especially with large-scale or complicated applications, we use MySQL alongside other technologies for certain tasks of reporting, caching as well as main data-store for portions of application.
What technologies for data storage and processing do you use alongside MySQL in […]

Read more

Sphinx search performance optimization: multi-threaded search

Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue a single query on your brand new r910 with 32 CPU cores and 16 disks, the maximum that is going to be used to process this query at any given point is 1 CPU core […]

Read more

Sphinx search performance optimization: attribute-based filters

One of the most common causes of a poor Sphinx search performance I find our customers face is misuse of search filters. In this article I will cover how Sphinx attributes (which are normally used for filtering) work, when they are a good idea to use and what to do when they are not, […]

Read more

Webinar for Full Text Search Throwdown

Tomorrow, August 22 at 10:00am PDT, I’ll present a webinar called Full Text Search Throwdown.  This is a no-nonsense performance comparison of solutions for full text indexing for MySQL applications, including:

LIKE predicates and regular expressions
MyISAM FULLTEXT indexes
InnoDB FULLTEXT indexes
Apache Solr
Sphinx Search
Trigraphs

I’ll compare the performance for building indexes and querying indexes.
If you’re developing an application with […]

Read more

First Sphinx Conference is Announced

The First ever Sphinx Users Conference is announced to take place in Moscow, Russia on October 24th,
which is the Sunday before Highload.ru conference, so if you’re attending that you may just drop by to this event too.
this is going to be free technically focused event, close in spirit to Percona Performance Conference, we organized […]

Read more

Slides from my Sphinx talk at RIT++ 2010

While the majority of Percona gang travelled to California for the MySQL event of the year, I headed in the opposite direction to Moscow for RIT++ 2010 conference where I presented a talk on Sphinx. You can get the PDF file here – Improving MySQL-based applications performance with Sphinx.
 
 

I have been invited to […]

Read more

Percona’s patches spread to a wider audience

Percona’s patches are now available to a wider audience via OurDelta, a community effort to provide  builds with features (Percona patches, Google patches, etc) and storage engines (PBXT, Sphinx, etc) that aren’t in the main MySQL server. Arjen Lentz is really the brainchild behind this. Kudos Arjen!
What does this mean for the […]

Read more