MySQL Forums
Forum List  »  Newbie

The table '#sql-6ac_9' is full
Posted by: Paolo Valleri
Date: February 24, 2016 07:16AM

Hi all,
I've a Mysql 5.7.11 32Bit installation on windows server 2008r2 64bit.
I got "The table '#sql-6ac_9' is full" running the following

ALTER TABLE `database`.`table`
ROW_FORMAT = DEFAULT , ENGINE = InnoDB

The table has 70M records with MyIsam as engine (The two files *.MYD and *.MYI take 3.5GB).
I've already tried to set
innodb_data_file_path=ibdata1:128M:autoextend:max:10G
to my.cnf but it didn't fix the issue.
The partition has 90GB of free space.
Am I missing something else in the configuration?

Paolo

Options: ReplyQuote


Subject
Written By
Posted
The table '#sql-6ac_9' is full
February 24, 2016 07:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.