Re: innodb growing oversize mysql version 5.5.28
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.
Subject
Views
Written By
Posted
1756
July 09, 2015 02:48AM
Re: innodb growing oversize mysql version 5.5.28
838
July 09, 2015 11:32PM
996
July 10, 2015 02:17AM
807
July 10, 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.