SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Zealot
    Join Date
    Nov 2009
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Binary logs: Server load

    Question.

    A friend of mine, who claims to be an experienced programmer (php and mysql) says that enabling binary logs creates an extra server load up to 50%, while on the official mysql site they say that the lost is around 1%, the lost of server performance. To support what he believes in, he says that every time a change to a database is made, server has got to implement that change, plus, record that change into binary log, therefore, doing two actions instead of one.

    Any comments?

    Thanks,
    Alex.

  2. #2
    SitePoint Wizard
    Join Date
    Nov 2005
    Posts
    1,191
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Two actions sure, but one action will be far quicker than the other. I'd probably go with the mysql version

  3. #3
    Non-Member
    Join Date
    Oct 2009
    Posts
    1,852
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    number of actions cannot be used as a measure. actions are different.

  4. #4
    SitePoint Wizard cranial-bore's Avatar
    Join Date
    Jan 2002
    Location
    Australia
    Posts
    2,634
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Your friend sounds like he's guessing. MySQL are more likely to have actually measured the difference. If it did commonly slow things down by 50% it wouldn't be recommended for production use.

  5. #5
    SitePoint Zealot
    Join Date
    Nov 2009
    Posts
    115
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by cranial-bore View Post
    Your friend sounds like he's guessing. MySQL are more likely to have actually measured the difference. If it did commonly slow things down by 50% it wouldn't be recommended for production use.
    I agree with you!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •