Re: MySQL v5.1 loses connection if too many updates in loop

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)

Re: MySQL v5.1 loses connection if too many updates in loop

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

Re: MySQL v5.1 loses connection if too many updates in loop

At 10:19 AM 1/18/2009, you 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

Re: MySQL v5.1 loses connection if too many updates in loop

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

Re: MySQL v5.1 loses connection if too many updates in loop

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,

Re: MySQL v5.1 loses connection if too many updates in loop

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

Re: MySQL v5.1 loses connection if too many updates in loop

On Sun, 18 Jan 2009 16:26:58 -0600, mos mo...@fastmail.fm wrote: 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

Re: MySQL v5.1 loses connection if too many updates in loop

He's using Delphi according to his first post. You might wanna use a TClientDataSet if you're not doing so already. It provides a bit more flexibility and won't keep the select query open for longer than is necessary. Have fun! Walter OlinData: Professional services for MySQL Support *

What's wrong with user defined variable in this MySQL 5.1 example?

I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to be working properly if the Select statement is sorted. Here is a simple example: CREATE TABLE `tmp` ( `Purch_Date` date DEFAULT NULL, `Product` char(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT