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 upgrd to 5 caused higher load avg, need optimization help

Discussion in 'Workarounds and Optimization' started by davus, Aug 24, 2012.

  1. davus

    davus Member

    Joined:
    Aug 23, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi everyone,

    We recently upgraded to MySQL 5 from 4, prior to that the load avg stayed around 1.0 or below, now it seems to hang around 4.

    I ran mysqltuner and got these results:
    Code:
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.5.24-cll
    [OK] Operating on 32-bit architecture with less than 2GB RAM
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 2G (Tables: 212)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [!!] InnoDB is enabled but isn't being used
    [!!] Total fragmented tables: 2
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 11s (6K q [564.818 qps], 240 conn, TX: 4M, RX: 378K)
    [--] Reads / Writes: 97% / 3%
    [--] Total buffers: 1.2G global + 2.7M per thread (151 max threads)
    [OK] Maximum possible memory usage: 1.6G (78% of installed RAM)
    [OK] Slow queries: 0% (0/6K)
    [OK] Highest usage of available connections: 2% (4/151)
    [OK] Key buffer size / total MyISAM indexes: 1.0G/696.2M
    [!!] Key buffer hit rate: 75.9% (1K cached / 361 reads)
    [OK] Query cache efficiency: 97.4% (5K cached / 5K selects)
    [OK] Query cache prunes per day: 0
    [OK] Temporary tables created on disk: 0% (0 on disk / 231 total)
    [OK] Thread cache hit rate: 98% (4 created / 240 connections)
    [OK] Table cache hit rate: 85% (41 open / 48 opened)
    [OK] Open file limit used: 2% (49/2K)
    [OK] Table locks acquired immediately: 100% (171 immediate / 171 locks)
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Add skip-innodb to MySQL configuration to disable InnoDB
        Run OPTIMIZE TABLE to defragment tables for better performance
        MySQL started within last 24 hours - recommendations may be inaccurate
    
    Here is my config file:
    Code:
    [mysqld]
    log-error="/var/lib/mysql/errorlog"
    table_cache=1024
    old-passwords=1
    skip-external-locking
    default-storage-engine=MyISAM
    innodb_file_per_table=1
    
    #customizations
    slow-query-log = TRUE
    slow-query-log-file =/var/lib/mysql/mysql.slow.log
    long_query_time = 2
    key_buffer_size=1024M
    query_cache_size=8M
    thread_cache_size=4
    
    and a mysqlreport result:
    Code:
    Use of uninitialized value in multiplication (*) at ./mysqlreport line 829.
    Use of uninitialized value in formline at ./mysqlreport line 1227.
    Use of uninitialized value in formline at ./mysqlreport line 1235.
    MySQL 5.5.24-cll         uptime 0 0:0:59        Fri Aug 24 14:31:00 2012
    
    __ Key _________________________________________________________________
    Buffer used   735.00k of  32.00M  %Used:   2.24
      Current       4.40M            %Usage:  13.76
    Write hit       0.00%
    Read hit       99.49%
    
    __ Questions ___________________________________________________________
    Total          39.52k   669.9/s
      DMS          33.65k   570.3/s  %Total:  85.14
      Com_          4.40k    74.6/s           11.14
      COM_QUIT      1.58k    26.8/s            4.00
      -Unknown        110     1.9/s            0.28
    Slow 2 s            0       0/s            0.00  %DMS:   0.00  Log:  ON
    DMS            33.65k   570.3/s           85.14
      SELECT       33.65k   570.3/s           85.13         99.99
      UPDATE            4     0.1/s            0.01          0.01
      REPLACE           0       0/s            0.00          0.00
      DELETE            0       0/s            0.00          0.00
      INSERT            0       0/s            0.00          0.00
    Com_            4.40k    74.6/s           11.14
      set_option    1.47k    24.9/s            3.72
      change_db     1.47k    24.9/s            3.71
      show_tables   1.46k    24.8/s            3.70
    
    __ SELECT and Sort _____________________________________________________
    Scan           33.63k   570.0/s %SELECT:  99.96
    Range           1.46k    24.8/s            4.35
    Full join           0       0/s            0.00
    Range check         0       0/s            0.00
    Full rng join       0       0/s            0.00
    Sort scan           1     0.0/s
    Sort range          0       0/s
    Sort mrg pass       0       0/s
    
    __ Table Locks _________________________________________________________
    Waited              0       0/s  %Total:   0.00
    Immediate      33.68k   570.9/s
    
    __ Tables ______________________________________________________________
    Open               58 of 1024    %Cache:   5.66
    Opened             65     1.1/s
    
    __ Connections _________________________________________________________
    Max used           15 of  151      %Max:   9.93
    Total           1.58k    26.8/s
    
    __ Created Temp ________________________________________________________
    Disk table          1     0.0/s
    Table           1.47k    24.8/s    Size:  16.0M
    File                6     0.1/s
    
    __ Threads _____________________________________________________________
    Running             2 of    4
    Cached              0 of    0      %Hit:   0.06
    Created         1.58k    26.8/s
    Slow                0       0/s
    
    __ Aborted _____________________________________________________________
    Clients             0       0/s
    Connects          107     1.8/s
    
    __ Bytes _______________________________________________________________
    Sent           25.67M  435.1k/s
    Received        2.41M   40.8k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage           2.25M of 127.98M  %Used:   1.76
    Read hit       70.65%
    Pages
      Free          8.05k            %Total:  98.24
      Data            144                      1.76 %Drty:   0.00
      Misc              0                      0.00
      Latched                                  0.00
    Reads             494     8.4/s
      From file       145     2.5/s           29.35
      Ahead Rnd         0       0/s
      Ahead Sql                 0/s
    Writes              0       0/s
    Flushes             0       0/s
    Wait Free           0       0/s
    
    __ InnoDB Lock _________________________________________________________
    Waits               0       0/s
    Current             0
    Time acquiring
      Total             0 ms
      Average           0 ms
      Max               0 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads           155     2.6/s
      Writes            3     0.1/s
      fsync             3     0.1/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created           0       0/s
      Read            144     2.4/s
      Written           0       0/s
    
    Rows
      Deleted           0       0/s
      Inserted          0       0/s
      Read              0       0/s
      Updated           0       0/s
    
    Any ideas? I tried reading through the tutorials on how to analyze these reports and made a few changes, but the load average doesn't look like it's improved any.

    sorry, here's my 'top' data:
    Code:
    top - 15:51:59 up 1 day, 16:57,  5 users,  load average: 5.67, 4.90, 4.72
    Tasks: 268 total,   2 running, 254 sleeping,  11 stopped,   1 zombie
    Cpu(s): 36.5%us, 21.3%sy,  0.4%ni, 41.0%id,  0.3%wa,  0.1%hi,  0.5%si,  0.0%st
    Mem:   2075264k total,  1908228k used,   167036k free,   122080k buffers
    Swap:  4192956k total,       80k used,  4192876k free,  1049012k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                      
     5936 formyip   19   0     0    0    0 Z  3.9  0.0   0:00.02 php <defunct>                                                                                
    18664 mysql     15   0 1357m 168m 5128 S  3.9  8.3   2:10.17 mysqld                                                                                       
     5927 root      15   0  2420 1032  704 R  2.0  0.0   0:00.01 top                                                                                          
     8146 nobody    16   0 13532 4452 1600 S  2.0  0.2   0:00.35 httpd                                                                                        
    31134 nobody    15   0 13532 4580 1732 S  2.0  0.2   0:00.18 httpd                                                                                        
    31206 nobody    15   0 13532 4596 1752 S  2.0  0.2   0:00.05 httpd                                                                                        
        1 root      15   0  2156  652  564 S  0.0  0.0   0:01.05 init                                                                                         
        2 root      RT  -5     0    0    0 S  0.0  0.0   0:07.20 migration/0                                                                                  
        3 root      34  19     0    0    0 S  0.0  0.0   0:02.65 ksoftirqd/0                                                                                  
        4 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/0                                                                                   
        5 root      RT  -5     0    0    0 S  0.0  0.0   0:12.71 migration/1                                                                                  
        6 root      34  19     0    0    0 S  0.0  0.0   0:03.95 ksoftirqd/1                                                                                  
        7 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/1                                                                                   
        8 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 events/0                                                                                     
        9 root      10  -5     0    0    0 S  0.0  0.0   0:00.01 events/1                                                                                     
       10 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khelper                                                                                      
       11 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 kthread                                                                                      
       15 root      10  -5     0    0    0 S  0.0  0.0   0:00.14 kblockd/0                                                                                    
       16 root      11  -5     0    0    0 S  0.0  0.0   0:00.36 kblockd/1                                                                                    
       17 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 kacpid                                                                                       
       89 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/0                                                                                     
       90 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/1                                                                                     
       93 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khubd                                                                                        
       95 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kseriod                                                                                      
      161 root      15   0     0    0    0 S  0.0  0.0   0:01.95 pdflush                                                                                      
      163 root      10  -5     0    0    0 S  0.0  0.0   0:04.76 kswapd0                                                                                      
      164 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 aio/0                                                                                        
      165 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 aio/1                                                                                        
      325 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 kpsmoused                                                                                    
      356 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 ata/0                                                                                        
      357 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 ata/1                                                                                        
      358 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 ata_aux                                                                                      
      362 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0                                                                                    
      363 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_1                                                                                    
      370 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 kstriped                                                                                     
      383 root      10  -5     0    0    0 S  0.0  0.0   0:37.95 kjournald                                                                                    
      408 root      17  -5     0    0    0 S  0.0  0.0   0:00.08 kauditd                                                                                      
      429 nobody    15   0 13532 4624 1768 S  0.0  0.2   0:00.03 httpd                                                                                        
      441 root      21  -4  2388  624  372 S  0.0  0.0   0:00.09 udevd                                                                                        
      447 nobody    15   0 13532 4448 1600 S  0.0  0.2   0:00.12 httpd                                                                                        
      746 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
      899 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kedac                                                                                        
     1192 nobody    15   0 13532 4436 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     1195 nobody    16   0 13532 4436 1592 S  0.0  0.2   0:00.04 httpd                                                                                        
     1263 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/0                                                                                    
     1264 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/1                                                                                    
     1265 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 kmpath_handlerd                                                                              
     1275 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     1279 nobody    16   0 13532 4432 1592 S  0.0  0.2   0:00.04 httpd                                                                                        
     1280 nobody    15   0 13532 4440 1592 S  0.0  0.2   0:00.02 httpd                                                                                        
     1281 nobody    16   0 13532 4436 1592 S  0.0  0.2   0:00.05 httpd                                                                                        
     1283 nobody    15   0 13532 4440 1596 S  0.0  0.2   0:00.00 httpd                                                                                        
     1284 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     1288 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kjournald                                                                                    
     1332 nobody    15   0 13532 4596 1748 S  0.0  0.2   0:00.02 httpd                                                                                        
     1334 nobody    15   0 13532 4432 1592 S  0.0  0.2   0:00.02 httpd                                                                                        
     1335 nobody    16   0 13532 4436 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     1336 nobody    16   0 13532 4436 1596 S  0.0  0.2   0:00.04 httpd                                                                                        
     1337 nobody    15   0 13532 4436 1592 S  0.0  0.2   0:00.02 httpd                                                                                        
     1338 nobody    17   0 13532 4408 1576 S  0.0  0.2   0:00.01 httpd                                                                                        
     1339 nobody    16   0 13532 4440 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     1343 nobody    20   0 13532 4428 1596 S  0.0  0.2   0:00.00 httpd                                                                                        
     1346 nobody    16   0 13532 4444 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     1348 nobody    16   0 13532 4444 1596 S  0.0  0.2   0:00.03 httpd                                                                                        
     1349 nobody    15   0 13532 4524 1680 S  0.0  0.2   0:00.01 httpd                                                                                        
     1533 root       0 -20     0    0    0 S  0.0  0.0   0:30.36 loop0                                                                                        
     1534 root      10  -5     0    0    0 S  0.0  0.0   0:11.29 kjournald                                                                                    
     1579 root      10  -5     0    0    0 S  0.0  0.0   0:00.10 kondemand/0                                                                                  
     1580 root      10  -5     0    0    0 S  0.0  0.0   0:00.01 kondemand/1                                                                                  
     1601 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 iscsi_eh                                                                                     
     1656 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 ib_addr                                                                                      
     1666 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_mcast                                                                                     
     1667 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_inform                                                                                    
     1668 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 local_sa                                                                                     
     1671 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 iw_cm_wq                                                                                     
     1675 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_cm/0                                                                                      
     1676 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_cm/1                                                                                      
     1681 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 rdma_cm                                                                                      
     1695 root      10 -10 32744  31m 1716 S  0.0  1.6   0:00.04 iscsiuio                                                                                     
     1700 root      18   0  2356  408  340 S  0.0  0.0   0:00.60 iscsid                                                                                       
     1701 root       5 -10  2816 2812 1888 S  0.0  0.1   0:00.00 iscsid                                                                                       
     1775 nobody    20   0 13532 4436 1592 S  0.0  0.2   0:00.02 httpd                                                                                        
     1876 sage      18   0  2388  768  632 S  0.0  0.0   0:00.00 imapd                                                                                        
     1990 root      15  -4 12652  792  544 S  0.0  0.0   0:01.61 auditd                                                                                       
     1992 root       7  -8 13188  888  576 S  0.0  0.0   0:00.43 audispd                                                                                      
     2005 root      15   0  5732 2440 1380 S  0.0  0.1   0:00.06 couriertls                                                                                   
     2080 nobody    18   0 13532 4428 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
     2085 nobody    16   0 13532 4436 1596 S  0.0  0.2   0:00.01 httpd                                                                                        
     2087 nobody    15   0 13532 4436 1596 S  0.0  0.2   0:00.01 httpd                                                                                        
     2089 nobody    21   0 13532 4436 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
     2174 root      15   0  1812  572  480 S  0.0  0.0   0:04.11 syslogd                                                                                      
     2177 root      15   0  1760  412  344 S  0.0  0.0   0:00.00 klogd                                                                                        
     2191 root      15   0  2560  376  272 S  0.0  0.0   0:00.81 irqbalance                                                                                   
     2237 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 rpciod/0                                                                                     
     2238 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 rpciod/1                                                                                     
     2252 root      18   0  1744  320  256 S  0.0  0.0   0:00.24 courierlogger                                                                                
     2253 root      18   0  2092  628  520 S  0.0  0.0   0:00.00 authdaemond                                                                                  
     2257 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     2261 nobody    16   0 13532 4440 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
     2265 nobody    15   0 13532 4432 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
     2288 root      25   0  5940  652  308 S  0.0  0.0   0:00.00 rpc.idmapd                                                                                   
     2289 root      18   0  2092  376  264 S  0.0  0.0   0:00.20 authdaemond                                                                                  
     2290 root      17   0  2092  376  264 S  0.0  0.0   0:00.23 authdaemond                                                                                  
     2291 root      18   0  2092  376  264 S  0.0  0.0   0:00.22 authdaemond                                                                                  
     2292 root      18   0  2092  376  264 S  0.0  0.0   0:00.24 authdaemond                                                                                  
     2293 root      18   0  2092  376  264 S  0.0  0.0   0:00.24 authdaemond                                                                                  
     2297 nobody    16   0 13532 4428 1596 S  0.0  0.2   0:00.00 httpd                                                                                        
     2300 nobody    17   0 13532 4424 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
     2301 nobody    15   0 13532 4600 1748 S  0.0  0.2   0:00.01 httpd                                                                                        
     2302 nobody    15   0 13532 4440 1596 S  0.0  0.2   0:00.01 httpd                                                                                        
     2323 dbus      15   0  2848  924  720 S  0.0  0.0   0:00.13 dbus-daemon                                                                                  
     2337 root      24   0  2252  772  668 S  0.0  0.0   0:00.00 hcid                                                                                         
     2343 root      24   0  1828  496  432 S  0.0  0.0   0:00.00 sdpd                                                                                         
     2366 root       8 -10     0    0    0 S  0.0  0.0   0:00.00 krfcommd                                                                                     
     2413 root      18   0 12952 1304  548 S  0.0  0.1   0:12.04 pcscd                                                                                        
     2427 root      18   0  1756  540  456 S  0.0  0.0   0:00.00 acpid                                                                                        
     2446 root      25   0  2004  456  372 S  0.0  0.0   0:00.00 hidd                                                                                         
     2478 nobody    20   0 13532 4428 1596 S  0.0  0.2   0:00.01 httpd                                                                                        
     2483 root      23   0 27388 1376 1064 S  0.0  0.1   0:00.74 automount                                                                                    
     2490 nobody    15   0 13532 4444 1600 S  0.0  0.2   0:00.02 httpd                                                                                        
     2498 nobody    16   0 13532 4440 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     2507 root      18   0  7244 1040  636 S  0.0  0.1   0:00.49 sshd                                                                                         
     2520 root      18   0 10248 2328 1692 S  0.0  0.1   0:00.00 cupsd                                                                                        
     2536 root      25   0  2832  832  652 S  0.0  0.0   0:00.00 xinetd                                                                                       
     2746 root      16   0  1744  320  256 S  0.0  0.0   0:00.08 courierlogger                                                                                
     2747 root      18   0  1856  532  456 S  0.0  0.0   0:00.07 couriertcpd                                                                                  
     2753 root      18   0  1744  324  256 S  0.0  0.0   0:00.00 courierlogger                                                                                
     2754 root      15   0  1856  528  456 S  0.0  0.0   0:00.01 couriertcpd                                                                                  
     2759 root      18   0  1744  320  256 S  0.0  0.0   0:00.82 courierlogger                                                                                
     2760 root      18   0  1856  528  456 S  0.0  0.0   0:00.87 couriertcpd                                                                                  
     2765 root      18   0  1744  324  256 S  0.0  0.0   0:00.63 courierlogger                                                                                
     2766 root      15   0  1856  532  456 S  0.0  0.0   0:00.56 couriertcpd                                                                                  
     2776 nobody    15   0 13532 4440 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     2777 nobody    16   0 13532 4436 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
     2778 nobody    15   0 13532 4412 1572 S  0.0  0.2   0:00.01 httpd                                                                                        
     2779 nobody    16   0 13532 4432 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
     2781 nobody    15   0 13532 4428 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
     2782 nobody    15   0 13532 4432 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     2787 nobody    15   0 13532 4440 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
     2866 root      22   0  160m 118m 7092 S  0.0  5.8   0:34.60 clamd                                                                                        
     2873 mailnull  15   0 10280 1776  572 S  0.0  0.1   0:00.89 exim                                                                                         
     2939 root      15   0  7696 1468 1104 S  0.0  0.1   0:00.32 pure-ftpd                                                                                    
     2941 root      18   0  7140 1232  984 S  0.0  0.1   0:00.13 pure-authd                                                                                   
     2956 root      17   0  5376 1100  568 S  0.0  0.1   0:00.30 crond                                                                                        
     2987 xfs       15   0  3396 1112  764 S  0.0  0.1   0:00.00 xfs                                                                                          
     3021 root      18   0  2356  476  356 S  0.0  0.0   0:00.00 atd                                                                                          
     3286 nobody    16   0 13532 4600 1748 S  0.0  0.2   0:00.25 httpd                                                                                        
     3589 formyip   33  18 25884  12m  724 S  0.0  0.6   0:00.95 cpanellogd                                                                                   
     3590 formyip   33  18  1736  408  352 S  0.0  0.0   0:00.99 logrunner                                                                                    
     3591 formyip   34  19  7452 5072  988 T  0.0  0.2   2:03.79 webalizer                                                                                    
     3628 root      18   0 18012 9644  692 S  0.0  0.5   0:00.47 cpdavd                                                                                       
     4657 root      18   0  6072 3856 1488 S  0.0  0.2   0:00.29 queueprocd                                                                                   
     5027 root      15   0 15916 9140 2048 S  0.0  0.4   0:01.29 cpsrvd-ssl                                                                                   
     5635 nobody    15   0 13532 4388 1572 S  0.0  0.2   0:00.00 httpd                                                                                        
     5689 nobody    17   0 13532 4368 1564 S  0.0  0.2   0:00.00 httpd                                                                                        
     5690 nobody    15   0 13532 4388 1576 S  0.0  0.2   0:00.00 httpd                                                                                        
     6168 root      15   0 22264 6704 1888 S  0.0  0.3   0:16.61 tailwatchd                                                                                   
     6266 nobody    16   0 13532 4632 1768 S  0.0  0.2   0:00.24 httpd                                                                                        
     6446 root      17   0  3820  528  436 S  0.0  0.0   0:04.20 rhnsd                                                                                        
     6610 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.19 httpd                                                                                        
     6638 avahi     18   0  2696 1300 1116 S  0.0  0.1   0:00.02 avahi-daemon                                                                                 
     6639 avahi     19   0  2696  432  296 S  0.0  0.0   0:00.00 avahi-daemon                                                                                 
     6699 haldaemo  19   0  6008 4004 1612 S  0.0  0.2   0:00.93 hald                                                                                         
     6700 root      18   0  3264 1000  848 S  0.0  0.0   0:00.00 hald-runner                                                                                  
     6774 haldaemo  15   0  2104  832  736 S  0.0  0.0   0:00.00 hald-addon-acpi                                                                              
     7071 root      23   0  1768  416  332 S  0.0  0.0   0:00.00 portsentry                                                                                   
     7187 named     18   0 73388  26m 2104 S  0.0  1.3   4:15.71 named                                                                                        
     7329 root      21   0 13116  10m 1408 S  0.0  0.5   0:30.91 mrtg                                                                                         
     7790 root      18   0  3660  548  344 S  0.0  0.0   0:00.02 smartd                                                                                       
     7793 root      22   0  1744  452  396 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7794 root      23   0  1744  448  396 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7795 root      18   0  1744  452  396 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7796 root      22   0  1744  452  396 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7804 root      22   0  1744  452  396 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7811 root      22   0  1744  456  396 S  0.0  0.0   0:00.00 mingetty                                                                                     
     8070 nobody    15   0 13532 4608 1748 S  0.0  0.2   0:00.41 httpd                                                                                        
     8211 nobody    15   0 13532 4452 1596 S  0.0  0.2   0:00.09 httpd                                                                                        
     8578 root      15   0 10248 2996 2420 S  0.0  0.1   0:00.83 sshd                                                                                         
     8688 root      34  19 25972  10m 2148 S  0.0  0.5   0:00.25 yum-updatesd                                                                                 
     8756 root      34  19  2656 1160  948 S  0.0  0.1   0:01.45 gam_server                                                                                   
     8948 root      15   0  4764 1440 1176 S  0.0  0.1   0:00.02 bash                                                                                         
     9357 root      16   0 10248 3040 2420 S  0.0  0.1   0:00.41 sshd                                                                                         
    10107 nobody    15   0 13532 4468 1608 S  0.0  0.2   0:00.06 httpd                                                                                        
    10114 nobody    15   0 13532 4468 1612 S  0.0  0.2   0:00.17 httpd                                                                                        
    10522 root      15   0 10116 2988 2412 S  0.0  0.1   0:10.57 sshd                                                                                         
    10762 root      15   0  4764 1468 1196 S  0.0  0.1   0:00.10 bash                                                                                         
    11091 root      15   0  4764 1480 1200 S  0.0  0.1   0:00.08 bash                                                                                         
    12387 nobody    16   0 13532 4444 1596 S  0.0  0.2   0:00.49 httpd                                                                                        
    13290 nobody    15   0 13532 4456 1600 S  0.0  0.2   0:00.15 httpd                                                                                        
    13985 nobody    16   0 13532 4544 1692 S  0.0  0.2   0:00.33 httpd                                                                                        
    14634 root      18   0  3660  548  344 S  0.0  0.0   0:00.04 smartd                                                                                       
    14680 nobody    15   0 13532 4452 1596 S  0.0  0.2   0:00.33 httpd                                                                                        
    18428 root      25   0  2552 1136  952 S  0.0  0.1   0:00.02 mysqld_safe                                                                                  
    18466 root      18   0 50888  46m 2644 S  0.0  2.3   1:41.69 spamd                                                                                        
    19481 root      15   0 10248 3012 2408 S  0.0  0.1   0:13.07 sshd                                                                                         
    19913 root      15   0 10248 3052 2420 S  0.0  0.1   0:00.15 sshd                                                                                         
    20078 root      15   0  4768 1668 1284 S  0.0  0.1   0:00.33 bash                                                                                         
    20412 root      15   0  4768 1464 1188 S  0.0  0.1   0:00.04 bash                                                                                         
    20455 nobody    16   0 13532 4444 1596 S  0.0  0.2   0:00.29 httpd                                                                                        
    20840 root      18   0  6640 2824 1564 S  0.0  0.1   0:00.44 authProg                                                                                     
    21970 root      33  18 25884  13m 2572 S  0.0  0.7   0:04.04 cpanellogd                                                                                   
    22576 root      16   0  2556 1264  800 S  0.0  0.1   7:31.01 top                                                                                          
    22944 nobody    15   0 13532 4436 1592 S  0.0  0.2   0:00.02 httpd                                                                                        
    22993 nobody    15   0 13532 4472 1616 S  0.0  0.2   0:00.12 httpd                                                                                        
    23281 root      15   0     0    0    0 S  0.0  0.0   0:12.79 pdflush                                                                                      
    23617 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.04 httpd                                                                                        
    23672 nobody    15   0 13532 4456 1600 S  0.0  0.2   0:00.12 httpd                                                                                        
    23673 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.88 webalizer                                                                                    
    23674 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.85 webalizer                                                                                    
    23675 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.87 webalizer                                                                                    
    23676 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.90 webalizer                                                                                    
    23677 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.88 webalizer                                                                                    
    23678 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.88 webalizer                                                                                    
    23679 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.86 webalizer                                                                                    
    23680 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.84 webalizer                                                                                    
    23681 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.88 webalizer                                                                                    
    23682 formyip   34  19  7608 4704  592 T  0.0  0.2   0:00.87 webalizer                                                                                    
    23755 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.06 httpd                                                                                        
    23756 nobody    16   0 13532 4456 1596 S  0.0  0.2   0:00.08 httpd                                                                                        
    23816 root      18   0  6640 2816 1564 S  0.0  0.1   0:00.43 authProg                                                                                     
    23895 nobody    15   0 13532 4464 1608 S  0.0  0.2   0:00.52 httpd                                                                                        
    24392 nobody    20   0 13532 4436 1592 S  0.0  0.2   0:00.09 httpd                                                                                        
    24518 nobody    15   0 13532 4444 1600 S  0.0  0.2   0:00.11 httpd                                                                                        
    24522 nobody    15   0 13532 4460 1608 S  0.0  0.2   0:00.09 httpd                                                                                        
    24524 nobody    16   0 13532 4596 1744 S  0.0  0.2   0:00.21 httpd                                                                                        
    24526 nobody    15   0 13532 4436 1592 S  0.0  0.2   0:00.09 httpd                                                                                        
    24692 nobody    15   0 13532 4448 1604 S  0.0  0.2   0:00.10 httpd                                                                                        
    24717 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.07 httpd                                                                                        
    24741 root      18   0  6640 2812 1560 S  0.0  0.1   0:00.54 authProg                                                                                     
    25524 root      18   0 19880 6752 2432 S  0.0  0.3   0:00.15 leechprotect                                                                                 
    25533 root      17   0 13396 2912  204 S  0.0  0.1   0:00.00 httpd                                                                                        
    26498 nobody    19   0 13532 4456 1600 S  0.0  0.2   0:00.09 httpd                                                                                        
    26502 nobody    16   0 13532 4612 1768 S  0.0  0.2   0:00.18 httpd                                                                                        
    26585 nobody    15   0 13532 4608 1752 S  0.0  0.2   0:00.06 httpd                                                                                        
    26590 nobody    16   0 13532 4452 1596 S  0.0  0.2   0:00.07 httpd                                                                                        
    27528 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.07 httpd                                                                                        
    27653 nobody    16   0 13532 4456 1600 S  0.0  0.2   0:00.61 httpd                                                                                        
    28991 nobody    15   0 13532 4432 1596 S  0.0  0.2   0:00.07 httpd                                                                                        
    28992 nobody    17   0 13532 4612 1768 S  0.0  0.2   0:00.07 httpd                                                                                        
    29163 root      18   0 13400 6000 3288 S  0.0  0.3   0:29.68 httpd                                                                                        
    29172 nobody    16   0 13532 4444 1596 S  0.0  0.2   0:00.17 httpd                                                                                        
    29341 nobody    16   0 13532 4440 1592 S  0.0  0.2   0:00.09 httpd                                                                                        
    29357 root      15   0 38812  34m 2516 S  0.0  1.7   0:05.19 spamd                                                                                        
    29393 nobody    16   0 13532 4460 1612 S  0.0  0.2   0:00.03 httpd                                                                                        
    29459 nobody    15   0 13532 4584 1736 S  0.0  0.2   0:00.04 httpd                                                                                        
    29503 nobody    16   0 13532 4440 1592 S  0.0  0.2   0:00.05 httpd                                                                                        
    29506 nobody    16   0 13532 4444 1596 S  0.0  0.2   0:00.07 httpd                                                                                        
    29507 nobody    15   0 13532 4460 1612 S  0.0  0.2   0:00.03 httpd                                                                                        
    29510 nobody    16   0 13532 4452 1608 S  0.0  0.2   0:00.05 httpd                                                                                        
    29524 root      33  18  5016 2000  608 S  0.0  0.1   0:00.01 cpanellogd                                                                                   
    29935 root      18   0  6640 2816 1560 S  0.0  0.1   0:00.53 authProg                                                                                     
    30083 root      18   0 52916  48m 2608 S  0.0  2.4   0:26.97 spamd                                                                                        
    30943 nobody    16   0 13532 4448 1600 S  0.0  0.2   0:00.04 httpd                                                                                        
    30983 nobody    15   0 13532 4440 1596 S  0.0  0.2   0:00.04 httpd                                                                                        
    31051 nobody    15   0 13532 4440 1596 S  0.0  0.2   0:00.04 httpd                                                                                        
    31053 nobody    15   0 13532 4436 1596 S  0.0  0.2   0:00.03 httpd                                                                                        
    31132 nobody    15   0 13532 4604 1748 S  0.0  0.2   0:00.04 httpd                                                                                        
    31141 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.04 httpd                                                                                        
    31213 nobody    16   0 13532 4620 1772 S  0.0  0.2   0:00.03 httpd                                                                                        
    31219 nobody    15   0 13536 4532 1684 R  0.0  0.2   0:00.06 httpd                                                                                        
    31221 nobody    16   0 13532 4452 1596 S  0.0  0.2   0:00.04 httpd                                                                                        
    31222 nobody    16   0 13532 4444 1596 S  0.0  0.2   0:00.05 httpd                                                                                        
    31223 nobody    15   0 13532 4440 1596 S  0.0  0.2   0:00.06 httpd                                                                                        
    31239 nobody    16   0 13532 4444 1596 S  0.0  0.2   0:00.04 httpd                                                                                        
    32082 nobody    15   0 13532 4440 1592 S  0.0  0.2   0:00.02 httpd                                                                                        
    32130 nobody    15   0 13532 4444 1596 S  0.0  0.2   0:00.03 httpd                                                                                        
    32131 nobody    16   0 13532 4452 1596 S  0.0  0.2   0:00.03 httpd                                                                                        
    32218 root      18   0  6640 2820 1560 S  0.0  0.1   0:00.66 authProg                                                                                     
    
    
     
    #1 davus, Aug 24, 2012
    Last edited: Aug 24, 2012
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    You would need to have MySQL up over 24 hours to run the reports to receive proper recommendations. That's why it warns this on the mysqltuner.pl script. Once you've waited 24 or more hours and that is no longer appearing, please feel free to post the results of the recommendations.

    Thanks!
     
  3. davus

    davus Member

    Joined:
    Aug 23, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for the heads up, here's the 24 hr result!

    mysqltuner:
    Code:
    >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at [url]http://mysqltuner.com/[/url]
     >>  Run with '--help' for additional options and output filtering
    
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.5.24-cll
    [OK] Operating on 32-bit architecture with less than 2GB RAM
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
    [--] Data in MyISAM tables: 2G (Tables: 212)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [!!] InnoDB is enabled but isn't being used
    [!!] Total fragmented tables: 7
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1d 0h 26m 33s (68M q [779.361 qps], 2M conn, TX: 44B, RX: 4B)
    [--] Reads / Writes: 96% / 4%
    [--] Total buffers: 1.2G global + 2.7M per thread (151 max threads)
    [OK] Maximum possible memory usage: 1.6G (78% of installed RAM)
    [OK] Slow queries: 0% (11/68M)
    [OK] Highest usage of available connections: 19% (30/151)
    [OK] Key buffer size / total MyISAM indexes: 1.0G/696.3M
    [OK] Key buffer hit rate: 99.4% (4M cached / 28K reads)
    [OK] Query cache efficiency: 99.4% (58M cached / 58M selects)
    [!!] Query cache prunes per day: 321116
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2K sorts)
    [OK] Temporary tables created on disk: 0% (630 on disk / 2M total)
    [OK] Thread cache hit rate: 99% (8K created / 2M connections)
    [OK] Table cache hit rate: 95% (307 open / 320 opened)
    [OK] Open file limit used: 23% (527/2K)
    [OK] Table locks acquired immediately: 100% (360K immediate / 360K locks)
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Add skip-innodb to MySQL configuration to disable InnoDB
        Run OPTIMIZE TABLE to defragment tables for better performance
    Variables to adjust:
        query_cache_size (> 8M)
    msqylreport:
    Code:
    Use of uninitialized value in multiplication (*) at ./mysqlreport line 829.
    Use of uninitialized value in formline at ./mysqlreport line 1227.
    Use of uninitialized value in formline at ./mysqlreport line 1235.
    MySQL 5.5.24-cll         uptime 1 0:28:35       Sat Aug 25 15:38:54 2012
    
    __ Key _________________________________________________________________
    Buffer used    19.87M of   1.00G  %Used:   1.94
      Current     133.85M            %Usage:  13.07
    Write hit      58.79%
    Read hit       99.36%
    
    __ Questions ___________________________________________________________
    Total          68.69M   779.6/s
      QC Hits      58.18M   660.3/s  %Total:  84.70
      Com_          7.61M    86.4/s           11.08
      COM_QUIT      2.54M    28.8/s            3.69
      DMS         361.65k     4.1/s            0.53
      -Unknown        847     0.0/s            0.00
    Slow 2 s           11     0.0/s            0.00  %DMS:   0.00  Log:  ON
    DMS           361.65k     4.1/s            0.53
      SELECT      348.30k     4.0/s            0.51         96.31
      UPDATE       10.53k     0.1/s            0.02          2.91
      DELETE        1.61k     0.0/s            0.00          0.45
      INSERT        1.21k     0.0/s            0.00          0.33
      REPLACE           0       0/s            0.00          0.00
    Com_            7.61M    86.4/s           11.08
      show_tables   2.54M    28.9/s            3.70
      set_option    2.53M    28.8/s            3.69
      change_db     2.53M    28.8/s            3.69
    
    __ SELECT and Sort _____________________________________________________
    Scan            2.54M    28.9/s %SELECT: 730.33
    Range         325.62k     3.7/s           93.49
    Full join           0       0/s            0.00
    Range check         0       0/s            0.00
    Full rng join       0       0/s            0.00
    Sort scan         654     0.0/s
    Sort range      1.53k     0.0/s
    Sort mrg pass       0       0/s
    
    __ Query Cache _________________________________________________________
    Memory usage    3.93M of   8.00M  %Used:  49.17
    Block Fragmnt  14.91%
    Hits           58.18M   660.3/s
    Inserts       343.10k     3.9/s
    Insrt:Prune    1.05:1     0.2/s
    Hit:Insert   169.59:1
    
    __ Table Locks _________________________________________________________
    Waited              0       0/s  %Total:   0.00
    Immediate     361.01k     4.1/s
    
    __ Tables ______________________________________________________________
    Open              307 of 1024    %Cache:  29.98
    Opened            320     0.0/s
    
    __ Connections _________________________________________________________
    Max used           30 of  151      %Max:  19.87
    Total           2.54M    28.8/s
    
    __ Created Temp ________________________________________________________
    Disk table        630     0.0/s
    Table           2.54M    28.9/s    Size:  16.0M
    File                6     0.0/s
    
    __ Threads _____________________________________________________________
    Running             1 of    2
    Cached              3 of    4      %Hit:  99.65
    Created         8.77k     0.1/s
    Slow                1     0.0/s
    
    __ Aborted _____________________________________________________________
    Clients             4     0.0/s
    Connects          274     0.0/s
    
    __ Bytes _______________________________________________________________
    Sent           44.53G  505.4k/s
    Received        4.17G   47.4k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage           2.25M of 127.98M  %Used:   1.76
    Read hit       70.65%
    Pages
      Free          8.05k            %Total:  98.24
      Data            144                      1.76 %Drty:   0.00
      Misc              0                      0.00
      Latched                                  0.00
    Reads             494     0.0/s
      From file       145     0.0/s           29.35
      Ahead Rnd         0       0/s
      Ahead Sql                 0/s
    Writes              0       0/s
    Flushes             0       0/s
    Wait Free           0       0/s
    
    __ InnoDB Lock _________________________________________________________
    Waits               0       0/s
    Current             0
    Time acquiring
      Total             0 ms
      Average           0 ms
      Max               0 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads           155     0.0/s
      Writes            3     0.0/s
      fsync             3     0.0/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created           0       0/s
      Read            144     0.0/s
      Written           0       0/s
    
    Rows
      Deleted           0       0/s
      Inserted          0       0/s
      Read              0       0/s
      Updated           0       0/s
    and the 'top' data:
    Code:
    top - 15:44:14 up 2 days, 16:49,  2 users,  load average: 5.88, 8.62, 8.74
    Tasks: 279 total,   3 running, 259 sleeping,  13 stopped,   4 zombie
    Cpu(s): 36.0%us, 21.4%sy,  0.5%ni, 41.1%id,  0.4%wa,  0.1%hi,  0.5%si,  0.0%st
    Mem:   2075264k total,  1901704k used,   173560k free,   117544k buffers
    Swap:  4192956k total,   341000k used,  3851956k free,  1227432k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                      
    18664 mysql     15   0 1367m  39m 4024 S  5.7  2.0  77:28.90 mysqld                                                                                       
    32036 formyip   18   0     0    0    0 Z  5.7  0.0   0:00.03 php <defunct>                                                                                
    32041 formyip   18   0     0    0    0 Z  5.7  0.0   0:00.03 php <defunct>                                                                                
    32021 root      15   0  2420 1032  704 R  3.8  0.0   0:00.02 top                                                                                          
    32044 formyip   17   0     0    0    0 Z  3.8  0.0   0:00.02 php <defunct>                                                                                
    32057 formyip   17   0 29484 6548 4608 R  3.8  0.3   0:00.02 php                                                                                          
     5317 nobody    16   0 13532 4240 1612 S  1.9  0.2   0:00.34 httpd                                                                                        
    23176 nobody    16   0 13532 4224 1596 S  1.9  0.2   0:00.04 httpd                                                                                        
        1 root      15   0  2156  584  556 S  0.0  0.0   0:01.30 init                                                                                         
        2 root      RT  -5     0    0    0 S  0.0  0.0   0:11.85 migration/0                                                                                  
        3 root      34  19     0    0    0 R  0.0  0.0   0:04.41 ksoftirqd/0                                                                                  
        4 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/0                                                                                   
        5 root      RT  -5     0    0    0 S  0.0  0.0   0:20.43 migration/1                                                                                  
        6 root      34  19     0    0    0 S  0.0  0.0   0:06.59 ksoftirqd/1                                                                                  
        7 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/1                                                                                   
        8 root      10  -5     0    0    0 S  0.0  0.0   0:00.01 events/0                                                                                     
        9 root      10  -5     0    0    0 S  0.0  0.0   0:00.01 events/1                                                                                     
       10 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khelper                                                                                      
       11 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kthread                                                                                      
       15 root      10  -5     0    0    0 S  0.0  0.0   0:00.19 kblockd/0                                                                                    
       16 root      10  -5     0    0    0 S  0.0  0.0   0:00.67 kblockd/1                                                                                    
       17 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 kacpid                                                                                       
       89 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/0                                                                                     
       90 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/1                                                                                     
       93 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khubd                                                                                        
       95 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kseriod                                                                                      
      163 root      10  -5     0    0    0 S  0.0  0.0   0:22.32 kswapd0                                                                                      
      164 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 aio/0                                                                                        
      165 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 aio/1                                                                                        
      325 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 kpsmoused                                                                                    
      356 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 ata/0                                                                                        
      357 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 ata/1                                                                                        
      358 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 ata_aux                                                                                      
      362 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0                                                                                    
      363 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_1                                                                                    
      370 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 kstriped                                                                                     
      383 root      10  -5     0    0    0 S  0.0  0.0   0:57.60 kjournald                                                                                    
      408 root      10  -5     0    0    0 S  0.0  0.0   0:00.15 kauditd                                                                                      
      427 root      34  18  8044 5488 1272 S  0.0  0.3   0:00.01 cpbackup                                                                                     
      441 root      21  -4  2388  340  336 S  0.0  0.0   0:00.09 udevd                                                                                        
      899 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kedac                                                                                        
     1133 nobody    15   0 13532 4236 1608 S  0.0  0.2   0:00.34 httpd                                                                                        
     1263 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/0                                                                                    
     1264 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/1                                                                                    
     1265 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 kmpath_handlerd                                                                              
     1288 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kjournald                                                                                    
     1533 root       0 -20     0    0    0 S  0.0  0.0   0:49.36 loop0                                                                                        
     1534 root      10  -5     0    0    0 S  0.0  0.0   0:18.05 kjournald                                                                                    
     1579 root      10  -5     0    0    0 S  0.0  0.0   0:00.16 kondemand/0                                                                                  
     1580 root      10  -5     0    0    0 S  0.0  0.0   0:00.03 kondemand/1                                                                                  
     1601 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 iscsi_eh                                                                                     
     1644 root      16   0  2556 1232  800 S  0.0  0.1   3:57.06 top                                                                                          
     1656 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 ib_addr                                                                                      
     1666 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_mcast                                                                                     
     1667 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_inform                                                                                    
     1668 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 local_sa                                                                                     
     1671 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 iw_cm_wq                                                                                     
     1673 nobody    15   0 13532 4388 1744 S  0.0  0.2   0:00.18 httpd                                                                                        
     1675 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_cm/0                                                                                      
     1676 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_cm/1                                                                                      
     1681 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 rdma_cm                                                                                      
     1695 root      10 -10 32744  31m 1716 S  0.0  1.6   0:00.04 iscsiuio                                                                                     
     1700 root      18   0  2356  348  324 S  0.0  0.0   0:01.04 iscsid                                                                                       
     1701 root       5 -10  2816 2812 1888 S  0.0  0.1   0:00.01 iscsid                                                                                       
     1762 nobody    15   0 13532 4220 1592 S  0.0  0.2   0:00.16 httpd                                                                                        
     1990 root      11  -4 12652  676  516 S  0.0  0.0   0:03.04 auditd                                                                                       
     1992 root       7  -8 13188  752  564 S  0.0  0.0   0:00.76 audispd                                                                                      
     1996 nobody    15   0 13532 4404 1768 S  0.0  0.2   0:00.19 httpd                                                                                        
     2174 root      15   0  1812  532  476 S  0.0  0.0   0:07.09 syslogd                                                                                      
     2177 root      15   0  1760  332  328 S  0.0  0.0   0:00.00 klogd                                                                                        
     2191 root      15   0  2560  340  272 S  0.0  0.0   0:01.32 irqbalance                                                                                   
     2237 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 rpciod/0                                                                                     
     2238 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 rpciod/1                                                                                     
     2252 root      18   0  1744  260  256 S  0.0  0.0   0:00.68 courierlogger                                                                                
     2253 root      18   0  2092  520  484 S  0.0  0.0   0:00.00 authdaemond                                                                                  
     2288 root      25   0  5940  240  236 S  0.0  0.0   0:00.00 rpc.idmapd                                                                                   
     2289 root      18   0  2092  328  256 S  0.0  0.0   0:00.41 authdaemond                                                                                  
     2290 root      18   0  2092  328  256 S  0.0  0.0   0:00.45 authdaemond                                                                                  
     2291 root      18   0  2092  320  256 S  0.0  0.0   0:00.47 authdaemond                                                                                  
     2292 root      15   0  2092  328  256 S  0.0  0.0   0:00.52 authdaemond                                                                                  
     2293 root      18   0  2092  328  256 S  0.0  0.0   0:00.48 authdaemond                                                                                  
     2323 dbus      15   0  2848  836  692 S  0.0  0.0   0:00.22 dbus-daemon                                                                                  
     2337 root      24   0  2252  404  400 S  0.0  0.0   0:00.00 hcid                                                                                         
     2343 root      24   0  1828  372  368 S  0.0  0.0   0:00.00 sdpd                                                                                         
     2366 root       8 -10     0    0    0 S  0.0  0.0   0:00.00 krfcommd                                                                                     
     2413 root      18   0 12952  548  432 S  0.0  0.0   0:20.14 pcscd                                                                                        
     2427 root      18   0  1756  444  440 S  0.0  0.0   0:00.00 acpid                                                                                        
     2446 root      25   0  2004  352  348 S  0.0  0.0   0:00.00 hidd                                                                                         
     2483 root      23   0 30464  812  696 S  0.0  0.0   0:01.17 automount                                                                                    
     2507 root      15   0  7244  736  636 S  0.0  0.0   0:01.04 sshd                                                                                         
     2520 root      18   0 10248  988  984 S  0.0  0.0   0:00.00 cupsd                                                                                        
     2536 root      25   0  2832  544  540 S  0.0  0.0   0:00.00 xinetd                                                                                       
     2746 root      16   0  1744  308  256 S  0.0  0.0   0:00.12 courierlogger                                                                                
     2747 root      19   0  1856  492  436 S  0.0  0.0   0:00.11 couriertcpd                                                                                  
     2753 root      18   0  1744  260  256 S  0.0  0.0   0:00.00 courierlogger                                                                                
     2754 root      15   0  1856  440  436 S  0.0  0.0   0:00.01 couriertcpd                                                                                  
     2759 root      18   0  1744  308  256 S  0.0  0.0   0:02.17 courierlogger                                                                                
     2760 root      15   0  1856  488  436 S  0.0  0.0   0:02.36 couriertcpd                                                                                  
     2765 root      18   0  1744  312  256 S  0.0  0.0   0:00.90 courierlogger                                                                                
     2766 root      15   0  1856  492  436 S  0.0  0.0   0:00.85 couriertcpd                                                                                  
     2866 root      17   0  160m 117m 6444 S  0.0  5.8   0:47.32 clamd                                                                                        
     2873 mailnull  15   0 10280  696  568 S  0.0  0.0   0:01.22 exim                                                                                         
     2939 root      15   0  7696 1056  984 S  0.0  0.1   0:00.40 pure-ftpd                                                                                    
     2941 root      20   0  7140  984  944 S  0.0  0.0   0:00.17 pure-authd                                                                                   
     2956 root      18   0  5376  612  548 S  0.0  0.0   0:00.50 crond                                                                                        
     2987 xfs       15   0  3396  596  564 S  0.0  0.0   0:00.00 xfs                                                                                          
     3021 root      18   0  2356  396  344 S  0.0  0.0   0:00.01 atd                                                                                          
     3628 root      18   0 18012 1768  636 S  0.0  0.1   0:00.71 cpdavd                                                                                       
     4541 nobody    16   0 13532 4228 1592 S  0.0  0.2   0:00.17 httpd                                                                                        
     4638 nobody    15   0 13532 4228 1592 S  0.0  0.2   0:00.16 httpd                                                                                        
     4643 nobody    15   0 13532 4224 1596 S  0.0  0.2   0:00.12 httpd                                                                                        
     4657 root      18   0  6072 1756 1232 S  0.0  0.1   0:00.45 queueprocd                                                                                   
     5027 root      15   0 15916 4152 1832 S  0.0  0.2   0:01.83 cpsrvd-ssl                                                                                   
     6000 nobody    16   0 13532 4352 1708 S  0.0  0.2   0:00.53 httpd                                                                                        
     6168 root      15   0 22264 4696 1548 S  0.0  0.2   0:31.87 tailwatchd                                                                                   
     6278 root      15   0 45988  37m 2644 S  0.0  1.9   1:01.85 spamd                                                                                        
     6446 root      15   0  3820  496  412 S  0.0  0.0   0:04.42 rhnsd                                                                                        
     6638 avahi     15   0  2696  868  796 S  0.0  0.0   0:00.03 avahi-daemon                                                                                 
     6639 avahi     19   0  2696  208  204 S  0.0  0.0   0:00.00 avahi-daemon                                                                                 
     6699 haldaemo  18   0  6008 1220  936 S  0.0  0.1   0:01.08 hald                                                                                         
     6700 root      18   0  3264  532  528 S  0.0  0.0   0:00.00 hald-runner                                                                                  
     6774 haldaemo  15   0  2104  528  524 S  0.0  0.0   0:00.00 hald-addon-acpi                                                                              
     7071 root      23   0  1768  312  308 S  0.0  0.0   0:00.00 portsentry                                                                                   
     7187 named     18   0 73388  25m 1592 S  0.0  1.3   5:25.20 named                                                                                        
     7329 root      25   0 13116 4524 1280 S  0.0  0.2   0:48.45 mrtg                                                                                         
     7790 root      18   0  3660  412  332 S  0.0  0.0   0:00.06 smartd                                                                                       
     7793 root      22   0  1744  392  388 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7794 root      23   0  1744  392  388 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7795 root      18   0  1744  392  388 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7796 root      22   0  1744  392  388 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7804 root      22   0  1744  392  388 S  0.0  0.0   0:00.00 mingetty                                                                                     
     7811 root      22   0  1744  392  388 S  0.0  0.0   0:00.00 mingetty                                                                                     
     8362 nobody    21   0 13532 4440 1792 S  0.0  0.2   0:00.50 httpd                                                                                        
     8688 root      34  19 25972 3156 1684 S  0.0  0.2   0:00.40 yum-updatesd                                                                                 
     8756 root      34  19  2656  936  772 S  0.0  0.0   0:02.23 gam_server                                                                                   
     9205 nobody    16   0 13532 4416 1780 S  0.0  0.2   0:00.14 httpd                                                                                        
     9527 root      15   0  6640 2812 1560 S  0.0  0.1   0:00.16 authProg                                                                                     
     9765 nobody    18   0 13532 4224 1596 S  0.0  0.2   0:00.11 httpd                                                                                        
     9773 nobody    16   0 13532 4244 1612 S  0.0  0.2   0:00.12 httpd                                                                                        
     9780 root      18   0  6640 2812 1560 S  0.0  0.1   0:00.12 authProg                                                                                     
     9885 nobody    16   0 13532 4220 1592 S  0.0  0.2   0:00.12 httpd                                                                                        
     9890 nobody    15   0 13532 4212 1592 S  0.0  0.2   0:00.07 httpd                                                                                        
     9893 nobody    16   0 13532 4216 1592 S  0.0  0.2   0:00.10 httpd                                                                                        
     9904 nobody    15   0 13532 4404 1768 S  0.0  0.2   0:00.10 httpd                                                                                        
    10019 root      18   0  6640 2820 1564 S  0.0  0.1   0:00.14 authProg                                                                                     
    10437 nobody    15   0 13532 4244 1608 S  0.0  0.2   0:00.28 httpd                                                                                        
    10439 nobody    16   0 13532 4280 1628 S  0.0  0.2   0:00.34 httpd                                                                                        
    10522 root      15   0 10116 2516 2296 S  0.0  0.1   0:16.47 sshd                                                                                         
    11091 root      15   0  4764 1172  968 S  0.0  0.1   0:00.10 bash                                                                                         
    12083 nobody    16   0 13532 4244 1608 S  0.0  0.2   0:00.29 httpd                                                                                        
    12202 nobody    16   0 13532 4228 1596 S  0.0  0.2   0:00.48 httpd                                                                                        
    12305 nobody    16   0 13532 4316 1680 S  0.0  0.2   0:00.29 httpd                                                                                        
    12308 nobody    15   0 13532 4324 1676 S  0.0  0.2   0:00.80 httpd                                                                                        
    12315 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.04 webalizer                                                                                    
    12316 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.04 webalizer                                                                                    
    12317 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.05 webalizer                                                                                    
    12318 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.03 webalizer                                                                                    
    12319 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.04 webalizer                                                                                    
    12320 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.02 webalizer                                                                                    
    12321 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.02 webalizer                                                                                    
    12322 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.04 webalizer                                                                                    
    12323 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.03 webalizer                                                                                    
    12324 mitch     34  19  4308 1380  592 T  0.0  0.1   0:00.04 webalizer                                                                                    
    13220 nobody    15   0 13532 4220 1592 S  0.0  0.2   0:00.09 httpd                                                                                        
    13316 nobody    15   0 13532 4228 1592 S  0.0  0.2   0:00.21 httpd                                                                                        
    13329 nobody    15   0 13532 4212 1592 S  0.0  0.2   0:00.30 httpd                                                                                        
    13628 nobody    15   0 13532 4400 1756 S  0.0  0.2   0:00.65 httpd                                                                                        
    13663 nobody    15   0 13532 4236 1608 S  0.0  0.2   0:00.09 httpd                                                                                        
    14634 root      18   0  3660  404  332 S  0.0  0.0   0:00.06 smartd                                                                                       
    15303 nobody    15   0 13532 4380 1744 S  0.0  0.2   0:00.08 httpd                                                                                        
    15380 nobody    16   0 13532 4320 1680 S  0.0  0.2   0:00.10 httpd                                                                                        
    15472 nobody    16   0 13532 4388 1764 S  0.0  0.2   0:00.06 httpd                                                                                        
    15607 nobody    16   0 13532 4224 1596 S  0.0  0.2   0:00.07 httpd                                                                                        
    15609 nobody    15   0 13532 4244 1608 S  0.0  0.2   0:00.10 httpd                                                                                        
    15635 nobody    15   0 13532 4232 1604 S  0.0  0.2   0:00.09 httpd                                                                                        
    15639 nobody    16   0 13532 4228 1592 S  0.0  0.2   0:00.23 httpd                                                                                        
    15646 nobody    15   0 13532 4188 1580 S  0.0  0.2   0:00.00 httpd                                                                                        
    15648 nobody    20   0 13532 4232 1596 S  0.0  0.2   0:00.08 httpd                                                                                        
    16700 root      34  18 26044  13m 2584 S  0.0  0.7   0:19.55 cpanellogd                                                                                   
    17367 sage      18   0  2388  764  632 S  0.0  0.0   0:00.00 imapd                                                                                        
    17414 root      17   0  5732 2440 1380 S  0.0  0.1   0:00.07 couriertls                                                                                   
    17563 root      33  18  1736  404  348 S  0.0  0.0   0:00.51 cpuwatch                                                                                     
    17564 root      34  19  2584 1040  832 T  0.0  0.1   0:01.30 gtar                                                                                         
    17565 root      39  19  2116  696  328 T  0.0  0.0   0:50.28 gzip                                                                                         
    18428 root      25   0  2552  568  564 S  0.0  0.0   0:00.02 mysqld_safe                                                                                  
    18484 root      18   0  6640 2812 1560 S  0.0  0.1   0:00.13 authProg                                                                                     
    19204 root      15   0     0    0    0 S  0.0  0.0   0:00.03 pdflush                                                                                      
    19301 nobody    15   0 13532 4224 1596 S  0.0  0.2   0:00.27 httpd                                                                                        
    19308 nobody    16   0 13532 4220 1592 S  0.0  0.2   0:00.06 httpd                                                                                        
    19378 nobody    15   0 13532 4236 1608 S  0.0  0.2   0:00.37 httpd                                                                                        
    19462 root      15   0     0    0    0 S  0.0  0.0   0:06.01 pdflush                                                                                      
    19744 nobody    16   0 13532 4220 1592 S  0.0  0.2   0:00.08 httpd                                                                                        
    19745 nobody    15   0 13532 4216 1592 S  0.0  0.2   0:00.08 httpd                                                                                        
    19810 nobody    15   0 13532 4220 1592 S  0.0  0.2   0:00.06 httpd                                                                                        
    19813 nobody    16   0 13532 4232 1596 S  0.0  0.2   0:00.06 httpd                                                                                        
    20784 nobody    16   0 13532 4220 1592 S  0.0  0.2   0:00.07 httpd                                                                                        
    20882 nobody    15   0 13532 4368 1744 S  0.0  0.2   0:00.07 httpd                                                                                        
    20940 root      19   0 19880 6756 2432 S  0.0  0.3   0:00.15 leechprotect                                                                                 
    20946 root      17   0 13396 2700  200 S  0.0  0.1   0:00.00 httpd                                                                                        
    20947 nobody    15   0 13532 4260 1632 S  0.0  0.2   0:00.05 httpd                                                                                        
    20948 nobody    15   0 13532 4228 1604 S  0.0  0.2   0:00.05 httpd                                                                                        
    20953 nobody    16   0 13532 4216 1592 S  0.0  0.2   0:00.07 httpd                                                                                        
    20958 nobody    15   0 13532 4376 1744 S  0.0  0.2   0:00.06 httpd                                                                                        
    21159 nobody    15   0 13532 4316 1680 S  0.0  0.2   0:00.11 httpd                                                                                        
    21228 nobody    16   0 13532 4248 1608 S  0.0  0.2   0:00.41 httpd                                                                                        
    21620 nobody    15   0 13532 4428 1780 S  0.0  0.2   0:00.27 httpd                                                                                        
    21865 nobody    16   0 13532 4224 1596 S  0.0  0.2   0:00.05 httpd                                                                                        
    21943 nobody    20   0 13400 3540 1000 S  0.0  0.2   0:00.00 httpd                                                                                        
    22074 nobody    16   0 13532 4228 1604 S  0.0  0.2   0:00.05 httpd                                                                                        
    22080 nobody    16   0 13532 4220 1596 S  0.0  0.2   0:00.05 httpd                                                                                        
    22217 nobody    15   0 13532 4300 1676 S  0.0  0.2   0:00.05 httpd                                                                                        
    22218 nobody    16   0 13532 4212 1596 S  0.0  0.2   0:00.06 httpd                                                                                        
    22927 nobody    15   0 13532 4232 1596 S  0.0  0.2   0:00.05 httpd                                                                                        
    22936 nobody    16   0 13536 4360 1744 S  0.0  0.2   0:00.04 httpd                                                                                        
    22937 nobody    16   0 13536 4372 1744 S  0.0  0.2   0:00.16 httpd                                                                                        
    23024 nobody    16   0 13532 4224 1600 S  0.0  0.2   0:00.09 httpd                                                                                        
    23047 nobody    15   0 13532 4232 1604 S  0.0  0.2   0:00.05 httpd                                                                                        
    23061 nobody    15   0 13532 4220 1592 S  0.0  0.2   0:00.05 httpd                                                                                        
    23067 nobody    15   0 13532 4224 1596 S  0.0  0.2   0:00.05 httpd                                                                                        
    23068 nobody    15   0 13532 4208 1596 S  0.0  0.2   0:00.03 httpd                                                                                        
    23155 nobody    15   0 13532 4228 1608 S  0.0  0.2   0:00.04 httpd                                                                                        
    23157 nobody    16   0 13532 4224 1596 S  0.0  0.2   0:00.05 httpd                                                                                        
    23160 nobody    16   0 13532 4224 1596 S  0.0  0.2   0:00.04 httpd                                                                                        
    23161 nobody    16   0 13532 4212 1592 S  0.0  0.2   0:00.03 httpd                                                                                        
    23162 nobody    16   0 13532 4204 1588 S  0.0  0.2   0:00.03 httpd                                                                                        
    23166 nobody    16   0 13532 4212 1592 S  0.0  0.2   0:00.06 httpd                                                                                        
    23167 nobody    16   0 13532 4224 1596 S  0.0  0.2   0:00.05 httpd                                                                                        
    23168 nobody    16   0 13532 4224 1596 S  0.0  0.2   0:00.04 httpd                                                                                        
    23180 nobody    19   0 13532 4220 1592 S  0.0  0.2   0:00.04 httpd                                                                                        
    23182 nobody    15   0 13532 4216 1596 S  0.0  0.2   0:00.03 httpd                                                                                        
    23186 nobody    15   0 13532 4212 1596 S  0.0  0.2   0:00.05 httpd                                                                                        
    23697 nobody    15   0 13532 4320 1676 S  0.0  0.2   0:00.23 httpd                                                                                        
    23839 nobody    15   0 13532 4244 1608 S  0.0  0.2   0:00.17 httpd                                                                                        
    25215 nobody    15   0 13524 4228 1600 S  0.0  0.2   0:00.14 httpd                                                                                        
    25491 mitch     33  18 26044  12m  724 S  0.0  0.6   0:00.00 cpanellogd                                                                                   
    25493 mitch     33  18  1736  412  352 S  0.0  0.0   0:00.54 logrunner                                                                                    
    25494 mitch     34  19  4152 1720  968 T  0.0  0.1   0:02.52 webalizer                                                                                    
    25961 nobody    16   0 13532 4404 1768 S  0.0  0.2   0:00.64 httpd                                                                                        
    27603 root      16   0 10248 3000 2420 S  0.0  0.1   0:00.08 sshd                                                                                         
    27909 root      15   0  4764 1440 1176 S  0.0  0.1   0:00.03 bash                                                                                         
    28190 nobody    15   0 13532 4220 1592 S  0.0  0.2   0:00.02 httpd                                                                                        
    28261 nobody    15   0 13532 4300 1672 S  0.0  0.2   0:00.02 httpd                                                                                        
    28272 nobody    16   0 13532 4400 1756 S  0.0  0.2   0:00.34 httpd                                                                                        
    28326 nobody    16   0 13532 4208 1588 S  0.0  0.2   0:00.02 httpd                                                                                        
    28328 nobody    15   0 13532 4304 1676 S  0.0  0.2   0:00.02 httpd                                                                                        
    28329 nobody    16   0 13532 4224 1596 S  0.0  0.2   0:00.01 httpd                                                                                        
    28331 nobody    15   0     0    0    0 Z  0.0  0.0   0:00.01 httpd <defunct>                                                                              
    28401 nobody    16   0 13532 4228 1600 S  0.0  0.2   0:00.02 httpd                                                                                        
    28409 nobody    15   0 13532 4216 1596 S  0.0  0.2   0:00.03 httpd                                                                                        
    28411 nobody    18   0 13532 4208 1588 S  0.0  0.2   0:00.01 httpd                                                                                        
    28413 nobody    16   0 13532 4208 1592 S  0.0  0.2   0:00.02 httpd                                                                                        
    28415 nobody    15   0 13532 4208 1584 S  0.0  0.2   0:00.01 httpd                                                                                        
    28419 nobody    16   0 13532 4224 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
    28422 nobody    15   0 13532 4220 1596 S  0.0  0.2   0:00.03 httpd                                                                                        
    28451 root      15   0 10276 2984 2392 S  0.0  0.1   0:00.04 sshd                                                                                         
    28494 nobody    15   0 13532 4296 1672 S  0.0  0.2   0:00.02 httpd                                                                                        
    28495 nobody    15   0 13532 4228 1600 S  0.0  0.2   0:00.01 httpd                                                                                        
    28500 nobody    16   0 13532 4212 1592 S  0.0  0.2   0:00.02 httpd                                                                                        
    28503 nobody    15   0 13532 4228 1600 S  0.0  0.2   0:00.00 httpd                                                                                        
    28507 nobody    15   0 13532 4208 1592 S  0.0  0.2   0:00.00 httpd                                                                                        
    28509 nobody    16   0 13532 4216 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
    28510 nobody    16   0 13532 4208 1588 S  0.0  0.2   0:00.01 httpd                                                                                        
    28511 nobody    15   0 13532 4216 1596 S  0.0  0.2   0:00.02 httpd                                                                                        
    28518 nobody    15   0 13536 4364 1740 S  0.0  0.2   0:00.02 httpd                                                                                        
    28519 nobody    18   0 13532 4204 1584 S  0.0  0.2   0:00.01 httpd                                                                                        
    28520 nobody    15   0 13532 4220 1592 S  0.0  0.2   0:00.01 httpd                                                                                        
    28536 root      15   0  6688 1628 1200 S  0.0  0.1   0:00.02 sftp-server                                                                                  
    29072 nobody    15   0 13532 4244 1608 S  0.0  0.2   0:00.06 httpd                                                                                        
    29076 nobody    15   0 13532 4308 1672 S  0.0  0.2   0:00.11 httpd                                                                                        
    29163 root      18   0 13400 5764 3264 S  0.0  0.3   0:48.08 httpd                                                                                        
    29357 root      15   0 38812 5892 2056 S  0.0  0.3   0:06.77 spamd                                                                                        
    29524 root      33  18  5016 1020  604 S  0.0  0.0   0:00.01 cpanellogd                                                                                   
    29948 nobody    16   0 13532 4208 1588 S  0.0  0.2   0:00.01 httpd                                                                                        
    30008 nobody    15   0 13532 4204 1588 S  0.0  0.2   0:00.00 httpd                                                                                        
    30010 nobody    15   0 13532 4204 1588 S  0.0  0.2   0:00.01 httpd                                                                                        
    30083 root      15   0 52576  34m 2372 S  0.0  1.7   0:28.62 spamd                                                                                        
    30723 nobody    16   0 13532 4208 1592 S  0.0  0.2   0:00.00 httpd                                                                                        
    32218 root      18   0  6664 1644 1024 S  0.0  0.1   0:02.05 authProg                                                                                     
    32737 nobody    15   0 13532 4232 1596 S  0.0  0.2   0:00.38 httpd                                                                                        
    
    
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Can you use mysqlsla (mysqlsla :: Parse, filter and sort MySQL slow, general and binary logs) to gather data from the slow query log? I'm going to bet the site causing the issue is formyip or else it's httpd running a high number of processes. Please also run "free -m" without the quotes when the load is high for us to see the full output of memory usage.
     
  5. davus

    davus Member

    Joined:
    Aug 23, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi cPanelTristan,

    Yeah it's definitely formyip sorry i should have mentioned that earlier, here's the free -m result, load avg was roughly around 5:
    Code:
                 total       used       free     shared    buffers     cached
    Mem:          2026       1857        169          0        110       1208
    -/+ buffers/cache:        537       1489
    Swap:         4094        332       3761
    and the mysqlsla result:
    Code:
    Report for slow logs: mysql.slow.log
    133 queries total, 30 unique
    Sorted by 't_sum'
    Grand Totals: Time 362 s, Lock 2 s, Rows sent 829, Rows Examined 221.38k
    
    
    ______________________________________________________________________ 001 ___
    Count         : 40  (30.08%)
    Time          : 105.241356 s total, 2.631034 s avg, 2.015848 s to 4.121548 s max  (29.06%)
      95% of Time : 97.253975 s total, 2.559315 s avg, 2.015848 s to 3.507069 s max
    Lock Time (s) : 3.106 ms total, 78 ?s avg, 45 ?s to 116 ?s max  (0.18%)
      95% of Lock : 2.874 ms total, 76 ?s avg, 45 ?s to 112 ?s max
    Rows sent     : 18 avg, 18 to 18 max  (86.85%)
    Rows examined : 18 avg, 18 to 18 max  (0.33%)
    Database      : fmpdatabase
    Users         : 
    	fmpuser@localhost  : 100.00% (40) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SHOW tables FROM fmpdatabase;
    
    Query sample:
    SET timestamp=1345744979;
    SHOW TABLES FROM fmpdatabase;
    
    ______________________________________________________________________ 002 ___
    Count         : 9  (6.77%)
    Time          : 26.008527 s total, 2.889836 s avg, 2.015929 s to 3.818689 s max  (7.18%)
    Lock Time (s) : 367.528 ms total, 40.836 ms avg, 30 ?s to 367.17 ms max  (20.93%)
    Rows sent     : 1 avg, 1 to 1 max  (1.09%)
    Rows examined : 1 avg, 1 to 1 max  (0.00%)
    Database      : 
    Users         : 
    	fmpuser@localhost  : 100.00% (9) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SELECT * FROM ip2location_0 ORDER BY ipfrom ASC LIMIT N;
    
    Query sample:
    SET timestamp=1345767296;
    SELECT * FROM ip2location_0 ORDER BY ipFROM ASC LIMIT 1;
    
    ______________________________________________________________________ 003 ___
    Count         : 9  (6.77%)
    Time          : 22.701416 s total, 2.52238 s avg, 2.045286 s to 3.828924 s max  (6.27%)
    Lock Time (s) : 799 ?s total, 89 ?s avg, 25 ?s to 499 ?s max  (0.05%)
    Rows sent     : 1 avg, 1 to 1 max  (1.09%)
    Rows examined : 1 avg, 1 to 1 max  (0.00%)
    Database      : 
    Users         : 
    	fmpuser@localhost  : 100.00% (9) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SELECT * FROM ip2location_0 ORDER BY ipfrom DESC LIMIT N;
    
    Query sample:
    SET timestamp=1345747678;
    SELECT * FROM ip2location_0 ORDER BY ipFROM DESC LIMIT 1;
    
    ______________________________________________________________________ 004 ___
    Count         : 8  (6.02%)
    Time          : 19.833436 s total, 2.479179 s avg, 2.002863 s to 3.415309 s max  (5.48%)
    Lock Time (s) : 209 ?s total, 26 ?s avg, 25 ?s to 27 ?s max  (0.01%)
    Rows sent     : 1 avg, 1 to 1 max  (0.97%)
    Rows examined : 1 avg, 1 to 1 max  (0.00%)
    Database      : fmpdatabase
    Users         : 
    	fmpuser@localhost  : 100.00% (8) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SELECT * FROM ip2location_3 ORDER BY ipfrom ASC LIMIT N;
    
    Query sample:
    SET timestamp=1345754159;
    SELECT * FROM ip2location_3 ORDER BY ipFROM ASC LIMIT 1;
    
    ______________________________________________________________________ 005 ___
    Count         : 6  (4.51%)
    Time          : 17.930774 s total, 2.988462 s avg, 2.023716 s to 3.575418 s max  (4.95%)
    Lock Time (s) : 171 ?s total, 29 ?s avg, 27 ?s to 31 ?s max  (0.01%)
    Rows sent     : 1 avg, 1 to 1 max  (0.72%)
    Rows examined : 1 avg, 1 to 1 max  (0.00%)
    Database      : 
    Users         : 
    	fmpuser@localhost  : 100.00% (6) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SELECT * FROM ip2location_4 ORDER BY ipfrom ASC LIMIT N;
    
    Query sample:
    SET timestamp=1345762977;
    SELECT * FROM ip2location_4 ORDER BY ipFROM ASC LIMIT 1;
    
    ______________________________________________________________________ 006 ___
    Count         : 5  (3.76%)
    Time          : 16.257496 s total, 3.251499 s avg, 2.079611 s to 3.873392 s max  (4.49%)
    Lock Time (s) : 182 ?s total, 36 ?s avg, 25 ?s to 78 ?s max  (0.01%)
    Rows sent     : 1 avg, 1 to 1 max  (0.60%)
    Rows examined : 1 avg, 1 to 1 max  (0.00%)
    Database      : 
    Users         : 
    	fmpuser@localhost  : 100.00% (5) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SELECT * FROM ip2location_2 ORDER BY ipfrom DESC LIMIT N;
    
    Query sample:
    SET timestamp=1345746239;
    SELECT * FROM ip2location_2 ORDER BY ipFROM DESC LIMIT 1;
    
    ______________________________________________________________________ 007 ___
    Count         : 5  (3.76%)
    Time          : 13.636698 s total, 2.72734 s avg, 2.069481 s to 3.635406 s max  (3.76%)
    Lock Time (s) : 164 ?s total, 33 ?s avg, 25 ?s to 61 ?s max  (0.01%)
    Rows sent     : 1 avg, 1 to 1 max  (0.60%)
    Rows examined : 1 avg, 1 to 1 max  (0.00%)
    Database      : fmpdatabase
    Users         : 
    	fmpuser@localhost  : 100.00% (5) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SELECT * FROM ip2location_6 ORDER BY ipfrom DESC LIMIT N;
    
    Query sample:
    SET timestamp=1345752178;
    SELECT * FROM ip2location_6 ORDER BY ipFROM DESC LIMIT 1;
    
    ______________________________________________________________________ 008 ___
    Count         : 5  (3.76%)
    Time          : 13.581265 s total, 2.716253 s avg, 2.069569 s to 3.581532 s max  (3.75%)
    Lock Time (s) : 216 ?s total, 43 ?s avg, 27 ?s to 101 ?s max  (0.01%)
    Rows sent     : 1 avg, 1 to 1 max  (0.60%)
    Rows examined : 1 avg, 1 to 1 max  (0.00%)
    Database      : 
    Users         : 
    	fmpuser@localhost  : 100.00% (5) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SELECT * FROM ip2location_1 ORDER BY ipfrom ASC LIMIT N;
    
    Query sample:
    SET timestamp=1345759559;
    SELECT * FROM ip2location_1 ORDER BY ipFROM ASC LIMIT 1;
    
    ______________________________________________________________________ 009 ___
    Count         : 4  (3.01%)
    Time          : 11.444493 s total, 2.861123 s avg, 2.029002 s to 3.507124 s max  (3.16%)
    Lock Time (s) : 105 ?s total, 26 ?s avg, 25 ?s to 27 ?s max  (0.01%)
    Rows sent     : 1 avg, 1 to 1 max  (0.48%)
    Rows examined : 1 avg, 1 to 1 max  (0.00%)
    Database      : 
    Users         : 
    	fmpuser@localhost  : 100.00% (4) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SELECT * FROM ip2location_1 ORDER BY ipfrom DESC LIMIT N;
    
    Query sample:
    SET timestamp=1345762977;
    SELECT * FROM ip2location_1 ORDER BY ipFROM DESC LIMIT 1;
    
    ______________________________________________________________________ 010 ___
    Count         : 4  (3.01%)
    Time          : 10.362593 s total, 2.590648 s avg, 2.180685 s to 2.766683 s max  (2.86%)
    Lock Time (s) : 1.367317 s total, 341.829 ms avg, 27 ?s to 492.924 ms max  (77.87%)
    Rows sent     : 1 avg, 1 to 1 max  (0.48%)
    Rows examined : 1 avg, 1 to 1 max  (0.00%)
    Database      : 
    Users         : 
    	fmpuser@localhost  : 100.00% (4) of query, 98.50% (131) of all users
    
    Query abstract:
    SET timestamp=N; SELECT * FROM ip2location_5 ORDER BY ipfrom ASC LIMIT N;
    
    Query sample:
    SET timestamp=1345750199;
    SELECT * FROM ip2location_5 ORDER BY ipFROM ASC LIMIT 1;
    
     
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    The database with all the slow queries appears to be this one:

    Code:
    Database : fmpdatabase
    With this user:

    Code:
    fmpuser@localhost
    The queries for that user are 100.00% and 98.50% of all users

    The query is the following that appears to be the slow one:

    Code:
    SET timestamp=N; SELECT * FROM ip2location_0 ORDER BY ipfrom ASC LIMIT N;
    That is the database needing optimized. If that doesn't have indexing on the table in question, then please index it. Also, any select * queries could end up being slow, since using a wildcard select is very undesirable.
     
  7. davus

    davus Member

    Joined:
    Aug 23, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi cPanelTristan,

    That table has ipfrom as the primary, would it help to index it on top of that? Granted, this table has a lot of rows, roughly 500k so do you think just splitting it up into smaller tables might help?
     
  8. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Any way that you can reduce the data in the tables would be good, yes, because a wildcard select will go through the entire table looking for the record. Not only reducing into smaller tables, but removing any unnecessary data as well.

    As for indexing, you should definitely index the table that holds the data, whatever table that might be.
     
  9. davus

    davus Member

    Joined:
    Aug 23, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for the input. I went ahead and broke down the tables so they would store maximum 100k rows each, indexed all the tables, but load avg still hasn't gone down. I did get a message from the smart daemon saying i had bad sectors though. Do you think that might be causing it?
     
  10. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    If you have bad sectors, that is going to be an issue. You'd likely want to migrate to new hardware if running a file system check doesn't resolve the issue.

    Prior to doing anything, please ensure you have full backups for the accounts off the machine. If you normally make backups on the machine, simply move them to another location. This way, if the server doesn't come back from the reboot and file system check, you can restore to another machine without losing data.
     
  11. davus

    davus Member

    Joined:
    Aug 23, 2012
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi, Here's an update. So, we switched the hardware and the load avg hadn't gotten any better. We broke down the tables some more so that they would only store 10k records each. This seemed to drop the load avg to below 2.0, with occasional spikes. Also, we started using memcached, but it doesn't seem to have had much of an effect.
     
  12. backblaze

    backblaze Member

    Joined:
    May 17, 2010
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    memcached - must be configured in your software to use it. (properly)
    lower your connections to 100
    bump your query cache to 32M (you see Query cache efficiency: 99.4%)
     
Loading...

Share This Page