Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 15, 2012
Optimize Your SQL With Percona’s Online Query Advisor!
Wouldn’t it be nice if you could get expert advice on your SQL queries to find problems in them, the [...]
February 15, 2012
Troubleshooting MySQL Upgrade Performance Regressions
So lets say you upgraded from MySQL 5.1 to Percona Server 5.5 and instead of expected performance improvement you see [...]
February 10, 2012
Why not make a tool to improve existing configurations?
A couple of users of our very popular MySQL Configuration Wizard have submitted feedback such as “I’d love to input [...]
February 6, 2012
Announcing Percona Toolkit Release 2.0.3
We’ve released Percona Toolkit 2.0.3, with a couple of major improvements and many minor ones. You can download it, read [...]
February 2, 2012
STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
DELETE IGNORE suppresses errors and downgrades them as warnings, if you are not aware how IGNORE behaves on tables with FOREIGN KEYs, [...]
February 1, 2012
Verifying backup integrity with CHECK TABLES
An attendee to Espen’s recent webinar asked how to check tables for corruption. This kind of ties into my recent [...]
January 26, 2012
MySQL Configuration Wizard Updated
We’ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If you [...]
January 25, 2012
How to Recover a Single InnoDB Table from a Full Backup
Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small [...]
January 24, 2012
linux.conf.au 2012 roundup
I spent last week at linux.conf.au in Ballarat, Victoria (that’s the Victoria in Australia, not wherever else there may be [...]
January 19, 2012
Percona XtraDB Cluster Feature 2: Multi-Master replication
This is about the second great feature – Multi-Master replication, what you get with Percona XtraDB Cluster. It is recommended [...]
January 18, 2012
Backing up binary log files with mysqlbinlog
Backing up binary logs are essential part of creating good backup infrastructure as it gives you the possibility for point [...]
January 17, 2012
Benchmarks of new innodb_flush_neighbor_pages
In our recent release of Percona Server 5.5.19 we introduced new value for innodb_flush_neighbor_pages=cont. This way we are trying to [...]
January 17, 2012
Percona XtraDB Cluster Feature 1: High Availability
There and in coming posts I am going to cover main features of Percona XtraDB Cluster. The first feature is [...]
January 12, 2012
Create 3 nodes XtraDB Cluster in 3 minutes
I understand that the new technology can be scaring and this makes entry barriers to try and get familiar with [...]
January 11, 2012
Making the impossible: 3 nodes intercontinental replication
In this post I want to show new possibilities which open with Percona XtraDB Cluster. We will create 3 nodes [...]
January 9, 2012
Learn about Percona XtraDB Cluster at Percona Live DC
You probably saw that Vadim blogged about the first alpha release of Percona XtraDB Cluster. Just in time: now I [...]
January 8, 2012
Is your MySQL Application having Busy IO by Oracle Measures ?
Preparing Choosing Storage Systems for MySQL talk for Percona Live in Washington,DC I ran into great paper called Sane SAN [...]
January 6, 2012
Configuring MySQL For High Number of Connections per Second
One thing I noticed during the observation was that there were roughly 2,000 new connections to MySQL per second during [...]
January 5, 2012
Looking for RAID Controller without Battery Learning problems ?
A lot have been written about Battery Learning Cycle problems and its impact to MySQL Performance. Here are couple of [...]