On Tue, Sep 30, 2003 at 11:07:59AM -0700, Dathan Vance Pattishall wrote: > > -->-----Original Message----- > -->From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > -->Sent: Tuesday, September 30, 2003 10:23 AM > -->To: Dathan Vance Pattishall > -->Cc: [EMAIL PROTECTED] > -->Subject: Re: What are the effects of key_buffer on a dedicated slave > > > -->Is that all your slave is doing? Replicating from the master? Are > there > -->no other queries being run against it? > --> > > It takes 50% of all reads from the application the db supports.
The first thing I'd do is figure how how well utilized the key buffer is today. Either grab a copy of mytop (it does it for you), or look at SHOW STATUS to compute the percentage based on the ratio of key_read_requests to key_reads. If you're already hitting the buffer 99% of the time, there's little point in increasing the size. 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,536,970 queries (405/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
