Re: Unexpected empty table performance problem with MySQL and InnoDB

2003-07-03 Thread Heikki Tuuri
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

Re: Unexpected empty table performance problem with MySQL and InnoDB

2003-07-03 Thread gsargucci
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'; +--++++---

Re: Unexpected empty table performance problem with MySQL and InnoDB

2003-07-02 Thread Heikki Tuuri
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

Re: Unexpected empty table performance problem with MySQL and InnoDB

2003-07-02 Thread gsargucci
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