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 [...]
UDF -vs- MySQL Stored Function
September 6, 2010 By 8 Comments
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 [...]
Percona at OSCON 2010
July 13, 2010 By Leave a Comment
This year we’re participating in OSCON as a Sponsor and organizing some BOFs. I will be on the conference 21 and 22 if you’re interested to chat. Here is the list of currently scheduled BOFs which I’ll be hosting: Running Databases on Flash Storage Sphinx Search 2010 XtraDB, XtraBackup, Maatkit, Percona Server See you there.
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 [...]
Sphinx 0.9.9 is finally here.
December 4, 2009 By Leave a Comment
Sphinx 0.9.9 is finally released to General Availability. The previous version 0.9.9-rc2 was released back in April so there was quite a gap. This release fixes about 40 bugs which are mostly rare or insignificant. Fixing bugs in 0.9.9 was smaller portion of work done in Sphinx during last half a year – 0.9.9-rc2 was [...]
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 [...]
