1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

CPU resources jump with mysql 4? Help!

Discussion in 'Plesk for Linux - 8.x and Older' started by goosemoose, Jan 31, 2005.

  1. goosemoose

    goosemoose Guest

    0
     
    I finally got my host to upgrade mysql to version 4 and now my cpu resource have jumped in plesk from 50-60% on avg to 90-100% on average. My privvmpages is also hovering around 48k rather than the 38k it was before the update.

    Does anyone know why this is happening, or how to fix it? It's causing a huge slow down in my forum because of the lack of resources.

    Thanks
     
  2. goosemoose

    goosemoose Guest

    0
     
    Maybe this will help someone help me. here is a top while my site basically becomes nonresponsive.
    [root@login mytop]# top



    20:35:02 up 4:14, 1 user, load average: 0.13, 0.54, 0.70
    20:35:07 up 4:14, 1 user, load average: 0.12, 0.53, 0.69
    20:35:12 up 4:14, 1 user, load average: 0.11, 0.52, 0.69
    20:35:17 up 4:14, 1 user, load average: 0.10, 0.51, 0.68
    20:35:22 up 4:14, 1 user, load average: 0.09, 0.50, 0.68
    20:35:27 up 4:14, 1 user, load average: 0.08, 0.49, 0.68
    20:35:32 up 4:14, 1 user, load average: 0.08, 0.49, 0.67
    20:35:37 up 4:14, 1 user, load average: 0.07, 0.48, 0.67
    20:35:42 up 4:14, 1 user, load average: 0.07, 0.47, 0.66
    20:35:47 up 4:15, 1 user, load average: 0.06, 0.46, 0.66
    20:35:52 up 4:15, 1 user, load average: 0.06, 0.45, 0.66
    20:35:57 up 4:15, 1 user, load average: 0.05, 0.45, 0.65
    20:36:02 up 4:15, 1 user, load average: 0.05, 0.44, 0.65
    20:36:07 up 4:15, 1 user, load average: 0.04, 0.43, 0.64
    20:36:12 up 4:15, 1 user, load average: 0.04, 0.42, 0.64
    20:36:17 up 4:15, 1 user, load average: 0.04, 0.42, 0.64
    20:36:22 up 4:15, 1 user, load average: 0.03, 0.41, 0.63
    20:36:27 up 4:15, 1 user, load average: 0.03, 0.40, 0.63
    20:36:32 up 4:15, 1 user, load average: 0.03, 0.40, 0.63
    20:36:37 up 4:15, 1 user, load average: 0.02, 0.39, 0.62
    20:36:42 up 4:15, 1 user, load average: 0.02, 0.38, 0.62
    20:36:47 up 4:16, 1 user, load average: 0.02, 0.38, 0.62
    20:36:52 up 4:16, 1 user, load average: 0.02, 0.37, 0.61
    20:36:57 up 4:16, 1 user, load average: 0.02, 0.36, 0.61
    20:37:02 up 4:16, 1 user, load average: 0.02, 0.36, 0.61
    20:37:07 up 4:16, 1 user, load average: 0.01, 0.35, 0.60
    20:37:12 up 4:16, 1 user, load average: 0.01, 0.34, 0.60
    20:37:17 up 4:16, 1 user, load average: 0.01, 0.34, 0.60
    20:37:23 up 4:16, 1 user, load average: 0.01, 0.33, 0.59
    20:37:28 up 4:16, 1 user, load average: 0.01, 0.33, 0.59
    20:37:33 up 4:16, 1 user, load average: 0.01, 0.32, 0.59
    20:37:38 up 4:16, 1 user, load average: 0.01, 0.32, 0.58
    20:37:43 up 4:16, 1 user, load average: 0.01, 0.31, 0.58
    20:37:48 up 4:17, 1 user, load average: 0.01, 0.30, 0.58
    20:37:53 up 4:17, 1 user, load average: 0.08, 0.32, 0.58
    20:37:58 up 4:17, 1 user, load average: 0.08, 0.31, 0.57
    20:38:03 up 4:17, 1 user, load average: 0.07, 0.31, 0.57
    20:38:08 up 4:17, 1 user, load average: 0.07, 0.30, 0.57
    20:38:13 up 4:17, 1 user, load average: 0.06, 0.29, 0.56
    20:38:18 up 4:17, 1 user, load average: 0.06, 0.29, 0.56
    20:38:23 up 4:17, 1 user, load average: 0.05, 0.28, 0.56
    20:38:28 up 4:17, 1 user, load average: 0.05, 0.28, 0.55
    45 processes: 44 sleeping, 1 running, 0 zombie, 0 stopped
    CPU states: cpu user nice system irq softirq iowait idle
    total 0.0% 0.0% 0.4% 0.0% 0.0% 0.0% 399.2%
    cpu00 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
    cpu01 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
    cpu02 0.0% 0.0% 0.5% 0.0% 0.0% 0.0% 99.4%
    cpu03 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
    Mem: 8275180k av, 7649348k used, 625832k free, 0k shrd, 1586420k buff
    3043592k active, 3739952k inactive
    Swap: 16386292k av, 20436k used, 16365856k free 2100576k cached

    PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
    7953 root 15 0 1040 1040 740 R 0.5 0.0 0:01 2 top
    1 root 8 0 460 460 412 S 0.0 0.0 0:00 2 init
    9472 root 9 0 544 544 468 S 0.0 0.0 0:01 1 syslogd
    9501 root 9 0 1524 1524 1388 S 0.0 0.0 0:00 2 sshd
    9635 root 8 0 836 836 704 S 0.0 0.0 0:00 3 xinetd
    9653 root 9 0 1016 1016 876 S 0.0 0.0 0:00 2 safe_mysqld
    9737 mysql 9 0 28868 28M 3352 S 0.0 0.3 0:14 3 mysqld
    9969 root 9 0 21004 20M 2408 S 0.0 0.2 0:00 2 spamd
    10124 root 9 0 10524 10M 9888 S 0.0 0.1 1:26 3 httpd
    10503 root 9 0 4928 4924 4760 S 0.0 0.0 0:01 2 httpsd
    10543 root 9 0 576 576 508 S 0.0 0.0 0:00 1 crond


    and here is a mytop


    MySQL on localhost (4.0.23a) up 0+04:29:31 [20:50:27]
    Queries: 204.1k qps: 13 Slow: 20.0 Se/In/Up/De(%): 74/04/08/05

    Cache Hits: 115.3k Hits/s: 7.3 Hits now: 0.0 Ratio: 75.9% Ratio now: 0.0%
    Key Efficiency: 95.6% Bps in/out: 2.0k/21.5k

    Id User Host/IP DB Time Cmd Query or State
    -- ---- ------- -- ---- --- ----------
    6083 dmaricic localhost goosemoose 0 Query show full process
    6082 dmaricic localhost goosemoose 1 Query DELETE FROM mos_s
    6081 dmaricic localhost goosemoose 5 Query DELETE FROM mos_s
    6079 dmaricic localhost goosemoose 7 Query UPDATE mos_sessio
    6080 dmaricic localhost goosemoose 7 Query DELETE FROM mos_s
     
  3. goosemoose

    goosemoose Guest

    0
     
    Anybody? I'm still having this problem.
     
  4. yuriymos

    yuriymos Basic Pleskian

    23
    73%
    Joined:
    Jul 18, 2003
    Messages:
    31
    Likes Received:
    0
    I have the same problem.
    As I investigated PSA is causing the problem.
    If you turn it off and comment all cronjobs - mysql will be going fine
     
Loading...