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?

Improve this question
0

1 Answer 1

Reset to default
2

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

Improve this answer
3
  • Where do I find those old innodb log files?
    – Aufwind
    Aug 7, 2011 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 8, 2011 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 8, 2011 at 17:31

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .