… other than /etc/my.cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… the current my.cnf file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my.cnf After…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…) This works on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my… 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
It may not even be using that my.cnf file. Or you may have the options in the wrong section of the file.
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… my mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per_table directive set in the my.cnf configuration file. I have the backup folder which contains xtrabackup log files, xtrabackup checkpoint file and a folder for my… missing? Do I have to set any directive in the my.cnf file to access the InnoDB table? Please help. Thanks in…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… param for InnoDB are [root@ng-lg-mdb1 ~]# cat /etc/my.cnf|grep innodb innodb_data_home_dir = innodb_data_file_path… approx 3 million records is taking too long and all my transactions are locked. select count(1),field1 from Table where…
Comment: What to tune in MySQL Server after installation
April 15, 2012 By 116 Comments
… would be important. Otherwise people like me will update their my.cnf and certainly the production site goes down 
Comment: High Rate insertion with MySQL and Innodb
March 29, 2012 By 16 Comments
Change it in my.cnf and restart
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
March 14, 2012 By 34 Comments
… you, you wrote a book to help people optimize their my.cnf settings, yet you were wailing against the available (and reasonably…
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… 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 extremely bad parameters. The kind you’ll get from tuning primers and automated my.cnf optimization…
