nal Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 10:48 PM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
> Hello Heikki,
>
> > why you do not look with SHOW INNODB STATUS if there are dang
Hello Heikki,
> why you do not look with SHOW INNODB STATUS if there are dangling
> transactions which could still see the delete-marked rows? Purge cannot
> remove them then.
This is what I see:
mysql> show table status like 'sccchangelog';
+--++++---
ECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 12:10 AM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
> Hi,
>
> I wanted to post a follow-up question to the inquiry below. I've done some
more research since my last post and now
Hi,
I wanted to post a follow-up question to the inquiry below. I've done some more
research since my last post and now think that the performance problem is related to
something other than uncommitted transactions. More specifically, I think the culprit
is the lack of timely synchronization