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 tra
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 growin
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
). It can't just delete the row because you might roll
> >back the transaction and it will have to undo that delete, or other
> >transactions might be using it for whatever purpose.
> >
> >http://dev.mysql.com/doc/refman/5.1/en/innodb-multi-versioning.html
> >http:
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 wr
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
ve me more?
Regards,
Leo Huang
2006/7/27, Chris <[EMAIL PROTECTED]>:
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 w
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 s
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!
>
&g
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
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.
Regards,
Leo Huang
2006/7/24, [EMAIL PROTECTED] <[EMAIL PROTECTED
se u can able to reduce 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
>
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
qu
: Thursday, August 18, 2005 10:18 AM
To: [EMAIL PROTECTED]
Cc: Scott Hamm; 'Mysql '
Subject: Re: Deleted rows
Scott, Shawn,
>The OP would like to detect that 4,5,6, and 7 are missing from the
>sequence. Your query would have only found that 7 was missing.
Right! For sequences longer
Scott,
Shawn,
>The OP would like to detect that 4,5,6,
and 7 are missing from the
>sequence. Your query would have only found that
7 was missing.
Right! For sequences longer than 1 you need something like...
SELECT
a.id+1 AS 'Missing From',
MIN(b.id)-1 AS 'To'
FROM test AS a, test AS
On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Peter,
>
> Your query may work for data with single-row gaps (like his example data)
> but it will not work if the sequence skips more than one number.
>
> Look at this sequence: 1,2,3,8,9,10
>
> The OP would like to detect tha
Peter,
Your query may work for data with single-row gaps (like his example data)
but it will not work if the sequence skips more than one number.
Look at this sequence: 1,2,3,8,9,10
The OP would like to detect that 4,5,6, and 7 are missing from the
sequence. Your query would have only found t
Scott,
>How do I execute a query that shows missing ID's like so:
SELECT id AS i
FROM tbl
WHERE i <> 1 AND NOT EXISTS(
SELECT id FROM tbl WHERE id = i - 1
);
PB
-
Scott Hamm wrote:
If I got a table as follows:
ID foo
1 12345
2 12346
4 12348
6 12349
7 12388
9 12390
How do I exe
Scott Hamm <[EMAIL PROTECTED]> wrote on 08/18/2005 08:59:00 AM:
> If I got a table as follows:
>
>
> ID foo
> 1 12345
> 2 12346
> 4 12348
> 6 12349
> 7 12388
> 9 12390
> How do I execute a query that shows missing ID's like so:
>
> 3
> 5
> 8
>
> I wouldn't expect for it to show deleted data th
If I got a table as follows:
ID foo
1 12345
2 12346
4 12348
6 12349
7 12388
9 12390
How do I execute a query that shows missing ID's like so:
3
5
8
I wouldn't expect for it to show deleted data that was deleted, just show
the "skipped" ID's.
That way I determine if operator deleted too much (
ed' number then your 'serial number' is not
really associated with the record.
Best wishes,
Paul Najman [EMAIL PROTECTED]
- Original Message -
From: "Daniel Crompton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 5:18 PM
Su
"Daniel Crompton" <[EMAIL PROTECTED]> wrote:
> I have one column as an auto increment for adding numbers:
>
> 1
> 2
> 3
> 4
> 5
>
> If i delete row 3 then add a new row and view the results i get:
>
> 1
> 2
> 4
> 5
> 6
>
> As you can see 3 has been deleted and its now added 6!
>
> Is this norm
> I have one column as an auto increment for adding numbers:
>
> 1
> 2
> 3
> 4
> 5
>
> If i delete row 3 then add a new row and view the results i get:
>
> 1
> 2
> 4
> 5
> 6
>
> As you can see 3 has been deleted and its now added 6!
>
> Is this normal?. How can i get it to always display numbers i
e 02, 2003 10:19 AM
To: [EMAIL PROTECTED]
Subject: Why does auto increment not take into account deleted rows?
I have one column as an auto increment for adding numbers:
1
2
3
4
5
If i delete row 3 then add a new row and view the results i get:
1
2
4
5
6
As you can see 3 has been deleted a
I have one column as an auto increment for adding numbers:
1
2
3
4
5
If i delete row 3 then add a new row and view the results i get:
1
2
4
5
6
As you can see 3 has been deleted and its now added 6!
Is this normal?. How can i get it to always display numbers in this column
in sequence.
TIA
ROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 3:01 PM
Subject: How to return the value of deleted rows
Hello Folks,
I wonder how can I return the number of deleted rows after a DELETE SQL
statement.
Is there any way to return the quantity of upd
tunes" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 2:01 PM
Subject: How to return the value of deleted rows
Hello Folks,
I wonder how can I return the number of deleted rows after a DELETE SQL
statement.
Is there any way to return
Hello Folks,
I wonder how can I return the number of deleted rows after a DELETE SQL statement.
Is there any way to return the quantity of updated rows as well?
Thanks,
C.F.
28 matches
Mail list logo
