Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
Order MySQL support from http://www.mysql.com/support/index.html
From: Franky Van Liedekerke ([EMAIL PROTECTED])
Subject: Re: innodb defragmentation question
View: Complete Thread (4 articles)
Original Format
the problem is that, if it happens again, I get a file of 900 MB, which
gets kinda big ... In order to rectify the situation after that, I'll
need to dump all innodb tables, drop them and reinsert them. This would
takes hours, and in the meantime the application running on top of it
would be do
Franky,
since MySQL performs
ALTER TABLE ... TYPE = InnoDB;
by totally rebuilding the table, it is very normal that the space usage
temporarily doubles in ibdata files.
But if it doubles also after an immediate SECOND rebuild, then that must be
a bug. If you can reproduce that phenomenon, pleas
since it has been the holidays, I can understand this one failed to draw
attention of the people able to answer, so I'm sending it again:
Hi all,
if I try to defrag an InnoDB table (using "alter table ...
type=innodb;") I see th
Hi all,
if I try to defrag an InnoDB table (using "alter table ...
type=innodb;") I see the size of ibdata1 growing to almost double its
size, and again it doubles if I try it again ... there's only 1 innodb
table in my setup, so no other table can be causing this.
Is this intentional/normal o
