Great article Peter. We’re still on 5.5 but tuned a few variables up with confidence since 5.6 sets… the mistake of copying the directive and using it in my.cnf which caused some trouble with a restart. 
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
March 31, 2013 By 8 Comments
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…you find in standard async MySQL replication. It is my belief that the lack of understanding of this system…to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be:…Node Queue Ops Bytes Flow Conflct time name P cnf # name cmt sta Up Dn Up Dn Up Dn…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… my.cnf files I see only need minor tweaks, which give only so-so performance improvements. Tuning my.cnf only helps a lot when my.cnf has extremely bad parameters. The kind you’ll get from tuning primers and automated my.cnf optimization…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
… hints regarding my.cnf tuning, only some trolling on how bad “automated scripts” are and how superior the writer is into tuning my.cnf (but on… named “The ultimate tool for generating optimal my.cnf files for MySQL” ? 
The meaning of tuning my.cnf is not do to some magic (which… form of autotuning). Not to mention that a very bad my.cnf can bring performance down even if you have correct design…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… serendipitous call (thanks!) yesterday asking what would be needed to tune[1] a database for better performance. It is a question… more than simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see something wrong… configuration alone. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done endlessly, with…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… in some way is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed…. innodb_buffer_pool_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much… session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution contains bunch of sample my.cnf files…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… tickets a query uses, making this parameter notoriously difficult to tune. It is important to note that this variable only comes…_concurrency (which is why these two variables are most often tuned in concert). To continue the example, if innodb_thread_concurrency…=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… default my.cnf files of MySQL like my-large.cnf, my-innodb-heavy-4G.cnf and so on have the thread_concurrency enabled with a tune advice… MySQL tuning howtos that explain how to tune the variable to get better performance. If you have the variable in your my.cnf don’t panic because it does nothing and you’ve only lost some of your valuable time tuning it.
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… attention. I use “tuning” in a generic way here — we focus on far more than my.cnf files. In fact my.cnf files are usually…/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way to… look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically designed to mock and… shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so definite, mathematical…) apply to all types of ratio-based and counter-based tuning techniques. Summary Major points in this article: Counter ratios are…
