Hi!
Note that [EMAIL PROTECTED] is not the appropriate mailing
list for messages like this! If you have a repeatable bug, then you
are welcome to post to this list.
>>>>> "Daniel" == Daniel Adams <[EMAIL PROTECTED]> writes:
Daniel> Okay,
Daniel> This has already happened once and I had to restore it from backup. I
Daniel> was using one of the pre-stable betas but i am not on the most current
Daniel> stable release and it still crashes. The table is a little over 500MB. I
Daniel> was doing a lot of inserts to the database both times this happened. The
Daniel> table has a fulltext index on two of the columns if that helps any. When
Daniel> if run "show table status" in mysql i get the following:
mysql> show table status;
<cut>
Daniel> | message | NULL | NULL | NULL | NULL |
Daniel> NULL | NULL | NULL | NULL | NULL | NULL
Daniel> | NULL | NULL | NULL
Daniel> | NULL |
I haven't seen the above ever before.
The only thing I can think of is that you have run out of some
resource like number of open files. Try adding 'ulimit -n 1024' in
the safe_mysqld script and start mysqld with a higher -O table_cache=#
option.
Did you try to do 'flush tables' and try to do 'show table status'
again?
If the table is now ok, then it's probably a file limit problem.
Note that the above doesn't necessary mean that the table is crashed.
Did you try to run 'check table' on the table in question?
Daniel> the table that keeps crashing is the message table. After I had finished
Daniel> doing the inserts i was doing it tried to do some more and they all
Daniel> failed so i checked the table and got this for the message table from
Daniel> "show table status":
Daniel> | message | MyISAM | Dynamic | 301717 | 1716 |
Daniel> 518037300 | 4294967295 | 327309312 | 0 | 426333 |
Daniel> 2001-03-26 21:08:08 | 2001-03-27 20:15:29 | NULL |
Daniel> | |
Daniel> It said Data_free was 0 so I deleted some junk off the partition and just
Daniel> restarted the server and got the first output with all the NULLs. CAN
Daniel> SOMEONE PLEASE TELL ME WHY THIS KEEPS HAPPENING!!??? I'm quickly losing
Daniel> my confidence in mysql's stability if it can't even handle heavy inserts
Daniel> on a 500mb table on a machine with more than enough hd space and 1 gig of
First: It's total normal that Data_free is 0. This just means that
the table itself doesn't have any free space but more data will be
allocated from the file system,
I would also recommend you to first upgrade to 3.23.36 and when you have
done that run 'check table' on the above table.
If you still have problems, please try to find out what is going
wrong. It could be for example that it's just 'show table status'
that is showing something wrong.
MySQL should be able to handle insertions into a 500mg table without
any problems, so I suspect it's something else that is wrong with your
setup. To be able to help you with this I would however know a lot
more about your setup or to find some way to reproduce this.
The follwing link contains a lot of information of how to find out
what's wrong:
http://www.mysql.com/doc/P/r/Problems.html
If this still doesn't help, you can always consider the option to pay
for MySQL support. In this case we can even login into your system
and try to find out what's wrong with it!
Regards,
Monty
PS: In the future, please submit bug reports with the mysqlbug script!
---------------------------------------------------------------------
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
