MySQL Forums
Forum List  »  MyISAM

Problem with ibdata1 (trying to convert to MyISAM)
Posted by: John Cubillos Vega
Date: January 14, 2014 02:54PM

Hi.
I have a problem in a database for a couple of tables that use InnoDB.
Precisely because of this, I want to convert them to MyISAM executing this query:

alter table TABLE_NAME engine MyISAM;

The problem is, that in the execution the file ibdata1 is still growing to the point that the partition fill up and kill MySql.


I also tried adding a second ibdata to another partition with enough space and although it does create the second file, Mysql does not get to use it but still fills up the disk by growing the original ibdata1 file.

What can I do?

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with ibdata1 (trying to convert to MyISAM)
2437
January 14, 2014 02:54PM


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.