MYSQL used by myself uses the MYISAM database and does not involve INNODB. Therefore, we plan not to load the INNODB Engine directly.
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.
