Re: Out of memory on INSERT

2004-06-17 Thread Garth Webb
On Tue, 2004-06-15 at 08:08, J S wrote: > Hi, > > I have a perl script which runs a bulk insert. When I run an insert with > about 100,000 lines it keels over with the following message: > > DBD::mysql::st execute failed: Out of memory (Needed 6100848 bytes) at > ./parse.pl line 227, <> line 10

Out of memory on INSERT

2004-06-17 Thread J S
Hi, I have a perl script which runs a bulk insert. When I run an insert with about 100,000 lines it keels over with the following message: DBD::mysql::st execute failed: Out of memory (Needed 6100848 bytes) at ./parse.pl line 227, <> line 15. There is 8GB of memory on the box so I'm sure th