See details of the "mysql_use_result" attribute: http://search.cpan.org/author/JWIED/DBD-mysql-2.1027/lib/DBD/mysql.pod#STATEMENT_HANDLES
Tim. On Mon, Jun 09, 2003 at 02:33:30PM -0700, Jamin Roth wrote: > OK running dmesg shows that the OS is out of memory. When $sth->execute is > run are all of the records returned? That would take out a ton of memory. > Other then Limiting the amount of returned results does any one have any > other ideas? > > Thanks, > > Jamin Roth > Systems/Network Administrator > Sorensen Associates Inc > Phone: (503) 665-0123 ext 234 > Fax: (503) 666-5113 > http://www.sorensen-associates.com/ > > > -----Original Message----- > From: Stephen Clouse [mailto:[EMAIL PROTECTED] > Sent: Monday, June 09, 2003 2:12 PM > To: Jamin Roth > Cc: [EMAIL PROTECTED] > Subject: Re: Vague DBI Error > > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Fri, Jun 06, 2003 at 05:27:30PM -0700, Jamin Roth wrote: > > I designed a simple script to backup my MySQL databases. Basically it > loops > > through all the databases then through each table. This section of code > > retreives the table and writes it to a csv file. When I execute the code > at > > the end of this message on a table with 2.7 million rows it works fine. > > When it's executed on 4.7 million rows it exits out with only "Terminated" > > as the error message. Is there any way I can get more information about > > what is going on? Could MySQL be timing out? Should I split up the table > > if it is over 2.5 million records (just do a limit in the SQL statement)? > > If this is Linux, it sounds like the kernel OOM killer is sniping the > process. > Hopefully you're not trying to hold all those records in memory at once.... > > - -- > Stephen Clouse <[EMAIL PROTECTED]> > Senior Programmer/DBE, Core Technology Developer > The IQ Group, Inc. <http://www.theiqgroup.com/> > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.7 (GNU/Linux) > > iD8DBQE+5Pg4A4aoazQ9p2cRAsk1AJ48gukiiX9gJX8gkNupUmTK58YdKgCg4J1b > LKzYhEcTDG4YgAj8Dp6HeQ0= > =j8yu > -----END PGP SIGNATURE----- >
