Default storage engine (InnoDB) is not available
That’s the big issue I was facing this morning when starting the MySQL service version 5.0.67/Win32. The first step I took is to simply look for a google-looked-up page that deals with this issue, and it was the mysql forums. However, I found the diffrent exposed solutions a lot radical as almost of them tend to a backup-delete-reinstall strategy, and it does not really suit my needs. So the first thing I’ve done is to try starting the mysql service in the console debug mode :
and the output was very explicit about the possible roots of the innoDB issue :
InnoDB: than specified in the .cnf file 0 10485760 bytes!
080913 13:24:24 [ERROR] Default storage engine (InnoDB) is not available
080913 13:24:24 [ERROR] Aborting
080913 13:24:24 [Note] mysqld-nt.exe: Shutdown complete
So basically, the MySQL service is complaining about a mismatch between the effective innoDB log file size on the disk (24MB), and the defined size (10MB) within the my.ini file. So changing the my.ini property would help solving the issue :
A little attenion should be paid to another property in my.ini file which is innodb_buffer_pool_size as its value is impacted by the innodb_log_file_size setting. After this simple setting, the service was correctly started. No data/log backup, deletion required, nor service reinstallation. Nevertheless, I still not understand the real issue behind this file size mismatch…