> 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.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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
