Binlog files

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #1227752
    Skillmind S.A.
    Participant

    I have a website with a scheculed full backup on the weekends and every time the website runs a full backup it creates more than 100GB of Binlog files. This is due to the constant Updates to the wp_options table with relatively big values.
    I saw that was reported a similar same issue 8 months ago. Are there any news on this subject? Is it somehow possible to avoid this?

    Thanks!

    #1227753
    Skillmind S.A.
    Participant
    This reply has been marked as moderator-only.
    #1227781
    udadmin
    Keymaster

    Hi,

    I believe that when that was reported some changes were made (if you have the link for the previous forum topic, that’d be helpful – my searches didn’t turn it up!). So your issue is likely to be slightly different. Are you able to share a relevant section of the log (run it through mysqlbinlog to turn back into readable SQL) – you can use the ‘private reply’ feature to avoid sharing it with the world. For some reason, this appears to only happen to a tiny number of people (as you observe, it’s been 8 months since last reported, and we can’t reproduce it on our own setups with full binary logging turned on).

    Thank you,
    David

Viewing 3 posts - 1 through 3 (of 3 total)
  • The topic ‘Binlog files’ is closed to new replies.