Does the binary log enabling affect the MySQL performances?

2004-03-23 Thread Enrico . Venturi 
Hello colleagues, I'd like to know
IF by enabling the binary logs production I'll affect meaningfully the 
MySQL DB performances, and
HOW MUCH the performances are impacted

Any witnesses on this topic?
Regards
Enrico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Does the binary log enabling affect the MySQL performances?

2004-03-23 Thread Tim Cutts 
On 23 Mar 2004, at 10:38, [EMAIL PROTECTED] wrote:

Hello colleagues, I'd like to know
IF by enabling the binary logs production I'll affect meaningfully the 
MySQL DB performances, and
HOW MUCH the performances are impacted
I just tested a load of a 6GB mysqldump (MyISAM tables), on an unloaded 
HP AlphaServer ES45 with 8 GB of RAM, and storage on an HSV 110 SAN 
device.  MySQL version was 4.0.17

Without binary logging, elapsed time was:

2480 seconds

With binary logging, elapsed time was:

2502 seconds

So it's about 1% slower, if that.  I'm logging to a different device 
from the databases.

As an additional point, if I add a replication slave to the equation, 
the time becomes:

2518 seconds

Which is scarcely any difference at all.

Tim

--
Dr Tim Cutts
Informatics Systems Group
Wellcome Trust Sanger Institute
Hinxton, Cambridge, CB10 1SA, UK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]