… 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. It… 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
Comment: Should MySQL update the default innodb_log_file_size?
November 22, 2011 By 37 Comments
… the sample my.cnf files that ship with MySQL. I’m discussing the compiled-in defaults: what happens when you run MySQL with no my.cnf at all, or you have a my.cnf but it has no InnoDB settings at… many servers (dozens?) with 8MB buffer pools and 5MB log files due to this problem.
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…_buffer being set to 4G while combined size of .MYI files is just 1GB. This would be just a waste. If… how much memory Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive workloads especially for large… analyze workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which may be great templates to use. Typically they would…
Comment: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…! If I may add a suggestion: I keep a sample my.cnf file on my website, which contains the parameters I would like to see…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.*EDIT* The….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket…-on-metadata=0 innodb-stats-sample-pages=256 innodb-stats-update-need-lock=0 innodb-status-file innodb-strict-mode innodb-thread…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… you are using “pid” with core files, which you probably should, as getting different samples often help developers to find what is… do couple of changes to enable core files. First you need “core-file” option to my.cnf which will instruct MySQL to dump core… my system (Ubuntu). You might be lucky and it might work in your system. I also enable multiple “versions” of core files…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… table you should set this variable to some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL… on different platforms (OS and Hardware) as well as different file systems as these could all be involved here. Different table…
Comment: What to tune in MySQL Server after installation
March 4, 2007 By 116 Comments
It could be helpful to show example my.cnf files for sample configurations.
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… can log into MySQL (if necessary, put a password into .my.cnf, or in the MYSQLOPTIONS variable). Now you can simply start… start ‘less’ on a sample‘s files so you can look at them. You can analyze the files without sift, but it saves…, and you often really need to drill into a particular sample‘s files and analyze it to see what’s going on…
