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. 06-27-2010 #1
    sado
    sado is offline
    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
    Reply With Quote Reply With Quote
  2. 06-27-2010 #2
    elija
    elija is offline
    Penguin of trust elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    2,843
    Please copy and paste the results of

    free

    here.
    If we hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate! (Zapp Brannigan)


    My new blog. It's probably not as good as I think it is.

    The Fifth Continent reborn
    Reply With Quote Reply With Quote
  3. 06-27-2010 #3
    sado
    sado is offline
    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
    Reply With Quote Reply With Quote
  4. 06-27-2010 #4
    elija
    elija is offline
    Penguin of trust elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    2,843
    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.
    If we hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate! (Zapp Brannigan)


    My new blog. It's probably not as good as I think it is.

    The Fifth Continent reborn
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules