Few days ago I was working on a case where we needed to modify a lot of data before pushing it to sphinx – MySQL did not have a function to do the thing so I thought I’ll write MySQL Stored Function and we’ll be good to go. It worked! But not so well really [...]
Slides from my Sphinx talk at RIT++ 2010
April 14, 2010 By 1 Comment
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 [...]
Can we get faster expression handling in MySQL
March 30, 2010 By 7 Comments
Andrew from Sphinx continues to work on improving SQL (or SphinxQL) support and now he published benchmarks comparing arithmetic expression handling in Sphinx to one in MySQL. The result ? Sphinx scored 3x to 20x faster. Andrew goes to explain results are not 100% comparable (as we can see in the table results are even [...]
Getting around optimizer limitations with an IN() list
January 9, 2010 By 9 Comments
There was a discussion on LinkedIn one month ago that caught my eye: Database search by “within x number of miles” radius? Anyone out there created a zipcode database and created a “search within x numer of miles” function ? Thankful for any tips you can throw my way.. J A few people commented that [...]
Percona is hiring a consultant
December 16, 2009 By 7 Comments
We’re hiring. We are looking for the following qualifications: Expert knowledge of MySQL. Not just “certified” — years of production experience with it. You need to know server internals, for example. You need to be able to do anything from optimizing difficult queries to moving high-volume services between data centers without interruption. Expert knowledge of [...]
Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
After having reviewed the definition my the previous post (The definitions), the next step is to respond to some questions. Do you need MySQL High-Availability? That question is quite obvious but some times, it is skipped. It can also be formulated “What is the downtime cost of the service?”. In the cost, you need to [...]
What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
It is rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason of the move could be just desire for better data consistency guaranty or being bitten repairing multiple GB MyISAM table few times, though Table Locks is probably the most important issue – with modern multi [...]
Sphinx at MySQL Meetup at San Francisco
August 10, 2009 By 9 Comments
I will be presenting at upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx covering the new cool features this search engine has as well as showing the demo on how simple it is to use Sphinx to implement high performance full text search for your MySQL driven application. [...]
Percona talks at OSCON
July 16, 2009 By Leave a Comment
The OSCON 2009 is taking place next week and we have bunch of talks we’re presenting. I am presenting Full Text Search with Sphinx, MySQL Community Patches and Extensions and Goal Driven Performance Optimization. Vadim and Ryan have a talk XTraDB OpenSource Storage Engine for MySQL. This month OSCON is taking place in Silicon Valley [...]
Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
In the recently released Sphinx version 0.9.9-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support is currently in its early preview stage but it is still fun to play with. A thing to mention – unlike MySQL Storage Engines, some of which as InfoBright [...]
