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.

vBulletin + MySQL + cPanel / WHM dedicated server optimization request

Discussion in 'Workarounds and Optimization' started by forofutbolistas, Mar 24, 2014.

  1. forofutbolistas

    Joined:
    Jan 25, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I recently upgraded my dedicated server to Apache/2.4.7 (Unix) PHP/5.3.28 MySQL 5.5.36-cll

    The server is only running a vBulletin forum (3.7 branch with all patches) that gets around 15,000 daily visits with around 800 visitors in the busiest hours.

    During those hours, the forum works very slow, so I was looking for some help optimizing the server.

    I have installed mysqlmymonlite.sh for CentOS / WHM to get all the info need, if someone may help me I would be very grateful :)

    Code:
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 WHM mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Mon Mar 24 05:28:47 PDT 2014
    Code:
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started 2014-03-23 17:57:44
    Uptime: 11 hours 31 min 2 sec  
    Uptime 41462
    Uptime_since_flush_status 41462
    
    --------------------
    Query Cache Limit (bytes): 1048576
    Query Cache Min Unit (bytes): 4096
    Query Cache Size (bytes): 134217728
    Query Cache Free Mem (bytes): 120641184
    Query Cache Used Mem (bytes): 13576544
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 13576544
    Code:
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 2, cores = 2, virtual = 4, hyperthreading = yes
          4  2800.304
          4  Intel(R) Xeon(TM) CPU 2.80GHz
          4  2048 KB
    Code:
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 2.6.18-274.3.1.el5PAE ((yourserverhostname)) 	03/24/2014
    
    05:28:47 AM  CPU   %user   %nice    %sys %iowait    %irq   %soft  %steal   %idle    intr/s
    05:28:49 AM  all   48.06    0.00    3.12    0.25    0.00    0.12    0.00   48.44   1156.00
    05:28:49 AM    0   60.00    0.00    4.00    1.00    0.00    0.00    0.00   35.00   1001.50
    05:28:49 AM    1   41.29    0.00    2.49    0.00    0.50    0.50    0.00   55.22    154.50
    05:28:49 AM    2   66.83    0.00    4.02    0.00    0.00    0.00    0.00   29.15      0.00
    05:28:49 AM    3   24.38    0.00    1.49    0.00    0.00    0.00    0.00   74.13      0.00
    
    05:28:49 AM  CPU   %user   %nice    %sys %iowait    %irq   %soft  %steal   %idle    intr/s
    05:28:51 AM  all   13.72    0.00    1.12    0.25    0.12    0.12    0.00   84.66   1129.50
    05:28:51 AM    0    3.50    0.00    0.50    0.00    0.00    0.00    0.00   96.00   1001.00
    05:28:51 AM    1   16.50    0.00    1.50    0.50    0.00    0.50    0.00   81.00    128.50
    05:28:51 AM    2    4.98    0.00    1.00    0.00    0.00    0.00    0.00   94.03      0.00
    05:28:51 AM    3   30.50    0.00    2.00    0.00    0.00    0.00    0.00   67.50      0.00
    
    Average:     CPU   %user   %nice    %sys %iowait    %irq   %soft  %steal   %idle    intr/s
    Average:     all   30.88    0.00    2.12    0.25    0.06    0.12    0.00   66.56   1142.75
    Average:       0   31.75    0.00    2.25    0.50    0.00    0.00    0.00   65.50   1001.25
    Average:       1   28.93    0.00    2.00    0.25    0.25    0.50    0.00   68.08    141.50
    Average:       2   35.75    0.00    2.50    0.00    0.00    0.00    0.00   61.75      0.00
    Average:       3   27.43    0.00    1.75    0.00    0.00    0.00    0.00   70.82      0.00
    
    top - 05:28:51 up 27 days, 14:22,  1 user,  load average: 2.27, 2.15, 2.06
    Tasks: 222 total,   1 running, 219 sleeping,   0 stopped,   2 zombie
    Cpu(s): 47.2%us,  3.5%sy,  0.1%ni, 48.3%id,  0.5%wa,  0.0%hi,  0.4%si,  0.0%st
    Mem:   4151412k total,  3603144k used,   548268k free,   160700k buffers
    Swap:  4192956k total,       80k used,  4192876k free,  2312324k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND            
    30737 nobody    15   0 73268  15m 6756 S 15.6  0.4   0:00.18 httpd              
    29871 nobody    15   0 73144  15m 7408 S  1.9  0.4   0:02.62 httpd              
    30034 nobody    22   0     0    0    0 Z  1.9  0.0   0:01.15 httpd <defunct>    
    30792 nobody    15   0 72868  15m 6984 S  1.9  0.4   0:00.47 httpd              
        1 root      15   0  2176  640  556 S  0.0  0.0   0:10.16 init               
        2 root      RT  -5     0    0    0 S  0.0  0.0   0:06.71 migration/0        
        3 root      34  19     0    0    0 S  0.0  0.0   0:00.14 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:05.36 migration/1        
        6 root      34  19     0    0    0 S  0.0  0.0   0:00.16 ksoftirqd/1        
        7 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/1         
        8 root      RT  -5     0    0    0 S  0.0  0.0   0:06.67 migration/2        
        9 root      34  19     0    0    0 S  0.0  0.0   0:00.13 ksoftirqd/2        
       10 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/2         
       11 root      RT  -5     0    0    0 S  0.0  0.0   0:05.87 migration/3        
       12 root      34  19     0    0    0 S  0.0  0.0   0:00.11 ksoftirqd/3        
       13 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 watchdog/3         
       14 root      10  -5     0    0    0 S  0.0  0.0   0:00.10 events/0           
       15 root      10  -5     0    0    0 S  0.0  0.0   0:00.10 events/1           
       16 root      10  -5     0    0    0 S  0.0  0.0   0:00.10 events/2           
       17 root      10  -5     0    0    0 S  0.0  0.0   0:00.12 events/3           
       18 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khelper            
       19 root      10  -5     0    0    0 S  0.0  0.0   0:00.01 kthread            
       25 root      10  -5     0    0    0 S  0.0  0.0   0:01.30 kblockd/0          
       26 root      10  -5     0    0    0 S  0.0  0.0   0:03.10 kblockd/1          
       27 root      10  -5     0    0    0 S  0.0  0.0   0:01.37 kblockd/2          
       28 root      10  -5     0    0    0 S  0.0  0.0   0:04.32 kblockd/3          
       29 root      19  -5     0    0    0 S  0.0  0.0   0:00.00 kacpid             
      117 root      19  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/0           
      118 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/1           
      119 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/2           
      120 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 cqueue/3           
      123 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khubd              
      125 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kseriod            
      198 root      15   0     0    0    0 S  0.0  0.0   0:00.17 khungtaskd         
      201 root      10  -5     0    0    0 S  0.0  0.0   1:36.07 kswapd0            
      202 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 aio/0              
      203 root      16  -5     0    0    0 S  0.0  0.0   0:00.00 aio/1              
      204 root      17  -5     0    0    0 S  0.0  0.0   0:00.00 aio/2              
      205 root      17  -5     0    0    0 S  0.0  0.0   0:00.00 aio/3              
      361 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 kpsmoused          
      405 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 ata/0              
      406 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 ata/1              
      407 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 ata/2              
      408 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 ata/3              
      409 root      16  -5     0    0    0 S  0.0  0.0   0:00.00 ata_aux            
      415 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0          
      416 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_1          
      417 root      10  -5     0    0    0 S  0.0  0.0   5:02.18 kjournald          
      442 root      10  -5     0    0    0 S  0.0  0.0   0:01.87 kauditd            
      475 root      21  -4  2404  636  392 S  0.0  0.0   0:00.45 udevd              
      950 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kedac              
     1367 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 kstriped           
     1386 root      12  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/0          
     1388 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/1          
     1389 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/2          
     1390 root      14  -5     0    0    0 S  0.0  0.0   0:00.00 kmpathd/3          
     1391 root      16  -5     0    0    0 S  0.0  0.0   0:00.00 kmpath_handlerd    
     1511 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kjournald          
     1513 root      11  -5     0    0    0 S  0.0  0.0   0:00.00 kjournald          
     1678 root       0 -20     0    0    0 S  0.0  0.0   0:16.55 loop0              
     1679 root      10  -5     0    0    0 S  0.0  0.0   0:01.35 kjournald          
     1767 root      18  -5     0    0    0 S  0.0  0.0   0:00.00 iscsi_eh           
     1831 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 cnic_wq            
     1854 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 ib_addr            
     1873 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_mcast           
     1874 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_inform          
     1875 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 local_sa           
     1881 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 iw_cm_wq           
     1889 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_cm/0            
     1890 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_cm/1            
     1891 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_cm/2            
     1892 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 ib_cm/3            
     1897 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 rdma_cm            
     1917 root      10 -10 22524  21m 1736 S  0.0  0.5   0:00.03 iscsiuio           
     1921 root      18   0  2372  420  348 S  0.0  0.0   0:04.12 iscsid             
     1922 root       5 -10  2836 2832 1904 S  0.0  0.1   0:00.04 iscsid             
     3739 root      15   0     0    0    0 S  0.0  0.0   0:00.32 pdflush            
     3994 root      15   0     0    0    0 S  0.0  0.0   0:05.79 pdflush            
     5918 root      15   0  8988 2868 2300 S  0.0  0.1   0:00.05 sshd               
     5919 sshd      15   0  8700 1332  868 S  0.0  0.0   0:00.03 sshd               
     6781 root      19  -4 13696  876  560 S  0.0  0.0   0:43.21 auditd             
     6783 root       7  -8 13216  932  584 S  0.0  0.0   0:09.08 audispd            
     6928 root      18   0  1832  584  488 S  0.0  0.0   0:19.30 syslogd            
     6931 root      15   0  1780  408  336 S  0.0  0.0   0:00.00 klogd              
     6945 root      15   0  2580  380  272 S  0.0  0.0   0:34.73 irqbalance         
     7017 dbus      16   0  2868  936  728 S  0.0  0.0   0:02.92 dbus-daemon        
     7060 root      25   0 12848 1296  556 S  0.0  0.0   1:08.16 pcscd              
     7074 root      21   0  1776  532  452 S  0.0  0.0   0:00.00 acpid              
     7087 haldaemo  19   0  6116 4084 1608 S  0.0  0.1   0:03.32 hald               
     7088 root      20   0  3284  984  840 S  0.0  0.0   0:00.00 hald-runner        
     7096 haldaemo  25   0  2124  804  716 S  0.0  0.0   0:00.00 hald-addon-acpi    
     7153 root      20   0 30464 1408 1084 S  0.0  0.0   0:02.41 automount          
    10949 root      15   0  7332 1060  644 S  0.0  0.0   0:04.47 sshd               
    11128 root      17   0  2892 1052  820 S  0.0  0.0   0:00.64 dovecot            
    11139 dovenull  18   0  7420 3692 1932 S  0.0  0.1   0:04.07 pop3-login         
    11140 dovenull  15   0  6112 2184 1796 S  0.0  0.1   0:00.30 imap-login         
    11141 dovecot   16   0  2772  852  724 S  0.0  0.0   0:03.53 anvil              
    11142 root      18   0  2904 1088  764 S  0.0  0.0   0:03.09 log                
    11144 dovenull  18   0 12832 9256 2096 S  0.0  0.2   0:15.08 pop3-login         
    11145 dovenull  18   0  6112 2524 2100 S  0.0  0.1   0:00.23 imap-login         
    11147 root      15   0  3576 1668  928 S  0.0  0.0   0:00.35 config             
    11164 root      15   0  7484 1520 1156 S  0.0  0.0   0:03.68 pure-ftpd          
    11166 root      16   0  8028 1232  980 S  0.0  0.0   0:00.85 pure-authd         
    11180 root      18   0  6260 1116  568 S  0.0  0.0   0:04.24 crond              
    11233 root      18   0  2376  476  360 S  0.0  0.0   0:00.03 atd                
    11611 root      15   0 17116  12m 4900 S  0.0  0.3   0:11.83 cpsrvd-ssl         
    11618 named     25   0 74012 7556 2112 S  0.0  0.2   8:29.76 named              
    11777 root      15   0  8988 2860 2300 S  0.0  0.1   0:00.02 sshd               
    11778 sshd      15   0  8700 1332  868 S  0.0  0.0   0:00.01 sshd               
    12821 avahi     18   0  2716 1300 1112 S  0.0  0.0   0:01.10 avahi-daemon       
    12822 avahi     22   0  2716  328  192 S  0.0  0.0   0:00.00 avahi-daemon       
    12829 root      15   0  8988 2852 2300 S  0.0  0.1   0:00.03 sshd               
    12830 sshd      15   0  8700 1328  876 S  0.0  0.0   0:00.00 sshd               
    12951 root      16   0  3792  720  356 S  0.0  0.0   0:00.43 smartd             
    12955 root      15   0  1764  444  384 S  0.0  0.0   0:00.00 mingetty           
    12956 root      15   0  1764  440  384 S  0.0  0.0   0:00.00 mingetty           
    12957 root      15   0  1764  440  384 S  0.0  0.0   0:00.00 mingetty           
    12958 root      20   0  1764  440  384 S  0.0  0.0   0:00.00 mingetty           
    12959 root      20   0  1764  440  384 S  0.0  0.0   0:00.00 mingetty           
    12960 root      21   0  1764  440  384 S  0.0  0.0   0:00.00 mingetty           
    13387 root      34  19 27336  10m 2228 S  0.0  0.3   0:03.56 yum-updatesd       
    13390 root      34  19  2676 1164  952 S  0.0  0.0   0:09.84 gam_server         
    14864 mailnull  18   0 10556 3844 2556 S  0.0  0.1   0:01.84 exim               
    14878 root      15   0 31576  27m 2360 S  0.0  0.7   0:08.82 /usr/local/cpan    
    15378 root      15   0 31576  26m 1176 S  0.0  0.7   0:00.08 spamd child        
    15410 root      15   0 31576  26m 1176 S  0.0  0.7   0:00.05 spamd child        
    16608 root      15   0  8988 2852 2300 S  0.0  0.1   0:00.03 sshd               
    16611 sshd      15   0  8700 1324  876 S  0.0  0.0   0:00.01 sshd               
    17679 root      15   0  9796 5188 2196 S  0.0  0.1   0:10.76 cPhulkd - proce    
    18534 root      21   0  5464 1244 1060 S  0.0  0.0   0:00.05 mysqld_safe        
    18826 mysql     15   0 2030m 543m 5464 S  0.0 13.4 962:19.83 mysqld             
    19421 root      15   0  8988 2860 2300 S  0.0  0.1   0:00.03 sshd               
    19424 sshd      15   0  8700 1332  876 S  0.0  0.0   0:00.00 sshd               
    20060 root      15   0  8988 2856 2300 S  0.0  0.1   0:00.04 sshd               
    20083 sshd      15   0  8700 1328  868 S  0.0  0.0   0:00.03 sshd               
    23259 root      18   0  6332 4380 1392 S  0.0  0.1   0:00.62 queueprocd - wa    
    23305 root      33  18  4584 2104  744 S  0.0  0.1   0:00.54 cpanellogd - sl    
    24119 root      15   0  8988 2848 2304 S  0.0  0.1   0:00.04 sshd               
    24120 sshd      15   0  8700 1344  892 S  0.0  0.0   0:00.01 sshd               
    24893 root      19   0  4128  844  712 S  0.0  0.0   0:00.00 ssl-params         
    27089 root      18   0 11192 6616 2396 S  0.0  0.2   0:00.24 leechprotect       
    28222 root      15   0 10336 3044 2440 S  0.0  0.1   0:00.12 sshd               
    28227 root      15   0  6780 1632 1216 S  0.0  0.0   0:00.01 sftp-server        
    28261 root      15   0 10204 3040 2456 S  0.0  0.1   0:00.16 sshd               
    28271 root      15   0  5644 1464 1192 S  0.0  0.0   0:00.05 bash               
    29789 nobody    15   0 72992  16m 8632 S  0.0  0.4   0:02.35 httpd              
    29794 nobody    15   0 72616  15m 7352 S  0.0  0.4   0:01.92 httpd              
    29843 nobody    16   0 72580  14m 7000 S  0.0  0.4   0:01.21 httpd              
    29858 nobody    16   0 72880  15m 7164 S  0.0  0.4   0:01.63 httpd              
    29875 nobody    15   0 73588  16m 7468 S  0.0  0.4   0:02.12 httpd              
    30025 nobody    15   0 73132  15m 6788 S  0.0  0.4   0:00.81 httpd              
    30032 nobody    15   0 73212  15m 6968 S  0.0  0.4   0:01.41 httpd              
    30046 nobody    15   0 73276  17m 8716 S  0.0  0.4   0:02.00 httpd              
    30071 nobody    15   0 72656  16m 8300 S  0.0  0.4   0:01.54 httpd              
    30238 nobody    15   0 73228  15m 7284 S  0.0  0.4   0:02.96 httpd              
    30283 nagios    18   0  1920  596  496 S  0.0  0.0   0:08.16 nrpe               
    30407 nobody    15   0 73208  15m 6772 S  0.0  0.4   0:01.22 httpd              
    30408 nobody    15   0 72676  15m 7088 S  0.0  0.4   0:01.20 httpd              
    30409 root      17   0     0    0    0 Z  0.0  0.0   0:00.00 cpsrvd-ss <defunct>
    30413 nobody    15   0 73164  15m 7500 S  0.0  0.4   0:02.92 httpd              
    30574 nobody    15   0 73208  15m 7268 S  0.0  0.4   0:01.35 httpd              
    30577 nobody    15   0 72896  15m 7072 S  0.0  0.4   0:00.91 httpd              
    30578 nobody    15   0 72220  14m 6764 S  0.0  0.4   0:00.61 httpd              
    30582 nobody    15   0 72200  14m 6852 S  0.0  0.4   0:00.88 httpd              
    30584 nobody    15   0 73736  15m 6768 S  0.0  0.4   0:01.08 httpd              
    30595 nobody    15   0 72216  16m 9236 S  0.0  0.4   0:02.24 httpd              
    30597 nobody    15   0 73280  15m 7248 S  0.0  0.4   0:01.02 httpd              
    30599 nobody    15   0 72888  14m 6856 S  0.0  0.4   0:00.57 httpd              
    30601 nobody    15   0 72556  14m 6720 S  0.0  0.4   0:00.45 httpd              
    30604 nobody    15   0 73444  16m 8188 S  0.0  0.4   0:00.37 httpd              
    30606 nobody    15   0 72836  14m 6720 S  0.0  0.4   0:00.98 httpd              
    30609 nobody    15   0 73432  17m 8592 S  0.0  0.4   0:01.72 httpd              
    30612 nobody    15   0 72608  14m 6556 S  0.0  0.4   0:00.79 httpd              
    30613 nobody    15   0 72616  14m 6612 S  0.0  0.4   0:00.88 httpd              
    30617 nobody    15   0 72924  14m 6392 S  0.0  0.4   0:00.22 httpd              
    30618 nobody    15   0 72180  15m 7504 S  0.0  0.4   0:00.53 httpd              
    30619 nobody    16   0 73160  15m 7216 S  0.0  0.4   0:00.93 httpd              
    30620 nobody    15   0 72880  14m 6760 S  0.0  0.4   0:00.54 httpd              
    30623 nobody    16   0 72548  13m 5508 S  0.0  0.3   0:00.25 httpd              
    30730 nobody    15   0 72588  14m 6628 S  0.0  0.4   0:00.46 httpd              
    30732 nobody    15   0 73256  16m 7568 S  0.0  0.4   0:00.32 httpd              
    30733 nobody    15   0 72844  13m 5464 S  0.0  0.3   0:00.29 httpd              
    30734 nobody    15   0 73208  15m 6848 S  0.0  0.4   0:00.42 httpd              
    30735 nobody    15   0 72308  13m 5952 S  0.0  0.3   0:00.17 httpd              
    30738 nobody    15   0 73204  15m 6744 S  0.0  0.4   0:00.21 httpd              
    30739 nobody    15   0 73292  15m 6752 S  0.0  0.4   0:00.31 httpd              
    30767 nobody    15   0 72672  14m 6552 S  0.0  0.4   0:00.13 httpd              
    30768 nobody    15   0 72572  14m 6776 S  0.0  0.4   0:00.82 httpd              
    30773 nobody    15   0 73584  15m 6340 S  0.0  0.4   0:00.19 httpd              
    30778 nobody    15   0 72664  13m 6084 S  0.0  0.3   0:00.16 httpd              
    30781 nobody    15   0 72968  14m 6376 S  0.0  0.4   0:00.58 httpd              
    30782 nobody    15   0 73204  14m 6280 S  0.0  0.4   0:00.25 httpd              
    30783 nobody    15   0 72756  14m 6460 S  0.0  0.4   0:00.18 httpd              
    30784 nobody    15   0 72212  12m 5204 S  0.0  0.3   0:00.09 httpd              
    30785 nobody    15   0 72220  12m 5204 S  0.0  0.3   0:00.14 httpd              
    30786 nobody    15   0 72832  14m 6292 S  0.0  0.4   0:00.27 httpd              
    30788 nobody    16   0 73152  15m 7136 S  0.0  0.4   0:00.62 httpd              
    30791 nobody    15   0 68916 9212 2824 S  0.0  0.2   0:00.03 httpd              
    30793 nobody    16   0 72928  14m 6616 S  0.0  0.4   0:00.22 httpd              
    30794 nobody    15   0 68916 9248 2820 S  0.0  0.2   0:00.04 httpd              
    30796 nobody    15   0 72964  13m 5500 S  0.0  0.3   0:00.26 httpd              
    30798 nobody    15   0 72884  14m 5908 S  0.0  0.3   0:00.26 httpd              
    30803 nobody    15   0 70872  15m 6880 S  0.0  0.4   0:00.20 httpd              
    30804 nobody    15   0 73644  15m 6468 S  0.0  0.4   0:00.26 httpd              
    30806 nobody    15   0 72660  14m 6560 S  0.0  0.4   0:00.27 httpd              
    30808 nobody    15   0 73052  16m 7836 S  0.0  0.4   0:00.32 httpd              
    30812 nobody    15   0 73252  15m 6524 S  0.0  0.4   0:00.59 httpd              
    30813 nobody    15   0 71716  12m 5464 S  0.0  0.3   0:00.16 httpd              
    30815 nobody    15   0 72964  14m 6344 S  0.0  0.4   0:00.48 httpd              
    30816 nobody    15   0 72564  14m 6148 S  0.0  0.3   0:00.42 httpd              
    30817 nobody    19   0 72600  15m 7432 S  0.0  0.4   0:01.18 httpd              
    30818 nobody    15   0 72840  14m 6676 S  0.0  0.4   0:00.31 httpd              
    30819 nobody    15   0 68924 9252 2820 S  0.0  0.2   0:00.02 httpd              
    30822 nobody    15   0 72652  13m 6072 S  0.0  0.3   0:00.14 httpd              
    30824 nobody    15   0 68548 9060 2820 S  0.0  0.2   0:00.04 httpd              
    30825 nobody    15   0 73144  14m 6508 S  0.0  0.4   0:00.54 httpd              
    30826 nobody    15   0 71732  12m 5456 S  0.0  0.3   0:00.06 httpd              
    30829 nobody    15   0 69652  12m 5404 S  0.0  0.3   0:00.05 httpd              
    30838 root      18   0  5720 1408  960 S  0.0  0.0   0:00.02 mysqlmymonlite.    
    30980 root      18   0 68400  11m 5264 S  0.0  0.3   0:01.48 httpd              
    31013 root      15   0  2440  988  708 R  0.0  0.0   0:00.01 top                
    
    
                 total       used       free     shared    buffers     cached
    Mem:          4054       3518        535          0        156       2258
    Low:           854        629        224
    High:         3199       2888        311
    -/+ buffers/cache:       1103       2950
    Swap:         4094          0       4094
    
    MemTotal:      4151412 kB
    MemFree:        548516 kB
    Buffers:        160700 kB
    Cached:        2312324 kB
    SwapCached:          0 kB
    Active:        2203488 kB
    Inactive:      1207492 kB
    HighTotal:     3276544 kB
    HighFree:       318588 kB
    LowTotal:       874868 kB
    LowFree:        229928 kB
    SwapTotal:     4192956 kB
    SwapFree:      4192876 kB
    Dirty:             968 kB
    Writeback:           0 kB
    AnonPages:      937880 kB
    Mapped:          34572 kB
    Slab:           155180 kB
    PageTables:      13156 kB
    NFS_Unstable:        0 kB
    Bounce:              0 kB
    CommitLimit:   6268660 kB
    Committed_AS:  4029748 kB
    VmallocTotal:   116728 kB
    VmallocUsed:     17804 kB
    VmallocChunk:    98344 kB
    HugePages_Total:     0
    HugePages_Free:      0
    HugePages_Rsvd:      0
    Hugepagesize:     2048 kB
    
    
     Private  +   Shared  =  RAM used	Program 
    
     88.0 KiB +   9.5 KiB =  97.5 KiB	klogd
     96.0 KiB +  25.0 KiB = 121.0 KiB	acpid
    116.0 KiB +  14.0 KiB = 130.0 KiB	nrpe
    116.0 KiB +  15.5 KiB = 131.5 KiB	init
    128.0 KiB +  12.5 KiB = 140.5 KiB	syslogd
    128.0 KiB +  15.5 KiB = 143.5 KiB	irqbalance
    136.0 KiB +  20.5 KiB = 156.5 KiB	atd
    128.0 KiB +  51.5 KiB = 179.5 KiB	hald-addon-acpi
    144.0 KiB +  44.5 KiB = 188.5 KiB	anvil
    144.0 KiB +  51.0 KiB = 195.0 KiB	ssl-params
    164.0 KiB + 120.5 KiB = 284.5 KiB	hald-runner
    280.0 KiB +  15.5 KiB = 295.5 KiB	udevd
    264.0 KiB +  56.0 KiB = 320.0 KiB	pure-authd
    304.0 KiB +  55.0 KiB = 359.0 KiB	dovecot
    340.0 KiB +  47.5 KiB = 387.5 KiB	log
    300.0 KiB +  98.0 KiB = 398.0 KiB	gam_server
    388.0 KiB +  16.0 KiB = 404.0 KiB	audispd
    248.0 KiB + 161.0 KiB = 409.0 KiB	mysqld_safe
    340.0 KiB +  72.0 KiB = 412.0 KiB	mingetty (6)
    416.0 KiB +  20.5 KiB = 436.5 KiB	auditd
    460.0 KiB +  21.0 KiB = 481.0 KiB	dbus-daemon
    484.0 KiB +  16.5 KiB = 500.5 KiB	smartd
    440.0 KiB +  79.0 KiB = 519.0 KiB	pure-ftpd
    460.0 KiB +  68.5 KiB = 528.5 KiB	sftp-server
    380.0 KiB + 162.5 KiB = 542.5 KiB	bash
    452.0 KiB + 152.0 KiB = 604.0 KiB	mysqlmymonlite.
    592.0 KiB +  23.0 KiB = 615.0 KiB	crond
    468.0 KiB + 184.0 KiB = 652.0 KiB	avahi-daemon (2)
    760.0 KiB +  43.5 KiB = 803.5 KiB	automount
    832.0 KiB +  59.0 KiB = 891.0 KiB	config
    892.0 KiB +  22.5 KiB = 914.5 KiB	pcscd
    824.0 KiB + 392.0 KiB =   1.2 MiB	imap-login (2)
      1.3 MiB +  81.0 KiB =   1.4 MiB	cpanellogd - sl
      1.3 MiB + 395.0 KiB =   1.7 MiB	iscsid (2)
      1.7 MiB + 239.0 KiB =   2.0 MiB	exim
      2.9 MiB + 161.5 KiB =   3.0 MiB	hald
      3.0 MiB + 157.0 KiB =   3.2 MiB	queueprocd - wa
      2.9 MiB + 328.0 KiB =   3.2 MiB	cPhulkd - proce
      4.2 MiB + 378.0 KiB =   4.6 MiB	leechprotect
      6.7 MiB +  53.0 KiB =   6.8 MiB	named
      4.6 MiB +   4.0 MiB =   8.6 MiB	sshd (17)
      8.7 MiB + 390.0 KiB =   9.1 MiB	pop3-login (2)
      8.9 MiB + 503.5 KiB =   9.4 MiB	yum-updatesd
      2.8 MiB +   8.1 MiB =  10.9 MiB	/usr/local/cpan
     10.8 MiB + 111.5 KiB =  10.9 MiB	cpsrvd-ssl
      4.5 MiB +  16.0 MiB =  20.4 MiB	spamd child (2)
     20.5 MiB + 348.0 KiB =  20.8 MiB	iscsiuio
    261.6 MiB +  19.2 MiB = 280.8 MiB	httpd (74)
    546.5 MiB + 190.5 KiB = 546.7 MiB	mysqld
    ---------------------------------
                            956.6 MiB
    =================================
    
     Private  +   Shared  =  RAM used	Program 
    
    
    smem -uk
    User     Count     Swap      USS      PSS      RSS 
    nagios       1        0   116.0K   119.0K   596.0K 
    dovecot      1        0   144.0K   174.0K   852.0K 
    dbus         1        0   460.0K   464.0K   936.0K 
    avahi        2        0   468.0K   616.0K     1.6M 
    mailnull     1        0     1.7M     1.9M     3.8M 
    sshd         7        0     1.1M     2.4M     9.1M 
    haldaemon     2        0     3.0M     3.2M     4.8M 
    named        1        0     6.7M     6.7M     7.4M 
    dovenull     4        0     9.5M    10.2M    17.2M 
    root        55        0    76.2M   105.8M   215.8M 
    nobody      71        0   256.0M   270.3M     1.0G 
    mysql        1        0   544.5M   544.5M   545.4M 
    
    smem -t -p
      PID User     Command                         Swap      USS      PSS      RSS 
    12956 root     /sbin/mingetty tty2            0.00%    0.00%    0.00%    0.01% 
    12957 root     /sbin/mingetty tty3            0.00%    0.00%    0.00%    0.01% 
    12958 root     /sbin/mingetty tty4            0.00%    0.00%    0.00%    0.01% 
    12959 root     /sbin/mingetty tty5            0.00%    0.00%    0.00%    0.01% 
    12960 root     /sbin/mingetty tty6            0.00%    0.00%    0.00%    0.01% 
    12955 root     /sbin/mingetty tty1            0.00%    0.00%    0.00%    0.01% 
     6931 root     klogd -x                       0.00%    0.00%    0.00%    0.01% 
     1921 root     iscsid                         0.00%    0.00%    0.00%    0.01% 
     7074 root     /usr/sbin/acpid                0.00%    0.00%    0.00%    0.01% 
    30283 nagios   /usr/local/nagios/bin/nrpe     0.00%    0.00%    0.00%    0.01% 
        1 root     init [3]                       0.00%    0.00%    0.00%    0.02% 
     6928 root     syslogd -m 0                   0.00%    0.00%    0.00%    0.01% 
     6945 root     irqbalance                     0.00%    0.00%    0.00%    0.01% 
    12822 avahi    avahi-daemon: chroot helpe     0.00%    0.00%    0.00%    0.01% 
    11233 root     /usr/sbin/atd                  0.00%    0.00%    0.00%    0.01% 
     7096 haldaemon hald-addon-acpi: listening     0.00%    0.00%    0.00%    0.02% 
    11141 dovecot  dovecot/anvil                  0.00%    0.00%    0.00%    0.02% 
    24893 root     dovecot/ssl-params             0.00%    0.00%    0.00%    0.02% 
     7088 root     hald-runner                    0.00%    0.00%    0.01%    0.02% 
      475 root     /sbin/udevd -d                 0.00%    0.01%    0.01%    0.02% 
    11166 root     /usr/sbin/pure-authd -s /va    0.00%    0.01%    0.01%    0.03% 
    16611 sshd     sshd: root [net]               0.00%    0.00%    0.01%    0.03% 
    12830 sshd     sshd: root [net]               0.00%    0.00%    0.01%    0.03% 
    11128 root     /usr/sbin/dovecot              0.00%    0.01%    0.01%    0.03% 
    19424 sshd     sshd: root [net]               0.00%    0.00%    0.01%    0.03% 
    20083 sshd     sshd: root [net]               0.00%    0.00%    0.01%    0.03% 
     5919 sshd     sshd: root [net]               0.00%    0.00%    0.01%    0.03% 
    11778 sshd     sshd: root [net]               0.00%    0.00%    0.01%    0.03% 
    24120 sshd     sshd: root [net]               0.00%    0.00%    0.01%    0.03% 
    11142 root     dovecot/log                    0.00%    0.01%    0.01%    0.03% 
    13390 root     /usr/libexec/gam_server        0.00%    0.01%    0.01%    0.03% 
     6783 root     /sbin/audispd                  0.00%    0.01%    0.01%    0.02% 
    18534 root     /bin/sh /usr/bin/mysqld_saf    0.00%    0.01%    0.01%    0.03% 
     6781 root     auditd                         0.00%    0.01%    0.01%    0.02% 
    10949 root     /usr/sbin/sshd                 0.00%    0.01%    0.01%    0.03% 
     7017 dbus     dbus-daemon --system           0.00%    0.01%    0.01%    0.02% 
    12821 avahi    avahi-daemon: running [serv    0.00%    0.01%    0.01%    0.03% 
    12951 root     /usr/sbin/smartd -q never      0.00%    0.01%    0.01%    0.02% 
    28227 root     /usr/libexec/openssh/sftp-s    0.00%    0.01%    0.01%    0.04% 
    11164 root     pure-ftpd (SERVER)             0.00%    0.01%    0.01%    0.04% 
    24119 root     sshd: root [priv]              0.00%    0.01%    0.01%    0.07% 
    12829 root     sshd: root [priv]              0.00%    0.01%    0.01%    0.07% 
    16608 root     sshd: root [priv]              0.00%    0.01%    0.01%    0.07% 
    20060 root     sshd: root [priv]              0.00%    0.01%    0.01%    0.07% 
    11777 root     sshd: root [priv]              0.00%    0.01%    0.01%    0.07% 
    19421 root     sshd: root [priv]              0.00%    0.01%    0.01%    0.07% 
     5918 root     sshd: root [priv]              0.00%    0.01%    0.01%    0.07% 
    28271 root     -bash                          0.00%    0.01%    0.01%    0.04% 
    11140 dovenull dovecot/imap-login             0.00%    0.01%    0.01%    0.05% 
    30838 root     /bin/bash ./mysqlmymonlite.    0.00%    0.01%    0.01%    0.03% 
    11180 root     crond                          0.00%    0.01%    0.01%    0.03% 
    11145 dovenull dovecot/imap-login             0.00%    0.01%    0.01%    0.06% 
    28261 root     sshd: root@pts/1               0.00%    0.01%    0.02%    0.07% 
    28222 root     sshd: root@notty               0.00%    0.01%    0.02%    0.07% 
     7153 root     automount --pid-file /var/r    0.00%    0.02%    0.02%    0.03% 
    30824 nobody   /usr/local/apache/bin/httpd    0.00%    0.01%    0.02%    0.22% 
    11147 root     dovecot/config                 0.00%    0.02%    0.02%    0.04% 
     7060 root     pcscd                          0.00%    0.02%    0.02%    0.03% 
    30791 nobody   /usr/local/apache/bin/httpd    0.00%    0.01%    0.02%    0.22% 
    23305 root     cpanellogd - sleeping for l    0.00%    0.03%    0.03%    0.05% 
     1922 root     iscsid                         0.00%    0.03%    0.04%    0.07% 
    30980 root     /usr/local/apache/bin/httpd    0.00%    0.03%    0.04%    0.27% 
    11139 dovenull dovecot/pop3-login             0.00%    0.04%    0.05%    0.09% 
    14864 mailnull /usr/sbin/exim -bd -q60m       0.00%    0.04%    0.05%    0.09% 
    30819 nobody   /usr/local/apache/bin/httpd    0.00%    0.06%    0.06%    0.30% 
    30813 nobody   /usr/local/apache/bin/httpd    0.00%    0.06%    0.06%    0.30% 
    30829 nobody   /usr/local/apache/bin/httpd    0.00%    0.06%    0.06%    0.30% 
    30826 nobody   /usr/local/apache/bin/httpd    0.00%    0.06%    0.06%    0.31% 
    31019 root     python /usr/bin/smem -t -p     0.00%    0.06%    0.07%    0.09% 
     7087 haldaemon hald                           0.00%    0.07%    0.07%    0.10% 
    23259 root     queueprocd - wait to proces    0.00%    0.07%    0.08%    0.11% 
    17679 root     cPhulkd - processo             0.00%    0.07%    0.08%    0.12% 
    30784 nobody   /usr/local/apache/bin/httpd    0.00%    0.08%    0.08%    0.32% 
    30578 nobody   /usr/local/apache/bin/httpd    0.00%    0.08%    0.08%    0.35% 
    30582 nobody   /usr/local/apache/bin/httpd    0.00%    0.08%    0.08%    0.36% 
    30785 nobody   /usr/local/apache/bin/httpd    0.00%    0.08%    0.08%    0.33% 
    30822 nobody   /usr/local/apache/bin/httpd    0.00%    0.08%    0.09%    0.34% 
    30816 nobody   /usr/local/apache/bin/httpd    0.00%    0.08%    0.09%    0.35% 
    30730 nobody   /usr/local/apache/bin/httpd    0.00%    0.08%    0.09%    0.36% 
    30623 nobody   /usr/local/apache/bin/httpd    0.00%    0.08%    0.09%    0.33% 
    29843 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.37% 
    30601 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.36% 
    30612 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.36% 
    30768 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.36% 
    30793 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.36% 
    30735 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.34% 
    30767 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.36% 
    30577 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.37% 
    29794 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.38% 
    30613 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.36% 
    30408 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.37% 
    30786 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.35% 
    30783 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.36% 
    30595 nobody   /usr/local/apache/bin/httpd    0.00%    0.08%    0.09%    0.41% 
    30599 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.37% 
    30733 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.09%    0.34% 
    30798 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.35% 
    30606 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.37% 
    30620 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.37% 
    30796 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.34% 
    30792 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.37% 
    30617 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.36% 
    29858 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.38% 
    30618 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.37% 
    30817 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.38% 
    30815 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.36% 
    30574 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.38% 
    30788 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.38% 
    30025 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.38% 
    30825 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.37% 
    30738 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.38% 
    30619 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.39% 
    30597 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.39% 
    30407 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.38% 
    30808 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.10%    0.40% 
    30782 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.37% 
    30734 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.38% 
    30818 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.37% 
    29871 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.39% 
    30032 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.38% 
    30804 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.10%    0.37% 
    30812 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.11%    0.37% 
    30737 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.11%    0.38% 
    30413 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.11%    0.39% 
    30739 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.11%    0.38% 
    29789 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.11%    0.42% 
    30773 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.11%    0.37% 
    30238 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.11%    0.39% 
    30803 nobody   /usr/local/apache/bin/httpd    0.00%    0.09%    0.11%    0.40% 
    30732 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.11%    0.40% 
    29875 nobody   /usr/local/apache/bin/httpd    0.00%    0.11%    0.11%    0.40% 
    27089 root     /usr/local/cpanel/3rdparty/    0.00%    0.10%    0.11%    0.16% 
    30046 nobody   /usr/local/apache/bin/httpd    0.00%    0.10%    0.11%    0.43% 
    30806 nobody   /usr/local/apache/bin/httpd    0.00%    0.11%    0.12%    0.40% 
    30584 nobody   /usr/local/apache/bin/httpd    0.00%    0.12%    0.12%    0.40% 
    30604 nobody   /usr/local/apache/bin/httpd    0.00%    0.12%    0.13%    0.42% 
    11618 named    /usr/sbin/named -u named -t    0.00%    0.17%    0.17%    0.18% 
    11144 dovenull dovecot/pop3-login             0.00%    0.17%    0.18%    0.22% 
    13387 root     /usr/bin/python -tt /usr/sb    0.00%    0.22%    0.23%    0.26% 
    15410 root     spamd chil                     0.00%    0.05%    0.25%    0.66% 
    15378 root     spamd chil                     0.00%    0.06%    0.25%    0.66% 
    14878 root     /usr/local/cpanel/3rdparty/    0.00%    0.07%    0.27%    0.69% 
    11611 root     cpsrvd (SSL) - waiting for     0.00%    0.27%    0.27%    0.30% 
     1917 root     iscsiuio                       0.00%    0.50%    0.51%    0.54% 
    18826 mysql    /usr/sbin/mysqld --basedir=    0.00%   13.38%   13.38%   13.40% 
    -------------------------------------------------------------------------------
      145 12                                      0.00%   21.98%   23.12%   44.96% 
    
    smem -wk
    Code:
    ----------------------------
    Server Disk Usage
    ----------------------------
    Filesystem    Type    Size  Used Avail Use% Mounted on
    /dev/sda3     ext3    222G   79G  132G  38% /
    /dev/sda1     ext3    251M   24M  215M  10% /boot
    tmpfs        tmpfs    2.0G     0  2.0G   0% /dev/shm
    /dev/sdb1     ext3    230G  188M  218G   1% /newstorage
    /usr/tmpDSK   ext3    1.9G   35M  1.8G   2% /tmp
    Code:
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 1804872 kilobytes of disk space
    Code:
    ----------------------------
    ulimit -aH
    ----------------------------
    core file size          (blocks, -c) unlimited
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 73728
    max locked memory       (kbytes, -l) 32
    max memory size         (kbytes, -m) unlimited
    open files                      (-n) 10240
    pipe size            (512 bytes, -p) 8
    POSIX message queues     (bytes, -q) 819200
    real-time priority              (-r) 0
    stack size              (kbytes, -s) unlimited
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 73728
    virtual memory          (kbytes, -v) unlimited
    file locks                      (-x) unlimited
    Code:
    ----------------------------------------------------------
    tail -15 /etc/security/limits.conf
    ----------------------------------------------------------
    #<domain>      <type>  <item>         <value>
    #
    
    #*               soft    core            0
    #*               hard    rss             10000
    #@student        hard    nproc           20
    #@faculty        soft    nproc           20
    #@faculty        hard    nproc           50
    #ftp             hard    nproc           0
    #@student        -       maxlogins       4
    
    *    hard    nofile  10240
    *    soft    nofile  10240
    
    # End of file
    Code:
    ----------------------------------------------------------
    mysqld process limits: 
    cat /proc/18826/limits
    ----------------------------------------------------------
    Limit                     Soft Limit           Hard Limit           Units     
    Max cpu time              unlimited            unlimited            seconds   
    Max file size             unlimited            unlimited            bytes     
    Max data size             unlimited            unlimited            bytes     
    Max stack size            10485760             unlimited            bytes     
    Max core file size        0                    unlimited            bytes     
    Max resident set          unlimited            unlimited            bytes     
    Max processes             73728                73728                processes 
    Max open files            61010                61010                files     
    Max locked memory         32768                32768                bytes     
    Max address space         unlimited            unlimited            bytes     
    Max file locks            unlimited            unlimited            locks     
    Max pending signals       73728                73728                signals   
    Max msgqueue size         819200               819200               bytes     
    Max nice priority         0                    0                    
    Max realtime priority     0                    0                    
    Code:
    ----------------------------------
    CPANEL WEB SERVER & PHP Info:
    ----------------------------------
    WHM / Cpanel version: 11.42.0.22
    
    WHM's PHP Handler config:
    /usr/local/cpanel/bin/rebuild_phpconf --current
    Available handlers: suphp dso cgi none
    DEFAULT PHP: 5
    PHP4 SAPI: none
    PHP5 SAPI: dso
    SUEXEC: not installed
    RUID2: not installed
    
    PHP 5.3.28 (cli) (built: Feb 25 2014 02:58:29) 
    Copyright (c) 1997-2013 The PHP Group
    Zend Engine v2.3.0, Copyright (c) 1998-2013 Zend Technologies
        with XCache v3.0.3, Copyright (c) 2005-2013, by mOo
        with XCache Cacher v3.0.3, Copyright (c) 2005-2013, by mOo
    
    System => Linux yourserverhostname 2.6.18-274.3.1.el5PAE #1 SMP Tue Sep 6 20:56:05 EDT 2011 i686
    Build Date => Feb 25 2014 02:57:42
    
    Configure Command =>  './configure'  '--disable-fileinfo' '--disable-pdo' '--disable-phar' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-sockets' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-freetype-dir=/usr' '--with-gd' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libxml-dir=/opt/xml2/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-zlib' '--with-zlib-dir=/usr' '--without-sqlite3'
    
    Server API | Command Line Interface
    Configuration File (php.ini) Path | /usr/local/lib
    Loaded Configuration File | /usr/local/lib/php.ini
    PHP API | 20090626
    Zend Extension Build | API220090626,NTS
    PHP Extension Build | API20090626,NTS
    DOM/XML API Version | 20031129
    Client API version | 5.5.36
    
    display_errors | STDOUT | STDOUT
    error_log | error_log | error_log
    extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20090626 | /usr/local/lib/php/extensions/no-debug-non-zts-20090626
    file_uploads | On | On
    log_errors | On | On
    log_errors_max_len | 1024 | 1024
    magic_quotes_gpc | On | On
    magic_quotes_sybase | Off | Off
    max_execution_time | 0 | 0
    max_file_uploads | 20 | 20
    memory_limit | 64M | 64M
    open_basedir | no value | no value
    post_max_size | 8M | 8M
    realpath_cache_size | 16K | 16K
    realpath_cache_ttl | 120 | 120
    safe_mode | Off | Off
    safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
    safe_mode_gid | Off | Off
    safe_mode_include_dir | no value | no value
    sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
    sql.safe_mode | Off | Off
    upload_max_filesize | 2M | 2M
    upload_tmp_dir | no value | no value
    safe_mode_allowed_env_vars | PHP_ | PHP_
    safe_mode_protected_env_vars | LD_LIBRARY_PATH | LD_LIBRARY_PATH
    
    GD Support | enabled
    GD Version | bundled (2.1.0 compatible)
    FreeType Support | enabled
    FreeType Linkage | with freetype
    FreeType Version | 2.2.1
    GIF Read Support | enabled
    GIF Create Support | enabled
    JPEG Support | enabled
    libJPEG Version | 6b
    PNG Support | enabled
    libPNG Version | 1.2.10
    WBMP Support | enabled
    libXML support | active
    libXML Compiled Version | 2.9.0
    libXML Loaded Version | 20900
    libXML streams | enabled
    PCRE (Perl Compatible Regular Expressions) Support | enabled
    PCRE Library Version | 8.21 2011-12-12
    ZLib Support | enabled
    
    xcache.coredump_directory | no value | no value
    xcache.disable_on_crash | Off | Off
    xcache.experimental | Off | Off
    xcache.test | Off | Off
    xcache.admin.enable_auth | On | On
    xcache.allocator | bestfit | bestfit
    xcache.cacher | On | On
    xcache.count | 4 | 4
    xcache.gc_interval | 900 | 900
    xcache.mmap_path | /dev/zero | /dev/zero
    xcache.readonly_protection | Off | Off
    xcache.shm_scheme | mmap | mmap
    xcache.size | 32M | 32M
    xcache.slots | 8K | 8K
    xcache.stat | On | On
    xcache.ttl | 0 | 0
    xcache.var_allocator | bestfit | bestfit
    xcache.var_count | 4 | 4
    xcache.var_gc_interval | 300 | 300
    xcache.var_maxttl | 14400 | 14400
    xcache.var_namespace | no value | no value
    xcache.var_namespace_mode | 0 | 0
    xcache.var_size | 2M | 2M
    xcache.var_slots | 4K | 4K
    xcache.var_ttl | 7200 | 7200
    
    memcache support => enabled
    Active persistent connections => 0
    Version => 2.2.7
    Revision => $Revision: 327750 $
    
    Directive => Local Value => Master Value
    memcache.allow_failover => 1 => 1
    memcache.chunk_size => 8192 => 8192
    memcache.default_port => 11211 => 11211
    memcache.default_timeout_ms => 1000 => 1000
    memcache.hash_function => crc32 => crc32
    memcache.hash_strategy => standard => standard
    memcache.max_failover_attempts => 20 => 20
    
    mysql
    
    
    PCRE (Perl Compatible Regular Expressions) Support => enabled
    PCRE Library Version => 8.21 2011-12-12
    
    Directive => Local Value => Master Value
    pcre.backtrack_limit => 1000000 => 1000000
    pcre.recursion_limit => 100000 => 100000
    
    
    
    
       Server Version: Apache/2.4.7 (Unix) OpenSSL/0.9.8e-fips-rhel5
       Server Built: Feb 25 2014 02:54:19
       Current Time: Monday, 24-Mar-2014 05:28:46 PDT
       Restart Time: Monday, 24-Mar-2014 03:59:39 PDT
       Total accesses: 77835 - Total Traffic: 567.7 MB
       CPU Usage: u74.71 s6.1 cu0 cs0 - 1.51% CPU load
       14.6 requests/sec - 108.7 kB/second - 7.5 kB/request
       29 requests currently being processed, 52 idle workers
    
    Server version: Apache/2.4.7 (Unix)
    Server built:   Feb 25 2014 02:54:19
    Cpanel::Easy::Apache v3.24.11 rev9999
    Server's Module Magic Number: 20120211:27
    Server loaded:  APR 1.5.0, APR-UTIL 1.5.3
    Compiled using: APR 1.5.0, APR-UTIL 1.5.3
    Architecture:   32-bit
    Server MPM:     prefork
      threaded:     no
        forked:     yes (variable process count)
    Server compiled with....
     -D APR_HAS_SENDFILE
     -D APR_HAS_MMAP
     -D APR_HAVE_IPV6 (IPv4-mapped addresses disabled)
     -D APR_USE_SYSVSEM_SERIALIZE
     -D APR_USE_PTHREAD_SERIALIZE
     -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
     -D APR_HAS_OTHER_CHILD
     -D AP_HAVE_RELIABLE_PIPED_LOGS
     -D DYNAMIC_MODULE_LIMIT=256
     -D HTTPD_ROOT="/usr/local/apache"
     -D SUEXEC_BIN="/usr/local/apache/bin/suexec"
     -D DEFAULT_PIDLOG="logs/httpd.pid"
     -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
     -D DEFAULT_ERRORLOG="logs/error_log"
     -D AP_TYPES_CONFIG_FILE="conf/mime.types"
     -D SERVER_CONFIG_FILE="conf/httpd.conf"
    
    Loaded Modules:
     core_module (static)
     authn_file_module (static)
     authn_core_module (static)
     authz_host_module (static)
     authz_groupfile_module (static)
     authz_user_module (static)
     authz_core_module (static)
     access_compat_module (static)
     auth_basic_module (static)
     socache_shmcb_module (static)
     socache_dbm_module (static)
     so_module (static)
     include_module (static)
     filter_module (static)
     deflate_module (static)
     http_module (static)
     mime_module (static)
     log_config_module (static)
     logio_module (static)
     expires_module (static)
     headers_module (static)
     setenvif_module (static)
     proxy_module (static)
     proxy_connect_module (static)
     proxy_http_module (static)
     slotmem_shm_module (static)
     ssl_module (static)
     mpm_prefork_module (static)
     unixd_module (static)
     status_module (static)
     autoindex_module (static)
     info_module (static)
     suexec_module (static)
     cgi_module (static)
     negotiation_module (static)
     dir_module (static)
     actions_module (static)
     userdir_module (static)
     alias_module (static)
     rewrite_module (static)
     bwlimited_module (shared)
     disable_suexec_module (shared)
     php5_module (shared)
    
    Compiled in modules:
      core.c
      mod_authn_file.c
      mod_authn_core.c
      mod_authz_host.c
      mod_authz_groupfile.c
      mod_authz_user.c
      mod_authz_core.c
      mod_access_compat.c
      mod_auth_basic.c
      mod_socache_shmcb.c
      mod_socache_dbm.c
      mod_so.c
      mod_include.c
      mod_filter.c
      mod_deflate.c
      http_core.c
      mod_mime.c
      mod_log_config.c
      mod_logio.c
      mod_expires.c
      mod_headers.c
      mod_setenvif.c
      mod_proxy.c
      mod_proxy_connect.c
      mod_proxy_http.c
      mod_slotmem_shm.c
      mod_ssl.c
      prefork.c
      mod_unixd.c
      mod_status.c
      mod_autoindex.c
      mod_info.c
      mod_suexec.c
      mod_cgi.c
      mod_negotiation.c
      mod_dir.c
      mod_actions.c
      mod_userdir.c
      mod_alias.c
      mod_rewrite.c
    Code:
    -------------------------------
    From /usr/local/apache/conf/httpd.conf
    -------------------------------
    Timeout 300
    KeepAlive On
    MaxKeepAliveRequests 100
    KeepAliveTimeout 5
    
    </IfModule>
    <IfModule prefork.c>
    </IfModule>
    <IfModule worker.c>
    </IfModule>
    StartServers 15
    <IfModule prefork.c>
    MinSpareServers 15
    MaxSpareServers 20
    </IfModule>
    MinSpareServers 15
    MaxSpareServers 20
    </IfModule>
    ServerLimit 384
    </IfModule>
    Code:
    ----------------------------
    mysqlreport output
    ----------------------------
    
    
    ----------------------------
    Total Server MyISAM and InnoDB Size
    ----------------------------
    *************************** 1. row ***************************
    innodb_tablespace_utilization_perc: NULL
                         total_size_gb: 1.6771595953032374
                         index_size_gb: 0.695234127342701
                          data_size_gb: 0.9819254679605365
                  innodb_total_size_gb: 0
                   innodb_data_size_gb: 0
                  innodb_index_size_gb: 0
                  myisam_total_size_gb: 1.6740348553285003
                   myisam_data_size_gb: 0.9790675854310393
                  myisam_index_size_gb: 0.6949672698974609
                            perc_index: 41.453069100
                             perc_data: 58.546930800
                     innodb_perc_index: NULL
                      innodb_perc_data: NULL
                     myisam_perc_index: 41.514504100
                      myisam_perc_data: 58.485495800
               innodb_perc_total_index: 0
                innodb_perc_total_data: 0
               myisam_perc_total_index: 99.961616100
                myisam_perc_total_data: 99.708951100
    Code:
    ----------------------------
    MySQL settings
    ----------------------------
    # Example MySQL config file for very large systems.
    #
    # This is for a large system with memory of 1G-2G where the system runs mainly
    # MySQL.
    #
    # MySQL programs look for option files in a set of
    # locations which depend on the deployment platform.
    # You can copy this option file to one of those
    # locations. For information about these locations, see:
    # http://dev.mysql.com/doc/mysql/en/option-files.html
    #
    # In this file, you can use all long options that a program supports.
    # If you want to know which options a program supports, run the program
    # with the "--help" option.
    
    # The following options will be passed to all MySQL clients
    [client]
    #password	= your_password
    port		= 3306
    socket		= /var/lib/mysql/mysql.sock
    
    # Here follows entries for some specific programs
    
    # The MySQL server
    [mysqld]
    port		= 3306
    socket		= /var/lib/mysql/mysql.sock
    skip-external-locking
    key_buffer_size = 1536M
    max_allowed_packet = 1M
    table_open_cache = 30000
    sort_buffer_size = 2M
    read_buffer_size = 2M
    read_rnd_buffer_size = 8M
    myisam_sort_buffer_size = 512M
    thread_cache_size = 8
    query_cache_size = 128M
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency = 8
    open_files_limit = 32768
    max_connections = 1000
    
    # Don't listen on a TCP/IP port at all. This can be a security enhancement,
    # if all processes that need to connect to mysqld run on the same host.
    # All interaction with mysqld must be made via Unix sockets or named pipes.
    # Note that using this option without enabling named pipes on Windows
    # (via the "enable-named-pipe" option) will render mysqld useless!
    # 
    #skip-networking
    
    # Replication Master Server (default)
    # binary logging is required for replication
    # log-bin=mysql-bin
    
    # required unique id between 1 and 2^32 - 1
    # defaults to 1 if master-host is not set
    # but will not function as a master if omitted
    server-id	= 1
    
    # Replication Slave (comment out master section to use this)
    #
    # To configure this host as a replication slave, you can choose between
    # two methods :
    #
    # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
    #    the syntax is:
    #
    #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
    #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
    #
    #    where you replace <host>, <user>, <password> by quoted strings and
    #    <port> by the master's port number (3306 by default).
    #
    #    Example:
    #
    #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
    #    MASTER_USER='joe', MASTER_PASSWORD='secret';
    #
    # OR
    #
    # 2) Set the variables below. However, in case you choose this method, then
    #    start replication for the first time (even unsuccessfully, for example
    #    if you mistyped the password in master-password and the slave fails to
    #    connect), the slave will create a master.info file, and any later
    #    change in this file to the variables' values below will be ignored and
    #    overridden by the content of the master.info file, unless you shutdown
    #    the slave server, delete master.info and restart the slaver server.
    #    For that reason, you may want to leave the lines below untouched
    #    (commented) and instead use CHANGE MASTER TO (see above)
    #
    # required unique id between 2 and 2^32 - 1
    # (and different from the master)
    # defaults to 2 if master-host is set
    # but will not function as a slave if omitted
    #server-id       = 2
    #
    # The replication master for this slave - required
    #master-host     =   <hostname>
    #
    # The username the slave will use for authentication when connecting
    # to the master - required
    #master-user     =   <username>
    #
    # The password the slave will authenticate with when connecting to
    # the master - required
    #master-password =   <password>
    #
    # The port the master is listening on.
    # optional - defaults to 3306
    #master-port     =  <port>
    #
    # binary logging - not required for slaves, but recommended
    #log-bin=mysql-bin
    #
    # binary logging format - mixed recommended 
    #binlog_format=mixed
    
    # Uncomment the following if you are using InnoDB tables
    #innodb_data_home_dir = /var/lib/mysql
    #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
    #innodb_log_group_home_dir = /var/lib/mysql
    # You can set .._buffer_pool_size up to 50 - 80 %
    # of RAM but beware of setting memory usage too high
    #innodb_buffer_pool_size = 384M
    #innodb_additional_mem_pool_size = 20M
    # Set .._log_file_size to 25 % of buffer pool size
    #innodb_log_file_size = 100M
    #innodb_log_buffer_size = 8M
    #innodb_flush_log_at_trx_commit = 1
    #innodb_lock_wait_timeout = 50
    
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates
    
    [myisamchk]
    key_buffer_size = 384M
    sort_buffer_size = 384M
    read_buffer = 2M
    write_buffer = 2M
    
    [mysqlhotcopy]
    interactive-timeout
    ---
    +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
    | Variable_name | Value |
    +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
    | auto_increment_increment | 1 |
    | auto_increment_offset | 1 |
    | autocommit | ON |
    | automatic_sp_privileges | ON |
    | back_log | 50 |
    | basedir | /usr |
    | big_tables | OFF |
    | binlog_cache_size | 32768 |
    | binlog_direct_non_transactional_updates | OFF |
    | binlog_format | STATEMENT |
    | binlog_stmt_cache_size | 32768 |
    | bulk_insert_buffer_size | 8388608 |
    | character_set_client | latin1 |
    | character_set_connection | latin1 |
    | character_set_database | latin1 |
    | character_set_filesystem | binary |
    | character_set_results | latin1 |
    | character_set_server | latin1 |
    | character_set_system | utf8 |
    | character_sets_dir | /usr/share/mysql/charsets/ |
    | collation_connection | latin1_swedish_ci |
    | collation_database | latin1_swedish_ci |
    | collation_server | latin1_swedish_ci |
    | completion_type | NO_CHAIN |
    | concurrent_insert | AUTO |
    | connect_timeout | 10 |
    | datadir | /var/lib/mysql/ |
    | date_format | %Y-%m-%d |
    | datetime_format | %Y-%m-%d %H:%i:%s |
    | default_storage_engine | InnoDB |
    | default_week_format | 0 |
    | delay_key_write | ON |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout | 300 |
    | delayed_queue_size | 1000 |
    | div_precision_increment | 4 |
    | engine_condition_pushdown | ON |
    | event_scheduler | OFF |
    | expire_logs_days | 0 |
    | flush | OFF |
    | flush_time | 0 |
    | foreign_key_checks | ON |
    | ft_boolean_syntax | + -><()~*:""&| |
    | ft_max_word_len | 84 |
    | ft_min_word_len | 4 |
    | ft_query_expansion_limit | 20 |
    | ft_stopword_file | (built-in) |
    | general_log | OFF |
    | general_log_file | /var/lib/mysql/server.log |
    | group_concat_max_len | 1024 |
    | have_compress | YES |
    | have_crypt | YES |
    | have_csv | YES |
    | have_dynamic_loading | YES |
    | have_geometry | YES |
    | have_innodb | YES |
    | have_ndbcluster | NO |
    | have_openssl | DISABLED |
    | have_partitioning | YES |
    | have_profiling | YES |
    | have_query_cache | YES |
    | have_rtree_keys | YES |
    | have_ssl | DISABLED |
    | have_symlink | YES |
    | hostname | yourserverhostname |
    | ignore_builtin_innodb | OFF |
    | init_connect | |
    | init_file | |
    | init_slave | |
    | innodb_adaptive_flushing | ON |
    | innodb_adaptive_hash_index | ON |
    | innodb_additional_mem_pool_size | 8388608 |
    | innodb_autoextend_increment | 8 |
    | innodb_autoinc_lock_mode | 1 |
    | innodb_buffer_pool_instances | 1 |
    | innodb_buffer_pool_size | 134217728 |
    | innodb_change_buffering | all |
    | innodb_checksums | ON |
    | innodb_commit_concurrency | 0 |
    | innodb_concurrency_tickets | 500 |
    | innodb_data_file_path | ibdata1:10M:autoextend |
    | innodb_data_home_dir | |
    | innodb_doublewrite | ON |
    | innodb_fast_shutdown | 1 |
    | innodb_file_format | Antelope |
    | innodb_file_format_check | ON |
    | innodb_file_format_max | Antelope |
    | innodb_file_per_table | OFF |
    | innodb_flush_log_at_trx_commit | 1 |
    | innodb_flush_method | |
    | innodb_force_load_corrupted | OFF |
    | innodb_force_recovery | 0 |
    | innodb_io_capacity | 200 |
    | innodb_large_prefix | OFF |
    | innodb_lock_wait_timeout | 50 |
    | innodb_locks_unsafe_for_binlog | OFF |
    | innodb_log_buffer_size | 8388608 |
    | innodb_log_file_size | 5242880 |
    | innodb_log_files_in_group | 2 |
    | innodb_log_group_home_dir | ./ |
    | innodb_max_dirty_pages_pct | 75 |
    | innodb_max_purge_lag | 0 |
    | innodb_mirrored_log_groups | 1 |
    | innodb_old_blocks_pct | 37 |
    | innodb_old_blocks_time | 0 |
    | innodb_open_files | 300 |
    | innodb_print_all_deadlocks | OFF |
    | innodb_purge_batch_size | 20 |
    | innodb_purge_threads | 0 |
    | innodb_random_read_ahead | OFF |
    | innodb_read_ahead_threshold | 56 |
    | innodb_read_io_threads | 4 |
    | innodb_replication_delay | 0 |
    | innodb_rollback_on_timeout | OFF |
    | innodb_rollback_segments | 128 |
    | innodb_spin_wait_delay | 6 |
    | innodb_stats_method | nulls_equal |
    | innodb_stats_on_metadata | ON |
    | innodb_stats_sample_pages | 8 |
    | innodb_strict_mode | OFF |
    | innodb_support_xa | ON |
    | innodb_sync_spin_loops | 30 |
    | innodb_table_locks | ON |
    | innodb_thread_concurrency | 0 |
    | innodb_thread_sleep_delay | 10000 |
    | innodb_use_native_aio | ON |
    | innodb_use_sys_malloc | ON |
    | innodb_version | 5.5.36 |
    | innodb_write_io_threads | 4 |
    | interactive_timeout | 28800 |
    | join_buffer_size | 131072 |
    | keep_files_on_create | OFF |
    | key_buffer_size | 1610612736 |
    | key_cache_age_threshold | 300 |
    | key_cache_block_size | 1024 |
    | key_cache_division_limit | 100 |
    | large_files_support | ON |
    | large_page_size | 0 |
    | large_pages | OFF |
    | lc_messages | en_US |
    | lc_messages_dir | /usr/share/mysql/ |
    | lc_time_names | en_US |
    | license | GPL |
    | local_infile | ON |
    | lock_wait_timeout | 31536000 |
    | locked_in_memory | OFF |
    | log | OFF |
    | log_bin | OFF |
    | log_bin_trust_function_creators | OFF |
    | log_error | /var/lib/mysql/yourserverhostname.err |
    | log_output | FILE |
    | log_queries_not_using_indexes | OFF |
    | log_slave_updates | OFF |
    | log_slow_queries | OFF |
    | log_warnings | 1 |
    | long_query_time | 10.000000 |
    | low_priority_updates | OFF |
    | lower_case_file_system | OFF |
    | lower_case_table_names | 0 |
    | max_allowed_packet | 1048576 |
    | max_binlog_cache_size | 18446744073709547520 |
    | max_binlog_size | 1073741824 |
    | max_binlog_stmt_cache_size | 18446744073709547520 |
    | max_connect_errors | 10 |
    | max_connections | 1000 |
    | max_delayed_threads | 20 |
    | max_error_count | 64 |
    | max_heap_table_size | 16777216 |
    | max_insert_delayed_threads | 20 |
    | max_join_size | 18446744073709551615 |
    | max_length_for_sort_data | 1024 |
    | max_long_data_size | 1048576 |
    | max_prepared_stmt_count | 16382 |
    | max_relay_log_size | 0 |
    | max_seeks_for_key | 4294967295 |
    | max_sort_length | 1024 |
    | max_sp_recursion_depth | 0 |
    | max_tmp_tables | 32 |
    | max_user_connections | 0 |
    | max_write_lock_count | 4294967295 |
    | metadata_locks_cache_size | 1024 |
    | min_examined_row_limit | 0 |
    | multi_range_count | 256 |
    | myisam_data_pointer_size | 6 |
    | myisam_max_sort_file_size | 2146435072 |
    | myisam_mmap_size | 4294967295 |
    | myisam_recover_options | OFF |
    | myisam_repair_threads | 1 |
    | myisam_sort_buffer_size | 536870912 |
    | myisam_stats_method | nulls_unequal |
    | myisam_use_mmap | OFF |
    | net_buffer_length | 16384 |
    | net_read_timeout | 30 |
    | net_retry_count | 10 |
    | net_write_timeout | 60 |
    | new | OFF |
    | old | OFF |
    | old_alter_table | OFF |
    | old_passwords | OFF |
    | open_files_limit | 61010 |
    | optimizer_prune_level | 1 |
    | optimizer_search_depth | 62 |
    | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on |
    | performance_schema | OFF |
    | performance_schema_events_waits_history_long_size | 10000 |
    | performance_schema_events_waits_history_size | 10 |
    | performance_schema_max_cond_classes | 80 |
    | performance_schema_max_cond_instances | 1000 |
    | performance_schema_max_file_classes | 50 |
    | performance_schema_max_file_handles | 32768 |
    | performance_schema_max_file_instances | 10000 |
    | performance_schema_max_mutex_classes | 200 |
    | performance_schema_max_mutex_instances | 1000000 |
    | performance_schema_max_rwlock_classes | 30 |
    | performance_schema_max_rwlock_instances | 1000000 |
    | performance_schema_max_table_handles | 100000 |
    | performance_schema_max_table_instances | 50000 |
    | performance_schema_max_thread_classes | 50 |
    | performance_schema_max_thread_instances | 1000 |
    | pid_file | /var/lib/mysql/yourserverhostname.pid |
    | plugin_dir | /usr/lib/mysql/plugin/ |
    | port | 3306 |
    | preload_buffer_size | 32768 |
    | profiling | OFF |
    | profiling_history_size | 15 |
    | protocol_version | 10 |
    | query_alloc_block_size | 8192 |
    | query_cache_limit | 1048576 |
    | query_cache_min_res_unit | 4096 |
    | query_cache_size | 134217728 |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    | query_prealloc_size | 8192 |
    | range_alloc_block_size | 4096 |
    | read_buffer_size | 2097152 |
    | read_only | OFF |
    | read_rnd_buffer_size | 8388608 |
    | relay_log | |
    | relay_log_index | |
    | relay_log_info_file | relay-log.info |
    | relay_log_purge | ON |
    | relay_log_recovery | OFF |
    | relay_log_space_limit | 0 |
    | report_host | |
    | report_password | |
    | report_port | 3306 |
    | report_user | |
    | rpl_recovery_rank | 0 |
    | secure_auth | OFF |
    | secure_file_priv | |
    | server_id | 1 |
    | skip_external_locking | ON |
    | skip_name_resolve | OFF |
    | skip_networking | OFF |
    | skip_show_database | OFF |
    | slave_compressed_protocol | OFF |
    | slave_exec_mode | STRICT |
    | slave_load_tmpdir | /tmp |
    | slave_max_allowed_packet | 1073741824 |
    | slave_net_timeout | 3600 |
    | slave_skip_errors | OFF |
    | slave_transaction_retries | 10 |
    | slave_type_conversions | |
    | slow_launch_time | 2 |
    | slow_query_log | OFF |
    | slow_query_log_file | /var/lib/mysql/server-slow.log |
    | socket | /var/lib/mysql/mysql.sock |
    | sort_buffer_size | 2097152 |
    | sql_auto_is_null | OFF |
    | sql_big_selects | ON |
    | sql_big_tables | OFF |
    | sql_buffer_result | OFF |
    | sql_log_bin | ON |
    | sql_log_off | OFF |
    | sql_low_priority_updates | OFF |
    | sql_max_join_size | 18446744073709551615 |
    | sql_mode | |
    | sql_notes | ON |
    | sql_quote_show_create | ON |
    | sql_safe_updates | OFF |
    | sql_select_limit | 18446744073709551615 |
    | sql_slave_skip_counter | 0 |
    | sql_warnings | OFF |
    | ssl_ca | |
    | ssl_capath | |
    | ssl_cert | |
    | ssl_cipher | |
    | ssl_key | |
    | storage_engine | InnoDB |
    | stored_program_cache | 256 |
    | sync_binlog | 0 |
    | sync_frm | ON |
    | sync_master_info | 0 |
    | sync_relay_log | 0 |
    | sync_relay_log_info | 0 |
    | system_time_zone | PDT |
    | table_definition_cache | 400 |
    | table_open_cache | 30000 |
    | thread_cache_size | 8 |
    | thread_concurrency | 8 |
    | thread_handling | one-thread-per-connection |
    | thread_stack | 196608 |
    | thread_statistics | OFF |
    | time_format | %H:%i:%s |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | tmp_table_size | 16777216 |
    | tmpdir | /tmp |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_isolation | REPEATABLE-READ |
    | unique_checks | ON |
    | updatable_views_with_limit | YES |
    | userstat | OFF |
    | version | 5.5.36-cll |
    | version_comment | MySQL Community Server (GPL) |
    | version_compile_machine | i686 |
    | version_compile_os | Linux |
    | wait_timeout | 28800 |
    +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
    +------------------------------------------+-------------+
    | Variable_name | Value |
    +------------------------------------------+-------------+
    | Aborted_clients | 27 |
    | Aborted_connects | 4 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Binlog_stmt_cache_disk_use | 0 |
    | Binlog_stmt_cache_use | 0 |
    | Bytes_received | 1070593611 |
    | Bytes_sent | 44099983735 |
    | Com_admin_commands | 52 |
    | Com_assign_to_keycache | 0 |
    | Com_alter_db | 0 |
    | Com_alter_db_upgrade | 0 |
    | Com_alter_event | 0 |
    | Com_alter_function | 0 |
    | Com_alter_procedure | 0 |
    | Com_alter_server | 0 |
    | Com_alter_table | 0 |
    | Com_alter_tablespace | 0 |
    | Com_analyze | 0 |
    | Com_begin | 0 |
    | Com_binlog | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 209265 |
    | Com_change_master | 0 |
    | Com_check | 0 |
    | Com_checksum | 0 |
    | Com_commit | 0 |
    | Com_create_db | 0 |
    | Com_create_event | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_procedure | 0 |
    | Com_create_server | 0 |
    | Com_create_table | 2 |
    | Com_create_trigger | 0 |
    | Com_create_udf | 0 |
    | Com_create_user | 0 |
    | Com_create_view | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 130737 |
    | Com_delete_multi | 0 |
    | Com_do | 0 |
    | Com_drop_db | 0 |
    | Com_drop_event | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_procedure | 0 |
    | Com_drop_server | 0 |
    | Com_drop_table | 2 |
    | Com_drop_trigger | 0 |
    | Com_drop_user | 0 |
    | Com_drop_view | 0 |
    | Com_empty_query | 0 |
    | Com_execute_sql | 0 |
    | Com_flush | 0 |
    | Com_grant | 0 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 114495 |
    | Com_insert_select | 2 |
    | Com_install_plugin | 0 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_lock_tables | 776 |
    | Com_optimize | 0 |
    | Com_preload_keys | 0 |
    | Com_prepare_sql | 0 |
    | Com_purge | 0 |
    | Com_purge_before_date | 0 |
    | Com_release_savepoint | 0 |
    | Com_rename_table | 0 |
    | Com_rename_user | 0 |
    | Com_repair | 0 |
    | Com_replace | 49690 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_resignal | 0 |
    | Com_revoke | 0 |
    | Com_revoke_all | 0 |
    | Com_rollback | 0 |
    | Com_rollback_to_savepoint | 0 |
    | Com_savepoint | 0 |
    | Com_select | 1330842 |
    | Com_set_option | 209282 |
    | Com_signal | 0 |
    | Com_show_authors | 0 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 0 |
    | Com_show_charsets | 0 |
    | Com_show_client_statistics | 0 |
    | Com_show_collations | 0 |
    | Com_show_contributors | 0 |
    | Com_show_create_db | 0 |
    | Com_show_create_event | 0 |
    | Com_show_create_func | 0 |
    | Com_show_create_proc | 0 |
    | Com_show_create_table | 0 |
    | Com_show_create_trigger | 0 |
    | Com_show_databases | 9 |
    | Com_show_engine_logs | 0 |
    | Com_show_engine_mutex | 0 |
    | Com_show_engine_status | 0 |
    | Com_show_events | 0 |
    | Com_show_errors | 0 |
    | Com_show_fields | 140 |
    | Com_show_function_status | 0 |
    | Com_show_grants | 0 |
    | Com_show_index_statistics | 0 |
    | Com_show_keys | 0 |
    | Com_show_master_status | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_plugins | 0 |
    | Com_show_privileges | 0 |
    | Com_show_procedure_status | 0 |
    | Com_show_processlist | 142 |
    | Com_show_profile | 0 |
    | Com_show_profiles | 0 |
    | Com_show_relaylog_events | 0 |
    | Com_show_slave_hosts | 0 |
    | Com_show_slave_status | 0 |
    | Com_show_status | 10 |
    | Com_show_storage_engines | 0 |
    | Com_show_table_statistics | 0 |
    | Com_show_table_status | 2 |
    | Com_show_tables | 0 |
    | Com_show_thread_statistics | 0 |
    | Com_show_triggers | 0 |
    | Com_show_user_statistics | 0 |
    | Com_show_variables | 26 |
    | Com_show_warnings | 0 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_stmt_close | 2451 |
    | Com_stmt_execute | 2451 |
    | Com_stmt_fetch | 0 |
    | Com_stmt_prepare | 2451 |
    | Com_stmt_reprepare | 0 |
    | Com_stmt_reset | 2451 |
    | Com_stmt_send_long_data | 0 |
    | Com_truncate | 4 |
    | Com_uninstall_plugin | 0 |
    | Com_unlock_tables | 776 |
    | Com_update | 248603 |
    | Com_update_multi | 44 |
    | Com_xa_commit | 0 |
    | Com_xa_end | 0 |
    | Com_xa_prepare | 0 |
    | Com_xa_recover | 0 |
    | Com_xa_rollback | 0 |
    | Com_xa_start | 0 |
    | Compression | OFF |
    | Connections | 209838 |
    | Created_tmp_disk_tables | 1793 |
    | Created_tmp_files | 478 |
    | Created_tmp_tables | 12054 |
    | Delayed_errors | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Flush_commands | 1 |
    | Handler_commit | 0 |
    | Handler_delete | 41581 |
    | Handler_discover | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 94597 |
    | Handler_read_key | 33863260 |
    | Handler_read_last | 142 |
    | Handler_read_next | 190990967 |
    | Handler_read_prev | 1819990 |
    | Handler_read_rnd | 19918237 |
    | Handler_read_rnd_next | 4079118847 |
    | Handler_rollback | 0 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_update | 283273 |
    | Handler_write | 393171 |
    | Innodb_buffer_pool_pages_data | 768 |
    | Innodb_buffer_pool_bytes_data | 12582912 |
    | Innodb_buffer_pool_pages_dirty | 0 |
    | Innodb_buffer_pool_bytes_dirty | 0 |
    | Innodb_buffer_pool_pages_flushed | 0 |
    | Innodb_buffer_pool_pages_free | 7423 |
    | Innodb_buffer_pool_pages_misc | 0 |
    | Innodb_buffer_pool_pages_total | 8191 |
    | Innodb_buffer_pool_read_ahead_rnd | 0 |
    | Innodb_buffer_pool_read_ahead | 0 |
    | Innodb_buffer_pool_read_ahead_evicted | 0 |
    | Innodb_buffer_pool_read_requests | 11923 |
    | Innodb_buffer_pool_reads | 769 |
    | Innodb_buffer_pool_wait_free | 0 |
    | Innodb_buffer_pool_write_requests | 0 |
    | Innodb_data_fsyncs | 3 |
    | Innodb_data_pending_fsyncs | 0 |
    | Innodb_data_pending_reads | 0 |
    | Innodb_data_pending_writes | 0 |
    | Innodb_data_read | 14782464 |
    | Innodb_data_reads | 837 |
    | Innodb_data_writes | 3 |
    | Innodb_data_written | 1536 |
    | Innodb_dblwr_pages_written | 0 |
    | Innodb_dblwr_writes | 0 |
    | Innodb_have_atomic_builtins | OFF |
    | Innodb_log_waits | 0 |
    | Innodb_log_write_requests | 0 |
    | Innodb_log_writes | 1 |
    | Innodb_os_log_fsyncs | 3 |
    | Innodb_os_log_pending_fsyncs | 0 |
    | Innodb_os_log_pending_writes | 0 |
    | Innodb_os_log_written | 512 |
    | Innodb_page_size | 16384 |
    | Innodb_pages_created | 0 |
    | Innodb_pages_read | 768 |
    | Innodb_pages_written | 0 |
    | Innodb_row_lock_current_waits | 0 |
    | Innodb_row_lock_time | 0 |
    | Innodb_row_lock_time_avg | 0 |
    | Innodb_row_lock_time_max | 0 |
    | Innodb_row_lock_waits | 0 |
    | Innodb_rows_deleted | 0 |
    | Innodb_rows_inserted | 0 |
    | Innodb_rows_read | 0 |
    | Innodb_rows_updated | 0 |
    | Innodb_truncated_status_writes | 0 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 1248293 |
    | Key_blocks_used | 159637 |
    | Key_read_requests | 135923276 |
    | Key_reads | 163037 |
    | Key_write_requests | 440436 |
    | Key_writes | 279244 |
    | Last_query_cost | 0.000000 |
    | Max_used_connections | 84 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 905 |
    | Open_streams | 0 |
    | Open_table_definitions | 326 |
    | Open_tables | 785 |
    | Opened_files | 8991 |
    | Opened_table_definitions | 338 |
    | Opened_tables | 846 |
    | Performance_schema_cond_classes_lost | 0 |
    | Performance_schema_cond_instances_lost | 0 |
    | Performance_schema_file_classes_lost | 0 |
    | Performance_schema_file_handles_lost | 0 |
    | Performance_schema_file_instances_lost | 0 |
    | Performance_schema_locker_lost | 0 |
    | Performance_schema_mutex_classes_lost | 0 |
    | Performance_schema_mutex_instances_lost | 0 |
    | Performance_schema_rwlock_classes_lost | 0 |
    | Performance_schema_rwlock_instances_lost | 0 |
    | Performance_schema_table_handles_lost | 0 |
    | Performance_schema_table_instances_lost | 0 |
    | Performance_schema_thread_classes_lost | 0 |
    | Performance_schema_thread_instances_lost | 0 |
    | Prepared_stmt_count | 0 |
    | Qcache_free_blocks | 4341 |
    | Qcache_free_memory | 120645144 |
    | Qcache_hits | 976042 |
    | Qcache_inserts | 1318609 |
    | Qcache_lowmem_prunes | 22137 |
    | Qcache_not_cached | 11139 |
    | Qcache_queries_in_cache | 3332 |
    | Qcache_total_blocks | 11461 |
    | Queries | 3488044 |
    | Questions | 3480691 |
    | Rpl_status | AUTH_MASTER |
    | Select_full_join | 4 |
    | Select_full_range_join | 0 |
    | Select_range | 326313 |
    | Select_range_check | 0 |
    | Select_scan | 156997 |
    | Slave_heartbeat_period | 0.000 |
    | Slave_open_temp_tables | 0 |
    | Slave_received_heartbeats | 0 |
    | Slave_retried_transactions | 0 |
    | Slave_running | OFF |
    | Slow_launch_threads | 16 |
    | Slow_queries | 1622 |
    | Sort_merge_passes | 236 |
    | Sort_range | 501604 |
    | Sort_rows | 110680824 |
    | Sort_scan | 55964 |
    | Ssl_accept_renegotiates | 0 |
    | Ssl_accepts | 0 |
    | Ssl_callback_cache_hits | 0 |
    | Ssl_cipher | |
    | Ssl_cipher_list | |
    | Ssl_client_connects | 0 |
    | Ssl_connect_renegotiates | 0 |
    | Ssl_ctx_verify_depth | 0 |
    | Ssl_ctx_verify_mode | 0 |
    | Ssl_default_timeout | 0 |
    | Ssl_finished_accepts | 0 |
    | Ssl_finished_connects | 0 |
    | Ssl_session_cache_hits | 0 |
    | Ssl_session_cache_misses | 0 |
    | Ssl_session_cache_mode | NONE |
    | Ssl_session_cache_overflows | 0 |
    | Ssl_session_cache_size | 0 |
    | Ssl_session_cache_timeouts | 0 |
    | Ssl_sessions_reused | 0 |
    | Ssl_used_session_cache_entries | 0 |
    | Ssl_verify_depth | 0 |
    | Ssl_verify_mode | 0 |
    | Ssl_version | |
    | Table_locks_immediate | 3804890 |
    | Table_locks_waited | 19511 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 0 |
    | Tc_log_page_waits | 0 |
    | Threads_cached | 7 |
    | Threads_connected | 2 |
    | Threads_created | 6451 |
    | Threads_running | 1 |
    | Uptime | 41475 |
    | Uptime_since_flush_status | 41475 |
    +------------------------------------------+-------------+
    +--------+-----------------+-----------+----+---------+------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+-----------------+-----------+----+---------+------+-------+------------------+
    | 209837 | forum_forum373 | localhost | | Query | 0 | | show processlist |
    +--------+-----------------+-----------+----+---------+------+-------+------------------+
    Code:
    ------------------------------------
    INNODB Buffer Pool Stats
    ------------------------------------
    
    ----------------------------
    INNODB Status
    ----------------------------
    
    ----------------------------
    MySQL Error Log
    ----------------------------
    
    140323 17:57:45 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
    140323 17:57:45 InnoDB: Compressed tables use zlib 1.2.3
    140323 17:57:45 InnoDB: Using Linux native AIO
    140323 17:57:45 InnoDB: Initializing buffer pool, size = 128.0M
    140323 17:57:45 InnoDB: Completed initialization of buffer pool
    140323 17:57:45 InnoDB: highest supported file format is Barracuda.
    140323 17:57:45  InnoDB: Waiting for the background threads to start
    140323 17:57:46 InnoDB: 5.5.36 started; log sequence number 2784394
    140323 17:57:46 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140323 17:57:46 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140323 17:57:46 [Note] Server socket created on IP: '0.0.0.0'.
    140323 17:57:46 [Note] Event Scheduler: Loaded 0 events
    140323 17:57:46 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.36-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    140323 21:52:17 [Warning] IP address '218.9.29.90' could not be resolved: Name or service not known
    
    Report Complete:
    Mon Mar 24 05:28:59 PDT 2014
    ----------------------------
     
  2. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    can you run mysqltuner.pl ?
     
  3. forofutbolistas

    Joined:
    Jan 25, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Yes, of course :)

    Code:
     >>  MySQLTuner 1.2.0_1 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  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.36-cll
    [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 1G (Tables: 225)
    [--] Data in InnoDB tables: 928K (Tables: 58)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 2M (Tables: 2)
    [!!] Total fragmented tables: 19
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 1d 12h 43m 14s (10M q [81.262 qps], 710K conn, TX: 149B, RX: 3B)
    [--] Reads / Writes: 71% / 29%
    [--] Total buffers: 1.8G global + 12.3M per thread (1000 max threads)
    [!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
    [!!] Maximum possible memory usage: 13.8G (348% of installed RAM)
    [OK] Slow queries: 0% (5K/10M)
    [OK] Highest usage of available connections: 12% (121/1000)
    [OK] Key buffer size / total MyISAM indexes: 1.5G/718.8M
    [OK] Key buffer hit rate: 100.0% (474M cached / 234K reads)
    [OK] Query cache efficiency: 45.9% (3M cached / 7M selects)
    [!!] Query cache prunes per day: 14468
    [OK] Sorts requiring temporary tables: 0% (386 temp sorts / 1M sorts)
    [OK] Temporary tables created on disk: 11% (4K on disk / 42K total)
    [OK] Thread cache hit rate: 96% (26K created / 710K connections)
    [OK] Table cache hit rate: 88% (1K open / 1K opened)
    [OK] Open file limit used: 2% (1K/61K)
    [OK] Table locks acquired immediately: 99% (11M immediate / 11M locks)
    [OK] InnoDB data size / buffer pool: 928.0K/128.0M
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        Enable the slow query log to troubleshoot bad queries
    Variables to adjust:
      *** MySQL's maximum memory usage is dangerously high ***
      *** Add RAM before increasing MySQL buffer variables ***
        query_cache_size (> 128M)
    
    I have optimized tables and the only use for the server is vBulletin + MySQL so I guess there should be no problems with high memory usage.
     
  4. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hey,

    Your settings are way too high
    [--] Total buffers: 1.8G global + 12.3M per thread (1000 max threads)
    [!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
    [!!] Maximum possible memory usage: 13.8G (348% of installed RAM)

    you seem to have 4GB server, but have only 32-bit mysql installed,
    anyways update the config to:

    Code:
    [client]
    #password	= your_password
    port		= 3306
    socket		= /var/lib/mysql/mysql.sock
    
    # The MySQL server
    [mysqld]
    port		= 3306
    socket		= /var/lib/mysql/mysql.sock
    skip-external-locking
    skip-name-resolve
    
    tmpdir=/dev/shm
    
    key_buffer_size = 1200M
    max_allowed_packet = 1M
    table_open_cache = 1000
    sort_buffer_size = 256K
    read_buffer_size = 128K
    read_rnd_buffer_size = 256K
    myisam_sort_buffer_size = 128M
    thread_cache_size = 16
    query_cache_size = 75M
    
    open_files_limit = 32768
    max_connections = 150
    
    innodb_buffer_pool_size = 20M
    
    #skip-networking
    
    server-id	= 1
    
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates
    
    [myisamchk]
    key_buffer_size = 384M
    sort_buffer_size = 384M
    read_buffer = 2M
    write_buffer = 2M
    
    [mysqlhotcopy]
    interactive-timeout
    
    and apache
    Code:
    -------------------------------
    From /usr/local/apache/conf/httpd.conf
    -------------------------------
    Timeout 300
    KeepAlive On
    MaxKeepAliveRequests 100
    KeepAliveTimeout 1
    
    </IfModule>
    <IfModule prefork.c>
    </IfModule>
    <IfModule worker.c>
    </IfModule>
    StartServers 10
    <IfModule prefork.c>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    ServerLimit 200
    </IfModule>
    
    and make sure you have php opcode installed like eaccelerator or APC
     
  5. forofutbolistas

    Joined:
    Jan 25, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Thanks a lot for the advice. I have just updated my.cnf and httpd.conf, and restarted MySQL / Apache.

    mysqltuner.pl is showing some improvements :)

    Code:
    >>  MySQLTuner 1.2.0_1 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  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.36-cll
    [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 1G (Tables: 225)
    [--] Data in InnoDB tables: 928K (Tables: 58)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 633K (Tables: 2)
    [!!] Total fragmented tables: 20
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 4h 2m 30s (1M q [83.784 qps], 84K conn, TX: 18B, RX: 404M)
    [--] Reads / Writes: 72% / 28%
    [--] Total buffers: 1.3G global + 960.0K per thread (150 max threads)
    [OK] Maximum possible memory usage: 1.4G (36% of installed RAM)
    [OK] Slow queries: 0% (415/1M)
    [OK] Highest usage of available connections: 28% (43/150)
    [OK] Key buffer size / total MyISAM indexes: 1.2G/721.8M
    [OK] Key buffer hit rate: 99.8% (60M cached / 109K reads)
    [OK] Query cache efficiency: 47.4% (380K cached / 802K selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (263 temp sorts / 192K sorts)
    [OK] Temporary tables created on disk: 8% (468 on disk / 5K total)
    [OK] Thread cache hit rate: 99% (458 created / 84K connections)
    [OK] Table cache hit rate: 98% (568 open / 575 opened)
    [OK] Open file limit used: 2% (716/32K)
    [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)
    [OK] InnoDB data size / buffer pool: 928.0K/20.0M
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        MySQL started within last 24 hours - recommendations may be inaccurate
        Enable the slow query log to troubleshoot bad queries
    I am using Xcache 3.0.3 as compiled with EasyApache, I have found it easier to implent than APC or eaccelerator.

    I'll wait 24 hours in order to check if it shows improvement on the forum's busiest hours.

    Thanks again :)
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,774
    Likes Received:
    663
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I am happy to see the community here was able to provide you with some advice. Did you notice any improvement during those busy hours?

    Thank you.
     
  7. forofutbolistas

    Joined:
    Jan 25, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Yes, one week after the new values in my.cnf and httpd.conf were applied the server is working much more lag-free during the nightly busiest hours.

    It bothers me a bit that it's only using around 25% of the 4 GB of RAM installed but I guess it may be due to CentOS 5.10 being a 32bit OS in my server.

    I'm very thankful for the help so promptly and profesionally offered. :)
     
  8. forofutbolistas

    Joined:
    Jan 25, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Hello again :eek:

    Yesterday night the same problems arose and high server load appeared just like before applying the optimization advice:

    Code:
    root@server [~]# nice top -c
    top - 15:35:56 up 41 days, 29 min,  1 user,  load average: 31.00, 31.29, 31.52
    Tasks: 247 total,   2 running, 244 sleeping,   0 stopped,   1 zombie
    Cpu(s): 59.0%us,  2.8%sy,  0.1%ni, 37.3%id,  0.2%wa,  0.0%hi,  0.5%si,  0.0%st
    Mem:   4151412k total,  3821052k used,   330360k free,   108980k buffers
    Swap:  4192956k total,       80k used,  4192876k free,  2286540k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
    29631 mysql     15   0 1596m 657m 5540 S 163.9 16.2  22534:30 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql -
    16387 nobody    15   0 73268  16m 7852 S  9.1  0.4   0:02.27 /usr/local/apache/bin/httpd -k start -DSSL
    16155 nobody    15   0 72560  15m 7740 S  5.5  0.4   0:02.97 /usr/local/apache/bin/httpd -k start -DSSL
    16367 nobody    15   0 72196  14m 7240 S  5.5  0.4   0:02.67 /usr/local/apache/bin/httpd -k start -DSSL
    18969 nobody    15   0 72872  14m 6496 S  5.5  0.4   0:00.40 /usr/local/apache/bin/httpd -k start -DSSL
    15813 nobody    15   0 73164  16m 7844 S  4.9  0.4   0:06.52 /usr/local/apache/bin/httpd -k start -DSSL
     8249 nobody    15   0 73728  17m 8792 S  4.2  0.4   0:12.16 /usr/local/apache/bin/httpd -k start -DSSL
    18925 nobody    15   0 74280  16m 6676 S  3.9  0.4   0:01.37 /usr/local/apache/bin/httpd -k start -DSSL
    18932 nobody    15   0 73292  17m 8664 S  3.9  0.4   0:01.09 /usr/local/apache/bin/httpd -k start -DSSL
    16241 nobody    15   0 72844  15m 6932 S  3.6  0.4   0:01.85 /usr/local/apache/bin/httpd -k start -DSSL
    19162 nobody    15   0 71472  15m 6296 S  3.6  0.4   0:00.18 /usr/local/apache/bin/httpd -k start -DSSL
    18775 nobody    15   0 73108  15m 6952 S  1.8  0.4   0:01.54 /usr/local/apache/bin/httpd -k start -DSSL
    15730 nobody    16   0 74208  16m 7076 S  1.5  0.4   0:02.05 /usr/local/apache/bin/httpd -k start -DSSL
    18982 nobody    16   0 74100  15m 6884 S  1.2  0.4   0:00.48 /usr/local/apache/bin/httpd -k start -DSSL
    18781 nobody    16   0 73116  15m 7360 S  0.9  0.4   0:01.50 /usr/local/apache/bin/httpd -k start -DSSL
    18918 nobody    15   0 73680  15m 6652 S  0.9  0.4   0:01.01 /usr/local/apache/bin/httpd -k start -DSSL
    19101 root      26  10  2556 1224  832 R  0.9  0.0   0:00.21 top -c
     9647 nobody    15   0 73996  17m 8140 S  0.6  0.4   0:13.26 /usr/local/apache/bin/httpd -k start -DSSL
    16277 nobody    15   0 72784  17m 9332 S  0.6  0.4   0:02.61 /usr/local/apache/bin/httpd -k start -DSSL
    19027 nobody    15   0 73436  15m 6980 S  0.6  0.4   0:00.51 /usr/local/apache/bin/httpd -k start -DSSL
    15694 nobody    15   0 72836  17m 9152 S  0.3  0.4   0:04.31 /usr/local/apache/bin/httpd -k start -DSSL
    15698 nobody    15   0 72548  15m 7704 S  0.3  0.4   0:03.30 /usr/local/apache/bin/httpd -k start -DSSL
    15787 nobody    15   0 72844  15m 7432 S  0.3  0.4   0:03.84 /usr/local/apache/bin/httpd -k start -DSSL
    15788 nobody    15   0 73144  15m 7288 S  0.3  0.4   0:06.77 /usr/local/apache/bin/httpd -k start -DSSL
    15805 nobody    15   0 72588  17m 9212 S  0.3  0.4   0:04.58 /usr/local/apache/bin/httpd -k start -DSSL
    16165 nobody    15   0 72180  14m 7092 S  0.3  0.4   0:04.59 /usr/local/apache/bin/httpd -k start -DSSL
    16176 nobody    15   0     0    0    0 Z  0.3  0.0   0:04.59 [httpd] <defunct>
    16349 nobody    15   0 73452  16m 8212 S  0.3  0.4   0:05.13 /usr/local/apache/bin/httpd -k start -DSSL
    16390 nobody    15   0 73276  15m 7232 S  0.3  0.4   0:02.78 /usr/local/apache/bin/httpd -k start -DSSL
    16392 nobody    15   0 73052  18m 9.8m S  0.3  0.5   0:02.72 /usr/local/apache/bin/httpd -k start -DSSL
    18608 nobody    15   0 72896  15m 7496 S  0.3  0.4   0:02.25 /usr/local/apache/bin/httpd -k start -DSSL
    18686 nobody    15   0 72940  15m 7068 S  0.3  0.4   0:01.85 /usr/local/apache/bin/httpd -k start -DSSL
    18916 nobody    15   0 73116  15m 7248 S  0.3  0.4   0:01.19 /usr/local/apache/bin/httpd -k start -DSSL
        1 root      15   0  2176  640  556 S  0.0  0.0   0:14.23 init [3]
        2 root      RT  -5     0    0    0 S  0.0  0.0   0:09.94 [migration/0]
        3 root      34  19     0    0    0 S  0.0  0.0   0:00.19 [ksoftirqd/0]
        4 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 [watchdog/0]
    root@server [~]# mysqladmin processlist
    +---------+-----------------+-----------+-----------------+---------+------+--------------+-------------------------------------------------------------------------------------+
    | Id      | User            | Host      | db              | Command | Time | State        | Info                                                                                |
    +---------+-----------------+-----------+-----------------+---------+------+--------------+-------------------------------------------------------------------------------------+
    | 5260187 | forum_user1 | localhost | forum_database1 | Query   | 0    | Sending data | SELECT COUNT(*) AS total FROM post_thanks WHERE userid = 8263 AND date > 1396737364 |
    | 5260195 | forum_user1 | localhost | forum_database1 | Sleep   | 0    |              |                                                                                     |
    | 5260196 | root            | localhost |                 | Query   | 0    |              | show processlist                                                                    |
    +---------+-----------------+-----------+-----------------+---------+------+--------------+-------------------------------------------------------------------------------------+
    Code:
     >>  MySQLTuner 1.2.0_1 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  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.36-cll
    [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    [--] Data in MyISAM tables: 1G (Tables: 225)
    [--] Data in InnoDB tables: 928K (Tables: 58)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 760K (Tables: 2)
    [!!] Total fragmented tables: 23
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 9h 43m 57s (2M q [84.865 qps], 200K conn, TX: 43B, RX: 946M)
    [--] Reads / Writes: 74% / 26%
    [--] Total buffers: 1.3G global + 960.0K per thread (150 max threads)
    [OK] Maximum possible memory usage: 1.5G (36% of installed RAM)
    [OK] Slow queries: 0% (1K/2M)
    [OK] Highest usage of available connections: 57% (86/150)
    [OK] Key buffer size / total MyISAM indexes: 1.2G/756.1M
    [OK] Key buffer hit rate: 99.9% (135M cached / 145K reads)
    [OK] Query cache efficiency: 45.7% (917K cached / 2M selects)
    [!!] Query cache prunes per day: 33944
    [OK] Sorts requiring temporary tables: 0% (2K temp sorts / 456K sorts)
    [OK] Temporary tables created on disk: 9% (984 on disk / 10K total)
    [OK] Thread cache hit rate: 99% (1K created / 200K connections)
    [OK] Table cache hit rate: 94% (783 open / 828 opened)
    [OK] Open file limit used: 2% (886/32K)
    [OK] Table locks acquired immediately: 99% (3M immediate / 3M locks)
    [OK] InnoDB data size / buffer pool: 928.0K/20.0M
    
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        MySQL started within last 24 hours - recommendations may be inaccurate
        Enable the slow query log to troubleshoot bad queries
    Variables to adjust:
        query_cache_size (> 100M)
    
    Is there any other optimization I may apply in order to improve those high server loads? :(
     
  9. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    track slow queries in your mysql my.cnf

    slow_query_log=1
    slow_query_log_file=mysql-slow.log
    long_query_time=0.1

    let it run for some time

    then review them
    cd /root/
    wget http://percona.com/get/pt-query-digest
    chmod +x pt-query-digest
    ./pt-query-digest /var/lib/mysql/mysql-slow.log > slow.txt

    result in slow.txt

    than analyze each query with mysql explain extendend and if needed optimize query/database structure/indexes

    you can post the result of slow.txt here
     
Loading...

Share This Page