On 7/28/06, Dan Nelson wrote:
In the last episode (Jul 28), leo huang said:
So, the deleted rows' disk space in tablespace can't re-use when I
use Innodb, can it? And the tablespace is growing when we update the
tables, even the amount of rows do not increase.
It can be re-used after the
In the last episode (Jul 29), Jochem van Dieten said:
On 7/28/06, Dan Nelson wrote:
In the last episode (Jul 28), leo huang said:
So, the deleted rows' disk space in tablespace can't re-use when I
use Innodb, can it? And the tablespace is growing when we update
the tables, even the amount of
hi, Chris
I'm sure it will, what makes you think it won't?
Because some paper say that when the row is deleted or update, Innodb
just make a mark that the row is deleted and it didn't delete the
rows. I can't find more information about the re-use tablespace. Can
you give me more?
Regards,
leo huang wrote:
hi, Chris
I'm sure it will, what makes you think it won't?
Because some paper say that when the row is deleted or update, Innodb
just make a mark that the row is deleted and it didn't delete the
rows. I can't find more information about the re-use tablespace. Can
you give me
hi, Chris
So, the deleted rows' disk space in tablespace can't re-use when I
use Innodb, can it? And the tablespace is growing when we update the
tables, even the amount of rows do not increase.
Regards,
Leo Huang
2006/7/28, Chris [EMAIL PROTECTED]:
leo huang wrote:
hi, Chris
I'm sure
In the last episode (Jul 28), leo huang said:
2006/7/28, Chris [EMAIL PROTECTED]:
leo huang wrote:
Because some paper say that when the row is deleted or update,
Innodb just make a mark that the row is deleted and it didn't
delete the rows. I can't find more information about the re-use
hi, Chris
Thank you for your advice!
I know that Innodb use the logfiles circularly. Can Innodb re-use the
deleted rows' disk space in tablespace?
Regards,
Leo Huang
2006/7/26, Chris [EMAIL PROTECTED]:
leo huang wrote:
hi, Dilipkumar
Thank you very much!
I think I know the fact: The
leo huang wrote:
hi, Chris
Thank you for your advice!
I know that Innodb use the logfiles circularly. Can Innodb re-use the
deleted rows' disk space in tablespace?
I'm sure it will, what makes you think it won't?
You might need an 'optimize table' or something to see a reduction in
the on
of innodb.
Try this it might help u out.
With Regards
Dilipkumar
[EMAIL PROTECTED]:
Hi, all
I know the Innodb use MVCC to achieve very high concurrency. Can
Innodb reuse the deleted rows disk space? I have an database which
have many update operation. If Innodb can\'t reuse
leo huang wrote:
hi, Dilipkumar
Thank you very much!
I think I know the fact: The Innodb can't reuse the deleted rows' disk
space. And a solution is: dump the data; shutdown mysql; delete the
files; restart mysql; import the data.
InnoDB does re-use the space inside the database, it's the
the space usage of innodb.
Try this it might help u out.
With Regards
Dilipkumar
[EMAIL PROTECTED]:
Hi, all
I know the Innodb use MVCC to achieve very high concurrency. Can
Innodb reuse the deleted rows disk space? I have an database which
have many update operation. If Innodb can\'t
Hi, all
I know the Innodb use MVCC to achieve very high concurrency. Can
Innodb reuse the deleted rows disk space? I have an database which
have many update operation. If Innodb can't reuse the space of deleted
rows, I worry about that MySQL will exhaust our disk space very
quickly
12 matches
Mail list logo