… come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used… mutexes. Another important configuration that I am using is that I am using “estimate” flushing method available only on Percona Server. The “estimate…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
Hi, I use percona server 5.5.20, I would be testing xtradb cluster with … the release, and noticed the configuration, but i did not understand where did all of the configuration go for example default_storage… paid support from percona, but at-least you can answer this one or provide a link to sample configuration. Your tool do…
Comment: mysql-proxy, urgh performance and scalability ?
May 13, 2012 By 27 Comments
… for production server. was wondering if you can help in installation and configuration, tutorials or anything, as i tried installing with percona server and…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference… number of fault-tolerant configurations (active/passive, active/active, N+1, etc.) It also provides messaging between servers within the same cluster…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb_buffer… see these tables going away if you close connection. In Percona Server you can do better as you can query temporary tables… Modified db pages 23419 I’m using the information from Percona Server again which provides a lot more insight about how memory…
Post: Testing Percona XtraDB Cluster with Vagrant
April 12, 2012 By 1 Comment
…to deploy. It contains the puppet recipes to install and configure a cluster of 3 nodes and a load balancer (glb…necessary files on my github repository: https://github.com/lefred/percona-cluster This is a step-by-step “terminalcast”: I …of XtraDB Cluster will help you testing this great MySQL server.
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
…Tuned flushing algorithm Disable flushing of neighbor pages and the configuration to provide better experience on SSD is : innodb_flush_neighbor… 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…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… and has the advantage of persisting across machine restarts. The configuration variables for my.cnf have been kept for compatibility and… the option ignore-builtin-innodb is incompatible with Percona Server with XtraDB, the server will not start and print the corresponding error instead…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… and 144GB buffer pools), as it is seems in this configuration this setting provides the best throughput innodb_io_capacity=20000… – 23,513 NOTPM, Percona Server – 30,436 NOTPM, advantage: 1.29x 52GB: MySQL 5.5.8 – 71,774 NOTPM, Percona Server – 88,792 NOTPM, advantage: 1.23x 144GB: MySQL 5.5.8 – 78,091 NOTPM, Percona Server – 109,631 NOTPM…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… are available here and from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona Server 5.5.13-20.4 is now the current stable release in the 5.5 series. All of Percona’s… has the advantage of also persisting across machine restarts. The configuration variables for my.cnf have been kept for compatibility and…
