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
Hello.
It is strange for me that there isn't a stack trace. If you can
- switch to the debug version of MySQL and run it under gdb
to find out where it is crashing. See:
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html
laide); mysql@lists.mysql.com
Subject: Re: mysqld crash with archive engine > 2gb
> Is there any message in the log files? or any error
> message from the OS?
David -
When the mysqld process restarts, there is nothing in
the logfile except the basic startup info. I have
listed it below:0:
> Is there any message in the log files? or any error
> message from the OS?
David -
When the mysqld process restarts, there is nothing in
the logfile except the basic startup info. I have
listed it below:0:33).
051116 10:06:33 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '5.0
: Marc Rossi [mailto:[EMAIL PROTECTED]
Sent: Thursday, 17 November 2005 3:16 PM
To: mysql@lists.mysql.com
Subject: mysqld crash with archive engine > 2gb
I am trying to populate a table using the archive
engine that I estimate will take up ~ 8gb of disk
space when finished. Right now I am crash
Marc:
Define "crashing the server". Does the whole machine shut down? The
mysqld process? What do error logs say? What version of MySQL are
you using? What's the create table statement? what's the current
avg_row_length and max_rows? What is ulimit -f as the MySQL user say?
-Sheeri
On 11/
I am trying to populate a table using the archive
engine that I estimate will take up ~ 8gb of disk
space when finished. Right now I am crashing the
server as soon as my file gets to the 2gb mark. OS is
linux and there are other files on the same filesystem
that are 30gb+ so I know the fs has sup
