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]