heavy Mysql problem

[TarantinoArchives]

okay. some weeks ago i had a server crash (harddisk issue) and lost lots of data (to be specific: random tables in my databases). some days later it happened again.
i had some backups (older ones, but i got it working again).

now... again, a table is broken... and the same one as i had before, the personal messages recipients table

Code Select Expand

Can't open file: 'yabbse_pm_recipients.MYI' (errno: 144)
File: /var/www/web2/html/forum/Sources/PersonalMessage.php
Line: 147

after the first crash i took precautions and put in limits to messages and cleaned up the database. this time, there's no HD crash... why the F*** do my tables get broken? when i check in phpmyadmin it sais "in use" at that specific table _pm_recipients


please help.

[[Unknown]]

When MySQL or the server crashes, tables can get broken.  You may try making the table InnoDB, which could help or could hurt if MySQL crashes... but at least it will be different.

144 means table crashed and last repair failed.  Why is your server crashing so much?

-[Unknown]

[TarantinoArchives]

When MySQL or the server crashes, tables can get broken.  You may try making the table InnoDB, which could help or could hurt if MySQL crashes... but at least it will be different.

144 means table crashed and last repair failed.  Why is your server crashing so much?

-[Unknown]

"so much" maybe is exagerated. it happened twice in a row after a year of perfect working...

so i change it from MYIsam to innnoDB or what?

[[Unknown]]

Well, as the table gets bigger you will probably want InnoDB anyway.  But, if you can get it back (you'll have to DROP the current table and restore your backup) and it doesn't go away again, you should be fine.

-[Unknown]

[TarantinoArchives]

i did that last time (dropping and restoring, althoug dropping didnt work the way it should coz the table was just... broken somehow). so i dont wanna try that again and again everyime that stupid table f**s me :-)

how do i convert from myisam to innodb?

[[Unknown]]

Well, you have to DROP it first and restore it.  Then:

ALTER TABLE tablename
TYPE=InnoDB;

-[Unknown]

[TarantinoArchives]

ok thanks. i'll try.
but with all the other tables i can just run the command? should i set the forum in maintenance, right? any risks with this conversion?

[[Unknown]]

I wouldn't convert all tables.  The sessions and log_online ones are good, though.

-[Unknown]

[TarantinoArchives]

I wouldn't convert all tables.  The sessions and log_online ones are good, though.

-[Unknown]

i just converted all of them. went smooth. forum seems faster.
they only thing i noticed is,that, for example when i want to move a topic, the drop down list is totally in disorder

[[Unknown]]

ALTER TABLE smf_boards
ORDER BY boardOrder;

-[Unknown]

[TarantinoArchives]

ALTER TABLE smf_boards
ORDER BY boardOrder;

-[Unknown]

wow that was fast. thanks. worked