vBulletin + MySQL + cPanel / WHM dedicated server optimization request

Jan 25, 2010
6
0
51
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: [email protected]/1               0.00%    0.01%    0.02%    0.07% 
28222 root     sshd: [email protected]               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
----------------------------
 
Jan 25, 2010
6
0
51
can you run mysqltuner.pl ?
Yes, of course :)

Code:
 >>  MySQLTuner 1.2.0_1 - Major Hayden <[email protected]>
 >>  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.
 

thinkbot

Well-Known Member
Oct 30, 2012
326
1
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
 
Jan 25, 2010
6
0
51
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,


and make sure you have php opcode installed like eaccelerator or APC
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 <[email protected]>
 >>  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 :)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
I'll wait 24 hours in order to check if it shows improvement on the forum's busiest hours.
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.
 
Jan 25, 2010
6
0
51
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.
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. :)
 
Jan 25, 2010
6
0
51
Hello again :eek:

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

Code:
[email protected] [~]# 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]
[email protected] [~]# 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 <[email protected]>
 >>  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? :(
 

thinkbot

Well-Known Member
Oct 30, 2012
326
1
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