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 > 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.15-standard' socket: > '/var/lib/mysql/mysql.sock' port: 3306 MySQL > Community Edition - Standard (GPL) > Number of processes running now: 0 > 051116 20:33:05 mysqld restarted > 051116 20:33:05 InnoDB: Started; log sequence > number 0 43665 > 051116 20:33:05 [Note] /usr/sbin/mysqld: ready for > connections. > Version: '5.0.15-standard' socket: > '/var/lib/mysql/mysql.sock' port: 3306 MySQL > Community Edition - Standard (GPL) > > As you can see from the log I am running 5.0.15. I > installed using the provided RPMs on a RH ES3 box. > > Below is the tablestatus. > > mysql> show table status like 'trade' \G > *************************** 1. row > *************************** > Name: trade > Engine: ARCHIVE > Version: 10 > Row_format: Compressed > Rows: 0 > Avg_row_length: 4137 > Data_length: 2147483647 > Max_data_length: 0 > Index_length: 0 > Data_free: 0 > Auto_increment: NULL > Create_time: 2005-11-16 20:33:05 > Update_time: 2005-11-16 20:33:05 > Check_time: NULL > Collation: latin1_swedish_ci > Checksum: NULL > Create_options: max_rows=4294967295 > avg_row_length=4137 > Comment: > 1 row in set (0.01 sec) > > Thanks for any assistance you can give. I am also > looking at alternative solutions in which I use > multiple ARCHIVE dbs with each being < 2 gb. > > Marc > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]