Binary logs: Server load

[AlexKravchenko]

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.

[hash]

Two actions sure, but one action will be far quicker than the other. I'd probably go with the mysql version

[Shrapnel_N5]

number of actions cannot be used as a measure. actions are different.

[cranial-bore]

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.

[AlexKravchenko]

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!