Thanks for the help Kent and the rest of the list,
Would be grateful for some help interpreting some mysql system
variables. Just to recap on what I am trying to achieve, I want
to load as much of a very large key file (224704512
mykeyfile.MYI) into RAM to improve selects.
I did a "show status;" and the mysql variables for the keys were
as follows :-
| Key_blocks_used | 7793 |
| Key_read_requests | 107315735 |
| Key_reads | 219450 |
| Key_write_requests | 0 |
| Key_writes | 0 |
Variable key_buffer_size is set to 8388600.
I understand that the key_buffer_size is in bytes so I have a 8MB
key buffer size. So I can increase this and that should improve
select speeds. That's great.
My QUESTION is : what do the "Key_read_requests" and "Key_reads"
figures tell me. Are they in bytes? I'm not quite sure how to use
them and interpret them to determine if select speeds are
improving?
Thanks everyone. This is such a great list!
Michael Thomas
> -----Original Message-----
> From: Kent Hoover [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 26, 2001 2:39 PM
> To: [EMAIL PROTECTED]
> Subject: Possible to load only index MYI file into RAM?
>
>
> You can tell MySQL to use (lots) more RAM to cache
> Index Keys by setting
>
> an explicit value for its key_buffer variable. You can use the
> SHOW STATUS query to determine the cache hit rate by
> comparing these
> two values: Key_reads versus Key_read_requests.
> Key_reads divided by
> Key_read_requests would give you the cache "miss rate".
>
> Cheers,
>
> Kent Hoover
>
>
>
---------------------------------------------------------------------
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
