up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
@Mchl, you are right. I did't pay attention. Is there a way to move the question to serverfault? – Aufwind Aug 7 '11 at 23:37
feedback

migrated from stackoverflow.com Aug 8 '11 at 6:28

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

1 Answer

up vote 2 down vote accepted

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

link|improve this answer
Where do I find those old innodb log files? – Aufwind Aug 7 '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 8 '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 8 '11 at 17:31
feedback

Your Answer

 
or
required, but never shown
discard

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