At 01:51 PM 1/18/2009, Walter Heck wrote:
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
Walter,
I just re-ran the program this time using my old 5.0 my.ini file
(which worked fine with MySQL 5.0) with MySQL 5.1.30 and the same problem
occurs, the Next statement loses connection to the MySQL 5.1 server after a
while if there are a lot of updates in the loop. If the updates are moved
outside of the loop, the program completes without a problem. So it looks
to me that there is some sort of contention for the table, between the Next
statement of the Select and the Update statement. They are both running on
the same thread and nothing else is updating the table. Is there anything
I should change in my My.Ini file?
TIA
Mike
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
