InnoDB“表已满".错误 [英] InnoDB "The Table is Full" error

问题描述

我在RedHat Enterprise Linux 4服务器上有一个MySQL InnoDB表，并且尝试导入以前使用mysqldump备份的数据库后，出现表已满"错误.

I have a MySQL InnoDB table on a RedHat Enterprise Linux 4 server, and after trying to import a database previously backed up using mysqldump I got a "the table is full" error.

该表当前具有463,062行，并且磁盘上的ibdata1文件当前为3.37Gb.快速的"SHOW VARIABLES;"显示innodb_data_file_path设置为ibdata1:10M:autoextend，文件系统为ext3，所以我希望它还有很大的增长空间.

The table currently has 463,062 rows in it, and the ibdata1 file on disk is currently 3.37Gb. A quick "SHOW VARIABLES;" shows that the innodb_data_file_path is set to ibdata1:10M:autoextend, and the filesystem is ext3, so I'd expect it to have plenty of room left to grow.

有什么想法可以确定问题到底是什么吗?

Any ideas how I can go about establishing exactly what the problem is?

推荐答案

检查存储InnoDB数据文件的磁盘是否已满

Check that the disk the InnoDB data file is stored on isn't full

这篇关于InnoDB“表已满".错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！