Description:we have a Mysql slave,the version is 8.0.25,we set innodb_flush_log_at_trx_commit=2,and sync_binlog=0,one day,the slave is poweroff ,not shutdown normal.when the mysql restart.we find the io_thread error.the slave gtid the same with master.but the data not the same,lo...
[ERROR] InnoDB: Expected to open 4 undo tablespaces but was able to find only 0 undo tablespaces.Set the innodb_undo_tablespaces parameter to the correct value and retry. Suggested value is 0 报错原因: 在初始化数据库的时候没有指定innodb_undo_tablespaces参数 解决方法: 在初始化数据库的时候写上...
[ERROR] InnoDB: Expected to open 4 undo tablespaces but was able to find only 0 undo tablespaces.Set the innodb_undo_tablespaces parameter to the correct value and retry. Suggested value is 0 报错原因: 在初始化数据库的时候没有指定innodb_undo_tablespaces参数 解决方法: 在初始化数据库的时候写上...
InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 110401 11:41:33 InnoDB: Started; log sequence number 0 44384 Configuration error: Error : Could not alloc node id at 10.0.14.32 port 1186:...
project-mysql_1 | 2021-05-19T14:02:10.776159Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. project-mysql_1 | 2021-05-19T14:02:10.776278Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool ...
2018-05-06T09:35:55.013341Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 2948657ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) Whats wrong and how to fix this? PS: I've been referring to these two SO, and am trying nearly all sol...