… on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log flushing, which can cause downward spikes in performance. Other… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and… important things to consider when you are concerned with write performance is using partitioning to reduce the size of the B…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
…. In this post I show the results of raw IO performance of this card. The benchmark methodology I described in previous… Fusion-io cards they use are highly underutilized. With the performance variance we see it is a good question how does…-9. It will be the same as my talk on Percona Live MySQL Conference 2012, if you did not attend my…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
April 26, 2012 By 53 Comments
… to be situational on the query (at least now on Percona 5.5 server) I have a complex query w. joins…) .90 for the data with SQL_CALC_FOUND_ROWS. No performance impact when using SQL_CALC_FOUND_ROWS 2) .013 for…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… has changed. New since 1.6: Percona XtraBackup can now save Galera replication information while performing a backup when given the –galera… restore a single table). Percona XtraBackup now supports streaming incremental backups. In previous versions streaming backups were performed by the innobackupex script…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… to announce the GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for… tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking. Client applications can continue reading… show how to use it to forecast scalability and performance The new Percona Toolkit release is available for download today. It is…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… buffer pool (LRU), namely Percona Server, this will enable a server restored from backup to give excellent performance without a lengthy “warm… possible to stream full backups. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the…
Post: Percona Announces New Relic Partnership
April 10, 2012 By 2 Comments
…. I even wrote it in the new edition of High Performance MySQL. Why? Simple. People who use New Relic are more… best solution for them, even if that means NOT using Percona, I do that. I am, personally, very happy that we… company lightly. But New Relic is an ideal fit for Percona and our customers.
Post: Free ticket to MySQL User Conference on SF Meetup with talk "Percona XtraDB Cluster"
March 16, 2012 By Leave a Comment
Just a reminder that I will be giving a talk “Percona XtraDB Cluster” on coming San Francisco MySQL Meetup, next Wednesday… + sessions + expo hall) to Percona Live MySQL User Conference 2012 and three copies our new book “High Performance MySQL, 3rd edition”. Well…
Post: Congratulations to Percona Live Ticket Winners!
March 29, 2012 By 2 Comments
… want to congratulate our three first-prize winners to the Percona Live MySQL Conference and Expo: David Juntgen Jeff Hansen Domenick…! Our ten second-prize winners receive a copy of High Performance MySQL Third Edition, and I’m still in progress with…
Post: BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
March 22, 2012 By Leave a Comment
The Percona Live MySQL Conference & Expo is going to be awesome! Great … Fires One of five copies of the new book High Performance MySQL, 3rd Edition Don’t miss this special offer – register…
