Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 2, 2012
Hijacking Innodb Foreign Keys
I guess I’m first to post in 2012 so Happy New Year all blog readers ! Now back to HardCore [...]
December 29, 2011
How To Test Your Upgrades – pt-upgrade
Upgrades are usually one of the biggest part of any database infrastructure maintenance. Even with enough planning something else can [...]
December 29, 2011
Identifying the load with the help of pt-query-digest and Percona Server
Overview Profiling, analyzing and then fixing queries is likely the most oft-repeated part of a job of a DBA and [...]
December 27, 2011
MySQL Training in Frankfurt, Germany
We will be holding our highly acclaimed MySQL workshops in Frankfurt, Germany the week of February 13th. Early registration is [...]
December 23, 2011
Solving INFORMATION_SCHEMA slowness
Many of us find INFORMATION_SCHEMA painfully slow to work it when it comes to retrieving table meta data. Many people [...]
December 23, 2011
Online MySQL Configuration Wizard from Percona
Update: Percona will no longer be offering the free services of Query Analyzer and MySQL Configuration Generator hosted at tools.percona.com. We [...]
December 13, 2011
MySQL Training in Washington, DC
Many of you have seen the announcement for our Percona Live in Washington, DC in January! But did you know [...]
December 8, 2011
Which Linux distribution for a MySQL database server? A specific point of view.
One of the more common questions I get asked is which Linux distribution I would use for a MySQL database [...]
December 2, 2011
kernel_mutex problem. Or double throughput with single variable
Problem with kernel_mutex in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5.6 there are [...]
December 2, 2011
Three ways that the poor man’s profiler can hurt MySQL
Over the last few years, Domas’s technique of using GDB as a profiler has become a key tool in helping [...]
November 29, 2011
Beware the Innodb Table Monitor
As I stated in my last post, I decided to use the Innodb Table monitor to diagnose an Index count mismatch [...]
November 21, 2011
Should MySQL update the default innodb_log_file_size?
Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the [...]
November 18, 2011
Eventual Consistency in MySQL
We’re told that foreign key constraints are the best way to enforce logical referential integrity (RI) in SQL, preventing rows [...]
November 15, 2011
MLC SSD card lifetime and write amplification
As MLC-based SSD cards are raising popularity, there is also a raising concern how long it can survive. As we [...]
November 13, 2011
Side load may massively impact your MySQL Performance
When we’re looking at benchmarks we typically run some stable workload and we run it in isolation – nothing else [...]
November 6, 2011
Improved InnoDB fast index creation
One of the serious limitations in the fast index creation feature introduced in the InnoDB plugin is that it only [...]
November 4, 2011
Emulating global transaction ID with pt-heartbeat
Global transaction IDs are being considered for a future version of MySQL. A global transaction ID lets you determine a [...]
October 21, 2011
Find where your data is replicated, win a Percona Live ticket
Percona Live London starts on Monday, so this is the last in the series of free-Percona-Live tickets we’ll give away. [...]
October 13, 2011
Benchmarking Galera replication overhead
When I mention Galera replication as in my previous post on this topic, the most popular question is how does [...]
October 7, 2011
Multiple MySQL instances on Fusion-io ioDrive
It is known that MySQL due internal limitations is not able to utilize all CPU and IO resources available on [...]