备忘:MySQL InnoDB Error "the table is full"

最新推荐文章于 2022-03-09 16:27:12 发布

zuroc

最新推荐文章于 2022-03-09 16:27:12 发布

阅读量230

点赞数

分类专栏：网络文章标签： MySQL Blog HTML

网络专栏收录该内容

75 篇文章

订阅专栏

本文介绍了解决MySQL InnoDB出现表已满错误的方法。首先检查my.cnf配置文件中的innodb_data_file_path设置，并增大最大文件大小限制。如需调整innodb_log_file_size，需先干净关闭MySQL服务，删除旧的日志文件，更新配置并重启服务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[size=large]
http://blog.imminentweb.com/technologies/mysql-innodb-error-table-full
----------

http://dev.mysql.com/doc/refman/5.0/en/full-table.html explains some common causes for the error "the table is full" and tells how to fix it.

If you are using MySQL InnoDB, and the file limit isn't reaching the maximum file size limit by the operation system, then check your my.cnf config file, and look for a line like

innodb_data_file_path = ibdata1:10M:autoextend:max:128M

Increase the "max:128M" to something bigger, such as "max:526M".

If you want to increase the innodb_log_file_size, do this:

1. shut down mysqld cleanly
2. remove ib_logfile* files in your mysql data directory, which is possibly /var/lib/mysql

我的路径是
vi /etc/mysql/my.cnf
改为
innodb_data_file_path = ibdata1:10M:autoextend

3. restart mysqld again and check all tables are fine.

[/size]