hi listers

i've upgraded my mysql env from 3.23.53 to 4.0.13. also, i changed os from m$ to rh 
7.3. what did not change was h/ware. 

since the upgrade, i often get the error message "table is marked as crashed and 
should be repaired". (errno 145). i then run myisamcheck --auto-repair to fix the 
problem but this is a reactive. 

what switches can i set on mysqld to trace the cause of this problem? 

to handle to symptom, i've set myisam_recover_option=backup,force in my.cnf this 
morning so hopefully the problem does not re-occur, though i'm sure sure if this will 
work

tks
    _________  _______   _      __
   /___    ___/ /   ___    / /   \   /    /
        /   /      /   /    /   / /   ^  v     /
       /   /      /   /__/   / /   /  \/ /   /
      /_ /      /______ / /_ /      /_ /

Cell: 083 440 2213
Ph:  021 980 4969

Reply via email to