The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL hogging memory after upgrade

Discussion in 'General Discussion' started by azzawazzi, May 26, 2006.

  1. azzawazzi

    azzawazzi Member

    Joined:
    Apr 21, 2006
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    Since upgrading to the latest Release version, MySQL is running a process that is hogging RAM and doesn't seem to end.

    In top it shows as:

    15032 mysql 15 0 523m 117m 4012 S 11.6 11.7 9:02.68 mysqld

    And it just runs until it's stopped.

    In the process viewer, it shows it as doing this:

    getsockname(16, {sa_family=AF_FILE, path="/var/lib/mysql"}, [28]) = 0
    fcntl64(16, F_SETFL, O_RDONLY) = 0
    fcntl64(16, F_GETFL) = 0x2 (flags O_RDWR)
    fcntl64(16, F_SETFL, O_RDWR|O_NONBLOCK) = 0
    setsockopt(16, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
    futex(0x8512084, FUTEX_WAKE, 1) = 1
    futex(0x8512080, FUTEX_WAKE, 1) = 1
    futex(0x8512370, FUTEX_WAKE, 1) = 1
    select(5, [3 4], NULL, NULL, NULL) = 1 (in [4])
    fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
    accept(4, {sa_family=AF_FILE, path="¨ƒ"}, [2]) = 872
    fcntl64(4, F_SETFL, O_RDWR) = 0

    Does anyone have any idea what is causing this? It's chewing up a LOT of memory!

    Azza.
     
  2. Adz

    Adz Member
    PartnerNOC

    Joined:
    Jul 2, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Same symptoms here on one of our servers but nothing on an identical server, identical spec, identical software.
     
  3. perfect-games

    perfect-games Well-Known Member

    Joined:
    Nov 11, 2004
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    alberta
    may i ask are you using mysql 5 latest cpanel release

    as there a bug i found in cpanel that mysql configs are not been updated

    if you need any help just send me a pm

    thanks

    steve
     
Loading...

Share This Page