by Baron Schwartz | Mar 28, 2011 | Benchmarks, Cloud, MySQL
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...
by Ryan Lowe | Mar 28, 2011 | Cloud, MySQL, Percona Software
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...
by Vadim Tkachenko | Mar 28, 2011 | MySQL, Percona Software
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...
by Baron Schwartz | Mar 28, 2011 | Percona Software
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...
by Aurimas Mikalauskas | Mar 28, 2011 | Insight for DBAs, MySQL
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: ... # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time...
by Baron Schwartz | Mar 27, 2011 | MySQL, Percona Software
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...
by Justin Swanhart | Mar 25, 2011 | Insight for DBAs, Insight for Developers, MySQL
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...
by Tokutek | Mar 25, 2011 | MySQL
Big Data + Big Ideas = Big Advantage “Big Data” is the new buzzword in IT. Doing a Google search will yield over 1M hits. In Boston, there were two back-to-back Big Data events last month. On Wednesday in New York, there was another Big Data event. Of course, everyone...
by Tokutek | Mar 24, 2011 | MySQL
Customers and Users Ernie Souhrada, Chief IT Architect at Jawa “With the introduction of Hot Schema Changes in TokuDB v5.0, Tokutek makes deriving value out of a large MySQL database simple, giving us the option to much more easily analyze our data and generate value...
by Justin Swanhart | Mar 23, 2011 | Insight for DBAs, Insight for Developers, MySQL
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...
by Tokutek | Mar 23, 2011 | MySQL
The Big Data Opportunity “What if you could analyze every transaction, capture insights from every customer interaction, and didn’t have to wait for months to get data from the field?”- McKinsey Column, Financial Times Despite this tremendous opportunity, MySQL...
by Tokutek | Mar 23, 2011 | MySQL
TokuDB v5 Overview
by Baron Schwartz | Mar 22, 2011 | Percona Events
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...
by Baron Schwartz | Mar 21, 2011 | MySQL, Percona Events
Many of the prominent companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software developers, hosted service providers, and appliance developers. We perform paid and unpaid research on their products, and we publish blog posts...
by Peter Zaitsev | Mar 21, 2011 | Insight for DBAs, MySQL
It has taken a years to get a proper integration between operating system kernel, device driver and hardware to get behavior with caches and IO modes correctly. I remember us having a lot of troubles with fsync() not flushing hard drive write cache and so potential...
by Baron Schwartz | Mar 21, 2011 | Insight for DBAs, MySQL
We’ve just published a new white paper analyzing the causes of emergency incidents filed by our customers. The numbers contradict the urban myth that bad SQL is the most common problem in databases. There are a number of surprises in other areas, too, such as...
by Baron Schwartz | Mar 21, 2011 | Benchmarks, MySQL
The duration of a benchmark is an important factor that helps determine how meaningful it is. Most systems have some “burstable capacity,” and this can influence the results a lot. You can see this in all areas of life — you can sprint much faster...
by Baron Schwartz | Mar 20, 2011 | MySQL, Percona Software
Here’s what is new in Percona Server and Percona XtraBackup since last week. We are working on compiling and checking download statistics for both pieces of software. The preliminary numbers are far higher than I thought they would be. Both Percona Server and...
by Zardosht.Kasheff | Mar 16, 2011 | MySQL
Yesterday, at the Boston MySQL Meetup, I gave a talk on indexing. It is posted here (also goo.gl/S2LBe). In short, indexes are used to improve query performance. As a result, good indexes are designed around queries that users find important in their application. The...
by Ryan Lowe | Mar 16, 2011 | Insight for DBAs, MySQL
HandlerSocket has really generated a lot of interest because of the dual promises of ease-of-use and blazing-fast performance. The performance comes from eliminating CPU consumption. Akira Higuchi’s HandlerSocket presentation from a couple of months back had...
