… 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: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
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 116 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…
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 4 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…
Comment: Why MySQL could be slow with large tables ?
August 22, 2010 By 139 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.
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction…_home_dir = /data/mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log… faster but it is surely better for operations. innodb_log_file_size = 1600M – another Benchmark optimization. Such large logs typically will…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… am doing some tuning reading articles like this one (by the way this website is awesome). Well I think my server can… the database latency. To give you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql…_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file_per_table=1 innodb_doublewrite=0…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 21, 2008 By 34 Comments
… think there is a difference between “better than default my.cnf” and “optimal my.cnf” – It is indeed possible to automate things, often by… better than default my.cnf in 99% cases. However it is not possible to get the most optimal config file automatically. This is in particularly so because during tuning there are many questions which human…
