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
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.