… off with the configuration details. Configuration First of all let me describe the EC2 instance type that I used. EC2 Configuration I chose… to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used…. 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… can answer this one or provide a link to sample configuration. Your tool do not provide config for xtradb cluster. thanks…
Comment: mysql-proxy, urgh performance and scalability ?
May 13, 2012 By 27 Comments
… production server. was wondering if you can help in installation and configuration, tutorials or anything, as i tried installing with percona server and…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… the benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO… going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my.cnf… with the size i specified. I wonder how many other configuration values have been ignored. Thanks for your help Baron.
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… it can increase amount of resources prepared statements take on server. There is no comparable variables of how many user variables… memory allocation and will result in increased memory allocation until server is restarted. I would suspect memory leak when you see…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… allows any number of servers to be part of the cluster using any number of fault-tolerant configurations (active/passive, active/active, N+1, etc.) It also provides messaging between servers within the same cluster…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
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… of XtraDB Cluster will help you testing this great MySQL server.
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… in an environment with a large three digit number of servers, and in which we clone new slaves from existing slaves… a crashed innodb, recovers this, and then it is being configured to become a new slave to the same master as…
