Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Usuage of Swap Space

dvaddidvaddi EntrantInactive User Role Beginner
Hi,

On the mysql 5.0 linux 2.6 kernel . I see the RAM of 2.8 GB is used out of 3.0 GB. And the server slows down almost comes to a hang.

when I do a free -m or top , I always see the Swap is hardly used or not used at all.

Do I have to do something for the server to use the swap space and also how I can see if I have a swap file or partition.

Thanks for any help.

Comments

  • sterinsterin Mentor Inactive User Role Contributor
    You generally do not want to use the swap space.

    On databases where most of the allocated RAM is always used it is very bad to let the DB process get so big that the OS starts to use the swap.
    And the general rule is that it's better to use a bit less memory than risking that the OS starts to swap.

    So 2.8GB allocated out of 3G sounds very good.

    When your server starts to go slow does it have high CPU or high I/O load?
  • dvaddidvaddi Entrant Inactive User Role Beginner
    when the server starts to slow there is high CPU.

    Thanks
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.