… 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…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
April 26, 2012 By 53 Comments
… 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: 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…_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…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… synchronous IO varying amount of threads and with measurements every 1 sec to see how bad are drops. So there is… 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1…-9. It will be the same as my talk on Percona Live MySQL Conference 2012, if you did not attend my…
Post: Percona XtraBackup 1.9.2 released (Beta)
March 29, 2012 By 2 Comments
Percona is glad to announce the release of Percona XtraBackup 1.9.2 on 28th March 2012. Downloads are available from … release, you should use the current Stable version – currently 1.6.5 in the 1.6 series at the time of writing. The… Available final release. If you wish to run pre-release Percona software, you can use our experimental software repositories or download…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… these features are also available either in Percona Server or in the upcoming MySQL 5.6 in the same or slightly different… Percona‘s PAM plugin. MariaDB 5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5… MariaDB IRC channel: There are strong forces to ensure 5.5 GA before percona live in Santa Clare This is great news indeed…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
Percona is glad to announce the 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…
Post: Percona Server 5.5.21-25.1 released!
March 29, 2012 By 8 Comments
… 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… 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: 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… 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…
