1114(HY000):桌子已满 [英] 1114 (HY000): The table is full
问题描述
我试图通过简单的查询将行添加到InnoDB
表中:
INSERT INTO zip_codes (zip_code, city) VALUES ('90210', 'Beverly Hills');
但是当我尝试此查询时,我得到以下信息:
错误1114(HY000):表
zip_codes
已满
做
SELECT COUNT(*) FROM zip_codes
给了我188,959行,考虑到我在同一数据库中有另一个具有810,635行的表,这似乎不算太多.
我对InnoDB engine
完全没有经验,并且从未遇到过MyISAM
的此问题.这里有哪些潜在问题?
仅当在zip_codes
表中添加一行时才会发生这种情况.
编辑:在解决与配置有关的分辨率之前,请先检查是否没有用完磁盘空间. /p>
在本例中,您的innodb_data_file_path
的最大尺寸似乎太小了
innodb_data_file_path = ibdata1:10M:autoextend:max:512M
在所有innodb表组合中,您不能承载超过512MB的数据.
也许您应该使用innodb_file_per_table
切换到每表一个innodb方案.
I'm trying to add a row to an InnoDB
table with a simply query:
INSERT INTO zip_codes (zip_code, city) VALUES ('90210', 'Beverly Hills');
But when I attempt this query, I get the following:
ERROR 1114 (HY000): The table
zip_codes
is full
Doing a
SELECT COUNT(*) FROM zip_codes
gives me 188,959 rows, which doesn't seem like too many considering I have another table with 810,635 rows in that same database.
I am fairly inexperienced with the InnoDB engine
and never experienced this issue with MyISAM
. What are some of the potential problems here ?
EDIT: This only occurs when adding a row to the zip_codes
table.
EDIT: First check, if you did not run out of disk-space, before resolving to the configuration-related resolution.
You seem to have a too low maximum size for your innodb_data_file_path
in your my.cnf
, In this example
innodb_data_file_path = ibdata1:10M:autoextend:max:512M
you cannot host more than 512MB of data in all innodb tables combined.
Maybe you should switch to an innodb-per-table scheme using innodb_file_per_table
.
这篇关于1114(HY000):桌子已满的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!