Re: /var/lib/mysql/ibdata1 growing out of control
"if the database got completely wrecked, we could just rebuild them and let new data populate them." -- then consider MyISAM. That engine will take 1/3 to 1/2 the space of InnoDB.
No, there is not automatic way of having at table loop on itself; that would have to be user code.
Caution: Switching to MyISAM is as simple as ALTER TABLE ENGINE=MyISAM. But it will add disk usage -- until you kill off ibdata1.
Rummage thru
http://forums.mysql.com/list.php?22 for more info.
Subject
Written By
Posted
Re: /var/lib/mysql/ibdata1 growing out of control
July 11, 2009 04:16PM
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.