MySQL sometimes just dies

Hi everyone,

This is probably more something for the MySQL lists, but since I only have
RT running on it, hopefully one of you will have experienced it too and have
some suggestions.

Quite often (once every couple of weeks at least) MySQL just dies - I have
checked the /var/log/mysqld.log files, but at best I can figure out from
there is that some mysqld processes hang.

Other things that go wrong is that my Attachments table get somewhat
corrupted. So much so that I can’t do a db dump. I have to do a ‘repaire
table Attachments’ every once in a while to keep that sorted out.

One more thing that I have noticed is that some strange table-files where
created/last accessed about 2 weeks ago
The following files are inbetween my regular RT2 table files:

-rw-rw---- 1 mysql mysql 8920 Jan 17 10:59 #sql-166a_ab.frm
-rw-rw---- 1 mysql mysql 188874752 Jan 17 11:00 #sql-166a_ab.MYD
-rw-rw---- 1 mysql mysql 1024 Jan 17 10:59 #sql-166a_ab.MYI

As you can see, the .MYD file is rather big. My Attachments.MYD file’s size
is 741416440. We have just over 19000 tickets on the system, of which the
first +/- 5000 was imported from RT1.

Any suggestion are welcome. I not a MySQL guru in any way, so please ask me
for more diagnostics (and where to find them) if necessary.

Rehan van der Merwe
Neil Harvey & Associates (Pty) Ltd
http://www.nha.co.za
rehan@nha.co.za
Tel: +27 21 6709237
Fax: +27 21 6709337