By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

tabe is full, but InnoDB free shows 3072 kB

P: 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
Share this Question
Share on Google+
1 Reply


P: 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

Post your reply

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