5

The question is simple. Does turning on binary logs in MySQL slow down performance considerably, i.e. will it write large amount of data to disk thereby causing high I/O, will it hog memory, does it have any implications for the CPU ?

Thanks

2 Answers 2

4

Reference

Running a server with binary logging enabled makes performance slightly slower. However, the benefits of the binary log in enabling you to set up replication and for restore operations generally outweigh this minor performance decrement.

4
  • 5
    Does that mean that percona performance blog is incorrect saying the following "But enabling the binary log reduces MySQL’s performance dramatically. " here www.percona.com/blog/2010/10/23/mysql-limitations-part-2-the-binary-log/
    – Adergaard
    Dec 4, 2014 at 15:58
  • define slightly , and define dramatically. Log will efect performance, that is for sure but I think no one can tell you how much. (I think it will be slightly, no metter what slightly means ;) ) Dec 4, 2014 at 16:03
  • 2
    I have 100 queries / second. If I'm correct about how bin_log works, it actually performs a write to disk for EACH of those. That's a humongous amount of writes. Sounds like it will come with an equally humongous cost in performance. I define humongous as somewhere between monster-super-duper-much and "damn, that's a lot".
    – Adergaard
    Dec 4, 2014 at 16:09
  • Adergaard's comment links to percona.com/blog/2010/10/23/… (there are non printable characters in his version) Aug 17, 2017 at 15:07
3

If the binary logs and the MySQL data write to the same disk mount, then yes it will slow things down.

If you create a separate disk mount just for logs, then it will not slow down as much.

In Facebook, there is a Database Engineer who splits up the MySQL files into separate disks. In light of this example, you could just setup a second disk, map log-bin to that disk. That way, no wasted spindles writing log data on a data volume.

1

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .