473,322 Members | 1,719 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

tabe is full, but InnoDB free shows 3072 kB

2
I am trying to insert a new record into table 'aaa'.
It said the table is full but the table status showed it still has 3072KB available. How to understand this result?


mysql> insert into aaa(name,type) values ('ddfdf','ddfde');
ERROR 1114 (HY000): The table 'aaa' is full
mysql> show table status like 'aaa' \G
*************************** 1. row ***************************
Name: aaa
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 7051
Avg_row_length: 48
Data_length: 344064
Max_data_length: 0
Index_length: 0
Data_free: 0
Auto_increment: 7333
Create_time: 2011-04-21 13:45:22
Update_time: NULL
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: InnoDB free: 3072 kB
1 row in set (0.00 sec)
Apr 21 '11 #1
1 3621
edwinC
2
I think I find the reason. 3072KB may leave for undo log.

I tried to delete a big table;

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from posts;
ERROR 1114 (HY000): The table 'posts' is full

If I choose a small collection, it won't have any problem.
mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from posts limit 50000;
Query OK, 50000 rows affected (0.27 sec)
Apr 21 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

12
by: Nohman Ishtiaq | last post by:
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...
3
by: Vanchau Nguyen | last post by:
Hi all, Hoping someone can help us with this strange Innodb problem. At about 5:15 AM 2/2/04 (this morning), our slave server stopped accepting connections. The machine was pingable, but you...
3
by: Andy Tran | last post by:
I built a system using mysql innodb to archive SMS messages but the innodb databases are not keeping up with the number of SMS messages coming in. I'm looking for performance of 200 msgs/sec where...
1
by: LRW | last post by:
I'm using mySQL 4.0.20, interfacing it with phpMyAdmin 2.5.6. I usually set tables up with a "default" type, which I believe is myISAM (or whatever that one is.) But I decided to go with InnoDB for...
0
by: Stefan van Roosmalen | last post by:
I want to use constraints, so I will have to use innodb tables (according to the website mysql.com). But, what is the difference between myisam and innodb tables ?? And why is there a comment...
5
by: Eddie | last post by:
I have a MySQL-server running Innodb. We have installed ~ 2GB of memory in the server. In spite of this MySQL keeps crashing due to out-of-memory errors. The server is a dual xeon i686 running...
1
by: Gh! | last post by:
How can I see how much disk space is being occupied by an InnoDB table? Looking into /var/lib/mysql doesn't seem to work anymore for InnoDB tables. Please tell also if there is a way to see how...
3
bartonc
by: bartonc | last post by:
This comment ("InnoDB free: 4096 kB") appears in the MySQL Table Editor on a brand new InnoDB table. Does this mean that this table will soon be full? Do I have some setting that must be change in...
4
pradeepjain
by: pradeepjain | last post by:
hii i need to drop a foreign key for a table and create a new foreign key how do i do it ..i tried SHOW TABLE STATUS FROM ratingd LIKE 'fourwheeler_rating';...
4
by: tvnaidu | last post by:
I have MFC application, if I execute app on laptop, it doesnot show full window, it shows 80% on full screen , remaining 20% go bottom, whereas on Desktop it shows complete, on laptop resolution is...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.