Does the binary log enabling affect the MySQL performances?
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?
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]
mysql performances for reliability
Hallo, i am looking for a reliability mechanism for mysql server. The problem is to find a way to assure that if the Data base machine go down, i assure however the services to the clients. Until now i found the COMPAQ solution LifeeKeeper for Linux Proliant clusters. does anybody knows if there is a free software solution? and if exists a measurement about the estimed reduction of performance (at least in percentage) if a reliability mecchanism with multiple mysqld solution? thank you in advance best regards Ornella - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL performances?
Hi, does any one used MySQL in real environment with big databases and a big number of connections? If yes, what's the hardware config? Thanks -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL performances?
Mohamed Sadok MOUHA schrieb: Hi, does any one used MySQL in real environment with big databases and a big number of connections? If yes, what's the hardware config? http://iworld.compaq.de -- http://it97.dyn.dhs.org -- IrmundThum - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL performances?
Well what exactly do you consider big? Mohamed Sadok MOUHA wrote: Hi, does any one used MySQL in real environment with big databases and a big number of connections? If yes, what's the hardware config? Thanks -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php