… quite a few “tuning primers” and “my.cnf generators” and “sample my.cnf files” online. The ultimate tool for generating an optimal my.cnf is not a tool…. Most 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…
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. Usually, though… 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… how much memory Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive workloads especially for large… session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which…
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 one of…/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way to find… that might be caused by a syntax error in the my.cnf file. For an example, take a look at this bug report…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… their my.cnf file by default. One example is Debian and its variants. Furthermore 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…
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… post 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: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…_concurrency (which is why these two variables are most often tuned in concert). To continue the example, if innodb_thread_concurrency…/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1… innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb_thread_concurrency=16 innodb_flush…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… showed that sometimes it may be very important variable to tune properly. I meant to write about it earlier but never… size of binary log file from default 1GB (some systems have it set to 100MB in their default my.cnf) down to 50MB and we never saw this problem ever again. Now the files were removed much…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… qc on. QC off tends to be best for well tuned OLTP and web sites using queries that mostly return a… we expect most tables to be InnoDB and use innodb_file_per_table. sql_mode also uses STRICT_TRANS_TABLES by… do it in the server defaults but in the default my.cnf file that we ship. It’s also done by the Windows…
Comment: Why MySQL could be slow with large tables ?
August 22, 2010 By 141 Comments
Eddie, this depends on 1. Your MY.CONF settings http://www.notesbit.com/index.php/web-mysql/mysql/mysql-tuning-optimizing-my-cnf-file/ 2. The type of table it is — is it MYISAM or INNODB? For InnoDB, you may also fix the INNODB specific settings.
