… logic against you, you wrote a book to help people optimize their my.cnf settings, yet you were wailing against the available (and…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
March 14, 2012 By 34 Comments
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… 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 only helps a lot when my.cnf has extremely bad parameters. The kind you’ll get from tuning primers and automated my.cnf optimization scripts…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
… regarding my.cnf tuning, only some trolling on how bad “automated scripts” are and how superior the writer is into tuning my.cnf (but… 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… that a very bad my.cnf can bring performance down even if you have correct design, index and optimized queries. Innodb on the…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 21, 2008 By 34 Comments
I think there is a difference between “better than default my.cnf” and “optimal my.cnf” – It is indeed possible to automate things, often by… be better than default my.cnf in 99% cases. However it is not possible to get the most optimal config file automatically. This…. For example recovery time (smaller innodb_log_file_size than optimal), fast warmup after MySQL Restarts (so you need double buffering…
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… is whenever it is better to use hardware upgrade or optimize software more. I already wrote about it, for example here…, Architecture optimized well enough ? Do not advice hardware upgrade as the first thing when you can triple performance by simple my.cnf change… exactly your goal with hardware upgrade ? Same as with software optimizations and changes you do should have a goal. You add…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand I have to … you should set this variable to some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL…
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.
Comment: Percona build7 with latest patches
November 21, 2008 By 26 Comments
Dim, To provide optimal my.cnf we should know your workload and server characteristics. And what is much worse – can you show some numbers ?
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 21, 2008 By 34 Comments
Apachez: “The ultimate tool for generating an optimal my.cnf is not a tool. It’s a human with many …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… than my.cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query optimization…/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…
