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]
