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