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/16/05, Marc Rossi <[EMAIL PROTECTED]> wrote: > 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 support. > > Any ideas? I tried to do the ALTER TABLE xxxxx > AVG_ROW_LENGTH=x MAX_ROWS=y using inputs that would > exceed 2GB, same results. > > TIA, > Marc > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
