On Tue, Sep 30, 2003 at 11:36:30AM -0700, Dathan Vance Pattishall wrote: > > Yes, I use a custom mytop (sent my patches in to you). In fact I'm > making a signed java applet to simulate mytop, just to be fancy ;) as > well as not having to ssh into a central box that can reach all my > servers.
Really? Which patch? Have I integrated it yet? :-) > I figured that but does it really matter on a dedicated slave handling > some reads, since there can never be parallel writes? I may be missing > the concept. Yes, you're missing something, I think. The key_buffer is part of what makes indexes fast for MyISAM tables. By keeping recently used index blocks in RAM, it doesn't need to hit the disk. This helps no matter how many readers/writers you have. It's a cache. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 586,742,904 queries (404/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]