What if the calculation above shows that I should have an innodb log file size of 1-2 MB? I’m running Percona server on an ec2 small instance with the XFS filesystem for the mysql data directory.
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… you need the fixes in your kernel, and many of Percona‘s customers are in the same situation. That’s why… 2.6.38, and whenever is the next time our servers reboot, they’ll be on kernel 3.x (depending what…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
April 26, 2012 By 53 Comments
… be situational on the query (at least now on Percona 5.5 server) I have a complex query w. joins on a…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… not allow me to recommend this drive for a database server usage, even in general this drive provides much better throughput…-9. It will be the same as my talk on Percona Live MySQL Conference 2012, if you did not attend my…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
…: 3746 tps Percona Server: 3704 tps And for comparison, average throughput for 4 tables: MySQL: 3882 tps Percona Server: 6735 tps The Percona Server is still… way to improve throughput in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server with innodb_log_file_size…
Post: Announcing Percona Server 5.5.21-25.0
March 19, 2012 By Leave a Comment
… release of Percona Server 5.5.21-25.0 on March 20th, 2012. Downloads are available here 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.0 is now the current stable release in the 5.5 series. All of Percona‘s…
Post: Percona Server 5.5.21-25.1 released!
March 29, 2012 By 8 Comments
… release of Percona Server 5.5.21-25.1 on March 30, 2012 (Downloads are available here 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…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There… application changes required to start work with Percona XtraDB Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
… more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… glad to announce the second beta release towards Percona XtraBackup 2.0! We call this version 1.9.1 … dump. For servers that support dump and restore of the XtraDB buffer pool (LRU), namely Percona Server, this will enable a server restored from… it was only possible to stream full backups. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed…
