…’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…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… 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…
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: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…Percona XtraDB Cluster. Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users and the beta release is based on Percona Server 5.5…Bug reports Previous posts on this topic: Percona XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux… is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important…-requests=0 –num-threads=$numthreads –rand-init=on –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io…
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…
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…
