Hi!
>>>>> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote: >> My 4.0.2 slave has run through about 14 million queries and it's going >> well. Sasha> Good news >> >> Do you have any feel for how much slower a debugging version of MySQL >> is compared to a normal version? ?I ask because my replication >> heartbeat monitor has noticed this particular slave falling behind on >> replication a fair amount. ?It usually doesn't get too far behind, but >> it's certainly farther behind that it's neighbor--which has a slower >> CPU. Sasha> Depends on the queries. I would say it could be from 3 to 10 times slower. To Sasha> know for sure, use BUILD/compile-pentium instead of Sasha> BUILD/compile-pentium-debug. This will compile a perfectly optimal binary. If you are using --skip-safemalloc or just configure with --with-debug instead of --with-debug=full, the speed difference should not be larger than 15-35 % (This is from our manual). If you start mysqld with the --debug option, then things will be 3-10 times slower. <cut> Regards, Monty --------------------------------------------------------------------- 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
