… the IO configuration I chose 8 x 200G EBS volumes in software RAID 10. Now let’s 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: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… up with the current my.cnf file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium… originally posted, the log files were created with the size i specified. I wonder how many other configuration values have been ignored…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…troubleshooting tasks with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use … + 2382090360) Page hash 127499384 Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: High Availability Deep Dive tutorial at PLMCE
April 6, 2012 By Leave a Comment
…we walk you through several deployment scenarios for Pacemaker MySQL high availability. We’re coming with pre-installed virtual…): http://ubuntuone.com/01mJtfGDc2QbxB9eaOqcWc Libvirt and VMware images and configuration files (bzipped tarball): http://ubuntuone.com/3nikxumH483slq8rfP73iZ If one of…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per_table directive set in the my.cnf configuration file. I have the backup folder which contains xtrabackup log files, xtrabackup checkpoint file…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM… cluster using any number of fault-tolerant configurations (active/passive, active/active, N+1, etc.) …url of the git repository including the Vagrant file and the puppet recipes is https://github…
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 (…already have one) Then you can find all the necessary files on my github repository: https://github.com/lefred/percona-…howto of XtraDB Cluster will help you testing this great MySQL server.
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
We’ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If … things like sharing configuration files and emailing them to yourself. The new release also adds features like downloading the configuration files so you don’t have to copy-paste them. If you share a configuration file, then the URL…
Post: Online MySQL Configuration Wizard from Percona
December 23, 2011 By 23 Comments
… you configure and manage your MySQL servers. Our online MySQL Configuration Wizard can help you generate a good basic configuration file for a server. This MySQL tuning wizard is our answer to the commonly asked question, “what is a good default configuration file…
