Mysql problem (Tables crashed)

Discussion in 'Installation/Configuration' started by vmbelizario, Jul 4, 2016.

  1. vmbelizario

    vmbelizario New Member

    Hi guys,
    I have a server with ISPconfig 3.0.5.4p8.
    Last week my company who host my server had a problem and my server powered off abruptly, 2 times. But this problem has been fixed and now i have some errors in my mysql; a few tables (differents databases) show this error:
    SSH: systemctl status mysqld -l
    [ERROR] mysqld: Table './databasename/tablenamexxx' is marked as crashed and should be repaired.
    I can read all informations from this table with no problem.
    I can update, insert, and delete with no problem.
    If i go to mysql terminal and run
    "use databasename;
    repair table tablenamexxx;"
    works, and after restarted mysql service the error disappear.
    But, after a few hours later, same problem again.

    What can i do ?
    Memory, disk size and CPU use / load is normal. Nothing wrong.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The harddisk may be damaged. Check the health of your harddisk with smartctl command.
     

Share This Page