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?