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 |
| 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.
Also what is the "have_raid" setting used only when software raid is in
effect? and what is a typical query_buffer_size for a database that does
about 100 inserts a second?
Thanks
---------------------------------------------------------------------
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
