Hi.
On Fri, Feb 16, 2001 at 03:05:35AM -0500, [EMAIL PROTECTED] wrote:
> Hello, I have a large database with a lot of queries and was trying to
> tune MySQL to get the best performance. I was reading the manuals and it
> said to set the key_buffer_size to the best value, you take the first
> two of the following values and divide by each other. I believe it said
> you should get less then 1%. I was not able to figure out what the best
> setting for me to be using was, so I am looking for help. Here are the
> values:
>
> | Key_read_requests | 2983998650 |
> | Key_reads | 2139560 |
This gets you less than 0.1%, i.e. good.
> | Key_write_requests | 744067782 |
> | Key_writes | 351704288 |
>
> The machine has 2 gigs of ram and currently the key_buffer_size is set
> to 800M. I was wondering if I should increase or decrease the value to
> get the best performance gain.
Have a look at the status of Key_blocks_used. If it is far below the
value of your key_buffer setting (regarding a key block has 1024
bytes), you want to decrease it (to let more memory for OS file system
caching).
Bye,
Benjamin.
---------------------------------------------------------------------
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
