On Sat, Mar 02, 2002 at 09:57:58PM -0800, Jeremy Zawodny wrote:
>
> Murphy's law strikes! Just a few hours ago I blasted the relay logs
> on my 4.0.2 slave. It ran out of disk space!
>
> I'll rsync the slave and build a fresh MySQL from the bitkeeper tree
> and let you know.
Sasha,
I re-synced my 4.x slave and updated with the latest BitKeeper code
and compile-pentium-debug. It is chugging along well now, but I've
noticed something odd.
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:
---snip---
mysql> show slave status \G
*************************** 1. row ***************************
Master_Host: db.finance.yahoo.com
Master_User: repl
Master_Port: 3306
Connect_retry: 15
Master_Log_File: binary-log.042
Read_Master_Log_Pos: 211593316
Relay_Log_File: db3-relay-bin.001
Relay_Log_Pos: 288092868
Relay_Master_Log_File: binary-log.042
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_do_db:
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 211155824
1 row in set (24.79 sec)
---snip---
Any ideas?
This is on FreeBSD 4.3 if that matters.
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 25 days, processed 867,644,812 queries (389/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
