David - Sorry for the delayed response. ulimit is unlimited. I am using the RPMs for RH EL3 downloaded from a mirror so I would assumed they have been built to allow > 2GB archives.
I am most likely going a different route at this point as my query response time is much too slow even with a 1GB archive table. Using a separate MyISAM table for each day of data (~ 132mb/3.2m rows) gives me the response time I need -- plus there are no scenarios in which I will be performing cross-day queries (I would guess I could use the merge table if necessary). Thanks again, Marc --- "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> wrote: > Hi Marc, > > I would be a bit suspicious of the version of zlib > or something similar. > If it has only been compiled with a 32bit compiler, > this could be > causing an artificial limit of 2Gb on a pointer. > > The ARCHIVE engine uses the zlib for its > compression, that comes with > mysql. I am presuming if it has been compiled in > 32bit mode that a > pointer or two maybe overflowing. > > These are just thoughts as I can't really find any > reason in your logs > as to why this should be happening. Do you have a > ulimit set for the > user? This could be constricting your file growth to > 2Gb. > > Regards > > David Logan > Database Administrator > HP Managed Services > 148 Frome Street, > Adelaide 5000 > Australia > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]