On Tue, Sep 30, 2003 at 11:07:59AM -0700, Dathan Vance Pattishall wrote:
> -->-----Original Message-----
> -->From: Jeremy Zawodny [mailto:Jeremy@stripped]
> -->Sent: Tuesday, September 30, 2003 10:23 AM
> -->To: Dathan Vance Pattishall
> -->Cc: mysql@stripped
> -->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
> -->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 D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 586,536,970 queries (405/sec. avg)