Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    1,056

    Question Swap not used at all... good or bad?

    On one of our MySQL only servers, swap is not used at all.

    free
    total used free shared buffers cached
    Mem: 2055392 2007020 48372 0 12216 1037364
    -/+ buffers/cache: 957440 1097952
    Swap: 2040212 0 2040212

    Is this good or bad? Shouldn't we allocate more memory to MySQL? Would this improve the overall perfomance?

    The server use 2 SCSI HDs, MySQL is on the second one. I assume swap is allocated from the 1st HD. Your comments are welcome.
    Founder of TradeHolding.com B2B Network and OneLoveNet.com Singles & Dating
    >> Business Blog
    >> Business Links Directory

  2. #2
    Join Date
    Apr 2003
    Location
    UK
    Posts
    2,560
    thats good - swap is where memory is being paged to disk, which is a lot slower than pure memory on chip (ie ram)

  3. #3
    Join Date
    Jun 2002
    Posts
    1,056
    All right, thanks for the info. So allocating more memory to MySQL would probably not improve things, right?
    Founder of TradeHolding.com B2B Network and OneLoveNet.com Singles & Dating
    >> Business Blog
    >> Business Links Directory

Posting Permissions

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