At 10:19 AM 1/18/2009, you wrote:
On Sun, Jan 18, 2009 at 2:13 AM, mos <mo...@fastmail.fm> wrote:
> I updated from MySQL 5.01 to 5.1 a few days ago. My Delphi application runs
> on XP with 3GB ram.
>
> I have a query #1 that executes a simple Select statement that fetches 5000
> rows from a single table sorted by date. (no joins)
>
> Inside a loop if any rows need to be updated, another query #2 will update
> that row and then a Next statement goes to the next row in Query#1 and this
> repeats until all the rows from the table are traversed. This seems pretty
> simple and has worked fine in v5.0.1. Since upgrading to v5.1.30 after
a few
> hundred rows have been updated, the Next statement will hang for 60 seconds
> and then I get a "lost connection to mysql server" message. If I take the
> updates out of the loop, it completes just fine. So why are a few thousand
> updates causing a problem inside of a loop? The updates are updating 1 row
> at a time and does not alter any of the keys in the table.
Is there anything in the error log?
No errors were reported in the error log. That was the first place I
looked. It just shows the server starting up and ready for connections.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
