Re: Delete from InnoDB

2003-07-01 Thread Heikki Tuuri
lt;[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2003 11:04 PM Subject: Re: Delete from InnoDB Heikki, thanks for the quick response. I am on HP-UX 11.00 with MySQL version 4.0.1 Yes all selects hang. On other tables they work. When I used to do a select count(*) from this_table I would get about a

Re: Delete from InnoDB

2003-07-01 Thread Heikki Tuuri
Taylor, SHOW TABLE STATUS reports an estimate of the number of rows. What do you mean that you cannot access any data from the table? All SELECTs hang? What OS, what MySQL version? What does SHOW INNODB STATUS\G print? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transaction