InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages (rou

最新推荐文章于 2024-05-20 20:25:47 发布
原创 最新推荐文章于 2024-05-20 20:25:47 发布 · 507 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文档详细记录了在启动MySQL时遇到的InnoDB数据文件大小配置错误，描述了错误信息并提供了具体的解决方案，包括修改my.cnf配置文件、重启服务和调整文件权限。

2016-09-14T09:17:37.713955Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2016-09-14T09:17:37.724151Z 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!

2016-09-14T09:17:37.724165Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2016-09-14T09:17:38.347878Z 0 [ERROR] Plugin 'InnoDB' init function returned error.

2016-09-14T09:17:38.347902Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2016-09-14T09:17:38.347906Z 0 [ERROR] Failed to initialize plugins.

2016-09-14T09:17:38.347913Z 0 [ERROR] Aborting

To solve this problem add the below given line in /etc/my.cnf file inside [mysqld] block.

innodb_data_file_path = ibdata1:10M:autoextend

service mysqld restart

restorecon -R /var/lib/mysql/

 

chmod -R 777 /var/lib/mysql
 

mysql参数修改 The Auto-extending innodb_system data file ‘./ibdata1‘ is of a different size 768 pages (
不积跬步，无以至千里；不积小流，无以成江海。
01-11 1046
【代码】mysql参数修改 The Auto-extending innodb_system data file './ibdata1' is of a different size 768 pages (
MySQL修改innodb_data_file_path参数的一些注意事项
IChen.的博客
08-06 4291
简介 innodb_data_file_path用来指定innodb tablespace文件，如果我们不在My.cnf文件中指定innodb_data_home_dir和innodb_data_file_path那么默认会在datadir目录下创建ibdata1 作为innodb tablespace。 说明 在测试环境下没有设置过多的详细参数就初始化并启动了服务，后期优化的过程中发现innodb_data_file_path设置过小： root@node1 14:59: [(none)]> sho
InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages (rou...
weixin_33894640的博客
09-14 455
2016-09-14T09:17:37.713955Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-09-14T09:17:37.724151Z 0 ...
InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages
热门推荐
云原生devsecops
05-10 1万+
different size 640 pages
The Auto-extending innodb_system data file './ibdata1' is of a different size 6400 pages (rounded do
Jerry_Pan1990的博客
11-01 5093
Mark一个解决的问题： ibadat1 是 共享表空间文件，在使用数据库时，会自动增大 包含： Data dictionary   Double write buffer  Insert buffer Rollback segments UNDO space Foreign key constraint system tables （前几个东东和innodb引擎写数据、回滚等...
[ERROR] [MY-012263] [InnoDB] The Auto-extending innodb_system data file './ibdata1' is of a differen...
epmgy315的博客
05-08 679
实际my.cnf发现里面的innodb_data_file_path = ibdata1:1G:autoextend 设置得太大，我这机器容量小，所以调到12M ， innodb_data_file_path = ibdata1:12M:autoextend
root@ecm-e00f:/# sudo journalctl -u mariadb -xe # 检查启动错误 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Initializing buffer pool, total> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Initialized memory pressure eve> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Completed initialization of buf> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: File system buffers for log dis> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: End of log at LSN=46996 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: 128 rollback segments are activ> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Setting file './ibtmp1' size to> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: log sequence number 46996; tran> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Loading buffer pool(s) from /yu> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Plugin 'FEEDBACK' is disabled. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Server socket created on IP: '0.0.0.0'. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Server socket created on IP: '::'. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Buffer pool(s) load completed a> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] /usr/sbin/mariadbd: ready for connectio> Jun 25 16:43:09 ecm-e00f mariadbd[336798]: Version: '10.11.11-MariaDB-0+deb12u1' socket: '/run/mysqld/mysqld.s> Jun 25 16:43:09 ecm-e00f systemd[1]: Started mariadb.service - MariaDB 10.11.11 database server. ░░ Subject: A start job for unit mariadb.service has finished successfully ░░ Defined-By: systemd ░░ Support: https://www.debian.org/support ░░ ░░ A start job for unit mariadb.service has finished successfully. ░░ ░░ The job identifier is 57427. Jun 25 16:43:09 ecm-e00f /etc/mysql/debian-start[336825]: Checking for insecure root accounts. Jun 25 16:43:09 ecm-e00f /etc/mysql/debian-start[336829]: Triggering myisam-recover for all MyISAM tables and a> lines 960-985/985 (END) Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Initialized memory pressure event listener Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Completed initialization of buffer pool Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: End of log at LSN=46996 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: 128 rollback segments are active. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: log sequence number 46996; transaction id 14 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Loading buffer pool(s) from /yunxiang/data/mysql/ib_buffer_pool Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Plugin 'FEEDBACK' is disabled. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Server socket created on IP: '0.0.0.0'. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] Server socket created on IP: '::'. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] InnoDB: Buffer pool(s) load completed at 250625 16:43:09 Jun 25 16:43:09 ecm-e00f mariadbd[336798]: 2025-06-25 16:43:09 0 [Note] /usr/sbin/mariadbd: ready for connections. Jun 25 16:43:09 ecm-e00f mariadbd[336798]: Version: '10.11.11-MariaDB-0+deb12u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 12 Jun 25 16:43:09 ecm-e00f systemd[1]: Started mariadb.service - MariaDB 10.11.11 database server. ░░ Subject: A start job for unit mariadb.service has finished successfully ░░ Defined-By: systemd ░░ Support: https://www.debian.org/support ░░ ░░ A start job for unit mariadb.service has finished successfully. ░░ ░░ The job identifier is 57427. Jun 25 16:43:09 ecm-e00f /etc/mysql/debian-start[336825]: Checking for insecure root accounts. Jun 25 16:43:09 ecm-e00f /etc/mysql/debian-start[336829]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables ~
06-26
[ERROR] InnoDB: auto-extending data file ./ibdata1 is full → 表空间不足（扩展 ibdata1） [Note] InnoDB: The first data file is filled to high watermark → 需重建表空间： `ALTER TABLE ... ENGINE...
【MySQL精通之路】InnoDB(6)-磁盘结构(3)-表空间
Anakki的博客
05-20 1473
系统表空间是更改缓冲区的存储区域。如果表是在系统表空间中创建的，而不是按文件表或通用表空间创建的，那么它也可能包含表和索引数据。在以前的MySQL版本中，系统表空间包含InnoDB数据字典。在MySQL 8.0中，InnoDB将元数据存储在MySQL数据字典中。请参阅第16章MySQL数据字典。在以前的MySQL版本中，系统表空间也包含双写缓冲区存储区域。从MySQL 8.0.20开始，此存储区域位于单独的双写文件中。参见第17.6.4节“双写缓冲区”。系统表空间可以有一个或多个数据文件。
[root@sibas-dev-02 bin]# service mysqld start Starting MySQL.Logging to '/usr/local/mysql-8.1.0/data/sibas-dev-02.err'. ... ERROR! The server quit without updating PID file (/usr/local/mysql-8.1.0/data/sibas-dev-02.pid).
最新发布
08-28
[ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable ``` 则说明权限问题，需要更改数据目录权限。 **如果错误日志没有提供足够信息，可以尝试以调试模式启动**： ```bash /usr/local/mysql-...
InnoDB: The Auto-extending innodb_system data file ‘./ibdata1‘ is of a different size 0 pages (round
X_yufei的博客
09-08 1112
处理方式是将mysql的datadir目录下的ibdata1、ib_logfile0、ib_logfile1 删除，再次启动即可。但是可能会影响到数据的完整性！
mariadb启动报错：[ERROR] InnoDB: The Auto-extending innodb_system data file。。。
CN_TangZheng的博客
12-16 2865
报错内容：[ERROR] InnoDB: The Auto-extending innodb_system data file ‘/data/mysql-33061/data/ibdata1’ is of a different size 768 pages than specified in the .cnf file: initial 131072 pages, max 0 (relevant if non-zero) pages! 问题分析：之前启动的mysql存在旧的文件，导致冲突 问题解决：删除
mysql 8.0 + The Auto-extending innodb_system data file ‘./ibdata1‘ is of a different size 768 pages
ycsdn10的博客
12-15 3501
一、安装8.0.13过程 linux 下载 安装 mysql 8.0+ (tar.xz)_ycsdn10的博客-优快云博客 二、主从配置产生问题 mysql 8.0.13在进行主从配置的时候，发现没有my.cnf,从网上找了创建了文件 /etc/my.cnf，然后发现启动报错 在对应data下有一个xxx.err文件，cat xxx.err 打开后可以看到报错日志 内容是： 2021-12-15T23:21:54.621332+08...
InnoDB: auto-extending data file ./ibdata1 is of a different size 0 pages (rounded down to MB) than
Jack.Zhai的博客
05-18 3362
报错详情 [mysql@infoplat5-zww:~]$/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data Installing MySQL system tables...2018-05-18 10:56:18 0 [...
[ERROR] InnoDB: ibdata1 different size (rounded down to MB)
cuangu9341的博客
08-31 246
启动mysql实例报错，查看 error log ## 错误信息 2018-08-31T10:38:36.945081Z 0 [ERROR] InnoDB: The Auto-extending innodb...
InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) tha...
weixin_30877181的博客
02-22 562
问题描述： 　　centos 安装MySQL 　　$yum install mysql-server　　安装之后执行命令mysql 　　报错： 　　查看mysql的启动日志： [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to M...
Mysql启动失败 InnoDB: auto-extending data file ./ibdata1 is of a different size 640
fockrock的博客
09-15 1202
centos6.5安装完mysql，输入mysql，提示： 重启mysqld： **查看日志文件：*more /var/log/mysqld.log，显示InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero
The innodb_system data file 'ibdata1' must be writable
与望
07-31 1万+
武器大师说过：最强的武器是补丁~ 那么在版本也是一个道理，很多以前可以的，可能更新后不能使用。 在mysql错误日志里出现：The innodb_system data file ‘ibdata1’ must be writable 字面意思：’ibdata1必须可写 那么解决方案自然是更改对应权限 通过yum安装的话， 5.7版本以前是 chmod -R 777 /usr/loca...
The innodb_system data file ‘/data/ibdata1‘ is of a different size 1755776 pages
05-23
这个错误通常发生在在一个 InnoDB 存储引擎的 MySQL 数据库中。它意味着在您的 MySQL 实例中，InnoDB 存储引擎正在尝试使用一个大小与实际不同的 ibdata1 文件。 解决此问题的方法是执行以下步骤： 1. 首先停止 MySQL 服务。您可以使用以下命令停止 MySQL 服务： ``` sudo systemctl stop mysql ``` 2. 然后备份您的当前 ibdata1 文件。您可以使用以下命令备份文件： ``` sudo cp /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak ``` 3. 删除当前 ibdata1 文件。您可以使用以下命令删除文件： ``` sudo rm /var/lib/mysql/ibdata1 ``` 4. 接下来，使用以下命令启动 MySQL 服务： ``` sudo systemctl start mysql ``` 5. 最后，您可以使用以下命令检查 MySQL 日志以查看是否有错误： ``` sudo tail -f /var/log/mysql/error.log ``` 执行完以上步骤后，您的 MySQL 实例应该能够正常启动，并且不再出现与 ibdata1 文件大小不匹配的问题。
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值