… 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…. For example recovery time (smaller innodb_log_file_size than optimal), fast warmup after MySQL Restarts (so you need double buffering and no…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 21, 2008 By 34 Comments
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… purely logical state and appropriate .ibd file may be open or closed. Furthermore besides MySQL table_cache Innodb maintains its own (called…. I used MySQL 5.4.2 for tests which should be as good as it gets in terms of optimizations in this…_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18:47:44 InnoDB: Warning: too many (68) files…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… optimized with them as it could be which makes it better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf …/mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… to help in optimizations or troubleshooting the applications. We ourselves often rely on it when doing commercial MySQL consulting and MySQL AB has… patching file sql/log_event.cc patching file sql/my_time.c patching file sql/mysql_priv.h patching file sql/mysqld.cc patching file sql… specify it in my.cnf file, the remaining part of the configuration will not matter, because the log file won’t be created…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… TB 1 (1-0-0) 2 2-2 64 Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== ==== ======= ====== ======= ============ =========== …following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = …
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/entry/server_defaults_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/refman/5.6/… at high query rates is likely to be optimal until full benchmarking to determine perfect size can …in the server defaults but in the default my.cnf file that we ship. It’s also done by …
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… work with MySQL Performance Optimization and Optimization for other applications the better I understand I…. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is…platforms (OS and Hardware) as well as different file systems as these could all be involved here…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
…optimal way. First, let’s recap what’s the script has to perform (the full script is given below). Kill the MySQL…host in the heartbeat ha.cf configuration file and then, finishes up some missing …address/g’ /etc/mysql/my.cnf sudo service mysql restart sleep 5 /usr/bin/mysql -u root -proot …
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.
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…file cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf…pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent… fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it…
