Okay,
This has already happened once and I had to restore it from backup. I
was using one of the pre-stable betas but i am not on the most current
stable release and it still crashes. The table is a little over 500MB. I
was doing a lot of inserts to the database both times this happened. The
table has a fulltext index on two of the columns if that helps any. When
if run "show table status" in mysql i get the following:
mysql> show table status;
+---------------+--------+------------+-------+----------------+--------
-----+-----------------+--------------+-----------+----------------+----
-----------------+---------------------+---------------------+----------
------+---------+
| Name | Type | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free | Auto_increment
| Create_time | Update_time | Check_time |
Create_options | Comment |
+---------------+--------+------------+-------+----------------+--------
-----+-----------------+--------------+-----------+----------------+----
-----------------+---------------------+---------------------+----------
------+---------+
| category | MyISAM | Dynamic | 49 | 23 |
1288 | 4294967295 | 3072 | 152 | 59 |
2001-03-26 21:08:01 | 2001-03-27 20:02:45 | NULL |
| |
| groupcounter | MyISAM | Fixed | 1227 | 60 |
73620 | 257698037759 | 29696 | 0 | 1228 |
2001-03-26 21:08:01 | 2001-03-26 21:08:01 | NULL |
| |
| list | MyISAM | Dynamic | 10177 | 85 |
871340 | 4294967295 | 925696 | 0 | 11491 |
2001-03-27 01:30:42 | 2001-03-27 20:15:28 | 2001-03-27 01:30:51 |
| |
| message | NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL | NULL | NULL
| NULL | NULL | NULL
| NULL |
| threadrequest | MyISAM | Dynamic | 10 | 76 |
764 | 4294967295 | 4096 | 0 | 12 |
2001-03-26 23:26:23 | 2001-03-27 00:54:43 | NULL |
| |
+---------------+--------+------------+-------+----------------+--------
-----+-----------------+--------------+-----------+----------------+----
-----------------+---------------------+---------------------+----------
------+---------+
5 rows in set (0.00 sec)
the table that keeps crashing is the message table. After I had finished
doing the inserts i was doing it tried to do some more and they all
failed so i checked the table and got this for the message table from
"show table status":
| message | MyISAM | Dynamic | 301717 | 1716 |
518037300 | 4294967295 | 327309312 | 0 | 426333 |
2001-03-26 21:08:08 | 2001-03-27 20:15:29 | NULL |
| |
It said Data_free was 0 so I deleted some junk off the partition and just
restarted the server and got the first output with all the NULLs. CAN
SOMEONE PLEASE TELL ME WHY THIS KEEPS HAPPENING!!??? I'm quickly losing
my confidence in mysql's stability if it can't even handle heavy inserts
on a 500mb table on a machine with more than enough hd space and 1 gig of
ram.
- Dan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
