Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Unanswered: Key_writes and Key_write_requests

    Sorry so many questions lately. Anyway, I guess I just don't understand these stats. The Key_write_requests is the number of requests to write a key block to the cache and the Key_writes are the number of times it had to be written to disk instead, right? So wouldn't you want to have many more requests than writes?

    I have a MyISAM only database running with over 200 MBs free in the key buffer but my ratio is almost one. Most requests are being written to disk. Is this normal or do I need to tune some more variables?

    Thanks,
    Paco

  2. #2
    Join Date
    Feb 2005
    Location
    Germany
    Posts
    22
    Doc. fos this:
    http://dev.mysql.com/doc/refman/4.1/...variables.html

    the quotient write_requests/writes should be close to 1. If it's much smaller, your io subsystem is to slow. requests than could not be fullfilled.
    Greetings, Martin

    thats's my understanding, but i may be wrong

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •