表格是完整错误 [英] Table is Full Error
问题描述
MySQL 4.1
我对数据库不是很精通，但只要在我的表格中包含第129行$'
行''demainpark'' ，我得到表是完全错误。我通过新闻组搜索了
，检查了关于MySQL的full_table信息
Docu，还查看了Documetation但却无法想出一个
回答我的问题：
这是我的my.ini文件：
[mysqld]
basedir = F：/ mysql4 / mysql
datadir = F：/ mysql4 / MYSQL / data
innodb_data_file_path = ibdata1：10M
set-variable = innodb_buffer_pool_size = 70M
set-variable = innodb_additional_mem_pool_size = 10M
set-variable = innodb_log_file_size = 20M
set-variable = innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
以下是名为''demainpark''的表状态的摘录：
Avg_row_length = 8192
Data_length = 16384
Create_options = max_rows = 1000000000 avg_row_length = 65535
table demainpark有大约15个奇数字段，varchar（），double，
时间戳字段
可以有人请指导我吗？ data_length是不正确的？
如何增加它？
提前致谢
MySQL 4.1
Im not very well versed with databases, but as soon as I include 129th
row in my table called ''demainpark'', I get Table is Full error. I have
searched thru the newsgroup, checked the full_table info on MySQL
Docu, also looked at the Documetation but couldnt come up with an
answer to my problem:
Here is my my.ini file:
[mysqld]
basedir=F:/mysql4/mysql
datadir=F:/mysql4/MYSQL/data
innodb_data_file_path = ibdata1:10M
set-variable = innodb_buffer_pool_size=70M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_log_file_size=20M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
Here are extracts from the status of table called ''demainpark'':
Avg_row_length = 8192
Data_length = 16384
Create_options = max_rows=1000000000 avg_row_length=65535
table demainpark has around 15 odd fields with varchar(), double,
timestamp fields
Can anyone please guide me on this ? is the data_length incorrect ?
how can i increase it ?
Thanks in advance
推荐答案
Nohman Ishtiaq写道：
Nohman Ishtiaq wrote:
MySQL 4.1
我不太熟悉数据库，但是只要我包含129th
在我的表中称为''demainpark''，我得到表是完全错误。我已经通过新闻组搜索了，检查了关于MySQL
Docu的full_table信息，还查看了Documetation，但无法找到我的问题的答案：
MySQL 4.1
Im not very well versed with databases, but as soon as I include 129th
row in my table called ''demainpark'', I get Table is Full error. I have
searched thru the newsgroup, checked the full_table info on MySQL
Docu, also looked at the Documetation but couldnt come up with an
answer to my problem:
你能告诉我们：
描述demainpark;
在mysql控制台中返回给你？
Could you tell what:
describe demainpark;
returns to you in mysql console?
Nohman Ishtiaq写道：
Nohman Ishtiaq wrote:
MySQL 4.1
我不太精通数据库，但是当我在我的表中包含名为''demainpark''的第129行时，我得到Table is Full错误。我已经通过新闻组搜索了，检查了关于MySQL
Docu的full_table信息，还查看了Documetation，但无法找到我的问题的答案：
MySQL 4.1
Im not very well versed with databases, but as soon as I include 129th
row in my table called ''demainpark'', I get Table is Full error. I have
searched thru the newsgroup, checked the full_table info on MySQL
Docu, also looked at the Documetation but couldnt come up with an
answer to my problem:
你能告诉我们：
描述demainpark;
在mysql控制台中返回给你？
Could you tell what:
describe demainpark;
returns to you in mysql console?
no **** @ nexlinx.net.pk （Nohman Ishtiaq）在留言新闻中写道：< 7a ************************** @ posting.google。 com> ...
no****@nexlinx.net.pk (Nohman Ishtiaq) wrote in message news:<7a**************************@posting.google. com>...
MySQL 4.1
我不太熟悉数据库，但只要在我的表中包含第129行，称为'demainpark ''，我得到表是完全错误。我已经通过新闻组搜索了，检查了关于MySQL
Docu的full_table信息，还查看了Documetation但是无法找到我的问题的答案：
这是我的my.ini文件：
[mysqld]
basedir = F：/ mysql4 / mysql
datadir = F：/ mysql4 / MYSQL / data
innodb_data_file_path = ibdata1： 10M
MySQL 4.1
Im not very well versed with databases, but as soon as I include 129th
row in my table called ''demainpark'', I get Table is Full error. I have
searched thru the newsgroup, checked the full_table info on MySQL
Docu, also looked at the Documetation but couldnt come up with an
answer to my problem:
Here is my my.ini file:
[mysqld]
basedir=F:/mysql4/mysql
datadir=F:/mysql4/MYSQL/data
innodb_data_file_path = ibdata1:10M
您的数据文件似乎无法自动扩展...
您应该改为：
innodb_data_file_path = ibdata1：10M：autoextend
希望这有帮助
You datafile doesn''t seem to be auto-extendable...
You should have instead:
innodb_data_file_path = ibdata1:10M:autoextend
Hope this helps
这篇关于表格是完整错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
