…: when you configure MySQL, what portion of it resides on the Fusion-IO card? Do you just have your datadir on there… going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
… use percona server 5.5.20, I would be testing xtradb cluster with three nodes. I went through your documentation provided with the release, and noticed the configuration, but i did not understand where did all of the configuration go… can answer this one or provide a link to sample configuration. Your tool do not provide config for xtradb cluster. thanks.. karim…
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: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
… with Virident webinar: “How to Turbocharge Your MySQL Performance Using Flash Storage” (From Virident…and on the webinar we will cover: Configuration and optimization techniques to fully leverage … for scaling MySQL instances on fewer servers while delivering optimal performance using flash …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… problem usually starts like this – you have configured MySQL to use reasonable global buffers, such…will result in increased memory allocation until server is restarted. I would suspect memory leak…create isolated repeatable test cases based on your application, which can illustrate memory leak and…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
March 14, 2012 By 34 Comments
… is reading your book different. These tools may not be able able to help out in certain situations because servers and the programs they run are never exactly the same. YET, your book without a doubt…, but your book is not a living breathing DBA, and information that it provides can NOT be every existing configuration. If your book…
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… the setup and some basic commands to check and manage your 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… it, these are the prerequisites you need to have on your system: VirtualBox Vagrant A CentOS Vagrant base box (you don… of XtraDB Cluster will help you testing this great MySQL server.
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…/jAppServer2004/ In that benchmark you could actually vary JDBC pool configuration (and hence number of threads on DB server side) to your liking.
