The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help with my cnf

Discussion in 'Workarounds and Optimization' started by foroxd, Nov 6, 2013.

  1. foroxd

    foroxd Member

    Joined:
    Nov 6, 2013
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello

    Please, I need help optimize mysql purchase, all data attached.

    mysqltuner.pl:

    Code:
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.0 WHM mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    mié nov 6 12:23:46 CET 2013
    
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started 2013-10-06 10:38:43
    Uptime: 31 days 2 hours 45 min 3 sec
    Uptime 2688303
    Uptime_since_flush_status 2688303
    
    Max Used Connections:      152/151 (100.66%)
    Key Buffer Used:           6.54M/8.00M (81.76%)
    Current Key Buffer Usage:  8.00M (100.00%)
    InnoDB Buffer Pool:        21.84M/127.98M (17.07%)
    Table Locks Waited:        782.09k Rate: 0.3/s (0.41%)
    --------------------
    Query Cache Limit (bytes): 1048576
    Query Cache Min Unit (bytes): 4096
    Query Cache Size (bytes): 0
    Query Cache Free Mem (bytes): 0
    Query Cache Used Mem (bytes): 0
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 0
    
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 1, cores = 4, virtual = 8, hyperthreading = yes
          8  2668.000
          8  Intel(R) Xeon(R) CPU           W3520  @ 2.67GHz
          8  8192 KB
    
    
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 3.10.9-xxxx-grs-ipv6-64 ((yourserverhostname)) 	06/11/13 	_x86_64_	(8 CPU)
    
    12:23:47     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    12:23:49     all   22,97    0,00    1,13    0,38    0,00    0,00    0,00    0,00   75,53
    12:23:49       0  100,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00
    12:23:49       1   19,50    0,00    0,50    0,00    0,00    0,00    0,00    0,00   80,00
    12:23:49       2   27,50    0,00    1,00    1,50    0,00    0,00    0,00    0,00   70,00
    12:23:49       3    1,00    0,00    0,50    0,00    0,00    0,00    0,00    0,00   98,51
    12:23:49       4    0,00    0,00    0,00    1,01    0,00    0,00    0,00    0,00   98,99
    12:23:49       5    0,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00  100,00
    12:23:49       6   22,11    0,00    4,52    0,00    0,00    0,00    0,00    0,00   73,37
    12:23:49       7   13,93    0,00    2,49    0,00    0,00    0,00    0,00    0,00   83,58
    
    12:23:49     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    12:23:51     all   23,75    0,00    1,50    0,00    0,00    0,00    0,00    0,00   74,75
    12:23:51       0  100,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00
    12:23:51       1    1,49    0,00    1,00    0,00    0,00    0,00    0,00    0,00   97,51
    12:23:51       2   27,00    0,00    4,50    0,00    0,00    0,00    0,00    0,00   68,50
    12:23:51       3   18,09    0,00    1,51    0,00    0,00    0,00    0,00    0,00   80,40
    12:23:51       4    0,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00  100,00
    12:23:51       5    0,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00  100,00
    12:23:51       6   31,66    0,00    3,02    0,00    0,00    0,00    0,00    0,00   65,33
    12:23:51       7   12,06    0,00    2,01    0,00    0,00    0,00    0,00    0,00   85,93
    
    Media:       CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    Media:       all   23,36    0,00    1,31    0,19    0,00    0,00    0,00    0,00   75,14
    Media:         0  100,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00
    Media:         1   10,47    0,00    0,75    0,00    0,00    0,00    0,00    0,00   88,78
    Media:         2   27,25    0,00    2,75    0,75    0,00    0,00    0,00    0,00   69,25
    Media:         3    9,50    0,00    1,00    0,00    0,00    0,00    0,00    0,00   89,50
    Media:         4    0,00    0,00    0,00    0,50    0,00    0,00    0,00    0,00   99,50
    Media:         5    0,00    0,00    0,00    0,00    0,00    0,00    0,00    0,00  100,00
    Media:         6   26,88    0,00    3,77    0,00    0,00    0,00    0,00    0,00   69,35
    Media:         7   13,00    0,00    2,25    0,00    0,00    0,00    0,00    0,00   84,75
    
    top - 12:23:52 up 31 days, 17:33,  1 user,  load average: 1.58, 1.34, 1.43
    Tasks: 206 total,   3 running, 202 sleeping,   0 stopped,   1 zombie
    Cpu(s): 18.5%us,  1.5%sy,  0.1%ni, 79.5%id,  0.3%wa,  0.0%hi,  0.2%si,  0.0%st
    Mem:  24737784k total, 21714080k used,  3023704k free,   286232k buffers
    Swap: 29694972k total,    83504k used, 29611468k free, 19668712k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND            
     9593 foroxd    20   0  363m  36m 9364 R 99.1  0.2   0:05.59 php                
     9716 foroxd    20   0  364m  36m 9356 R 47.5  0.2   0:00.24 php                
     9719 foroxd    20   0  356m  31m 9280 S 23.8  0.1   0:00.12 php                
     3272 mysql     20   0 4449m 134m 6932 S 15.8  0.6  12231:14 mysqld             
     9712 foroxd    20   0     0    0    0 Z 13.9  0.0   0:00.25 php <defunct>      
    29237 root      20   0     0    0    0 S  2.0  0.0   0:00.96 kworker/4:1        
        1 root      20   0 19276 1140  976 S  0.0  0.0   0:09.02 init               
        2 root      20   0     0    0    0 S  0.0  0.0   0:00.09 kthreadd           
        3 root      20   0     0    0    0 S  0.0  0.0   4:37.59 ksoftirqd/0        
        5 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/0:0H       
        7 root      RT   0     0    0    0 S  0.0  0.0   0:08.12 migration/0        
        8 root      20   0     0    0    0 S  0.0  0.0   0:00.00 rcu_bh             
        9 root      20   0     0    0    0 S  0.0  0.0  61:33.20 rcu_sched          
       10 root      RT   0     0    0    0 S  0.0  0.0   0:08.95 migration/1        
       11 root      20   0     0    0    0 S  0.0  0.0   2:10.05 ksoftirqd/1        
       13 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/1:0H       
       14 root      RT   0     0    0    0 S  0.0  0.0   0:19.38 migration/2        
       15 root      20   0     0    0    0 S  0.0  0.0   1:41.62 ksoftirqd/2        
       17 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/2:0H       
       18 root      RT   0     0    0    0 S  0.0  0.0   0:09.11 migration/3        
       19 root      20   0     0    0    0 S  0.0  0.0   3:59.54 ksoftirqd/3        
       21 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/3:0H       
       22 root      RT   0     0    0    0 S  0.0  0.0   0:02.53 migration/4        
       23 root      20   0     0    0    0 S  0.0  0.0   0:38.75 ksoftirqd/4        
       25 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/4:0H       
       26 root      RT   0     0    0    0 S  0.0  0.0   0:22.38 migration/5        
       27 root      20   0     0    0    0 S  0.0  0.0   0:52.44 ksoftirqd/5        
       29 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/5:0H       
       30 root      RT   0     0    0    0 S  0.0  0.0   0:08.82 migration/6        
       31 root      20   0     0    0    0 S  0.0  0.0   0:40.09 ksoftirqd/6        
       33 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/6:0H       
       34 root      RT   0     0    0    0 S  0.0  0.0   0:05.32 migration/7        
       35 root      20   0     0    0    0 S  0.0  0.0   0:30.41 ksoftirqd/7        
       37 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/7:0H       
       38 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 khelper            
       39 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kdevtmpfs          
       40 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 netns              
      514 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 writeback          
      516 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kintegrityd        
      517 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bioset             
      519 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kblockd            
      658 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ata_sff            
      668 root      20   0     0    0    0 S  0.0  0.0   0:00.00 khubd              
      678 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 md                 
      681 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 edac-poller        
      713 root      20   0     0    0    0 S  0.0  0.0   0:29.15 kworker/5:1        
      715 root      20   0     0    0    0 S  0.0  0.0   0:27.44 kworker/7:1        
      790 root      20   0 49000 7544 1752 S  0.0  0.0   7:25.63 tailwatchd         
      813 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 rpciod             
      814 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kvm-irqfd-clean    
      869 root      20   0     0    0    0 S  0.0  0.0   0:15.90 kswapd0            
      870 root      25   5     0    0    0 S  0.0  0.0   0:00.00 ksmd               
      873 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/7:0        
      996 root      20   0     0    0    0 S  0.0  0.0   0:00.32 fsnotify_mark      
     1036 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 nfsiod             
     1049 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 cifsiod            
     1070 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsIO              
     1071 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit          
     1072 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit          
     1073 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit          
     1074 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit          
     1075 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit          
     1076 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit          
     1077 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit          
     1078 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit          
     1079 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jfsSync            
     1093 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 xfsalloc           
     1095 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 xfs_mru_cache      
     1098 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 xfslogd            
     1105 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ocfs2_wq           
     1108 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 user_dlm           
     1123 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bioset             
     1133 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 glock_workqueue    
     1134 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 delete_workqueu    
     1142 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 gfs_recovery       
     1147 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 crypto             
     1179 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kthrotld           
     1852 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bioset             
     1853 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 drbd-reissue       
     1885 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 iscsi_eh           
     1930 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0          
     1935 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_1          
     1938 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_2          
     1941 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_3          
     1944 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_4          
     1947 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_5          
     1970 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 bond0              
     2029 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 mlx4               
     2047 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 vfio-irqfd-clea    
     2101 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kpsmoused          
     2128 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 dm_bufio_cache     
     2131 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kdelayd            
     2134 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kmpathd            
     2135 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kmpath_handlerd    
     2220 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 deferwq            
     2223 root      20   0     0    0    0 S  0.0  0.0   2:42.64 jbd2/sda3-8        
     2224 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ext4-dio-unwrit    
     2281 root      16  -4 10716  756  408 S  0.0  0.0   0:02.82 udevd              
     2486 root       0 -20     0    0    0 S  0.0  0.0   0:40.08 kworker/0:1H       
     2652 root      20   0     0    0    0 S  0.0  0.0   0:00.00 jbd2/sda2-8        
     2653 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 ext4-dio-unwrit    
     2797 root       0 -20     0    0    0 S  0.0  0.0   1:23.21 loop0              
     2803 root      20   0     0    0    0 S  0.0  0.0   0:14.45 kjournald          
     3024 root      20   0  238m 5272  916 S  0.0  0.0   3:45.85 rsyslogd           
     3038 named     20   0  658m  28m 2420 S  0.0  0.1  24:52.37 named              
     3151 root      20   0 11476 1172 1172 S  0.0  0.0   0:00.01 mysqld_safe        
     3685 root       0 -20     0    0    0 S  0.0  0.0   0:00.06 kworker/1:1H       
     3991 root      20   0  135m 1376 1240 S  0.0  0.0   0:05.39 pure-ftpd          
     3993 root      20   0  133m 1264 1220 S  0.0  0.0   0:05.92 pure-authd         
     4003 root      20   0  114m 1128  680 S  0.0  0.0   0:19.43 crond              
     4023 root      20   0 21540  456  376 S  0.0  0.0   0:00.02 atd                
     4057 root      20   0     0    0    0 S  0.0  0.0   0:15.39 kworker/2:1        
     4113 root       0 -20     0    0    0 S  0.0  0.0   0:00.04 kworker/2:1H       
     4406 root       0 -20     0    0    0 S  0.0  0.0   0:00.03 kworker/3:1H       
     5088 root      20   0  4104  440  436 S  0.0  0.0   0:00.00 mingetty           
     5090 root      20   0  4108  436  432 S  0.0  0.0   0:00.00 mingetty           
     5092 root      20   0  4108  436  432 S  0.0  0.0   0:00.00 mingetty           
     5095 root      20   0  4104  440  436 S  0.0  0.0   0:00.00 mingetty           
     5097 root      20   0  4104  440  436 S  0.0  0.0   0:00.00 mingetty           
     5099 root      20   0  4104  440  436 S  0.0  0.0   0:00.00 mingetty           
     5853 root       0 -20     0    0    0 S  0.0  0.0   0:00.01 kworker/6:1H       
     5883 root       0 -20     0    0    0 S  0.0  0.0   0:00.00 kworker/7:1H       
     6324 nobody    20   0 67644 4276 1784 S  0.0  0.0   0:00.02 httpd              
     7033 nobody    20   0 67500 4104 1772 S  0.0  0.0   0:00.04 httpd              
     7064 nobody    20   0 67596 4228 1772 S  0.0  0.0   0:00.10 httpd              
     7884 root       0 -20     0    0    0 S  0.0  0.0   0:00.01 kworker/4:1H       
     8151 root      20   0 97.7m 3684 2772 S  0.0  0.0   0:00.01 sshd               
     8157 nobody    20   0 67644 4276 1772 S  0.0  0.0   0:00.02 httpd              
     8161 root      20   0 57396 2196 1580 S  0.0  0.0   0:00.00 sftp-server        
     8277 root      20   0 97.7m 3780 2868 S  0.0  0.0   0:00.00 sshd               
     8288 root      20   0  105m 1880 1512 S  0.0  0.0   0:00.01 bash               
     8431 nobody    20   0 67552 4196 1784 S  0.0  0.0   0:00.07 httpd              
     8432 nobody    20   0 67324 3892 1720 S  0.0  0.0   0:00.00 httpd              
     8454 nobody    20   0 67504 4136 1784 S  0.0  0.0   0:00.03 httpd              
     8513 nobody    20   0 67324 2776  756 S  0.0  0.0   0:00.00 httpd              
     8532 nobody    20   0 67516 4160 1784 S  0.0  0.0   0:00.03 httpd              
     8651 root      20   0 33876 4176 1812 S  0.0  0.0   0:02.37 authProg           
     8682 nobody    20   0 67644 4252 1772 S  0.0  0.0   0:00.01 httpd              
     8701 nobody    20   0 67476 4036 1784 S  0.0  0.0   0:00.01 httpd              
     8704 nobody    20   0 67496 4104 1788 S  0.0  0.0   0:00.02 httpd              
     8725 nobody    20   0 67596 4136 1772 S  0.0  0.0   0:00.02 httpd              
     8727 nobody    20   0 67644 4272 1772 S  0.0  0.0   0:00.02 httpd              
     8728 nobody    20   0 67492 4092 1784 S  0.0  0.0   0:00.01 httpd              
     8735 nobody    20   0 67484 4120 1784 S  0.0  0.0   0:00.02 httpd              
     8738 nobody    20   0 67596 4220 1772 S  0.0  0.0   0:00.02 httpd              
     8941 nobody    20   0 67492 4032 1784 S  0.0  0.0   0:00.02 httpd              
     8972 nobody    20   0 67644 4248 1772 S  0.0  0.0   0:00.01 httpd              
     8977 nobody    20   0 67644 4264 1772 S  0.0  0.0   0:00.02 httpd              
     8992 nobody    20   0 67644 4200 1772 S  0.0  0.0   0:00.00 httpd              
     9027 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/5:0        
     9240 nobody    20   0 67492 4104 1772 S  0.0  0.0   0:00.00 httpd              
     9335 nobody    20   0 67644 4192 1772 S  0.0  0.0   0:00.02 httpd              
     9342 nobody    20   0 67468 4124 1872 S  0.0  0.0   0:00.00 httpd              
     9351 nobody    20   0 67596 4136 1772 S  0.0  0.0   0:00.01 httpd              
     9352 nobody    20   0 67496 4064 1772 S  0.0  0.0   0:00.00 httpd              
     9353 nobody    20   0 67492 4084 1768 S  0.0  0.0   0:00.00 httpd              
     9493 root      20   0  104m 1944 1228 S  0.0  0.0   0:00.01 mysqlmymonlite.    
     9715 root      20   0 15068 1272  884 R  0.0  0.0   0:00.00 top                
     9738 root      20   0  157m  51m 2784 S  0.0  0.2   0:10.51 spamd child        
     9909 root      20   0     0    0    0 S  0.0  0.0   0:21.15 kworker/0:1        
    10607 root      20   0 33880 4180 1812 S  0.0  0.0   0:02.42 authProg           
    10655 root      20   0 33876 4172 1812 S  0.0  0.0   0:02.38 authProg           
    11486 root       0 -20     0    0    0 S  0.0  0.0   0:00.01 kworker/5:1H       
    12410 root      20   0 23552 2264 1496 S  0.0  0.0   0:03.35 cpsrvd-dormant     
    12585 root      20   0 33876 4176 1812 S  0.0  0.0   0:02.41 authProg           
    13552 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/4:0        
    13590 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/1:1        
    14029 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/2:2        
    14248 root      20   0 67188 4456 2460 S  0.0  0.0   2:05.62 httpd              
    14252 root      20   0 33876 4176 1812 S  0.0  0.0   0:02.42 authProg           
    18278 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/6:0        
    18338 root      20   0     0    0    0 S  0.0  0.0   0:00.29 kworker/u32:0      
    18517 root      20   0 50620 8672 2296 S  0.0  0.0   0:00.06 leechprotect       
    20018 root      20   0 91548 4332 1840 S  0.0  0.0   1:18.16 miniserv.pl        
    20928 root      20   0 34572 3036 1488 S  0.0  0.0   1:00.28 queueprocd - wa    
    20957 root      20   0  106m 3160 1304 S  0.0  0.0   0:25.93 dnsadmin - serv    
    20990 root      20   0 23456 2180 1484 S  0.0  0.0   1:05.65 cpdavd-dormant     
    20995 root      38  18 27112 1792 1212 S  0.0  0.0   0:03.40 cpanellogd - sl    
    21246 root      20   0 66300 1208  516 S  0.0  0.0   0:00.01 sshd               
    25292 root      20   0  151m  13m 1408 S  0.0  0.1   0:33.44 lfd - sleeping     
    26362 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/3:1        
    27298 root      20   0     0    0    0 S  0.0  0.0   0:06.21 kworker/1:0        
    27543 root      20   0     0    0    0 S  0.0  0.0   0:00.05 kworker/u32:2      
    28666 root      20   0     0    0    0 S  0.0  0.0   0:05.27 kworker/6:2        
    29942 root      18  -2 10712  704  352 S  0.0  0.0   0:00.16 udevd              
    30441 root      20   0  407m 222m 5368 S  0.0  0.9   3:06.20 clamd              
    30451 mailnull  20   0 69436 3132 2376 S  0.0  0.0   0:25.17 exim               
    30485 root      20   0  153m  48m 3092 S  0.0  0.2   4:53.80 /usr/local/cpan    
    31077 root      20   0     0    0    0 S  0.0  0.0   0:15.98 kworker/3:2        
    31186 root      20   0  4108  452  356 S  0.0  0.0   0:00.00 courierlogger      
    31187 root      20   0 19240  724  580 S  0.0  0.0   0:00.26 authdaemond        
    31188 root      20   0 19240  360  196 S  0.0  0.0   0:01.37 authdaemond        
    31189 root      20   0 19240  364  200 S  0.0  0.0   0:01.38 authdaemond        
    31190 root      20   0 19240  360  196 S  0.0  0.0   0:01.38 authdaemond        
    31191 root      20   0 19240  360  196 S  0.0  0.0   0:01.34 authdaemond        
    31193 root      20   0 19240  364  200 S  0.0  0.0   0:01.35 authdaemond        
    31200 root      20   0  4108  452  356 S  0.0  0.0   0:01.57 courierlogger      
    31201 root      20   0  8320  656  556 S  0.0  0.0   0:01.91 couriertcpd        
    31206 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kworker/0:2        
    31207 root      20   0  4108  320  240 S  0.0  0.0   0:00.00 courierlogger      
    31208 root      20   0  8320  628  532 S  0.0  0.0   0:00.00 couriertcpd        
    31213 root      20   0  4108  448  356 S  0.0  0.0   0:00.94 courierlogger      
    31214 root      20   0  8320  656  556 S  0.0  0.0   0:01.64 couriertcpd        
    31219 root      20   0  4108  320  240 S  0.0  0.0   0:00.00 courierlogger      
    31220 root      20   0  8320  628  532 S  0.0  0.0   0:00.00 couriertcpd        
    32759 root      20   0  155m  49m 2548 S  0.0  0.2   0:11.60 spamd child        
    
    
                 total       used       free     shared    buffers     cached
    Mem:         24157      21205       2952          0        279      19207
    Low:         24157      21205       2952
    High:            0          0          0
    -/+ buffers/cache:       1717      22440
    Swap:        28998         81      28917
    
    MemTotal:       24737784 kB
    MemFree:         3023704 kB
    Buffers:          286232 kB
    Cached:         19668712 kB
    SwapCached:        41424 kB
    Active:         16928900 kB
    Inactive:        3693360 kB
    Active(anon):     375920 kB
    Inactive(anon):   291528 kB
    Active(file):   16552980 kB
    Inactive(file):  3401832 kB
    Unevictable:           0 kB
    Mlocked:               0 kB
    SwapTotal:      29694972 kB
    SwapFree:       29611468 kB
    Dirty:               556 kB
    Writeback:             0 kB
    AnonPages:        626132 kB
    Mapped:            33024 kB
    Shmem:               124 kB
    Slab:             837328 kB
    SReclaimable:     762772 kB
    SUnreclaim:        74556 kB
    KernelStack:        2088 kB
    PageTables:        12152 kB
    NFS_Unstable:          0 kB
    Bounce:                0 kB
    WritebackTmp:          0 kB
    CommitLimit:    42063864 kB
    Committed_AS:    1155024 kB
    VmallocTotal:   34359738367 kB
    VmallocUsed:      335612 kB
    VmallocChunk:   34359293956 kB
    HardwareCorrupted:     0 kB
    DirectMap4k:        5632 kB
    DirectMap2M:    25151488 kB
    
    
     Private  +   Shared  =  RAM used	Program 
    
     80.0 KiB + 376.0 KiB = 456.0 KiB	atd
     24.0 KiB + 436.0 KiB = 460.0 KiB	mingetty (6)
    444.0 KiB + 356.0 KiB = 800.0 KiB	courierlogger (5)
    392.0 KiB + 556.0 KiB = 948.0 KiB	couriertcpd (4)
    700.0 KiB + 408.0 KiB =   1.1 MiB	udevd (2)
    448.0 KiB + 680.0 KiB =   1.1 MiB	crond
    164.0 KiB + 976.0 KiB =   1.1 MiB	init
      0.0 KiB +   1.1 MiB =   1.1 MiB	mysqld_safe
     44.0 KiB +   1.2 MiB =   1.2 MiB	pure-authd
    136.0 KiB +   1.2 MiB =   1.3 MiB	pure-ftpd
    964.0 KiB + 580.0 KiB =   1.5 MiB	authdaemond (6)
    580.0 KiB +   1.2 MiB =   1.8 MiB	cpanellogd - sl
    368.0 KiB +   1.5 MiB =   1.8 MiB	bash
    716.0 KiB +   1.2 MiB =   1.9 MiB	mysqlmymonlite.
    696.0 KiB +   1.4 MiB =   2.1 MiB	cpdavd-dormant
    616.0 KiB +   1.5 MiB =   2.1 MiB	sftp-server
    768.0 KiB +   1.5 MiB =   2.2 MiB	cpsrvd-dormant
      1.5 MiB +   1.5 MiB =   3.0 MiB	queueprocd - wa
    756.0 KiB +   2.3 MiB =   3.1 MiB	exim
      1.8 MiB +   1.3 MiB =   3.1 MiB	dnsadmin - serv
      2.4 MiB +   1.8 MiB =   4.2 MiB	miniserv.pl
      4.3 MiB + 916.0 KiB =   5.1 MiB	rsyslogd
      2.5 MiB +   2.8 MiB =   5.3 MiB	sshd (3)
      5.7 MiB +   1.7 MiB =   7.4 MiB	tailwatchd
      6.2 MiB +   2.2 MiB =   8.5 MiB	leechprotect
     11.5 MiB +   1.8 MiB =  13.3 MiB	authProg (5)
     12.6 MiB +   1.4 MiB =  14.0 MiB	lfd - sleeping
     25.7 MiB +   2.4 MiB =  28.0 MiB	named
     45.0 MiB +   3.0 MiB =  48.1 MiB	/usr/local/cpan
     66.3 MiB +   2.4 MiB =  68.7 MiB	httpd (29)
     95.4 MiB +   2.7 MiB =  98.1 MiB	spamd child (2)
    114.2 MiB +   9.2 MiB = 123.4 MiB	php (4)
    127.5 MiB +   6.8 MiB = 134.2 MiB	mysqld
    217.0 MiB +   5.2 MiB = 222.2 MiB	clamd
    
     Private  +   Shared  =  RAM used	Program 
    
    
    ----------------------------
    Server Disk Usage
    ----------------------------
    S.ficheros    Tipo    Size  Used Avail Use% Montado en
    rootfs      rootfs    1,7T   33G  1,6T   2% /
    /dev/root     ext4    1,7T   33G  1,6T   2% /
    devtmpfs  devtmpfs     12G  344K   12G   1% /dev
    /dev/sda2     ext4     99G  110M   94G   1% /boot
    tmpfs        tmpfs     12G     0   12G   0% /dev/shm
    /dev/loop0    ext3    4,0G  139M  3,7G   4% /tmp
    /dev/loop0    ext3    4,0G  139M  3,7G   4% /var/tmp
    
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 3764228 kilobytes of disk space
    
    ----------------------------
    ulimit -aH
    ----------------------------
    core file size          (blocks, -c) 1000000
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 192740
    max locked memory       (kbytes, -l) 64
    max memory size         (kbytes, -m) unlimited
    open files                      (-n) 4096
    pipe size            (512 bytes, -p) 8
    POSIX message queues     (bytes, -q) 819200
    real-time priority              (-r) 0
    stack size              (kbytes, -s) 8192
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 14335
    virtual memory          (kbytes, -v) unlimited
    file locks                      (-x) unlimited
    
    ----------------------------------------------------------
    tail -15 /etc/security/limits.conf
    ----------------------------------------------------------
    #        - nice - max nice priority allowed to raise to values: [-20, 19]
    #        - rtprio - max realtime priority
    #
    #<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
    
    # End of file
    
    ----------------------------------------------------------
    mysqld process limits: 
    cat /proc/3272/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            8388608              unlimited            bytes     
    Max core file size        0                    0                    bytes     
    Max resident set          unlimited            unlimited            bytes     
    Max processes             192740               192740               processes 
    Max open files            2422                 2422                 files     
    Max locked memory         65536                65536                bytes     
    Max address space         unlimited            unlimited            bytes     
    Max file locks            unlimited            unlimited            locks     
    Max pending signals       192740               192740               signals   
    Max msgqueue size         819200               819200               bytes     
    Max nice priority         0                    0                    
    Max realtime priority     0                    0                    
    Max realtime timeout      unlimited            unlimited            us        
    
    ----------------------------------
    CPANEL WEB SERVER & PHP Info:
    ----------------------------------
    WHM / Cpanel version: 11.38.2.7
    
    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: suphp
    SUEXEC: enabled
    RUID2: not installed
    
    PHP 5.3.27 (cli) (built: Oct  5 2013 17:55:13) 
    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 the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd.
        with XCache Cacher v3.0.3, Copyright (c) 2005-2013, by mOo
        with Suhosin v0.9.33, Copyright (c) 2007-2012, by SektionEins GmbH
    
    System => Linux yourserverhostname 3.10.9-xxxx-grs-ipv6-64 #1 SMP Wed Aug 21 11:51:59 CEST 2013 x86_64
    Build Date => Oct  5 2013 17:54:26
    
    Configure Command =>  './configure'  '--disable-fileinfo' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-intl' '--enable-libxml' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-ucd-snmp-hack' '--enable-wddx' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-bz2' '--with-config-file-path=/usr/local/lib' '--with-config-file-scan-dir=/usr/local/lib/php.ini.d' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-enchant=/usr' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-icu-dir=/usr' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libexpat-dir=/usr' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-snmp' '--with-sqlite=shared' '--with-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr'
    
    Configure Command |  './configure'  '--disable-fileinfo' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-intl' '--enable-libxml' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-ucd-snmp-hack' '--enable-wddx' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-bz2' '--with-config-file-path=/usr/local/lib' '--with-config-file-scan-dir=/usr/local/lib/php.ini.d' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-enchant=/usr' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-icu-dir=/usr' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libexpat-dir=/usr' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-snmp' '--with-sqlite=shared' '--with-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr'
    Server API | Command Line Interface
    Configuration File (php.ini) Path | /usr/local/lib
    Loaded Configuration File | /usr/local/lib/php.ini
    Scan this dir for additional .ini files | /usr/local/lib/php.ini.d
    PHP API | 20090626
    Zend Extension Build | API220090626,NTS
    PHP Extension Build | API20090626,NTS
    DOM/XML API Version | 20031129
    Client API version | 5.5.32
    Client API library version | 5.5.32
    Client API header version | 5.5.32
    Client API version | 5.5.32
    Phar API version | 1.1.1
    
    display_errors | Off | Off
    error_log | ErroresNHRN | ErroresNHRN
    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 | 1 | 1
    magic_quotes_gpc | Off | Off
    magic_quotes_sybase | Off | Off
    max_execution_time | 0 | 0
    max_file_uploads | 20 | 20
    memory_limit | 128M | 128M
    open_basedir | no value | no value
    post_max_size | 64M | 64M
    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 | 100M | 100M
    upload_tmp_dir | no value | no value
    sqlite3.extension_dir | no value | no value
    safe_mode_allowed_env_vars | PHP_ | PHP_
    safe_mode_protected_env_vars | LD_LIBRARY_PATH | LD_LIBRARY_PATH
    suhosin.disable.display_errors | Off | Off
    suhosin.memory_limit | 0 | 0
    
    cURL support | enabled
    cURL Information | 7.24.0
    ZLib Version | 1.2.3
    GD Support | enabled
    GD Version | bundled (2.1.0 compatible)
    FreeType Support | enabled
    FreeType Linkage | with freetype
    FreeType Version | 2.3.11
    GIF Read Support | enabled
    GIF Create Support | enabled
    JPEG Support | enabled
    libJPEG Version | 6b
    PNG Support | enabled
    libPNG Version | 1.2.49
    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
    Soap Client | enabled
    Soap Server | enabled
    ZLib Support | enabled
    
    suhosin.apc_bug_workaround | Off | Off
    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 | Off | Off
    xcache.allocator | bestfit | bestfit
    xcache.cacher | On | On
    xcache.count | 1 | 1
    xcache.gc_interval | 0 | 0
    xcache.mmap_path | /dev/zero | /dev/zero
    xcache.readonly_protection | Off | Off
    xcache.shm_scheme | mmap | mmap
    xcache.size | 32 | 32
    xcache.slots | 8K | 8K
    xcache.stat | On | On
    xcache.ttl | 7200 | 7200
    xcache.var_allocator | bestfit | bestfit
    xcache.var_count | 1 | 1
    xcache.var_gc_interval | 300 | 300
    xcache.var_maxttl | 0 | 0
    xcache.var_namespace | no value | no value
    xcache.var_namespace_mode | 0 | 0
    xcache.var_size | 32 | 32
    xcache.var_slots | 8K | 8K
    xcache.var_ttl | 7200 | 7200
    
    suhosin.cookie.encrypt | Off | Off
    suhosin.executor.disable_eval | Off | Off
    suhosin.get.max_value_length | 512 | 512
    suhosin.get.max_vars | 100 | 100
    suhosin.memory_limit | 0 | 0
    suhosin.post.max_value_length | 1000000 | 1000000
    suhosin.post.max_vars | 1000 | 1000
    suhosin.request.max_value_length | 1000000 | 1000000
    suhosin.request.max_vars | 1000 | 1000
    suhosin.upload.disallow_binary | 0 | 0
    suhosin.upload.disallow_elf | 1 | 1
    suhosin.upload.max_uploads | 25 | 25
    suhosin.upload.remove_binary | 0 | 0
    suhosin.upload.verification_script | no value | no value
    
    
    
       Server Version: Apache/2.2.25 (Unix) mod_ssl/2.2.25 OpenSSL/1.0.0-fips
       Server Built: Oct 5 2013 17:52:05
       Current Time: Wednesday, 06-Nov-2013 12:23:46 CET
       Restart Time: Friday, 01-Nov-2013 20:56:22 CET
       Parent Server Generation: 222
       Total accesses: 5195675 - Total Traffic: 6.8 GB
       CPU Usage: u1.27 s.32 cu137.89 cs0 - .0348% CPU load
       12.9 requests/sec - 17.7 kB/second - 1397 B/request
       12 requests currently being processed, 18 idle workers
    
    Server version: Apache/2.2.25 (Unix)
    Server built:   Oct  5 2013 17:52:05
    Cpanel::Easy::Apache v3.22.14 rev9999
    Server's Module Magic Number: 20051115:33
    Server loaded:  APR 1.4.8, APR-Util 1.5.2
    Compiled using: APR 1.4.8, APR-Util 1.5.2
    Architecture:   64-bit
    Server MPM:     Prefork
      threaded:     no
        forked:     yes (variable process count)
    Server compiled with....
     -D APACHE_MPM_DIR="server/mpm/prefork"
     -D APR_HAS_SENDFILE
     -D APR_HAS_MMAP
     -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
     -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=128
     -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_LOCKFILE="logs/accept.lock"
     -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)
     authz_host_module (static)
     authz_groupfile_module (static)
     authz_user_module (static)
     authz_default_module (static)
     auth_basic_module (static)
     auth_digest_module (static)
     cache_module (static)
     disk_cache_module (static)
     dbd_module (static)
     echo_module (static)
     include_module (static)
     filter_module (static)
     charset_lite_module (static)
     deflate_module (static)
     log_config_module (static)
     logio_module (static)
     expires_module (static)
     headers_module (static)
     unique_id_module (static)
     setenvif_module (static)
     proxy_module (static)
     proxy_connect_module (static)
     proxy_ftp_module (static)
     proxy_http_module (static)
     proxy_scgi_module (static)
     proxy_ajp_module (static)
     proxy_balancer_module (static)
     ssl_module (static)
     mpm_prefork_module (static)
     http_module (static)
     mime_module (static)
     status_module (static)
     autoindex_module (static)
     info_module (static)
     suexec_module (static)
     cgi_module (static)
     negotiation_module (static)
     dir_module (static)
     imagemap_module (static)
     actions_module (static)
     speling_module (static)
     userdir_module (static)
     alias_module (static)
     rewrite_module (static)
     so_module (static)
     bwlimited_module (shared)
     suphp_module (shared)
    
    Compiled in modules:
      core.c
      mod_authn_file.c
      mod_authz_host.c
      mod_authz_groupfile.c
      mod_authz_user.c
      mod_authz_default.c
      mod_auth_basic.c
      mod_auth_digest.c
      mod_cache.c
      mod_disk_cache.c
      mod_dbd.c
      mod_echo.c
      mod_include.c
      mod_filter.c
      mod_charset_lite.c
      mod_deflate.c
      mod_log_config.c
      mod_logio.c
      mod_expires.c
      mod_headers.c
      mod_unique_id.c
      mod_setenvif.c
      mod_proxy.c
      mod_proxy_connect.c
      mod_proxy_ftp.c
      mod_proxy_http.c
      mod_proxy_scgi.c
      mod_proxy_ajp.c
      mod_proxy_balancer.c
      mod_ssl.c
      prefork.c
      http_core.c
      mod_mime.c
      mod_status.c
      mod_autoindex.c
      mod_info.c
      mod_suexec.c
      mod_cgi.c
      mod_negotiation.c
      mod_dir.c
      mod_imagemap.c
      mod_actions.c
      mod_speling.c
      mod_userdir.c
      mod_alias.c
      mod_rewrite.c
      mod_so.c
    
    
    -------------------------------
    From /usr/local/apache/conf/httpd.conf
    -------------------------------
    Timeout 150
    KeepAlive On
    MaxKeepAliveRequests 100
    KeepAliveTimeout 3
    
    </IfModule>
    StartServers 3
    <IfModule prefork.c>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    ServerLimit 256
    MaxClients 150
    MaxRequestsPerChild 10000
    </IfModule>
    
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MySQL   5.5.32-cll          uptime 31 2:45:11   Wed Nov  6 12:23:54 2013
    
    __ Key _________________________________________________________________
    Buffer used     6.54M of    8.00M   %Used:  81.76
      Current       8.00M              %Usage: 100.00
    Write hit      44.59%
    Read hit       96.42%
    
    __ Questions ___________________________________________________________
    Total         146.93M      54.7/s
      DMS         111.20M      41.4/s  %Total:  75.68
      Com_         26.95M      10.0/s           18.34
      COM_QUIT      8.85M       3.3/s            6.02
      -Unknown     62.97k       0.0/s            0.04
    Slow 10 s          65       0.0/s            0.00  %DMS:   0.00 Log: OFF
    DMS           111.20M      41.4/s           75.68
      SELECT       99.20M      36.9/s           67.51         89.21
      UPDATE        9.80M       3.6/s            6.67          8.81
      INSERT        1.44M       0.5/s            0.98          1.30
      DELETE      503.62k       0.2/s            0.34          0.45
      REPLACE     256.18k       0.1/s            0.17          0.23
    Com_           26.95M      10.0/s           18.34
      set_option   15.80M       5.9/s           10.75
      change_db    10.87M       4.0/s            7.40
      show_fields  68.53k       0.0/s            0.05
    
    __ Rows ________________________________________________________________
    Rows            1.60T    596.9k/s
      Using idx     8.31G      3.1k/s  %Index:   0.52
    Rows/question  10.92k
    
    __ SELECT and Sort _____________________________________________________
    Scan           10.91M       4.1/s %SELECT:  11.00
    Range          38.19M      14.2/s           38.49
    Full join     113.50k       0.0/s            0.11
    Range check         0         0/s            0.00
    Full rng join   2.64k       0.0/s            0.00
    Sort scan       8.03M       3.0/s
    Sort range      9.12M       3.4/s
    Sort mrg pass   1.80k       0.0/s
    
    __ Table Locks _________________________________________________________
    Waited        782.09k       0.3/s  %Total:   0.41
    Immediate     190.20M      70.7/s
    
    __ Tables ______________________________________________________________
    Open              400 of    400    %Cache: 100.00
    Opened        107.43k       0.0/s
    
    __ Connections _________________________________________________________
    Max used          152 of    151      %Max: 100.66
    Total           8.86M       3.3/s
    
    __ Created Temp ________________________________________________________
    Disk table    330.87k       0.1/s   %Disk:  12.34
    Table           2.68M       1.0/s    Size:  16.0M
    File            4.76k       0.0/s
    
    __ Threads _____________________________________________________________
    Running             2 of      5
    Created         8.85M       3.3/s
    Slow                0         0/s
    Cached              0 of      0      %Hit:   0.08
    
    __ Aborted _____________________________________________________________
    Clients         7.41k       0.0/s
    Connects          381       0.0/s
    
    __ Bytes _______________________________________________________________
    Sent            7.09T      2.6M/s
    Received       43.11G     16.0k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage          21.84M of  127.98M  %Usage:  17.07
    Read hit       99.97%
    Pages
      Free          6.79k              %Total:  82.93
      Data          1.40k                       17.06  %Drty:   0.00
      Misc              1                        0.01
      Latched           0                        0.00
    Reads           2.82M       1.0/s
      From disk       742       0.0/s   %Disk:   0.03
      Ahead Rnd         0         0/s
    Writes         32.99k       0.0/s
    Wait Free           0         0/s   %Wait:   0.00
    Flushes         3.50k       0.0/s
    
    __ InnoDB Lock _________________________________________________________
    Waits               0         0/s
    Current             0
    Time acquiring
      Total             0 ms
      Average           0 ms
      Max               0 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads           811       0.0/s
      Writes        5.56k       0.0/s
      fsync         2.57k       0.0/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created         656       0.0/s
      Read            741       0.0/s
      Written       3.50k       0.0/s
    
    Rows
      Deleted           0         0/s
      Inserted      2.74k       0.0/s
      Read        685.00k       0.3/s
      Updated           0         0/s
    
    ----------------------------
    Total Server MyISAM and InnoDB Size
    ----------------------------
    *************************** 1. row ***************************
    innodb_tablespace_utilization_perc: 100
                         total_size_gb: 3.554803087376058
                         index_size_gb: 0.9043547064065933
                          data_size_gb: 2.650448380969465
                  innodb_total_size_gb: 0.0028076171875
                   innodb_data_size_gb: 0.0009002685546875
                  innodb_index_size_gb: 0.0019073486328125
                  myisam_total_size_gb: 3.5488528003916144
                   myisam_data_size_gb: 2.6469267597422004
                  myisam_index_size_gb: 0.9019260406494141
                            perc_index: 25.440360100
                             perc_data: 74.559639800
                     innodb_perc_index: 67.934782600
                      innodb_perc_data: 32.065217300
                     myisam_perc_index: 25.414580100
                      myisam_perc_data: 74.585419800
               innodb_perc_total_index: 0.210907100
                innodb_perc_total_data: 0.033966600
               myisam_perc_total_index: 99.731447600
                myisam_perc_total_data: 99.867131100
    
    ----------------------------
    MySQL settings
    ----------------------------
    [mysqld]
    innodb_file_per_table=1
    open_files_limit=2422
    ---
    +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
    | 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/xd.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 | ON |
    | 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.32 |
    | innodb_write_io_threads | 4 |
    | interactive_timeout | 28800 |
    | join_buffer_size | 131072 |
    | keep_files_on_create | OFF |
    | key_buffer_size | 8388608 |
    | 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 | 151 |
    | 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 | 18446744073709551615 |
    | max_sort_length | 1024 |
    | max_sp_recursion_depth | 0 |
    | max_tmp_tables | 32 |
    | max_user_connections | 0 |
    | max_write_lock_count | 18446744073709551615 |
    | metadata_locks_cache_size | 1024 |
    | min_examined_row_limit | 0 |
    | multi_range_count | 256 |
    | myisam_data_pointer_size | 6 |
    | myisam_max_sort_file_size | 9223372036853727232 |
    | myisam_mmap_size | 18446744073709551615 |
    | myisam_recover_options | OFF |
    | myisam_repair_threads | 1 |
    | myisam_sort_buffer_size | 8388608 |
    | 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 | 2422 |
    | 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/lib64/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 | 0 |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    | query_prealloc_size | 8192 |
    | range_alloc_block_size | 4096 |
    | read_buffer_size | 131072 |
    | read_only | OFF |
    | read_rnd_buffer_size | 262144 |
    | 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 | 0 |
    | 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/xd-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 | CEST |
    | table_definition_cache | 400 |
    | table_open_cache | 400 |
    | thread_cache_size | 0 |
    | thread_concurrency | 10 |
    | thread_handling | one-thread-per-connection |
    | thread_stack | 262144 |
    | 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.32-cll |
    | version_comment | MySQL Community Server (GPL) |
    | version_compile_machine | x86_64 |
    | version_compile_os | Linux |
    | wait_timeout | 28800 |
    +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
    +------------------------------------------+---------------+
    | Variable_name | Value |
    +------------------------------------------+---------------+
    | Aborted_clients | 7407 |
    | Aborted_connects | 381 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Binlog_stmt_cache_disk_use | 0 |
    | Binlog_stmt_cache_use | 0 |
    | Bytes_received | 43113298458 |
    | Bytes_sent | 7091922303949 |
    | Com_admin_commands | 52993 |
    | 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 | 1300 |
    | Com_alter_tablespace | 0 |
    | Com_analyze | 0 |
    | Com_begin | 0 |
    | Com_binlog | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 10867796 |
    | Com_change_master | 0 |
    | Com_check | 25042 |
    | Com_checksum | 0 |
    | Com_commit | 0 |
    | Com_create_db | 2 |
    | Com_create_event | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_procedure | 0 |
    | Com_create_server | 0 |
    | Com_create_table | 753 |
    | Com_create_trigger | 0 |
    | Com_create_udf | 0 |
    | Com_create_user | 0 |
    | Com_create_view | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 499958 |
    | Com_delete_multi | 3660 |
    | Com_do | 0 |
    | Com_drop_db | 1 |
    | Com_drop_event | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_procedure | 0 |
    | Com_drop_server | 0 |
    | Com_drop_table | 752 |
    | Com_drop_trigger | 0 |
    | Com_drop_user | 0 |
    | Com_drop_view | 0 |
    | Com_empty_query | 0 |
    | Com_execute_sql | 0 |
    | Com_flush | 2 |
    | Com_grant | 1 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 1440285 |
    | Com_insert_select | 1349 |
    | Com_install_plugin | 0 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_lock_tables | 8083 |
    | Com_optimize | 25133 |
    | 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 | 256180 |
    | 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 | 99198400 |
    | Com_set_option | 15799312 |
    | Com_signal | 0 |
    | Com_show_authors | 0 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 0 |
    | Com_show_charsets | 14 |
    | Com_show_client_statistics | 0 |
    | Com_show_collations | 0 |
    | Com_show_contributors | 0 |
    | Com_show_create_db | 155 |
    | Com_show_create_event | 0 |
    | Com_show_create_func | 0 |
    | Com_show_create_proc | 0 |
    | Com_show_create_table | 15585 |
    | Com_show_create_trigger | 0 |
    | Com_show_databases | 86 |
    | 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 | 68525 |
    | Com_show_function_status | 1687 |
    | Com_show_grants | 1643 |
    | Com_show_index_statistics | 0 |
    | Com_show_keys | 39 |
    | Com_show_master_status | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_plugins | 0 |
    | Com_show_privileges | 0 |
    | Com_show_procedure_status | 1687 |
    | Com_show_processlist | 8965 |
    | 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 | 26 |
    | Com_show_storage_engines | 399 |
    | Com_show_table_statistics | 0 |
    | Com_show_table_status | 27401 |
    | Com_show_tables | 2049 |
    | Com_show_thread_statistics | 0 |
    | Com_show_triggers | 26571 |
    | Com_show_user_statistics | 0 |
    | Com_show_variables | 1246 |
    | Com_show_warnings | 0 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_stmt_close | 0 |
    | Com_stmt_execute | 0 |
    | Com_stmt_fetch | 0 |
    | Com_stmt_prepare | 0 |
    | Com_stmt_reprepare | 0 |
    | Com_stmt_reset | 0 |
    | Com_stmt_send_long_data | 0 |
    | Com_truncate | 785 |
    | Com_uninstall_plugin | 0 |
    | Com_unlock_tables | 8069 |
    | Com_update | 9785972 |
    | Com_update_multi | 10778 |
    | 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 | 8855979 |
    | Created_tmp_disk_tables | 330878 |
    | Created_tmp_files | 4764 |
    | Created_tmp_tables | 2681319 |
    | Delayed_errors | 1322 |
    | Delayed_insert_threads | 3 |
    | Delayed_writes | 131303 |
    | Flush_commands | 1 |
    | Handler_commit | 42524 |
    | Handler_delete | 1414338 |
    | Handler_discover | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 17325152 |
    | Handler_read_key | 2310230256 |
    | Handler_read_last | 83768 |
    | Handler_read_next | 5370899522 |
    | Handler_read_prev | 613626383 |
    | Handler_read_rnd | 65566859 |
    | Handler_read_rnd_next | 1595627407106 |
    | Handler_rollback | 0 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_update | 28557986 |
    | Handler_write | 81074156 |
    | Innodb_buffer_pool_pages_data | 1397 |
    | Innodb_buffer_pool_bytes_data | 22888448 |
    | Innodb_buffer_pool_pages_dirty | 0 |
    | Innodb_buffer_pool_bytes_dirty | 0 |
    | Innodb_buffer_pool_pages_flushed | 3498 |
    | Innodb_buffer_pool_pages_free | 6793 |
    | Innodb_buffer_pool_pages_misc | 1 |
    | 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 | 2823381 |
    | Innodb_buffer_pool_reads | 742 |
    | Innodb_buffer_pool_wait_free | 0 |
    | Innodb_buffer_pool_write_requests | 32994 |
    | Innodb_data_fsyncs | 2571 |
    | Innodb_data_pending_fsyncs | 0 |
    | Innodb_data_pending_reads | 0 |
    | Innodb_data_pending_writes | 0 |
    | Innodb_data_read | 14340096 |
    | Innodb_data_reads | 811 |
    | Innodb_data_writes | 5561 |
    | Innodb_data_written | 116703232 |
    | Innodb_dblwr_pages_written | 3498 |
    | Innodb_dblwr_writes | 381 |
    | Innodb_have_atomic_builtins | ON |
    | Innodb_log_waits | 0 |
    | Innodb_log_write_requests | 3049 |
    | Innodb_log_writes | 895 |
    | Innodb_os_log_fsyncs | 1169 |
    | Innodb_os_log_pending_fsyncs | 0 |
    | Innodb_os_log_pending_writes | 0 |
    | Innodb_os_log_written | 1940480 |
    | Innodb_page_size | 16384 |
    | Innodb_pages_created | 656 |
    | Innodb_pages_read | 741 |
    | Innodb_pages_written | 3498 |
    | 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 | 2744 |
    | Innodb_rows_read | 684999 |
    | Innodb_rows_updated | 0 |
    | Innodb_truncated_status_writes | 0 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 25 |
    | Key_blocks_used | 6698 |
    | Key_read_requests | 8016346295 |
    | Key_reads | 286787162 |
    | Key_write_requests | 23508110 |
    | Key_writes | 13025350 |
    | Last_query_cost | 0.000000 |
    | Max_used_connections | 152 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 639 |
    | Open_streams | 0 |
    | Open_table_definitions | 400 |
    | Open_tables | 400 |
    | Opened_files | 1511723 |
    | Opened_table_definitions | 30593 |
    | Opened_tables | 107698 |
    | 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 | 0 |
    | Qcache_free_memory | 0 |
    | Qcache_hits | 0 |
    | Qcache_inserts | 0 |
    | Qcache_lowmem_prunes | 0 |
    | Qcache_not_cached | 0 |
    | Qcache_queries_in_cache | 0 |
    | Qcache_total_blocks | 0 |
    | Queries | 146931988 |
    | Questions | 146931988 |
    | Rpl_status | AUTH_MASTER |
    | Select_full_join | 113501 |
    | Select_full_range_join | 2640 |
    | Select_range | 38185507 |
    | Select_range_check | 0 |
    | Select_scan | 10908867 |
    | Slave_heartbeat_period | 0.000 |
    | Slave_open_temp_tables | 0 |
    | Slave_received_heartbeats | 0 |
    | Slave_retried_transactions | 0 |
    | Slave_running | OFF |
    | Slow_launch_threads | 0 |
    | Slow_queries | 65 |
    | Sort_merge_passes | 1797 |
    | Sort_range | 9115615 |
    | Sort_rows | 546215229 |
    | Sort_scan | 8030002 |
    | 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 | 190197652 |
    | Table_locks_waited | 782093 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 0 |
    | Tc_log_page_waits | 0 |
    | Threads_cached | 0 |
    | Threads_connected | 4 |
    | Threads_created | 8848878 |
    | Threads_running | 1 |
    | Uptime | 2688311 |
    | Uptime_since_flush_status | 2688311 |
    +------------------------------------------+---------------+
    +---------+-----------------+-----------+-----------------+----------------+------+--------------------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +---------+-----------------+-----------+-----------------+----------------+------+--------------------+------------------+
    | 1 | eximstats | localhost | eximstats | Sleep | 131 | | |
    | 8849045 | leechprotect | localhost | leechprotect | Sleep | 2238 | | |
    | 8854936 | DELAYED | localhost | eximstats | Delayed insert | 204 | Waiting for INSERT | |
    | 8855519 | DELAYED | localhost | eximstats | Delayed insert | 131 | Waiting for INSERT | |
    | 8855520 | DELAYED | localhost | eximstats | Delayed insert | 131 | Waiting for INSERT | |
    | 8855954 | foroxd_foroxdco | localhost | foroxd_foroxdco | Sleep | 7 | | |
    | 8855978 | root | localhost | | Query | 0 | | show processlist |
    +---------+-----------------+-----------+-----------------+----------------+------+--------------------+------------------+
    
    ------------------------------------
    INNODB Buffer Pool Stats
    ------------------------------------
    *************************** 1. row ***************************
                             POOL_ID: 0
                           POOL_SIZE: 8191
                        FREE_BUFFERS: 6793
                      DATABASE_PAGES: 1397
                  OLD_DATABASE_PAGES: 495
             MODIFIED_DATABASE_PAGES: 0
                  PENDING_DECOMPRESS: 0
                       PENDING_READS: 0
                   PENDING_FLUSH_LRU: 0
                  PENDING_FLUSH_LIST: 0
                    PAGES_MADE_YOUNG: 0
                PAGES_NOT_MADE_YOUNG: 0
               PAGES_MADE_YOUNG_RATE: 0
           PAGES_MADE_NOT_YOUNG_RATE: 0
                   NUMBER_PAGES_READ: 741
                NUMBER_PAGES_CREATED: 656
                NUMBER_PAGES_WRITTEN: 3498
                     PAGES_READ_RATE: 0
                   PAGES_CREATE_RATE: 0
                  PAGES_WRITTEN_RATE: 0
                    NUMBER_PAGES_GET: 2823381
                            HIT_RATE: 1000
        YOUNG_MAKE_PER_THOUSAND_GETS: 0
    NOT_YOUNG_MAKE_PER_THOUSAND_GETS: 0
             NUMBER_PAGES_READ_AHEAD: 0
           NUMBER_READ_AHEAD_EVICTED: 0
                     READ_AHEAD_RATE: 0
             READ_AHEAD_EVICTED_RATE: 0
                        LRU_IO_TOTAL: 0
                      LRU_IO_CURRENT: 0
                    UNCOMPRESS_TOTAL: 0
                  UNCOMPRESS_CURRENT: 0
    
    ----------------------------
    INNODB Status
    ----------------------------
    *************************** 1. row ***************************
      Type: InnoDB
      Name: 
    Status: 
    =====================================
    131106 12:23:54 INNODB MONITOR OUTPUT
    =====================================
    Per second averages calculated from the last 22 seconds
    -----------------
    BACKGROUND THREAD
    -----------------
    srv_master_thread loops: 118169 1_second, 118165 sleeps, 9654 10_second, 21674 background, 21674 flush
    srv_master_thread log flush and writes: 118211
    ----------
    SEMAPHORES
    ----------
    OS WAIT ARRAY INFO: reservation count 405, signal count 404
    Mutex spin waits 479, rounds 6221, OS waits 127
    RW-shared spins 274, rounds 8220, OS waits 274
    RW-excl spins 0, rounds 0, OS waits 0
    Spin rounds per wait: 12.99 mutex, 30.00 RW-shared, 0.00 RW-excl
    ------------
    TRANSACTIONS
    ------------
    Trx id counter 1578F
    Purge done for trx's n:o < 155C3 undo n:o < 0
    History list length 715
    LIST OF TRANSACTIONS FOR EACH SESSION:
    ---TRANSACTION 0, not started
    MySQL thread id 8855980, OS thread handle 0x2ae75ef4700, query id 146931995 localhost root
    show engine innodb status
    --------
    FILE I/O
    --------
    I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
    I/O thread 1 state: waiting for completed aio requests (log thread)
    I/O thread 2 state: waiting for completed aio requests (read thread)
    I/O thread 3 state: waiting for completed aio requests (read thread)
    I/O thread 4 state: waiting for completed aio requests (read thread)
    I/O thread 5 state: waiting for completed aio requests (read thread)
    I/O thread 6 state: waiting for completed aio requests (write thread)
    I/O thread 7 state: waiting for completed aio requests (write thread)
    I/O thread 8 state: waiting for completed aio requests (write thread)
    I/O thread 9 state: waiting for completed aio requests (write thread)
    Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
     ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
    Pending flushes (fsync) log: 0; buffer pool: 0
    811 OS file reads, 5561 OS file writes, 2571 OS fsyncs
    0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
    -------------------------------------
    INSERT BUFFER AND ADAPTIVE HASH INDEX
    -------------------------------------
    Ibuf: size 1, free list len 0, seg size 2, 0 merges
    merged operations:
     insert 0, delete mark 0, delete 0
    discarded operations:
     insert 0, delete mark 0, delete 0
    Hash table size 276671, node heap has 1 buffer(s)
    1.73 hash searches/s, 0.00 non-hash searches/s
    ---
    LOG
    ---
    Log sequence number 5226739
    Log flushed up to   5226739
    Last checkpoint at  5226739
    0 pending log writes, 0 pending chkp writes
    1174 log i/o's done, 0.00 log i/o's/second
    ----------------------
    BUFFER POOL AND MEMORY
    ----------------------
    Total memory allocated 137363456; in additional pool allocated 0
    Dictionary memory allocated 535494
    Buffer pool size   8191
    Free buffers       6793
    Database pages     1397
    Old database pages 495
    Modified db pages  0
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 0, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 741, created 656, written 3498
    0.00 reads/s, 0.00 creates/s, 0.00 writes/s
    No buffer pool page gets since the last printout
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 1397, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    --------------
    ROW OPERATIONS
    --------------
    0 queries inside InnoDB, 0 queries in queue
    1 read views open inside InnoDB
    Main thread process no. 3272, id 2948382086912, state: sleeping
    Number of rows inserted 2744, updated 0, deleted 0, read 684999
    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1.64 reads/s
    ----------------------------
    END OF INNODB MONITOR OUTPUT
    ============================
    
    
    ----------------------------
    MySQL Error Log
    ----------------------------
    
    131006 10:38:43 InnoDB: The InnoDB memory heap is disabled
    131006 10:38:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    131006 10:38:43 InnoDB: Compressed tables use zlib 1.2.3
    131006 10:38:43 InnoDB: Using Linux native AIO
    131006 10:38:43 InnoDB: Initializing buffer pool, size = 128.0M
    131006 10:38:43 InnoDB: Completed initialization of buffer pool
    131006 10:38:43 InnoDB: highest supported file format is Barracuda.
    131006 10:38:44  InnoDB: Waiting for the background threads to start
    131006 10:38:45 InnoDB: 5.5.32 started; log sequence number 3744622
    131006 10:38:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    131006 10:38:45 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    131006 10:38:45 [Note] Server socket created on IP: '0.0.0.0'.
    131006 10:38:45 [Note] Event Scheduler: Loaded 0 events
    131006 10:38:45 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.32-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    
    Report Complete:
    mié nov 6 12:23:54 CET 2013
    ----------------------------
    
    thanks
     
  2. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Copy your current my.cnf, exact server spec, what kind of scripts you got on the server (custom or some CMS), and mysqltuner.pl result
     
  3. foroxd

    foroxd Member

    Joined:
    Nov 6, 2013
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    my.cnf


    Code:
    [mysqld]
    back_log = 100
    #skip-innodb
    #innodb=OFF
    max_connections = 400
    key_buffer_size = 256M
    myisam_sort_buffer_size = 256M
    myisam_max_sort_file_size = 3072M
    join_buffer_size = 256K
    read_buffer_size = 256K
    sort_buffer_size = 256K
    table_definition_cache = 10000
    table_open_cache = 10000
    thread_cache_size = 384
    wait_timeout = 120
    interactive_timeout = 60
    connect_timeout = 10
    tmp_table_size = 384M
    max_heap_table_size = 384M
    max_allowed_packet = 64M
    max_seeks_for_key = 1000
    group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 256K
    bulk_insert_buffer_size = 8M
    query_cache_limit = 1536K
    query_cache_size = 64M
    query_cache_type = 1
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    range_alloc_block_size = 4096
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = MyISAM
    max_write_lock_count = 16
    lock_wait_timeout=100
    
    # mysql 5.5 specific
    innodb_buffer_pool_instances=8
    innodb_flush_method = O_DIRECT
    innodb_file_per_table = 1
    innodb_open_files = 1000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 8000M
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 5M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 2
    innodb_thread_concurrency = 16
    innodb_lock_wait_timeout=50
    
    innodb_io_capacity = 200
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    
    
    long_query_time=1
    slow_query_log=0
    slow_query_log_file=/var/log/mysql/slowq.log
    
    [mysqld_safe]
    nice = -5
    open-files-limit = 8192
    
    [mysqldump]
    quick
    quote-names
    max_allowed_packet = 64M
    
    [myisamchk]
    key_buffer_size = 1024M
    sort_buffer_size = 1M
    read_buffer_size = 1M
    write_buffer_size = 1M
    
    [mysqlhotcopy]
    interactive-timeout
    
    1 vbulletin and 2 wordpress.

    Thanks and regards
     
  4. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    still mysqltuner results missing and what hdd you have
    it provides most of the improtant information in one place
     
  5. foroxd

    foroxd Member

    Joined:
    Nov 6, 2013
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello

    mysqltuner

    Code:
    -------- General Statistics --------------------------------------------------
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 5.5.32-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
    [--] Data in MyISAM tables: 2G (Tables: 328)
    [--] Data in InnoDB tables: 944K (Tables: 59)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 2M (Tables: 2)
    [!!] Total fragmented tables: 40
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 23h 40m 48s (4M q [51.349 qps], 232K conn, TX: 200B, RX: 1B)
    [--] Reads / Writes: 80% / 20%
    [--] Total buffers: 8.5G global + 1.2M per thread (400 max threads)
    [OK] Maximum possible memory usage: 9.0G (38% of installed RAM)
    [OK] Slow queries: 0% (312/4M)
    [OK] Highest usage of available connections: 19% (78/400)
    [OK] Key buffer size / total MyISAM indexes: 256.0M/925.3M
    [OK] Key buffer hit rate: 97.1% (184M cached / 5M reads)
    [OK] Query cache efficiency: 52.3% (1M cached / 3M selects)
    [!!] Query cache prunes per day: 49051
    [OK] Sorts requiring temporary tables: 0% (171 temp sorts / 441K sorts)
    [!!] Joins performed without indexes: 1299
    [OK] Temporary tables created on disk: 6% (4K on disk / 71K total)
    [OK] Thread cache hit rate: 99% (78 created / 232K connections)
    [OK] Table cache hit rate: 23% (622 open / 2K opened)
    [OK] Open file limit used: 4% (842/20K)
    [OK] Table locks acquired immediately: 99% (3M immediate / 3M locks)
    [OK] InnoDB data size / buffer pool: 944.0K/7.8G
    
    -------- 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
        Adjust your join queries to always utilize indexes
    Variables to adjust:
        query_cache_size (> 64M)
        join_buffer_size (> 256.0K, or always use indexes with joins)
    ssd 1,77 TB

    thanks
     
  6. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    [mysqld]
    back_log = 100
    #skip-innodb

    max_connections = 400
    wait_timeout = 120
    interactive_timeout = 60
    connect_timeout = 2


    key_buffer_size = 1500M
    myisam_sort_buffer_size = 256M
    myisam_max_sort_file_size = 3072M

    join_buffer_size = 1M
    read_buffer_size = 256K
    sort_buffer_size = 128K
    read_rnd_buffer_size = 2M

    table_definition_cache = 1000
    table_open_cache = 2500

    thread_cache_size = 32

    tmp_table_size = 50M
    max_heap_table_size = 50M

    max_allowed_packet = 64M

    concurrent_insert = 2
    bulk_insert_buffer_size = 16M

    query_cache_type = 1
    query_cache_size = 64M
    query_cache_limit = 1M

    default-storage-engine = MyISAM
    max_write_lock_count = 10


    # mysql 5.5 specific
    innodb_buffer_pool_instances=8
    innodb_flush_method = O_DIRECT
    innodb_file_per_table = 1
    innodb_open_files = 3000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 1000M

    innodb_log_files_in_group = 2
    innodb_log_file_size = 5M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 2
    #innodb_thread_concurrency = 16
    #innodb_lock_wait_timeout=50

    #innodb_io_capacity = 200
    #innodb_read_io_threads = 2
    #innodb_write_io_threads = 2

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

    [mysqld_safe]
    nice = -5
    open-files-limit = 8192

    [mysqldump]
    quick
    quote-names
    max_allowed_packet = 64M

    [myisamchk]
    key_buffer_size = 1024M
    sort_buffer_size = 1M
    read_buffer_size = 1M
    write_buffer_size = 1M

    [mysqlhotcopy]
    interactive-timeout



    I've removed and commented out some of the settings, do you even understand them why there were there ?

    innodb settings optimizations doesnt really make sense much in case of your config since, you got very little content in innodb tables
    if you plan to put in innodb more contents increase innodb_log_file_size to at least 50M (before restart you need to remove old ib_logfile* files )

    you can restart the server with new my.cnf settings above

    "ssd 1,77 TB"
    you really have 1,77 TB SSD in this setup ?
     
  7. foroxd

    foroxd Member

    Joined:
    Nov 6, 2013
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Sorry, it 1Tb hdd
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  9. foroxd

    foroxd Member

    Joined:
    Nov 6, 2013
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Sorry, I was out the holidays.

    It goes very well but sometimes load up a bit.

    Thanks and regards
     
Loading...

Share This Page