Sp. Raja,
- Alkuperäinen viesti -
Lähettäjä: "Sp.Raja" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: "mysql" <[EMAIL PROTECTED]>
Lähetetty: Friday, March 05, 2004 2:28 PM
Aihe: Re: Innodb table space getti
IL PROTECTED]>
> Cc: "R Narayanan" <[EMAIL PROTECTED]>
> Date: Fri, Mar-5-2004 9:14 AM
> Subject: Re: Innodb table space getting filled up without any increase in actual
> rows!! - Looks like can be fixed.
>
> FYI.
>
>
> Sp. Raja,
>
> you have
CTED]>;
<[EMAIL PROTECTED]>
Lähetetty: Thursday, March 04, 2004 4:38 PM
Aihe: Re: Innodb table space getting filled up without any increase in
actual rows!!
Heikki,
Thanks for your reply.
As you said I have attached trace collected for SHOW INNODB STATUS.
Please point me the things which
lt;[EMAIL PROTECTED]>
> > Date: Thu, Mar-4-2004 1:30 AM
> > Subject: Re: Innodb table space getting filled up without any increase in actual
> > rows!!
> >
> > Sp. Raja,
> >
> > please check with
> >
> > SHOW INNODB STATUS\G
> >
Sp. Raja,
please check with
SHOW INNODB STATUS\G
if purge is still running and removing delete-marked rows. Also check that
you do not have old, dangling transactions, which can prevent purge from
running, as those old transactions could still see the delete-marked rows.
Best regards,
Heikki
I
