Find the answer to your Linux question:
Results 1 to 4 of 4
Having a bit of an issue with my Linux server and figured I would toss it in here to see if anyone could help. We're seeing MySQL progressively take more ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jun 2010
    Posts
    2

    MySQL Locking


    Having a bit of an issue with my Linux server and figured I would toss it in here to see if anyone could help. We're seeing MySQL progressively take more and more CPU and memory. We're not exactly sure what is causing it but in TOP it is reporting the following:

    CPU - 8.4 Memory - 1.8 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/***.***.com.pid --skip-external-locking

    It started off very low but over the last two months it has become worse. Since I am sort of a Linux newbie I am looking for anything that might be causing the issue or suggestions to how I could alleviate it or if this is normal. Any help would be much appreciated.

    Server Specs:
    Intel Xeon 3110 (Dual Core)
    4 GB RAM
    2x 250 GB (dual) HD
    MySQL 5.0.90-community
    PHP version 5.3.2
    Apache version 2.2.15

  2. #2
    Penguin of trust elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    3,653
    Please copy and paste the results of

    free

    here.
    "I used to be with it, then they changed what it was.
    Now what was it isn't it, and what is it is weird and scary to me.
    It'll happen to you too."

    Grandpa Simpson



    The Fifth Continent

  3. #3
    Just Joined!
    Join Date
    Jun 2010
    Posts
    2
    total used free shared buffers cached
    Mem: 4151928 1815052 2336876 0 243520 1211448
    -/+ buffers/cache: 360084 3791844
    Swap: 5678936 0 5678936

  4. $spacer_open
    $spacer_close
  5. #4
    Penguin of trust elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    3,653
    That looks fine to me. Most of the memory is being used as beffers and cache to speed things up. When it's needed for "real work" it will be automatically used.
    "I used to be with it, then they changed what it was.
    Now what was it isn't it, and what is it is weird and scary to me.
    It'll happen to you too."

    Grandpa Simpson



    The Fifth Continent

Posting Permissions

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