mysql参数修改 The Auto-extending innodb_system data file ‘./ibdata1‘ is of a different size 768 pages (

梦里梦外; 2024-02-05 23:35 6阅读 0赞

## 参数修改后报错 ##

2024-01-11T16:16:17.189735+08:00 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 32000 pages, max 0 (relevant if non-zero) pages!
    2024-01-11T16:16:17.189781+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
    2024-01-11T16:16:17.790489+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
    2024-01-11T16:16:17.790536+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2024-01-11T16:16:17.790544+08:00 0 [ERROR] Failed to initialize builtin plugins.
    2024-01-11T16:16:17.790552+08:00 0 [ERROR] Aborting
    
    2024-01-11T16:16:17.790600+08:00 0 [Note] Binlog end
    2024-01-11T16:16:17.790701+08:00 0 [Note] Shutting down plugin 'CSV'
    2024-01-11T16:16:17.791374+08:00 0 [Note] /usr/sbin/mysqld: Shutdown complete
    
    2024-01-11T16:16:18.993080+08:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2024-01-11T16:16:18.995186+08:00 0 [Note] /usr/sbin/mysqld (mysqld 5.7.37-log) starting as process 12543 ...
    2024-01-11T16:16:19.022957+08:00 0 [Note] InnoDB: PUNCH HOLE support available
    2024-01-11T16:16:19.023019+08:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2024-01-11T16:16:19.023026+08:00 0 [Note] InnoDB: Uses event mutexes
    2024-01-11T16:16:19.023032+08:00 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2024-01-11T16:16:19.023038+08:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2024-01-11T16:16:19.023043+08:00 0 [Note] InnoDB: Using Linux native AIO
    2024-01-11T16:16:19.023695+08:00 0 [Note] InnoDB: Number of pools: 1
    2024-01-11T16:16:19.023838+08:00 0 [Note] InnoDB: Using CPU crc32 instructions
    2024-01-11T16:16:19.033937+08:00 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 4, chunk size = 128M
    2024-01-11T16:16:19.162957+08:00 0 [Note] InnoDB: Completed initialization of buffer pool
    2024-01-11T16:16:19.186027+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().
    2024-01-11T16:16:19.196254+08:00 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 32000 pages, max 0 (relevant if non-zero) pages!
    2024-01-11T16:16:19.196298+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
    2024-01-11T16:16:19.797034+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
    2024-01-11T16:16:19.797082+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2024-01-11T16:16:19.797090+08:00 0 [ERROR] Failed to initialize builtin plugins.
    2024-01-11T16:16:19.797104+08:00 0 [ERROR] Aborting
    
    2024-01-11T16:16:19.797163+08:00 0 [Note] Binlog end
    2024-01-11T16:16:19.797258+08:00 0 [Note] Shutting down plugin 'CSV'
    2024-01-11T16:16:19.797930+08:00 0 [Note] /usr/sbin/mysqld: Shutdown complete

注释掉修改的

# innodb_data_file_path  = ibdata1:500M:autoextend