SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot Offspring2099's Avatar
    Join Date
    May 2005
    Location
    Los Angeles, CA
    Posts
    182
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question key_buffer_size question

    Hello,

    I'm a little lost. I thought the reason why one should increase 'key_buffer_size' is so that the system doesn't page when indexing row(s), because this buffer is in physical memory and is now reserved for index buffers.

    So why is it when I increase the `key_buffer_size` my VM Size in Windows Xp grows proportionally?

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    are you talking about the VM size for the mysql process? VM size in XP does not refer to the amount of data on disk for that application. VM size is the amount of memory that the application has requested. not necessarily used, but requested.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  3. #3
    SitePoint Zealot Offspring2099's Avatar
    Join Date
    May 2005
    Location
    Los Angeles, CA
    Posts
    182
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by longneck View Post
    are you talking about the VM size for the mysql process? VM size in XP does not refer to the amount of data on disk for that application. VM size is the amount of memory that the application has requested. not necessarily used, but requested.
    Yes, that's what I'm talking about. And Thank You for the explanation.


Bookmarks

Posting Permissions

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