foroxd

Member
Nov 6, 2013
5
0
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
 

thinkbot

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

foroxd

Member
Nov 6, 2013
5
0
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
 

foroxd

Member
Nov 6, 2013
5
0
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
 

thinkbot

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