RE: mysqld crash with archive engine > 2gb

2005-11-21 Thread Marc Rossi
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

Re: mysqld crash with archive engine > 2gb

2005-11-18 Thread Gleb Paharenko
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

RE: mysqld crash with archive engine > 2gb

2005-11-17 Thread Logan, David (SST - Adelaide)
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:

Re: mysqld crash with archive engine > 2gb

2005-11-17 Thread Marc Rossi
> 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

RE: mysqld crash with archive engine > 2gb

2005-11-17 Thread Logan, David (SST - Adelaide)
: 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

Re: mysqld crash with archive engine > 2gb

2005-11-17 Thread sheeri kritzer
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/

mysqld crash with archive engine > 2gb

2005-11-16 Thread Marc Rossi
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