#####################
配置文件部分如下:
#undo innodb_max_undo_log_size = 1024M innodb_undo_log_truncate = on innodb_undo_logs = 128 innodb_undo_tablespaces = 3 innodb_purge_rseg_truncate_frequency = 128
启动后错误日志如下:
2021-03-30T02:34:11.760364Z mysqld_safe Logging to '/home/work/mysql/log/mysql.err'. 2021-03-30T02:34:11.797080Z mysqld_safe Starting mysqld daemon with databases from /home/work/mysql/data 2021-03-30T10:34:12.038396+08:00 0 [Warning] option 'general_log': boolean value '/home/work/mysql/log/mysql.log' wasn't recognized. Set to OFF. 2021-03-30T10:34:12.038475+08:00 0 [Warning] option 'general_log': boolean value '/home/work/mysql/log/mysql.log' wasn't recognized. Set to OFF. 2021-03-30T10:34:12.038488+08:00 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead. 2021-03-30T10:34:12.038715+08:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-30T10:34:12.038788+08:00 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-03-30T10:34:12.038830+08:00 0 [Note] /home/work/mysql/bin/mysqld (mysqld 5.7.25-28-log) starting as process 330878 ... 2021-03-30T10:34:12.049232+08:00 0 [Warning] option 'innodb-buffer-pool-chunk-size': unsigned value 128 adjusted to 1048576 2021-03-30T10:34:12.049864+08:00 0 [Note] InnoDB: PUNCH HOLE support available 2021-03-30T10:34:12.049886+08:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-03-30T10:34:12.049893+08:00 0 [Note] InnoDB: Uses event mutexes 2021-03-30T10:34:12.049900+08:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-03-30T10:34:12.049912+08:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2021-03-30T10:34:12.049921+08:00 0 [Note] InnoDB: Using Linux native AIO 2021-03-30T10:34:12.056298+08:00 0 [Note] InnoDB: Number of pools: 1 2021-03-30T10:34:12.056460+08:00 0 [Note] InnoDB: Using CPU crc32 instructions 2021-03-30T10:34:12.060447+08:00 0 [Note] InnoDB: Initializing buffer pool, total size = 30G, instances = 8, chunk size = 1M 2021-03-30T10:34:13.727815+08:00 0 [Note] InnoDB: Completed initialization of buffer pool 2021-03-30T10:34:14.264939+08:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-03-30T10:34:14.277604+08:00 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /home/work/hdd1/mysql/data/xb_doublewrite 2021-03-30T10:34:14.277972+08:00 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 4096 MB 2021-03-30T10:34:14.278715+08:00 0 [Note] InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700 3800 3900 4000 2021-03-30T10:34:19.027579+08:00 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 4096 MB 2021-03-30T10:34:19.028433+08:00 0 [Note] InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700 3800 3900 4000 2021-03-30T10:34:23.862138+08:00 0 [Note] InnoDB: Setting log file ./ib_logfile2 size to 4096 MB 2021-03-30T10:34:23.862291+08:00 0 [Note] InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 2600 2700 2800 2900 3000 3100 3200 3300 3400 3500 3600 3700 3800 3900 4000 2021-03-30T10:34:28.628734+08:00 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-03-30T10:34:28.628833+08:00 0 [Warning] InnoDB: New log files created, LSN=208100792182065 2021-03-30T10:34:28.629383+08:00 0 [ERROR] InnoDB: Expected to open 3 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 2021-03-30T10:34:28.629410+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2021-03-30T10:34:29.431332+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error. 2021-03-30T10:34:29.431346+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2021-03-30T10:34:29.431357+08:00 0 [ERROR] Failed to initialize builtin plugins. 2021-03-30T10:34:29.431364+08:00 0 [ERROR] Aborting 2021-03-30T10:34:29.431381+08:00 0 [Note] Binlog end 2021-03-30T10:34:29.431467+08:00 0 [Note] Shutting down plugin 'MyISAM' 2021-03-30T10:34:29.431489+08:00 0 [Note] Shutting down plugin 'CSV' 2021-03-30T10:34:29.432828+08:00 0 [Note] /home/work/mysql/bin/mysqld: Shutdown complete
解决问题:注释掉该参数:
#undo innodb_max_undo_log_size = 1024M innodb_undo_log_truncate = on innodb_undo_logs = 128 # innodb_undo_tablespaces = 3 innodb_purge_rseg_truncate_frequency = 128
####################