Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 12, 2012
Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB [...]
March 5, 2012
O’Reilly Strata 2012: The Year of the Data Scientist
We had the privilege this past week to be invited to be part of the 2012 O’Reilly Strata “Making Data [...]
February 27, 2012
Announcing Percona XtraBackup 1.9.1
Percona is glad to announce the second beta release towards Percona XtraBackup 2.0! We call this version 1.9.1 as we are [...]
February 27, 2012
Evidenzia Upgrades to TokuDB v5.2 to Address Storage Growth and Scale Performance
Ensuring sufficient disk I/O to catch copyright violations at network speed. Evidenzia GmbH & Co. KG Issues addressed: Storage growth, including maxed-out [...]
February 25, 2012
Introducing new type of benchmark
Traditionally the most benchmarks are focusing on throughput. We all get used to that, and in fact in our benchmarks, [...]
February 24, 2012
Percona XtraDB Cluster Events
We are on our way to delivery a production ready release of Percona XtraDB Cluster by the end March-2012. We [...]
February 23, 2012
Percona XtraDB Cluster 5.5.20 – Beta release
I am happy to announce the availability of beta release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster [...]
February 23, 2012
Black-Box MySQL Performance Analysis with TCP Traffic
For about the past year I’ve been formulating a series of tools and practices that can provide deep insight into [...]
February 23, 2012
Percona Server vs MySQL on Intel 320 SSD
If you are terrified by the stability of the results in MySQL in my previous post, I am going to [...]
February 23, 2012
Some fun with R visualization
My previous post I finished with the graph with unstable results. There I won’t analyze causes, but rather I want [...]
February 22, 2012
Benchmarks of Intel 320 SSD 600GB
I have a chance to test a system with Intel 320 SSD drives (NewRelic provided me with an access to [...]
February 22, 2012
How to Monitor MySQL with Percona’s Nagios Plugins
In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and intended [...]
February 21, 2012
Database Algorithms sin Pantalones
So there I was, gesticulating in front of the chalkboard, lecturing to 120 students. Topic: the beauty of advanced data [...]
February 21, 2012
DBD::mysql 4.014 breaks pt-table-checksum 2.0
DBD::mysql 4.014 breaks pt-table-checksum 2.0. The cause is unknown, but the effect is a lot of errors like: DBD::mysql::st execute [...]
February 20, 2012
How to recover deleted rows from an InnoDB Tablespace
In my previous post I explained how it could be possible to recover, on some specific cases, a single table [...]
February 20, 2012
How to convert MySQL’s SHOW PROFILES into a real profile
SHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn’t a full-featured profile. [...]
February 20, 2012
MySQL Meetups in North Carolina this week
A quick reminder. I’m speaking on two MySQL meetups in North Carolina this week. Tuesday,Feb 21 on Raleigh MySQL/PHP Meetup [...]
February 19, 2012
Why don’t our new Nagios plugins use caching?
In response to the release of our new MySQL monitoring plugins on Friday, one commenter asked why the new Nagios [...]
February 18, 2012
MariaDB 5.3.4 benchmarks
MariaDB 5.3 has reached the release candidate milestone, and the 5.3 version promises a lot of new features and optimization [...]
February 18, 2012
Can we improve MySQL variable handling ?
MySQL Settings (also known as Server Variables) have interesting property. When you set variable in running server this change is [...]