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? -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
