[MY-012961] [InnoDB] Only one log file found

I've been playing around with building MySQL on various cloud providers.

If the VM has less than 2GB of RAM you can come across this error when restarting MySQL...

This happens when you have innodb_dedicated_server = 1 set.

MySQL is meant to create two log files but as there is limited RAM, it creates only 1 - and then it cries the next time it's restarted.

[MY-012961] [InnoDB] Only one log file found

To fix, add this extra line:

innodb_log_files_in_group = 2

Hope this helps!

Want to get in touch? mail@adsar.co.uk