1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MySQL log big size, auto shrink?

Discussion in 'Plesk for Windows - 8.x and Older' started by Burnout, Nov 2, 2009.

  1. Burnout

    Burnout New Pleskian

    22
    57%
    Joined:
    Nov 23, 2008
    Messages:
    18
    Likes Received:
    0
    Hello,

    They mysqld.log file in %plesk_installdir%\Databases\MySQL\Log gets pretty big now -> 1,77GB.

    Can I just delete this file? Is it possible that MySQL cleans up that file itself?


    Kind regards,

    Burn
     
  2. Burnout

    Burnout New Pleskian

    22
    57%
    Joined:
    Nov 23, 2008
    Messages:
    18
    Likes Received:
    0
    The file has been growing till > 2GB now. I think I'm going to delete it.

    Is there a logrotation possibility please?


    Regard,

    Burn
     
  3. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    What about just removing mysql logging in MySQL config file?
     
  4. Burnout

    Burnout New Pleskian

    22
    57%
    Joined:
    Nov 23, 2008
    Messages:
    18
    Likes Received:
    0
    I find that a bit drastic. Isn't there logrotation available please?
     
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    I can suggest you create some logrotation.bat script for this purpose and run it periodically via created Scheduled Task in Plesk.
     
Loading...