Previous Thread
Next Thread
Print Thread
Rate Thread
#249282 06/06/2003 8:34 PM
Joined: Sep 2001
Posts: 129
Member
Member
Offline
Joined: Sep 2001
Posts: 129
What are you guys getting as a ratio for key_requests/key reads I cant seem to get this higher than 160, before I upped the key_buffer from 32Mb to 384Mb it was only 100 the with 384Mb it was about 160 I have now upped it to 512Mb and its still 160.

In that tuning artical on one of the other posts it hint at this figure being over 1000 !

My info:
Key_read_requests 53846996
Key_reads 341678
key_buffer_size 536866816

is there a way I can see the what the highest use of the 512mb has been ? I can work out an averge using the uptime but cant see a max figure.


Regards
Clint

Running on WIN2003 Web Server.

Paranoid people get followed too!
Sponsored Links
Joined: Apr 2003
Posts: 10
Newbie
Newbie
Offline
Joined: Apr 2003
Posts: 10
You can find out the usage of you Key Buffer with the following:

Cache Miss Rate = Key_reads / Key_reads_requests

The Cache Miss Rate should be smaller than 0.01.
I think with your 0.006 you are good.

The usage of your Key Buffer is shown in the Key blocks used value in the output of SHOW STATUS

So long...

Indy

Edit: You can use the Cache Miss Rate for finding an optimal size for your Key Buffer. Decrement the size and let MySQL run for while. Then take a look again, if the CMR is not higher, then the smaller size will be ok.

Last edited by indy; 06/07/2003 7:10 AM.

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)