Have you compared my.cnf files? Is the system you installed it on the same? I mean, did you reinstall the OS or anything? If not, we can rule that out :)
Walter OlinData: Professional services for MySQL Support * Consulting * Administration On Sun, Jan 18, 2009 at 5:19 PM, Baron Schwartz <ba...@xaprb.com> 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? > > > -- > 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=li...@olindata.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
