Firstly, I inserted 60,000,000 rows into the innoDB table ama.
Then I tried to add the primary key and index to the table ama.
mysql> ALTER TABLE ama ADD PRIMARY KEY(answer_date_time, calling_number, called_number, node_name, fn), ADD Index iama_call_type (call_type);
But I get the following error:
ERROR 1114 (HY000) at line 1: The table 'ama' is full
I checked the error log as follows.
InnoDB: Error: Write to file (merge) failed at offset 1 384827392.
InnoDB: 1048576 bytes should have been written, only 442368 were written.
InnoDB: Operating system error number 0.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 0 means 'Success'.
InnoDB: Some operating system error numbers are described at
InnoDB:
http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
130812 11:59:04 [ERROR] /usr/sbin/mysqld: The table 'ama' is full
But the disk had still 32GB spaces.
I found the size of the ibdata1 was 27GB.
Any idea what is the way out?
Thanks.
Edited 1 time(s). Last edit at 08/15/2013 09:00PM by Chien-Ming Lee.