Conversation

Notices

  1. adiwan adiwan

    Database Error begone!

    about 10 months ago from web
    1. Cerulean Spark Cerulean Spark

      @adiwan Turns out if you don’t set binary log expiration in MySQL and leave it unattended for about 10 years you eventually run out of disk space

      about 10 months ago from web
      1. adiwan adiwan

        @ceruleanspark Ah... Makes sense. At a project I was working on they had similar issues. They logged EVERYTHING and had space issues in production. So much so that they had to make rotating logs but soon after so much was logged that the rotating logs would only save about 2-3 hours and yet more and more logging was added. My code had also very verbose logging that could be disabled but the client wanted even that output all the time. Coincidentally their DB views got so big that certain joints in some applications suddenly stopped working because it had too many columns. It was quite the ordeal to debug that.

        about 10 months ago from web