I just realized that we haven’t blogged a list of our sessions at the O’Reilly MySQL Conference and Expo (#mysqlconf) yet. Here is a hopefully complete list.
Using Flexviews – part two, change data capture
March 25, 2011 By 26 Comments
In my previous post I introduced materialized view concepts. This post begins with an introduction to change data capture technology and describes some of the ways in which it can be leveraged for your benefit. This is followed by a description of FlexCDC, the change data capture tool included with Flexviews. It continues with an [...]
Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
We have a special Friends of Percona discount code that you can use to get 20% off of registration at the MySQL conference in April: mys11pkb. If you click the image to the left, or this special link, it will pre-fill the code for you when you check out. Read on to see the list [...]
Percona Live is on Wednesday – thank you to all our sponsors
February 14, 2011 By Leave a Comment
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 [...]
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.
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 [...]
