SQL error: No such file or directory

    All my sites down. I face this error more than two times every week SQL error: No such file or directory .after I restart mysql sites up and running.


    service mysql restart


    Code
    1. [ ok . Stopping MySQL database server: mysqld
    2. [ ok . Starting MySQL database server: mysqld .
    3. [info] Checking for tables which need an upgrade, are corrupt or were
    4. not closed cleanly..

    I tried to fix all Database tables via phpmyadmin. all Database fixed and all goes good for day or so. how I can fix this error definitively?


    Server specs,
    I-mscp 1.2.9
    Debian 7 32bit
    Thank you in advance!

    Solved by tune InnoDB to use lesser amount of ram


    Code
    1. [mysqld]
    2. innodb_buffer_pool_size=5M
    3. innodb_log_buffer_size=256K
    4. #max_connections=10
    5. key_buffer_size=8
    6. innodb_additional_mem_pool_size=512K

    @everyone

    wishes you a Merry Christmas and a happy New Year!