1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    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...