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
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