I need someone who know Dedicated Server very well

Discussion in 'Site & Server Administration' started by rzoned, Apr 4, 2009.

0
  1. #1
    Hey Guys, here is my situation

    I have dedicated server, but I'm not into technical linux expert
    I got someone helping me before, but seems he can not know whats wrong this time

    here is my current cpu list

    PID : 31429
    USER :mysql
    Priority :0
    CPU :38.2
    Memory : 1.4
    /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/vrt.animecrusade.com.pid --skip-external-locking


    I got no idea, why this mysql take CPU so high
    and I dont think i have really big web (yet :) )that can load that high CPU

    I try to tracer and here it is
    Process 31429 attached - interrupt to quit
    select(13, [10 12], NULL, NULL, NULL) = 1 (in [12])
    fcntl64(12, F_SETFL, O_RDWR|O_NONBLOCK) = 0
    accept(12, {sa_family=AF_FILE, path="œ¿"}, [2]) = 15
    fcntl64(12, F_SETFL, O_RDWR) = 0
    getsockname(15, {sa_family=AF_FILE, path="/var/lib/mysql"}, [28]) = 0
    fcntl64(15, F_SETFL, O_RDONLY) = 0
    fcntl64(15, F_GETFL) = 0x2 (flags O_RDWR)
    fcntl64(15, F_SETFL, O_RDWR|O_NONBLOCK) = 0
    setsockopt(15, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
    time(NULL) = 1238829572
    clone(child_stack=0xb12ce4b4, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0xb12cebd8, {entry_number:6, base_addr:0xb12ceb90, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}, child_tidptr=0xb12cebd8) = 20527


    any advice how to trace and solve this problem ?
    I try disable the plugin2 in wordpress that I think cause, but so far none works

    if someone willing to help, then great.. :)
    or I can offer you bit cash if u can get this problem solved :)

    Thanks
     
    rzoned, Apr 4, 2009 IP
  2. rzoned

    rzoned Well-Known Member

    Messages:
    162
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #2
    here is the statistic on my server

    mysql 38.33 1.40 0.0
    Top Process %CPU 38.8 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/vrt.animecrusade.com.pid --skip-external-locking




    Server Load 0.40 (2 cpus)
    Memory Used 32.3 %
    Swap Used 0.00 %

    but sometime, server load can go high as 1.5
    i dunno if it is very high or not

    someone know about this ?
     
    rzoned, Apr 4, 2009 IP
  3. svrhost

    svrhost Peon

    Messages:
    127
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hi
    I can help you on this as I myself have a Dedicated Server :)
    Let me know if you still need help on this
     
    svrhost, Apr 4, 2009 IP
  4. lachrymologist

    lachrymologist Active Member

    Messages:
    456
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    70
    #4
    how big is your DB?
     
    lachrymologist, Apr 4, 2009 IP
  5. tera

    tera Peon

    Messages:
    159
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #5
    My men please cool 1.5 is not big enough but you must tell us if you have traffic and cache .

    see if server is swapping vmstat google it and research

    check how much traffic you have

    check if wp is caching the pages(usefull for sites with thousands of visitors)

    check log slow queries at mysql and then tell us the results also specs of server.
     
    tera, Apr 6, 2009 IP