title: Limiting mysql log file size
body: <p>I have a mysql log file that regularly goes over 30gb, this sucks when you realise that your server is full because of this file. I need a simple solution to limit this file to about 1gb, i don't need logs that run that long, and i'd rather avoid this problem in the future. </p>
  
  <p>Any ideas? Thanks</p>