Hi all. I did a delete query on an InnoDB table where items were older than a certain
date.
That worked fine, and it told me that some 30,000 objects had been deleted.
i did a commit, and then decided to delete a few more by changing the date parameter.
Now the query just hangs, and when I do a show table status, the number of rows
constantly changes even after I killed off the query and did more commits.
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
****************************************************************
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
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
*****************************************************************
