On Tuesday 05 March 2002 01:17 am, Jeremy Zawodny wrote: > When the machine is pounding away on updates (over 300/sec), it can > take a long time to get a response to SHOW SLAVE STATUS. ?I get one, > but it can take between 5 and 30 seconds:
My first inclination was to blame FreeBSD threads, but then I decided I need to gather some more hard evidence before I could do it. Is SHOW SLAVE STATUS the only command that is that slow when this happens? Try SHOW PROCESSLIST, SHOW VARIABLES, SHOW STATUS, SHOW MASTER STATUS. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ --------------------------------------------------------------------- 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
