1

I read some fine tuning recommendations on the mysqlperfomanceblog and tryed to adapt them.

I added to my.cnf:

innodb_buffer_pool_size        = 1000M
innodb_log_file_size           = 256M

After doing this and restarting the server, I there is no InnoDB entry in the list which the command SHOW ENGINES creates in the mysql shell (terminal). If I do comment out the second variable (innodb_log_file_size) InnoDB is again in the list. What does that mean? I have read that innodb_log_file_size should be 1/4 times of the size of innodb_buffer_pool_size. Do I miss something?

Community
  • 1
Aufwind
  • 113
  • 4

1 Answers1

2

You have to remove the old innodb log files which aren't the right size anymore.

C. Ramseyer
  • 281
  • 1
  • 3
  • Where do I find those old innodb log files? – Aufwind Aug 07 '11 at 23:48
  • 1
    @Aufwind, Usually /var/lib/mysql. Check your my.cnf to see what your datadir is pointing to. Make sure that your server shuts down properly - check your MySQL's [log-]error log. – HTTP500 Aug 08 '11 at 14:15
  • 1
    If you cannot locate the log files, you should run 'updatedb' and then run 'locate ib_logfile0'. This tells you where the log file is located. There will be 2 logfiles : ib_logfile0 and ib_logfile1. – RolandoMySQLDBA Aug 08 '11 at 17:31