… here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62-13.3 is now the current stable release in the 5.1 series. All of Percona‘s software is…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that…_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx… that I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
April 26, 2012 By 53 Comments
… on Percona 5.5 server) I have a complex query w. joins on a table with 10+ million rows. Results are Data & Count Query = 1.8 seconds 1) .90 for the data 2) .90 for the count Data & FOUND_ROWS = .913 1) .90 for the data with SQL_CALC_FOUND_ROWS. No…
Post: Percona Server 5.5.21-25.1 released!
March 29, 2012 By 8 Comments
… and from the Percona Software Repositories). Based on MySQL 5.5.21, including all the bug fixes in it, Percona Server 5.5.21-25.1 is now the current stable release in the 5.5 series. All of Percona‘s software is…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… product Percona XtraDB Cluster. Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL Users and is based on Percona Server 5.5.20… XtraDB Cluster in 3 minutes Benchmarking Galera replication overhead Percona Server 5.5.15 + Galera 21.1-beta2 State of the art: Galera – synchronous replication…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… of these features are also available either in Percona Server or in the upcoming MySQL 5.6 in the same or slightly different… subtlety to this list. For example, Percona Server has the same group commit fix, and MySQL 5.6 offers microsecond timestamp support, as… exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5, so it will inherit…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… allocated but it is a lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc… see these tables going away if you close connection. In Percona Server you can do better as you can query temporary tables… Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db pages 23419 I’m using the information from Percona Server again…
Comment: Copying InnoDB tables between servers
March 8, 2012 By 10 Comments
… been renamed in 5.5.10 as per: http://www.percona.com/doc/percona-server/5.5/release-notes/Percona-Server-5.5.10-20.1.html#5.5.10-20.1 “Old system variable…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… second beta release towards Percona XtraBackup 2.0! We call this version 1.9.1 as we are using the 1.9.x version… production use, check out our latest stable release (which was 1.6.5 at the time of writing). This beta adds some… dump. For servers that support dump and restore of the XtraDB buffer pool (LRU), namely Percona Server, this will enable a server restored from…
Comment: Percona Server vs MySQL on Intel 320 SSD
March 21, 2012 By 21 Comments
Patrick, There are two factors: 1. Speed of recovery is much better in MySQL/Percona Server 5.5 2. Having on SSD makes it also much faster. So having big log files is practical under these conditions. It still may be long, but that that painful as in old InnoDB.
