Henning Sprang wrote: > sascha mantscheff wrote: > >> I'm not using replication, but for a test if it really works I would >> do some data manipulations on the master and afterwards a complete >> mysqldump of master and replica and diff the result.
> ok, this is an new and interesting idea, has anyone an idea how long it > can take to diff two mysqldumps of 300 mb on a AMD 600 with 196 MB RAM? I think if there are just small differences the diff didn't take much longer than making a dump times two. But I got in throuble with this idea because after a mass update of records the subsequent diff used all memory an swap space. I think the size of the files should be less than the total RAM if you want to be sure that it will always work with the standard unix diff utility Rune --------------------------------------------------------------------- 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
