Hello Heikki,
Thanks for your response. Hmmm... When I run 'show processlist', I get something
like the following:
++--++--+-+-+---+--+
| Id | User | Host | db | Command
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';
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 dangling
transactions which
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
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 think that the performance problem
is related to something other than