MySQL used by myself uses the MyISAM database and does not involve InnoDB. Therefore, we plan not to load the InnoDB Engine directly.
Add skip-InnoDB to my. ini (/etc/My. CnF in Linux.
After I set it like this, there is no problem in Linux. I started MySql in WINXP on my local machine today, prompting that the MySQL cannot be started. Check the error log of the MySQL directory:
Reference
090613 10:15:27 [Error] default storage engine (InnoDB) is not available
090613 10:15:27 [Error] aborting
090613 10:15:27 [note] C:/www/MySQL/bin/mysqld-NT: shutdown complete
It is estimated that after the parameter is added last time, it never starts up... MySQL of the local machine has not been used for a long time.
Check, my. in INI, the default-storage-engine = InnoDB engine is set to InnoDB, and skip-InnoDB is added to it.
Change default-storage-engine to MyISAM, and MySQL starts OK!
You can delete the ibdata1, ib_logfile0, and ib_logfile1 files in the data directory under skip-InnoDB.
After the test, when Skip-InnoDB is not added, the three files are deleted and the three files are automatically created at startup. The log is as follows:
Reference
InnoDB: The first specified data file./ibdata1 did not exist:
InnoDB: a new database to be created!
090613 10:19:37 InnoDB: setting file./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: Wait...
090613 10:19:37 InnoDB: Log File./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file./ib_logfile0 size to 24 MB
InnoDB: Database physically writes the file full: Wait...
090613 10:19:38 InnoDB: Log File./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file./ib_logfile1 size to 24 MB
InnoDB: Database physically writes the file full: Wait...
InnoDB: doublewrite buffer not found: creating new
InnoDB: doublewrite buffer created
InnoDB: creating foreign key constraint system tables
InnoDB: foreign key constraint system tables created
090613 10:19:39 InnoDB: started; log sequence number 0 0
090613 10:19:39 [note] C:/www/MySQL/bin/mysqld-NT: Ready for connections.
Delete these three files, add skip-InnoDB, and then start the log:
Reference
090613 10:30:12 [note] C:/www/MySQL/bin/mysqld-NT: normal Shutdown
090613 10:30:12 [note] C:/www/MySQL/bin/mysqld-NT: shutdown complete
090613 10:30:17 [note] C:/www/MySQL/bin/mysqld-NT: Ready for connections.
Version: '5. 0.45 'socket: ''' port: 3306 Source Distribution
The three files will not be generated automatically.