…:51:16 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible… 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 # Set .._log_file_size to 25 % of buffer pool size innodb_log…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… 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 RECREATE did…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… of my mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per_table directive set in the my.cnf… of the InnoDB tables. Is there something which I am missing? Do I have to set any directive in the my.cnf file to access the InnoDB table? Please help. Thanks in advance. Abhilasj
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 = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer…
Comment: What to tune in MySQL Server after installation
April 15, 2012 By 116 Comments
… tips. BUT: Please add a big warning that just changing “innodb_log_file_size” is not enough (see other comments for… would be important. Otherwise people like me will update their my.cnf and certainly the production site goes down 
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… the maximum InnoDB: allowed value would be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18:47:44 InnoDB: Warning: too… be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf So we can see Innodb may with…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… can have innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status.
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults-file=/etc/my.cnf –export /tmp/ Then apply the logs to get a consistent backup: # innobackupex –defaults-file=/etc/my.cnf –apply-log…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… less understandable with value 0 meaning disabling Innodb internal thread queuing. Another one is innodb_flush_logs_at_trx_commit – initially it…’t mix what do you currently have set in your my.cnf file – For example using values “none”, “disk”, “os” instead of…” ? Using string values would make things much more friendly with my.cnf and “show variables” output being more obvious and self documenting…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…. Q27 If my workload has a hi amount of concurrent writes to about 6 tables, what version of Innodb/MySQL would you….1 which may be even better. Q28: My impression (from an external user of Innodb point of view) is that performance bugs… is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer…
