Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
July 28, 2011
How Innodb Contention may manifest itself
Even though multiple fixes have been implemented in Percona Server and MySQL 5.5, there are still workloads in which case [...]
July 27, 2011
What’s required to tune MySQL?
I got a serendipitous call (thanks!) yesterday asking what would be needed to tune[1] a database for better performance. It [...]
April 27, 2011
The four fundamental performance metrics
There are many ways to slice and aggregate metrics of activity on a system such as MySQL. In the best [...]
April 25, 2011
Performance Schema overhead
As continuation of my CPU benchmarks it is interesting to see what is scalability limitation in MySQL 5.6.2, and I [...]
April 25, 2011
MySQL at Facebook, present and future
Harrison Fisk, from the Facebook database team, will be in New York City delivering the closing keynote at Percona Live [...]
April 21, 2011
InnoDB page sizes: plans and ideas
It is well known fact that InnoDB standard page size is 16K or 16384 bytes. Sometime ago we added feature [...]
April 21, 2011
Reality of Innodb Caching
I have mentioned few times Innodb caches data in pages and even if you have working set consisting of relatively [...]
April 20, 2011
Drop table performance
There have been recent discussions about DROP TABLE performance in InnoDB. (You can refer to Peter’s post https://www.percona.com/blog/2011/02/03/performance-problem-with-innodb-and-drop-table/ and these [...]