MySQL Forums
Forum List  »  InnoDB

Re: innodb growing oversize mysql version 5.5.28
Posted by: Rick James
Date: July 09, 2015 11:32PM

Presumably you did one of these, which was bigger than you expected:
* ALTER
* INSERT into a table

I would guess you have a CREATE or INSERT from a SELECT with a CROSS JOIN. But the CROSS JOIN was an accident -- forgot the WHERE clause connecting the tables.

Apparently you have innodb_file_per_table = OFF, so it will be difficult to recover the wasted space in ibdata1.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: innodb growing oversize mysql version 5.5.28
831
July 09, 2015 11:32PM


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.