An error was reported when MySQL was restarted, which may be caused by modifying my.CNF:
[ERROR] Plugin ‘InnoDB’ init function returns ERROR.
[ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE fails.
[ERROR] Unknown/unsupported STORAGE ENGINE: InnoDB
CD /var/lib/mysql
cd-rf ib_logfile*
service mysql restart
service>
Unknown/unsupported storage engine: InnoDB
1. Maybe the innodb_buffer_POOL_size setting is too small and there is not enough memory. 2. Check the parameters related to innodb in the configuration file: skip-innodb/skip-bdb/skip-locking
, the three tuning parameters are easy to cause problems. In particular, the first parameter is said to be saved in the province after opening. However, after use, MySQL may fail to restart. The corresponding parameter of
skip-external locking is the same for some old versions: skip-external locking
. In the new version, such parameters as skip-innodb may be removed. If the configuration is improper, the parameters of the old version are used, which may lead to startup failure.
skip-innodb new version has been changed to loose-skip-innodb
skip-bdb new version has been abolished;
skip-external-locking has been changed to skip-locking
skip-external-locking: Skipping external locking, external-locking is used for locking MyISAM tables in multi-process conditions, according to the official MySQL development website. If more than one server is using the same database directory, each server must open external locking.
when external-locking works, each process must wait for the previous process to complete the operation and release the locking if it wants to access the table. Because the server often needs to wait for unlocking when accessing the data table, external locking in the single-server environment can degrade MySQL performance. Therefore, in many sources of Linux distributions, the MySQL configuration file USES skp-external-locking by default to avoid external locking. When skip-innodb is not added, three files such as data/ibdata1,ib_logfile0 and ib_logfile1 are deleted. These three files will be created automatically when MySQL starts.
if you delete these three files, add skip-innodb, startup will not regenerate into these three files. 3. If you reset innodb_log_file_size and so on, you need to delete the ib_logfile in the data directory, and then restart the database, otherwise an error
will be reported
Read More:
- Failed to read auto-increment value from the storage engine in MySQL
- Solution to 1030 got error 28 from storage engine in MySQL
- MySQL error 1030 got error 1 from storage engine
- Thoroughly solve mysql error: 1030,’Got error 28 from storage engine’
- [Solved] express Log Error: Got error 28 from storage engine
- Deploy mongodb fragment combined with replica set to realize distributed storage of MySQL database files (step 10)
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- Doris query task failed to initialize storage reader
- Failed to start Ceph object storage daemon osd.14
- As Error:Failed to find configured root that contains /storage/emulated/0/xxx/xxx/xxx.png
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- MySQL error set: failed to start mysql.service : Unit mysql.service is masked.
- Docker start error: failed to start docker application container engine.
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed
- MySQL uses net start MySQL startup prompt (failed to start, the service did not report any error)
- ansoft:Com Engine non-responsive since
- MySQL installation failed: dpkg: error processing package MySQL server (- – configure): dependency problem
- Off line data storage and upload scheme
- ERROR Docker Engine API on Mac Osx
- [solved] genymotion, “unable to load VirtualBox engine”