… anything you find in standard async MySQL replication. It is my belief that the lack of understanding … An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options…Queue Ops Bytes Flow Conflct time name P cnf # name cmt sta Up Dn Up Dn Up…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… scripts and results are on Benchmark Wiki and the relevant my.cnf settings were innodb_buffer_pool_size=16G innodb_log_file_size… by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve… the tested setting–multiple purge thread implementation at the moment seems to be the one in Percona Server 5.1. MySQL 5…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… an optimal my.cnf is not a tool. It’s a human with many years of experience, deep knowledge of MySQL and the… my.cnf. It is not the be-all and end-all of performance. Tuning your server settings has far less impact on performance than tuning… 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…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… to deliver huge wins. If MySQL is actually badly configured, you …unlikely circumstances, I sometimes see unlikely settings, such as making the sort …at your my.cnf file. It’s sometimes possible to look at the my.cnf …I prefer to avoid the word “tuning,” because database tuning is an activity that can…
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…-dist-type=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…=true’. Q: Can you quickly show the my.cnf settings again? A: Sure, see this post or…on asynchronous replication, galera and built-in mysql replication are independent from each other. Q… recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…use “tuning” in a generic way here — we focus on far more than my.cnf files. In fact my.cnf …var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file…all of which we can frequently help customers set up much more efficiently and with better …
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… the 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… some performance benefits. As we always say, set up benchmark tests to identify which tuning parameters provide the most benefit to your… of MySQL tuning howtos that explain how to tune the variable to get better performance. If you have the variable in your my.cnf don…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… a long time before the MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically… is a shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so definite… InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size setting…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how… which are running with default settings. Even though you can tune quite a lot of variables in MySQL Servers only few of them… session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which…
