Vlad Fedorkov and the creator of Sphinx Search speaking at Percona Live 2014. They cover the basics of Sphinx, as well as faceted search, auto-correction, searching with ranges, geo spatial search, non-full-text search (filtering, grouping, sorting), and about some of Sphinx’s full-text search operators (ie. field-limit operator and quorum operator). A talk at Percona Live […]
10 Older Entries »
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 force behind Sphinx, on Wednesday, November 20th at 10 a.m. PST as we discuss how to get started with Sphinx and seamlessly integrate it into your applications and MySQL. The title of our webinar is, “How to Optimally Configure Sphinx Search for MySQL” and you can register …[Read more]
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 your environment? Please feel free to elaborate in the comments about your use case and experiences!
Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.
The post What technologies are you running alongside MySQL? appeared first on …[Read more]
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 and 1 disk. In fact, only one or
Seriously, if query is CPU intensive, it is only going to be using 3% of the available CPU capacity (for the same 32-core machine). If disk IO intensive – 6% of the available IO capacity (for the 16-disk RAID10 or RAID0 for that matter).
Let me put it another way. If your MySQL or Sphinx query takes 10s to run on a machine with a single CPU core and single disk, putting it on a machine with 32 such cores and 16 such disks will not make it any better.
But you knew this already. Question is – can you do something about it?
In case of Sphinx – indeed you can! And with very little …[Read more]
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, but you still
want to take advantage of otherwise superb Sphinx
While Sphinx is great for full text search, you can certainly go beyond full text search, but before you go there, it is a good idea to make sure you’re doing it the right way.
In Sphinx, columns are basically one of two kinds:
a) full text
Speaking in MySQL terms, Full text columns are always indexed and using the very …[Read more]
You may have already seen the announcement MariaDB Foundation to Safeguard Leading Open Source Database. We at Open Query wholeheartedly support this (r)evolution of the MySQL ecosystem, which appears to be increasingly necessary as Oracle Corp is seriously dropping the ball with security updates and actually just general development and innovation. Oracle has actually done some very good work, I happily acknowledge that – but security issues are critical, having crashing bugs and incorrect query results in a .28 of a GA release is uncool, and not incorporating awesome development efforts by the community is just astonishing.
MariaDB is where the Sphinx fulltext …[Read more]
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
I’ll compare the performance for building indexes and querying indexes.
If you’re developing an application with text search features, this will be a very practical and informative overview of your technology options!
Register for this free webinar at …[Read more]
Are you looking to expand your knowledge about MySQL and MariaDB database solutions?
Well, you’re in luck! SkySQL is introducing an exclusive collection of educational videos featuring some of the industry’s leading experts on the MySQL database and related technologies. View informative, technical talks on a variety of topics, from the experts at SkySQL, MariaDB, Calpont InfiniDB, Continuent, ScaleDB, Severalnines, Sphinx, Webyog, and others.
I'm giving thoughts on the viability of MySQL plugins. This is due to a particular experience I've had, which is thankfully solved. However, it left some bitter taste in my mouth.
MySQL plugins are a tricky business. To create a plugin, you must compile it against the MySQL version you wish the users to use it with. Theoretically, you should compile it against any existing MySQL version, minors as well (I'm not sure whether it may sometimes or most times work across minor versions).
But, most important, you must adapt your plugin to major versions.
Another option for plugin makers, is to actually not recompile it, but rather provide with the source code, and let the end user compile it with her own MySQL version. But here, too, the code must be compatible with whatever changes the new MySQL version may have.
And if it doesn't compile with the new MySQL version?
That's what happened to me. The …[Read more]
I've written a patch which completes Sphinx's integration with MySQL 5.5.
Up until a couple months ago, Sphinx would not compile with MySQL 5.5 at all. This is, thankfully, resolved as of Sphinx 2.0.3.
However, to my disdain, I've found out that it only partially work: the sphinx_snippets() user defined function is not included within the plugin library. After some quick poking I discovered that it was not added to the build, and when added, would not compile.
I rely on sphinx_snippets() quite a lot, and like it. Eventually I wrote the fix to the snippets_udf.cc which allows it to run in a MySQL 5.5 server.
Here are the changes for the 2.0.4 version of Sphinx:
10 Older Entries »