On Tue, Mar 05, 2002 at 12:13:25PM -0800, Jeremy Zawodny wrote: > On Tue, Mar 05, 2002 at 09:19:35AM -0700, Sasha Pachev wrote: > > 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? > > Yes. > > > Try SHOW PROCESSLIST, SHOW VARIABLES, SHOW STATUS, SHOW MASTER > > STATUS. > > Tried all of them and they're fast.
Just an update for you, Sasha. My 4.0.2 slave has run through about 14 million queries and it's going well. 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. And could that fact have anything to do with SHOW SLAVE STATUS being slow sometimes? Thanks! Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 27 days, processed 977,270,881 queries (407/sec. avg) --------------------------------------------------------------------- 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
