Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 11 of 11
  1. #1
    Member
    Join Date
    Sep 2004
    Posts
    11

    Angry MySQL - high memory usage

    hi,
    i have the followning problem:

    if i chceck Main >> Server Status >> CPU/Memory/MySQL Usage i get a 113% usage of the memory on this process:

    mysql 3.72 113.07 0.0
    Top Process %CPU 6.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/srv1.compacthost.com.pid --skip-locking --port3306 --socket/var/lib/mysql/mysql.sock
    Top Process %CPU 4.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/srv1.compacthost.com.pid --skip-locking --port3306 --socket/var/lib/mysql/mysql.sock
    Top Process %CPU 2.2 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/srv1.compacthost.com.pid --skip-locking --port3306 --socket/var/lib/mysql/mysql.sock

    the CPU usage is normal, it has to do something with sessions, if i delete the session data in the tmp folder, the memory usage goes down... someone told me that this helps.. yep it helps but in 3-4 days is the mem usage again high.. perhaps is the MySQL configuration wrong?!

    can somebody help me?

    thanks

  2. #2
    Member
    Join Date
    Mar 2004
    Location
    This Planet
    Posts
    984

    Default

    Oh i checked mine and found it to be that high almost in all daily reports. This spiking has started from 5th March 2006 and nothing much has been done on server except for running ./upcp

    Not really sure if anything has changed after 5th March 2005 from cPanel's end. I am on CURRENT Tree

    Anybody else seeing this??

    TIA
    Anup

  3. #3
    Member
    Join Date
    Apr 2005
    Posts
    28

    Default

    yes most of my servers with current cpanel builds are showing HIGH mysql ram usage too. this is really bugging me ... cpanel pro's can you answer is this bug or some nuts and bolts need to tighten?

  4. #4
    Member
    Join Date
    Jun 2003
    Location
    USA - Baltimore
    Posts
    52

    Default

    same problem over here..

  5. #5
    Member
    Join Date
    Jun 2004
    Location
    Southern California
    Posts
    255

    Default yes i'm experiencing that daily as well

    yes i experience it on my 2 servers as well.

  6. #6
    Member
    Join Date
    Jun 2004
    Location
    Southern California
    Posts
    255

    Default bump

    any response to this. have done some searches with no positive result.

  7. #7
    Member
    Join Date
    Mar 2002
    Location
    Alberta, Canada
    Posts
    1,509

    Default

    Had the same problem on a Server also using Current and switching to Release solved the problem.
    Helping people Host, Create, and Maintain their Web Site
    Also providing Server Admin Services - setup / troubleshooting

    http://potentproducts.com/

  8. #8
    Member
    Join Date
    Jun 2004
    Location
    Southern California
    Posts
    255

    Default already in release update mode and no luck

    my server is set to release and from the last 2 updates I've run over the past month it's been the same problem.

  9. #9
    Member
    Join Date
    Dec 2005
    Location
    UK, Milton Keynes
    Posts
    26

    Default

    Any updates on this? I am having the same problem.

  10. #10
    Member kship's Avatar
    Join Date
    Oct 2004
    Location
    HUNTSVILLE, TEXAS
    Posts
    21

    Default same

    same here as well

  11. #11
    Member kship's Avatar
    Join Date
    Oct 2004
    Location
    HUNTSVILLE, TEXAS
    Posts
    21

    Default possible fix

    remove the advanced guestbook from the server completely and remove any instances of it installed. I did this and the server has been purring nicely since.

Similar Threads & Tags
Similar threads

  1. Replies: 1
    Last Post: 02-11-2010, 02:58 AM
  2. High memory usage
    By Guigows in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 06-18-2008, 11:25 AM
  3. VERY high memory usage
    By mpi in forum New User Questions
    Replies: 8
    Last Post: 02-05-2007, 04:30 AM
  4. I really need your help, high Memory Usage
    By lexmark in forum cPanel and WHM Discussions
    Replies: 71
    Last Post: 11-24-2004, 06:57 AM
  5. High CPU / Memory Usage
    By gal3ler in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 01-16-2004, 08:19 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube