mysql auto repair table upon crash

[tdsii]

many times, i see my forum down due to corrupted table, mostly the session table.

is there anyway to automatically repair tables when they are detected/marked as corrupted?

tdsii Reviewed by tdsii on 28th Feb 2011. mysql auto repair table upon crash many times, i see my forum down due to corrupted table, mostly the session table. is there anyway to automatically repair tables when they are detected/marked as corrupted? Rating: 5

[Perl]

What forum script are u using

[tdsii]

problem happened in both ipb and vb and both in session table. remember session table is memory and on vps we always have memory issues.

[Mr Happy]

Sounds to me like your looking for a pump to remove water from a leak. Would the obvious thing not be to fix the leak and cause of the problem?

Remove some memory heavy functions or upgrade your server. Relying on a script to repair corrupted tables is a bad idea.

[tdsii]

your correct, but nothing much i can do with 512ram of memory on a heavy site

[Lock Down]

I would suggest putting the sessions back to MyIsam from memory. That works well if you have a lot of memory and a large number online.

But it will crash a lot on a vps with minimal memory. That is why IPB made it using MyIsam in the first place.

[Perl]

your correct, but nothing much i can do with 512ram of memory on a heavy site

Add some more RAM the problem will be solved

[jomasaco]

an loop
CHECK TABLE foreach table msg !=ok repair, optimize

or

$alltables = mysql_query("SHOW TABLES");
while ($table = mysql_fetch_assoc($alltables))
{
   foreach ($table as $db => $tablename)
   {
       mysql_query("OPTIMIZE TABLE '".$tablename."'")
           or die(mysql_error());
           echo $tablename." Opmizide<br />";
   }
      foreach ($table as $db => $tablename)
   {
       mysql_query("REPAIR TABLE '".$tablename."'")
           or die(mysql_error());
           echo $tablename." Repaired<br />";
   }
} 

[tdsii]

jomasaco thanks for the code