Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
October 6, 2011
When Do InnoDB Table Statistics Update?
InnoDB table statistics are used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. [...]
October 3, 2011
Percona Server 5.5.15 + Galera 21.1-beta2
Codership team published beta2 of MySQL 5.5.15 with Galera replication https://launchpad.net/codership-mysql and we made port to Percona Server: source code: [...]
September 2, 2011
Understand InnoDB spin waits, win a Percona Live ticket
It’s Friday again (so soon!) and time for our TGIF contest, to give away a free ticket to Percona Live [...]
August 27, 2011
Recovering Linux software RAID, RAID5 Array
Dealing with MySQL you might need to deal with RAID recovery every so often. Sometimes because of client lacking the [...]
August 26, 2011
Getting MySQL Core file on Linux
Core file can be quite helpful to troubleshoot MySQL Crashes yet it is not always easy to get, especially with [...]
August 26, 2011
Return of the Query Cache, win a Percona Live ticket
It’s Friday again, and time for another TGIF give-away of a Percona Live London ticket! But first, what’s new with [...]
August 24, 2011
Make your file system error resilient
One of the typical problems I see setting up ext2/3/4 file system is sticking to defaults when it comes to [...]
July 29, 2011
Reasons for MySQL Replication Lag
One common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along [...]