Percona Live is in only two days away – and we’ve managed to completely sell out (something I predicted earlier). Before I go into details, I want to thank three sponsors who have been absolutely awesome: Clustrix is providing an open bar all evening, New Relic is providing all attendees with lunch and Fusion-io is [...]
Blog Redesign 2011
January 16, 2011 By 9 Comments
After more than four years of using a theme that can charitably be described as rustic, we’ve updated our look. We’re using the News theme from StudioPress, which is a bargain; their themes and theme framework are an engineering marvel. We’re still using the amazing Sphinx search plugin from Ivinco for fast and relevant searches. [...]
First Sphinx Conference is Announced
September 10, 2010 By Leave a Comment
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 [...]
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 [...]
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 [...]
