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 Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: ""Taylor Lewick"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, July 01, 2003 10:32 PM Subject: Delete from InnoDB > --=_154B26A2.4A2A23E3 > Content-Type: text/plain; charset=US-ASCII > Content-Transfer-Encoding: quoted-printable > > Hi all. I did a delete query on an InnoDB table where items were older t= > han a certain date. > That worked fine, and it told me that some 30,000 objects had been delete= > d. > > i did a commit, and then decided to delete a few more by changing the dat= > e parameter. > Now the query just hangs, and when I do a show table status, the number o= > f rows constantly changes even after I killed off the query and did more = > commits. =20 > > My question is what happened and what can I do to fix this? Right now I = > can't access any data from this table. > > Thanks, > Taylor > > **************************************************************** > =09 Please Note > The information in this E-mail message is legally privileged > and confidential information intended only for the use of the > individual(s) named above. If you, the reader of this message, > are not the intended recipient, you are hereby notified that=20 > you should not further disseminate, distribute, or forward this > E-mail message. If you have received this E-mail in error, > please notify the sender. Thank you > ***************************************************************** > > --=_154B26A2.4A2A23E3-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
