Well, you could diff the old and the new conf and see if any of the changes point you in the right direction. You could even post the diff here so we can help you think :)
Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Sun, Jan 18, 2009 at 7:35 PM, mos <mo...@fastmail.fm> wrote: > At 10:49 AM 1/18/2009, you wrote: >> >> 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 :) > > I uninstalled MySQL 5.01 and installed MySQL 5.1 on the same machine without > re-installing XP Pro. > With 5.1 I switched to the MySQL-huge.cnf and tweaked a few of the > directories and that's about it. I can go back to the old cnf if you think > that's going to change. > > The weird thing about this is the loop will work fine for a few hundred > iterations then all of a sudden the Next statement is frozen and then loses > connection to the server. This fails every single time it is run. If I take > the updates out of the loop and process them later, it works fine. So there > is some sort of contention between traversing a table and updating a row of > the table at the same time. There are no other applications running against > the server. This is the only application making requests to the MySQL > server. > > BTW, the server is on the same machine as the application. It is not going > over the network. > > Mike > > >> 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=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
