November 27, 2014

InnoDB Flushing: a lot of memory and slow disk

You may have seen in the last couple of weekly news posts that Baron mentioned we are working on a new adaptive flushing algorithm in InnoDB. In fact, we already have three such algorithms in Percona Server (reflex, estimate, keep_average). Why do we need one more? Okay, first let me start by showing the current […]

MySQL on Amazon RDS part 2: Determining Peak Throughput

This is a continuation of my series of benchmark posts comparing Amazon RDS to a server running on Amazon EC2. Upcoming posts (probably 6 or 8 in total) will extend the scope of the benchmark to include data on our Dell r900 with traditional hard drives in RAID10, and a server in the Joyent cloud. […]

What’s up with HandlerSocket?

I’ve presented at two different venues about HandlerSocket recently and the number one question that always arises is: Why hasn’t HandlerSocket become more popular than it is? Considering how fast and awesome HandlerSocket is, it’s not seeing as rapid adoption as some might expect. I theorize that there are five reasons for this:

Percona Server and XtraBackup available on Solaris

I am happy to announce that Percona Server and Percona XtraBackup are now available for the Solaris platform! You can download the latest Percona Server 5.1.55-12.6 stable release from our download area. As for Percona XtraBackup, we made Solaris binaries for the upcoming XtraBackup-1.6 release, and they are available from “pre-release” directory. There are couple […]

Promote Percona Server and XtraBackup with Web Badges

We have web badges for promoting Percona Server and XtraBackup! If you use them and want to put little buttons in your website’s footer or sidebar, now it’s easy. There is copy-paste ready HTML for three styles of badge, for each of them: Percona Server badges and Percona XtraBackup badges.

Maatkit’s mk-query-digest filters

Have you ever seen BIG weird numbers in mk-query-digest report that just seem wrong? I have! Here’s one report I got today:

Percona Server and XtraBackup weekly news, March 28th

It’s time for the weekly roundup of news for Percona Server and XtraBackup. To follow up on my note from last week, we’re still checking and validating the download stats. It appears that Percona Server has been downloaded well over 100,000 times, and Percona XtraBackup has been downloaded over 200,000 times. But when we changed […]

Using Flexviews – part two, change data capture

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 […]

Using Flexviews – part one, introduction to materialized views

If you know me, then you probably have heard of Flexviews. If not, then it might not be familiar to you. I’m giving a talk on it at the MySQL 2011 CE, and I figured I should blog about it before then. For those unfamiliar, Flexviews enables you to create and maintain incrementally refreshable materialized […]

Two quick site updates: videos online; Kindle edition

Two notes for readers. First, we have been publishing a great deal of video material on our companion site Percona.TV. This includes our recordings from past conferences, user group meetings, screencasts, and most recently our webinars. (I hate the proprietary formats and silly technical restrictions that the webinar companies impose. I figured out how to […]