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=arch...@jab.org
