Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Aug 8 '11 at 6:28

This question came from our site for professional and enthusiast programmers.

up vote 2 down vote accepted

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

share|improve this answer
Where do I find those old innodb log files? – Aufwind Aug 7 '11 at 23:48
@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 8 '11 at 14:15
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 8 '11 at 17:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.