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.

Very slow MySQL CREATE TABLE

Discussion in 'Workarounds and Optimization' started by nyanhost, Feb 25, 2014.

  1. nyanhost

    nyanhost Active Member

    Joined:
    Nov 4, 2013
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello!

    My MYSQL 5.6.16 is very slow for operation "CREATE TABLE".

    System configuration: Intel i7-3770 / 16GB RAM / 2x3TB HDD [Software RAID1]
    Current Load Average: load average: 0.32, 0.38, 0.56

    I use MyISAM and InnoDB engine type.
    InnoDB - 0.87 sec...
    Code:
    mysql> CREATE TABLE Test_Inno1 ( maiy CHAR(20)) ENGINE=InnoDB;
    Query OK, 0 rows affected (0.57 sec)
    
    mysql> CREATE TABLE Test_Inno2 ( maiy CHAR(20)) ENGINE=InnoDB;
    Query OK, 0 rows affected (0.87 sec)
    
    mysql> CREATE TABLE Test_Inno3 ( maiy CHAR(20)) ENGINE=InnoDB;
    Query OK, 0 rows affected (0.43 sec)
    
    mysql> CREATE TABLE Test_Inno4 ( maiy CHAR(20)) ENGINE=InnoDB;
    Query OK, 0 rows affected (0.41 sec)
    
    MyISAM ~0.10 sec. average:
    Code:
    
    mysql> CREATE TABLE Test_MyISAM1 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.06 sec)
    
    mysql> CREATE TABLE Test_MyISAM2 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.14 sec)
    
    mysql> CREATE TABLE Test_MyISAM3 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.04 sec)
    
    mysql> CREATE TABLE Test_MyISAM4 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.12 sec)
    
    mysql> CREATE TABLE Test_MyISAM5 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.11 sec)
    
    mysql> CREATE TABLE Test_MyISAM6 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.14 sec)
    
    mysql> CREATE TABLE Test_MyISAM7 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.15 sec)
    
    mysql> CREATE TABLE Test_MyISAM8 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.07 sec)
    
    
    Configuration file: /etc/my.cnf
    Code:
    [mysqld]
    innodb_data_home_dir=/var/lib/mysql
    innodb_log_group_home_dir=/var/lib/mysql
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    port=3306
    user=mysql
    
    max_allowed_packet = 64M
    
    innodb_lock_wait_timeout=30
    innodb_log_file_size=256M
    innodb_log_buffer_size=8M
    key_buffer_size=2G
    innodb_log_files_in_group=3
    skip-innodb_checksums
    skip-innodb_doublewrite
    
    innodb_additional_mem_pool_size=20M
    innodb_buffer_pool_size=6G
    innodb_buffer_pool_instances = 6
    innodb_thread_concurrency = 16
    innodb_max_dirty_pages_pct = 90
    
    read_buffer_size=4M
    innodb_file_io_threads = 4
    innodb_write_io_threads = 4
    
    default-storage-engine=MyISAM
    innodb_file_per_table=1
    query_cache_size=128M
    query_cache_limit=2M
    query_cache_type=1
    query_cache_min_res_unit=512K
    table_open_cache=8192
    table_definition_cache=8192
    join_buffer_size=12M
    myisam_sort_buffer_size=2G
    max_heap_table_size=128M
    sort_buffer_size=12M
    innodb_flush_method=O_DIRECT
    innodb_log_buffer_size=16M
    tmp_table_size=64M
    read_rnd_buffer_size=32M
    innodb_flush_log_at_trx_commit=1
    max_connections=100
    max_connect_errors = 10000
    
    wait_timeout=30
    net_read_timeout=30
    net_write_timeout=30
    
    
    thread_cache_size=32
    thread_concurrency=10
    thread_stack = 256K
    
    tmpdir = /dev/shm
    transaction_isolation = REPEATABLE-READ
    
    

    Please, help me... It is very bad result :(
    If I run MySQL without my current config that result to increases a execution time on 1-2+ sec...

    May be due to RAID?
     
    #1 nyanhost, Feb 25, 2014
    Last edited: Feb 25, 2014
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    nyanhost Active Member

    Joined:
    Nov 4, 2013
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello! Thank you

    ./mysqlmymonlite.sh run:confused:
    Code:
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 WHM mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Tue Feb 25 23:31:56 CET 2014
    
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started 2014-02-25 23:20:10.000000
    Uptime: 11 min 46 sec    
    Uptime 706
    Uptime_since_flush_status 706
    
    Max Used Connections:      10/100 (10.00%)
    Key Buffer Used:           23.03M/2.00G (1.12%)
    Current Key Buffer Usage:  396.48M (19.36%)
    Query Cache:               19.45M/128.00M (15.19%)
    Table Locks Waited:        0 Rate: 0/s (0.00%)
    --------------------
    Query Cache Limit (bytes): 2097152
    Query Cache Min Unit (bytes): 524288
    Query Cache Size (bytes): 134217728
    Query Cache Free Mem (bytes): 113813688
    Query Cache Used Mem (bytes): 20404040
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 20404040
    
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 1, cores = 4, virtual = 8, hyperthreading = yes
          5  1600.000
          1  2800.000
          1  3000.000
          1  3401.000
          8  Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz
          8  8192 KB
    
    
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 2.6.32-431.3.1.el6.x86_64 ((yourserverhostname)) 	02/25/2014 	_x86_64_	(8 CPU)
    
    11:31:56 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    11:31:58 PM  all    1.07    0.00    0.82   23.15    0.00    0.06    0.00    0.00   74.91
    11:31:58 PM    0    2.04    0.00    2.04   88.27    0.00    0.51    0.00    0.00    7.14
    11:31:58 PM    1    2.02    0.00    2.02   72.22    0.00    0.00    0.00    0.00   23.74
    11:31:58 PM    2    0.50    0.00    0.50    3.00    0.00    0.00    0.00    0.00   96.00
    11:31:58 PM    3    0.50    0.00    0.50   12.50    0.00    0.00    0.00    0.00   86.50
    11:31:58 PM    4    3.00    0.00    1.50    1.00    0.00    0.00    0.00    0.00   94.50
    11:31:58 PM    5    0.50    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.50
    11:31:58 PM    6    0.50    0.00    0.00    9.50    0.00    0.00    0.00    0.00   90.00
    11:31:58 PM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    11:31:58 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    11:32:00 PM  all    0.56    0.00    0.31   29.34    0.00    0.00    0.00    0.00   69.78
    11:32:00 PM    0    2.53    0.00    1.52   91.92    0.00    0.00    0.00    0.00    4.04
    11:32:00 PM    1    1.00    0.00    1.00   79.60    0.00    0.00    0.00    0.00   18.41
    11:32:00 PM    2    0.00    0.00    0.00   19.10    0.00    0.00    0.00    0.00   80.90
    11:32:00 PM    3    0.50    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.50
    11:32:00 PM    4    0.50    0.00    0.00   25.50    0.00    0.00    0.00    0.00   74.00
    11:32:00 PM    5    0.00    0.00    0.00    0.50    0.00    0.00    0.00    0.00   99.50
    11:32:00 PM    6    0.00    0.00    0.50   18.09    0.00    0.00    0.00    0.00   81.41
    11:32:00 PM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    Average:     all    0.82    0.00    0.56   26.25    0.00    0.03    0.00    0.00   72.34
    Average:       0    2.28    0.00    1.78   90.10    0.00    0.25    0.00    0.00    5.58
    Average:       1    1.50    0.00    1.50   75.94    0.00    0.00    0.00    0.00   21.05
    Average:       2    0.25    0.00    0.25   11.03    0.00    0.00    0.00    0.00   88.47
    Average:       3    0.50    0.00    0.25    6.25    0.00    0.00    0.00    0.00   93.00
    Average:       4    1.75    0.00    0.75   13.25    0.00    0.00    0.00    0.00   84.25
    Average:       5    0.25    0.00    0.00    0.25    0.00    0.00    0.00    0.00   99.50
    Average:       6    0.25    0.00    0.25   13.78    0.00    0.00    0.00    0.00   85.71
    Average:       7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    top - 23:32:01 up 8 days,  4:36,  1 user,  load average: 1.18, 1.48, 1.71
    Tasks: 241 total,   1 running, 236 sleeping,   4 stopped,   0 zombie
    Cpu(s):  1.6%us,  0.6%sy,  0.1%ni, 95.1%id,  2.6%wa,  0.0%hi,  0.0%si,  0.0%st
    Mem:  16016076k total,  5667556k used, 10348520k free,   127000k buffers
    Swap: 33554296k total,    42168k used, 33512128k free,  1102304k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                         
    32005 user294   20   0  450m  71m  26m D  7.9  0.5   0:06.31 httpd                                           
      740 mysql     20   0 10.7g 2.9g 8672 S  2.0 18.8   0:27.79 mysqld                                          
     3893 user138   20   0  379m  15m 9636 S  2.0  0.1   0:00.22 php                                             
     3976 root      20   0  148m  12m  796 D  2.0  0.1   0:00.24 lfd - checking                                  
    16949 nobody    20   0  450m  72m  26m S  2.0  0.5   0:16.06 httpd                                           
    17842 nobody    20   0  448m  69m  26m S  2.0  0.4   0:11.57 httpd                                           
        1 root      20   0 19232 1052  860 S  0.0  0.0   0:04.88 init                                            
        2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthreadd                                        
        3 root      RT   0     0    0    0 S  0.0  0.0   0:03.10 migration/0                                     
        4 root      20   0     0    0    0 S  0.0  0.0   0:17.57 ksoftirqd/0                                     
        5 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/0                                     
        6 root      RT   0     0    0    0 S  0.0  0.0   0:00.64 watchdog/0                                      
        7 root      RT   0     0    0    0 S  0.0  0.0   0:02.43 migration/1                                     
        8 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/1                                     
        9 root      20   0     0    0    0 S  0.0  0.0   0:02.82 ksoftirqd/1                                     
       10 root      RT   0     0    0    0 S  0.0  0.0   0:00.46 watchdog/1                                      
       11 root      RT   0     0    0    0 S  0.0  0.0   0:00.88 migration/2                                     
       12 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/2                                     
       13 root      20   0     0    0    0 S  0.0  0.0   0:02.85 ksoftirqd/2                                     
       14 root      RT   0     0    0    0 S  0.0  0.0   0:00.48 watchdog/2                                      
       15 root      RT   0     0    0    0 S  0.0  0.0   0:00.57 migration/3                                     
       16 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/3                                     
       17 root      20   0     0    0    0 S  0.0  0.0   0:03.01 ksoftirqd/3                                     
       18 root      RT   0     0    0    0 S  0.0  0.0   0:00.47 watchdog/3                                      
       19 root      RT   0     0    0    0 S  0.0  0.0   0:06.34 migration/4                                     
       20 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/4                                     
       21 root      20   0     0    0    0 S  0.0  0.0   0:04.96 ksoftirqd/4                                     
       22 root      RT   0     0    0    0 S  0.0  0.0   0:00.50 watchdog/4                                      
       23 root      RT   0     0    0    0 S  0.0  0.0   0:02.91 migration/5                                     
       24 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/5                                     
       25 root      20   0     0    0    0 S  0.0  0.0   0:01.79 ksoftirqd/5                                     
       26 root      RT   0     0    0    0 S  0.0  0.0   0:00.49 watchdog/5                                      
       27 root      RT   0     0    0    0 S  0.0  0.0   0:01.55 migration/6                                     
       28 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/6                                     
       29 root      20   0     0    0    0 S  0.0  0.0   0:03.50 ksoftirqd/6                                     
       30 root      RT   0     0    0    0 S  0.0  0.0   0:00.47 watchdog/6                                      
       31 root      RT   0     0    0    0 S  0.0  0.0   0:01.33 migration/7                                     
       32 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/7                                     
       33 root      20   0     0    0    0 S  0.0  0.0   0:02.83 ksoftirqd/7                                     
       34 root      RT   0     0    0    0 S  0.0  0.0   0:00.47 watchdog/7                                      
       35 root      20   0     0    0    0 S  0.0  0.0   0:30.68 events/0                                        
       36 root      20   0     0    0    0 S  0.0  0.0   0:26.43 events/1                                        
       37 root      20   0     0    0    0 S  0.0  0.0   0:19.09 events/2                                        
       38 root      20   0     0    0    0 S  0.0  0.0   0:16.66 events/3                                        
       39 root      20   0     0    0    0 S  0.0  0.0   0:20.51 events/4                                        
       40 root      20   0     0    0    0 S  0.0  0.0   0:23.32 events/5                                        
       41 root      20   0     0    0    0 S  0.0  0.0   0:27.43 events/6                                        
       42 root      20   0     0    0    0 S  0.0  0.0   0:26.39 events/7                                        
       43 root      20   0     0    0    0 S  0.0  0.0   0:00.00 cgroup                                          
       44 root      20   0     0    0    0 S  0.0  0.0   0:00.00 khelper                                         
       45 root      20   0     0    0    0 S  0.0  0.0   0:00.00 netns                                           
       46 root      20   0     0    0    0 S  0.0  0.0   0:00.00 async/mgr                                       
       47 root      20   0     0    0    0 S  0.0  0.0   0:00.00 pm                                              
       48 root      20   0     0    0    0 S  0.0  0.0   0:04.72 sync_supers                                     
       49 root      20   0     0    0    0 S  0.0  0.0   0:01.98 bdi-default                                     
       50 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/0                                   
       51 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/1                                   
       52 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/2                                   
       53 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/3                                   
       54 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/4                                   
       55 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/5                                   
       56 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/6                                   
       57 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/7                                   
       58 root      20   0     0    0    0 S  0.0  0.0   7:45.74 kblockd/0                                       
       59 root      20   0     0    0    0 S  0.0  0.0   0:00.23 kblockd/1                                       
       60 root      20   0     0    0    0 S  0.0  0.0   0:00.10 kblockd/2                                       
       61 root      20   0     0    0    0 S  0.0  0.0   0:00.07 kblockd/3                                       
       62 root      20   0     0    0    0 S  0.0  0.0   0:00.77 kblockd/4                                       
       63 root      20   0     0    0    0 S  0.0  0.0   0:00.12 kblockd/5                                       
       64 root      20   0     0    0    0 S  0.0  0.0   0:00.07 kblockd/6                                       
       65 root      20   0     0    0    0 S  0.0  0.0   0:00.03 kblockd/7                                       
       66 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kacpid                                          
       67 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kacpi_notify                                    
       68 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kacpi_hotplug                                   
       69 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_aux                                         
       70 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/0                                       
       71 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/1                                       
       72 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/2                                       
       73 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/3                                       
       74 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/4                                       
       75 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/5                                       
       76 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/6                                       
       77 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/7                                       
       78 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ksuspend_usbd                                   
       79 root      20   0     0    0    0 S  0.0  0.0   0:00.00 khubd                                           
       80 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kseriod                                         
       81 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/0                                            
       82 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/1                                            
       83 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/2                                            
       84 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/3                                            
       85 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/4                                            
       86 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/5                                            
       87 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/6                                            
       88 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/7                                            
       89 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/0                                       
       90 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/1                                       
       91 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/2                                       
       92 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/3                                       
       93 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/4                                       
       94 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/5                                       
       95 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/6                                       
       96 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/7                                       
       97 root      20   0     0    0    0 S  0.0  0.0   0:00.00 linkwatch                                       
       98 root      20   0     0    0    0 S  0.0  0.0   0:00.53 khungtaskd                                      
       99 root      20   0     0    0    0 S  0.0  0.0   0:28.87 kswapd0                                         
      100 root      25   5     0    0    0 S  0.0  0.0   0:00.00 ksmd                                            
      101 root      39  19     0    0    0 S  0.0  0.0   0:24.52 khugepaged                                      
      102 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/0                                           
      103 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/1                                           
      104 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/2                                           
      105 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/3                                           
      106 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/4                                           
      107 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/5                                           
      108 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/6                                           
      109 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/7                                           
      110 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/0                                        
      111 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/1                                        
      112 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/2                                        
      113 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/3                                        
      114 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/4                                        
      115 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/5                                        
      116 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/6                                        
      117 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/7                                        
      122 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/0                                      
      123 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/1                                      
      124 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/2                                      
      125 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/3                                      
      126 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/4                                      
      127 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/5                                      
      128 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/6                                      
      129 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/7                                      
      131 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kpsmoused                                       
      132 root      20   0     0    0    0 S  0.0  0.0   0:00.00 usbhid_resumer                                  
      162 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kstriped                                        
      342 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0                                       
      343 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_1                                       
      344 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_2                                       
      345 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_3                                       
      346 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_4                                       
      347 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_5                                       
      469 root      20   0     0    0    0 S  0.0  0.0  22:42.53 md2_raid1                                       
      474 root      20   0     0    0    0 S  0.0  0.0   0:00.84 md1_raid1                                       
      480 root      20   0     0    0    0 S  0.0  0.0  62:40.81 md3_raid1                                       
      487 root      20   0     0    0    0 S  0.0  0.0   1:54.07 md0_raid1                                       
      515 root      20   0     0    0    0 S  0.0  0.0   3:49.37 jbd2/md2-8                                      
      516 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ext4-dio-unwrit                                 
      591 root      16  -4 10672  484  320 S  0.0  0.0   0:00.15 udevd                                           
      889 root      20   0     0    0    0 S  0.0  0.0   1:28.38 flush-9:2                                       
      929 root      20   0     0    0    0 S  0.0  0.0   5:44.35 kondemand/0                                     
      930 root      20   0     0    0    0 S  0.0  0.0   1:12.33 kondemand/1                                     
      931 root      20   0     0    0    0 S  0.0  0.0   0:41.40 kondemand/2                                     
      932 root      20   0     0    0    0 S  0.0  0.0   0:30.69 kondemand/3                                     
      933 root      20   0     0    0    0 S  0.0  0.0   3:46.78 kondemand/4                                     
      934 root      20   0     0    0    0 S  0.0  0.0   0:47.09 kondemand/5                                     
      935 root      20   0     0    0    0 S  0.0  0.0   0:33.31 kondemand/6                                     
      936 root      20   0     0    0    0 S  0.0  0.0   0:25.46 kondemand/7                                     
      970 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kjournald                                       
      971 root      20   0     0    0    0 S  0.0  0.0   0:32.98 jbd2/md3-8                                      
      972 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ext4-dio-unwrit                                 
     1083 root      20   0     0    0    0 S  0.0  0.0   0:04.54 kauditd                                         
     1113 root       0 -20     0    0    0 D  0.0  0.0   3:04.45 loop0                                           
     1114 root      20   0     0    0    0 S  0.0  0.0   0:31.22 kjournald                                       
     1245 root      20   0     0    0    0 S  0.0  0.0   0:14.26 flush-7:0                                       
     1247 root      20   0     0    0    0 S  0.0  0.0   0:57.77 flush-9:3                                       
     1347 root      16  -4 93200  736  560 S  0.0  0.0   0:17.20 auditd                                          
     1404 root      20   0  148m  12m 1308 S  0.0  0.1   0:43.48 lfd - sleeping                                  
     1455 root      20   0  243m 4784  840 S  0.0  0.0   0:55.56 rsyslogd                                        
     1469 named     20   0  689m  96m 2800 S  0.0  0.6   3:32.02 named                                           
     2134 root      20   0  4080  472  468 S  0.0  0.0   0:00.00 acpid                                           
     2170 root      20   0 66608  532  444 S  0.0  0.0   0:00.00 sshd                                            
     2271 nobody    20   0  453m  72m  25m S  0.0  0.5   0:03.00 httpd                                           
     2316 root      20   0  138m 1448 1084 T  0.0  0.0   0:00.00 crontab                                         
     2317 root      20   0  116m 1736 1392 T  0.0  0.0   0:00.00 vi                                              
     2385 root      20   0  138m 1448 1084 T  0.0  0.0   0:00.00 crontab                                         
     2392 root      20   0  116m 1724 1384 T  0.0  0.0   0:00.00 vi                                              
     2848 root      20   0  114m 1108  648 S  0.0  0.0   0:27.89 crond                                           
     2859 root      20   0 21540  420  368 S  0.0  0.0   0:00.00 atd                                             
     2938 root      20   0 98876  18m 5796 S  0.0  0.1   0:29.72 cpsrvd-ssl                                      
     3069 dovecot   20   0 29428 1916 1420 S  0.0  0.0   0:00.00 auth                                            
     3083 root      20   0 39620 1096 1056 S  0.0  0.0   0:00.00 ihttpd                                          
     3094 root      20   0  4064  488  484 S  0.0  0.0   0:00.00 mingetty                                        
     3096 root      20   0  4064  488  484 S  0.0  0.0   0:00.00 mingetty                                        
     3098 root      20   0  4064  488  484 S  0.0  0.0   0:00.00 mingetty                                        
     3100 root      20   0  4064  488  484 S  0.0  0.0   0:00.00 mingetty                                        
     3102 root      20   0  4064  488  484 S  0.0  0.0   0:00.00 mingetty                                        
     3104 root      20   0  4064  488  484 S  0.0  0.0   0:00.00 mingetty                                        
     3876 root      20   0  138m 1672 1012 S  0.0  0.0   0:00.00 crond                                           
     3877 root      20   0  138m 1668 1012 S  0.0  0.0   0:00.00 crond                                           
     3882 root      20   0  6184  820  648 S  0.0  0.0   0:00.00 jailshell                                       
     3884 root      20   0  6184  820  648 S  0.0  0.0   0:00.00 jailshell                                       
     3890 user138   20   0  6184  412  240 S  0.0  0.0   0:00.00 jailshell                                       
     3891 user138   20   0  410m  14m 8888 S  0.0  0.1   0:00.04 php                                             
     3892 user138   20   0  6184  412  240 S  0.0  0.0   0:00.00 jailshell                                       
     3978 root      20   0  104m 1976 1228 S  0.0  0.0   0:00.01 mysqlmymonlite.                                 
     4166 root      20   0 15024 1288  880 R  0.0  0.0   0:00.00 top                                             
     5240 root      20   0 36272 3564 1428 S  0.0  0.0   0:03.25 queueprocd - wa                                 
     5312 root      20   0 71492 3068 2588 S  0.0  0.0   0:03.96 cPhulkd - proce                                 
     5348 root      20   0  110m 2816  660 S  0.0  0.0   0:00.96 cpdavd - accept                                 
     5349 root      38  18 27252 2592 1164 S  0.0  0.0   0:00.73 cpanellogd - sl                                 
     5416 root      20   0 19596 1116  820 S  0.0  0.0   0:00.43 dovecot                                         
     5420 dovenull  20   0 42464 3596 2692 S  0.0  0.0   0:01.65 pop3-login                                      
     5421 dovenull  20   0 42356 3516 2692 S  0.0  0.0   0:00.19 imap-login                                      
     5422 dovecot   20   0 13300 1120  932 S  0.0  0.0   0:00.14 anvil                                           
     5423 root      20   0 13432 1300  968 S  0.0  0.0   0:00.17 log                                             
     5425 dovenull  20   0 42340 3448 2648 S  0.0  0.0   0:00.01 pop3-login                                      
     5426 dovenull  20   0 42480 3592 2700 S  0.0  0.0   0:00.25 imap-login                                      
     5427 root      20   0 16408 2104 1100 S  0.0  0.0   0:00.37 config                                          
     5463 root      18  -2 10668  380  196 S  0.0  0.0   0:00.00 udevd                                           
     5533 root      20   0  585m 249m 1848 S  0.0  1.6   3:09.43 clamd                                           
     5540 mailnull  20   0 71536 2984  704 S  0.0  0.0   0:01.98 exim                                            
     5558 root      20   0  161m  49m 3032 S  0.0  0.3   0:12.47 /usr/local/cpan                                 
     5575 root      20   0  161m  48m 1156 S  0.0  0.3   0:00.06 spamd child                                     
     5576 root      20   0  161m  48m 1156 S  0.0  0.3   0:00.08 spamd child                                     
     7002 root      20   0  135m 2084 1380 S  0.0  0.0   0:00.19 pure-ftpd                                       
     7004 root      20   0  133m 1792 1308 S  0.0  0.0   0:00.13 pure-authd                                      
    12714 root      20   0 79524 9676 1644 S  0.0  0.1   0:28.39 tailwatchd                                      
    14301 root      20   0  326m  31m  10m S  0.0  0.2   0:25.61 httpd                                           
    15969 nobody    20   0  458m  86m  33m S  0.0  0.6   0:21.24 httpd                                           
    17704 root      20   0 19404 1524 1180 S  0.0  0.0   0:00.00 ssl-params                                      
    22628 root      20   0 82032  33m  352 S  0.0  0.2   0:00.00 nginx                                           
    22629 nobody    20   0 85032  37m  952 S  0.0  0.2   0:05.91 nginx                                           
    22630 nobody    20   0 85104  37m  956 S  0.0  0.2   0:08.13 nginx                                           
    22631 nobody    20   0 84968  37m  952 S  0.0  0.2   0:04.76 nginx                                           
    22632 nobody    20   0 85096  37m  952 S  0.0  0.2   0:05.48 nginx                                           
    22633 nobody    20   0 84888  37m  948 S  0.0  0.2   0:04.33 nginx                                           
    22634 nobody    20   0 84888  37m  952 S  0.0  0.2   0:06.02 nginx                                           
    22637 nobody    20   0 84816  37m  948 S  0.0  0.2   0:04.47 nginx                                           
    22638 nobody    20   0 84840  37m  952 S  0.0  0.2   0:05.50 nginx                                           
    22639 nobody    20   0 82032  33m  516 S  0.0  0.2   0:00.02 nginx                                           
    22756 root      20   0  1972 1036  472 S  0.0  0.0   0:01.03 splitlogs                                       
    22757 root      20   0  1984 1052  472 S  0.0  0.0   0:01.11 splitlogs                                       
    22767 root      20   0 79900  10m 2948 S  0.0  0.1   0:00.04 leechprotect                                    
    23516 nobody    20   0  448m  69m  26m S  0.0  0.4   0:09.67 httpd                                           
    24014 nobody    20   0  449m  76m  32m S  0.0  0.5   0:09.52 httpd                                           
    24624 root      20   0  100m 3984 2956 S  0.0  0.0   0:00.83 sshd                                            
    24630 root      20   0  105m 2012 1532 S  0.0  0.0   0:01.34 bash                                            
    25255 root      20   0  619m 189m 7536 S  0.0  1.2   1:52.17 billmgr                                         
    30015 nobody    20   0  454m  74m  25m S  0.0  0.5   0:06.25 httpd                                           
    32004 nobody    20   0  454m  74m  25m S  0.0  0.5   0:06.59 httpd                                           
    32066 nobody    20   0  445m  64m  24m S  0.0  0.4   0:04.17 httpd                                           
    32459 root      20   0  103m 1524 1240 S  0.0  0.0   0:00.04 mysqld_safe                                     
    
    
                 total       used       free     shared    buffers     cached
    Mem:         15640       5534      10105          0        124       1076
    Low:         15640       5534      10105
    High:            0          0          0
    -/+ buffers/cache:       4334      11306
    Swap:        32767         41      32726
    
    MemTotal:       16016076 kB
    MemFree:        10348396 kB
    Buffers:          127000 kB
    Cached:          1102304 kB
    SwapCached:        28760 kB
    Active:          4652552 kB
    Inactive:         693628 kB
    Active(anon):    4098184 kB
    Inactive(anon):    52016 kB
    Active(file):     554368 kB
    Inactive(file):   641612 kB
    Unevictable:           0 kB
    Mlocked:               0 kB
    SwapTotal:      33554296 kB
    SwapFree:       33512128 kB
    Dirty:              1768 kB
    Writeback:             0 kB
    AnonPages:       4089500 kB
    Mapped:            70168 kB
    Shmem:             33028 kB
    Slab:             149980 kB
    SReclaimable:      79596 kB
    SUnreclaim:        70384 kB
    KernelStack:        2376 kB
    PageTables:        22936 kB
    NFS_Unstable:          0 kB
    Bounce:                0 kB
    WritebackTmp:          0 kB
    CommitLimit:    41562332 kB
    Committed_AS:   11798192 kB
    VmallocTotal:   34359738367 kB
    VmallocUsed:      115296 kB
    VmallocChunk:   34359527432 kB
    HardwareCorrupted:     0 kB
    AnonHugePages:   3217408 kB
    HugePages_Total:       0
    HugePages_Free:        0
    HugePages_Rsvd:        0
    HugePages_Surp:        0
    Hugepagesize:       2048 kB
    DirectMap4k:        6144 kB
    DirectMap2M:    16474112 kB
    
    --------------------------
    ps_mem.py output:
    http://www.pixelbeat.org/scripts/ps_mem.py
    --------------------------
     Private  +   Shared  =  RAM used	Program 
    
      4.0 KiB +  17.5 KiB =  21.5 KiB	acpid
     68.0 KiB +  32.5 KiB = 100.5 KiB	atd
     24.0 KiB +  93.0 KiB = 117.0 KiB	mingetty (6)
    200.0 KiB +  60.0 KiB = 260.0 KiB	anvil
    248.0 KiB +  35.0 KiB = 283.0 KiB	auditd
     64.0 KiB + 221.5 KiB = 285.5 KiB	ihttpd
    148.0 KiB + 140.5 KiB = 288.5 KiB	udevd (2)
    272.0 KiB +  40.0 KiB = 312.0 KiB	init
    344.0 KiB +  62.0 KiB = 406.0 KiB	log
    352.0 KiB +  56.5 KiB = 408.5 KiB	dovecot
    356.0 KiB +  76.5 KiB = 432.5 KiB	ssl-params
    296.0 KiB + 202.0 KiB = 498.0 KiB	mysqld_safe
    248.0 KiB + 302.0 KiB = 550.0 KiB	jailshell (4)
    492.0 KiB +  82.0 KiB = 574.0 KiB	pure-authd
    480.0 KiB + 315.0 KiB = 795.0 KiB	cPhulkd - proce
    608.0 KiB + 225.0 KiB = 833.0 KiB	bash
    772.0 KiB +  99.0 KiB = 871.0 KiB	pure-ftpd
    784.0 KiB + 100.0 KiB = 884.0 KiB	auth
    728.0 KiB + 206.0 KiB = 934.0 KiB	crontab (2)
    752.0 KiB + 200.0 KiB = 952.0 KiB	mysqlmymonlite.
      1.0 MiB +  72.0 KiB =   1.1 MiB	config
    720.0 KiB + 423.5 KiB =   1.1 MiB	crond (3)
    692.0 KiB + 644.0 KiB =   1.3 MiB	vi (2)
      1.4 MiB + 115.5 KiB =   1.5 MiB	cpanellogd - sl
      1.1 MiB + 480.0 KiB =   1.6 MiB	splitlogs (2)
      1.7 MiB + 367.0 KiB =   2.0 MiB	sshd (2)
      1.7 MiB + 429.0 KiB =   2.1 MiB	pop3-login (2)
      1.7 MiB + 442.0 KiB =   2.1 MiB	imap-login (2)
      2.1 MiB + 129.5 KiB =   2.2 MiB	cpdavd - accept
      2.2 MiB + 137.0 KiB =   2.3 MiB	queueprocd - wa
      2.4 MiB +  72.5 KiB =   2.5 MiB	exim
      4.1 MiB +  46.0 KiB =   4.1 MiB	rsyslogd
      1.1 MiB +   5.3 MiB =   6.4 MiB	lfd - sleeping
      1.4 MiB +   5.3 MiB =   6.7 MiB	lfd - checking 
      7.5 MiB + 359.0 KiB =   7.8 MiB	leechprotect
      7.9 MiB + 260.5 KiB =   8.1 MiB	tailwatchd
     12.9 MiB +   3.2 MiB =  16.1 MiB	php (2)
     16.4 MiB + 174.0 KiB =  16.6 MiB	cpsrvd-ssl
      2.5 MiB +  15.2 MiB =  17.7 MiB	/usr/local/cpan
      4.6 MiB +  30.2 MiB =  34.7 MiB	spamd child (2)
     95.7 MiB + 119.5 KiB =  95.8 MiB	named
     80.3 MiB +  32.4 MiB = 112.7 MiB	nginx (10)
    187.8 MiB + 393.5 KiB = 188.2 MiB	billmgr
    248.6 MiB + 102.5 KiB = 248.7 MiB	clamd
    286.2 MiB +  52.1 MiB = 338.3 MiB	httpd (11)
      2.9 GiB + 229.5 KiB =   2.9 GiB	mysqld
    ---------------------------------
                              4.0 GiB
    =================================
    
     Private  +   Shared  =  RAM used	Program 
    
    
    smem -uk
    User     Count     Swap      USS      PSS      RSS 
    dovecot      2        0   984.0K     1.1M     3.0M 
    mailnull     1        0     2.4M     2.4M     2.9M 
    dovenull     4        0     3.3M     4.0M    13.8M 
    user138      8        0    25.3M    31.0M    61.9M 
    user294      1   292.0K    27.1M    31.2M    71.0M 
    named        1    10.4M    95.7M    95.8M    96.8M 
    nobody      18     2.9M   333.0M   402.9M   997.4M 
    root        57    30.1M   512.9M   580.8M   783.9M 
    mysql        1        0     2.9G     2.9G     2.9G 
    
    smem -t -p
      PID User     Command                         Swap      USS      PSS      RSS 
     2134 root     /usr/sbin/acpid                0.00%    0.00%    0.00%    0.00% 
     3094 root     /sbin/mingetty /dev/tty1       0.00%    0.00%    0.00%    0.00% 
     3096 root     /sbin/mingetty /dev/tty2       0.00%    0.00%    0.00%    0.00% 
     3098 root     /sbin/mingetty /dev/tty3       0.00%    0.00%    0.00%    0.00% 
     3100 root     /sbin/mingetty /dev/tty4       0.00%    0.00%    0.00%    0.00% 
     3102 root     /sbin/mingetty /dev/tty5       0.00%    0.00%    0.00%    0.00% 
     3104 root     /sbin/mingetty /dev/tty6       0.00%    0.00%    0.00%    0.00% 
     2859 root     /usr/sbin/atd                  0.00%    0.00%    0.00%    0.00% 
      591 root     /sbin/udevd -d                 0.00%    0.00%    0.00%    0.00% 
     3890 user138  jailshell (user138) [init]     0.00%    0.00%    0.00%    0.00% 
     4183 user138  jailshell (user138) [init]     0.00%    0.00%    0.00%    0.00% 
     4186 user138  jailshell (user138) [init]     0.00%    0.00%    0.00%    0.00% 
     3892 user138  jailshell (user138) [init]     0.00%    0.00%    0.00%    0.00% 
     3882 root     jailshell (user138) [3890]     0.00%    0.00%    0.00%    0.01% 
     4174 root     jailshell (user138) [4183]     0.00%    0.00%    0.00%    0.01% 
     4178 root     jailshell (user138) [4186]     0.00%    0.00%    0.00%    0.01% 
     3884 root     jailshell (user138) [3892]     0.00%    0.00%    0.00%    0.01% 
     5463 root     /sbin/udevd -d                 0.00%    0.00%    0.00%    0.00% 
     2170 root     /usr/sbin/sshd                 0.00%    0.00%    0.00%    0.00% 
     2848 root     crond                          0.00%    0.00%    0.00%    0.01% 
     5422 dovecot  dovecot/anvil                  0.00%    0.00%    0.00%    0.01% 
     3083 root     /usr/local/ispmgr/sbin/ihtt    0.00%    0.00%    0.00%    0.01% 
     1347 root     auditd                         0.00%    0.00%    0.00%    0.00% 
        1 root     /sbin/init                     0.00%    0.00%    0.00%    0.01% 
     5416 root     /usr/sbin/dovecot              0.00%    0.00%    0.00%    0.01% 
     5423 root     dovecot/log                    0.00%    0.00%    0.00%    0.01% 
     4170 root     CROND                          0.00%    0.00%    0.00%    0.01% 
     4171 root     CROND                          0.00%    0.00%    0.00%    0.01% 
     3877 root     CROND                          0.00%    0.00%    0.00%    0.01% 
    17704 root     dovecot/ssl-params             0.00%    0.00%    0.00%    0.01% 
     3876 root     CROND                          0.00%    0.00%    0.00%    0.01% 
     2316 root     /usr/bin/crontab -e            0.00%    0.00%    0.00%    0.01% 
     2385 root     /usr/bin/crontab -e            0.00%    0.00%    0.00%    0.01% 
    32459 root     /bin/sh /usr/bin/mysqld_saf    0.00%    0.00%    0.00%    0.01% 
     7004 root     /usr/sbin/pure-authd -s /va    0.00%    0.00%    0.00%    0.01% 
     2392 root     /bin/vi /tmp/crontab.bAr1CY    0.00%    0.00%    0.00%    0.01% 
     2317 root     /bin/vi /tmp/crontab.wqUNGX    0.00%    0.00%    0.00%    0.01% 
     5312 root     cPhulkd - processo             0.01%    0.00%    0.00%    0.02% 
    22756 root     /usr/local/cpanel/bin/split    0.00%    0.00%    0.00%    0.01% 
    22757 root     /usr/local/cpanel/bin/split    0.00%    0.00%    0.01%    0.01% 
    24630 root     -bash                          0.00%    0.00%    0.01%    0.01% 
     7002 root     pure-ftpd (SERVER)             0.00%    0.00%    0.01%    0.01% 
     3069 dovecot  dovecot/auth                   0.00%    0.00%    0.01%    0.01% 
     3978 root     /bin/bash ./mysqlmymonlite.    0.00%    0.00%    0.01%    0.01% 
     5425 dovenull dovecot/pop3-login             0.00%    0.01%    0.01%    0.02% 
     5421 dovenull dovecot/imap-login             0.00%    0.01%    0.01%    0.02% 
     5426 dovenull dovecot/imap-login             0.00%    0.01%    0.01%    0.02% 
     5420 dovenull dovecot/pop3-login             0.00%    0.01%    0.01%    0.02% 
     5427 root     dovecot/config                 0.00%    0.01%    0.01%    0.01% 
     5349 root     cpanellogd - sleeping for l    0.00%    0.01%    0.01%    0.02% 
    24624 root     sshd: root@pts/1               0.00%    0.01%    0.01%    0.02% 
     5348 root     cpdavd - accepting connecti    0.04%    0.01%    0.01%    0.02% 
     5240 root     queueprocd - wait to proces    0.01%    0.01%    0.01%    0.02% 
     5540 mailnull /usr/sbin/exim -bd -q60m       0.00%    0.02%    0.02%    0.02% 
     1455 root     /sbin/rsyslogd -i /var/run/    0.00%    0.03%    0.03%    0.03% 
    22628 root     nginx: master process /usr/    0.00%    0.01%    0.04%    0.21% 
    22639 nobody   nginx: cache manager proces    0.00%    0.01%    0.04%    0.21% 
     1404 root     lfd - sleepin                  0.00%    0.01%    0.04%    0.08% 
     4191 root     python /usr/bin/smem -t -p     0.00%    0.04%    0.04%    0.05% 
     3976 root     lfd - checking directorie      0.00%    0.01%    0.04%    0.08% 
     4187 user138  /usr/bin/php /home/user138/    0.00%    0.04%    0.05%    0.09% 
     3891 user138  /usr/bin/php /home/user138/    0.00%    0.04%    0.05%    0.09% 
    22767 root     /usr/local/cpanel/3rdparty/    0.00%    0.05%    0.05%    0.07% 
    14301 root     /usr/local/apache/bin/httpd    0.00%    0.03%    0.05%    0.20% 
     4184 user138  /usr/bin/php /home/user138/    0.00%    0.04%    0.05%    0.10% 
    12714 root     tailwatch                      0.01%    0.05%    0.05%    0.06% 
     3893 user138  /usr/bin/php /home/user138/    0.00%    0.04%    0.05%    0.10% 
    22638 nobody   nginx: worker process          0.00%    0.06%    0.08%    0.24% 
    22633 nobody   nginx: worker process          0.00%    0.06%    0.08%    0.24% 
    22632 nobody   nginx: worker process          0.00%    0.06%    0.08%    0.24% 
    22629 nobody   nginx: worker process          0.00%    0.06%    0.08%    0.24% 
    22637 nobody   nginx: worker process          0.00%    0.06%    0.08%    0.24% 
    22634 nobody   nginx: worker process          0.00%    0.06%    0.08%    0.24% 
    22631 nobody   nginx: worker process          0.00%    0.06%    0.08%    0.24% 
    22630 nobody   nginx: worker process          0.00%    0.06%    0.08%    0.24% 
     2938 root     cpsrvd (SSL) - waiting for     0.00%    0.11%    0.11%    0.12% 
     5576 root     spamd chil                     0.00%    0.01%    0.11%    0.31% 
     5575 root     spamd chil                     0.00%    0.02%    0.11%    0.31% 
     5558 root     /usr/local/cpanel/3rdparty/    0.00%    0.02%    0.11%    0.32% 
    32066 nobody   /usr/local/apache/bin/httpd    0.00%    0.14%    0.17%    0.42% 
    17842 nobody   /usr/local/apache/bin/httpd    0.00%    0.16%    0.19%    0.44% 
    23516 nobody   /usr/local/apache/bin/httpd    0.00%    0.16%    0.19%    0.45% 
    32005 user294  /usr/local/apache/bin/httpd    0.00%    0.17%    0.20%    0.45% 
    16949 nobody   /usr/local/apache/bin/httpd    0.00%    0.18%    0.20%    0.46% 
    24014 nobody   /usr/local/apache/bin/httpd    0.00%    0.17%    0.21%    0.49% 
     2271 nobody   /usr/local/apache/bin/httpd    0.00%    0.19%    0.22%    0.47% 
    30015 nobody   /usr/local/apache/bin/httpd    0.00%    0.20%    0.22%    0.48% 
    32004 nobody   /usr/local/apache/bin/httpd    0.00%    0.20%    0.23%    0.48% 
    15969 nobody   /usr/local/apache/bin/httpd    0.00%    0.23%    0.27%    0.55% 
     1469 named    /usr/sbin/named -u named       0.03%    0.61%    0.61%    0.62% 
    25255 root     /usr/local/ispmgr/bin/billm    0.00%    1.20%    1.20%    1.21% 
     5533 root     /usr/local/cpanel/3rdparty/    0.00%    1.59%    1.59%    1.60% 
      740 mysql    /usr/sbin/mysqld --basedir=    0.00%   18.74%   18.74%   18.75% 
    -------------------------------------------------------------------------------
       93 9                                       0.13%   25.13%   26.09%   31.73% 
    
    smem -wk
    Area                           Used      Cache   Noncache 
    firmware/hardware                 0          0          0 
    kernel image                      0          0          0 
    kernel dynamic memory          1.4G       1.2G     263.7M 
    userspace memory               4.0G      69.6M       3.9G 
    free memory                    9.8G       9.8G          0 
    
    
    ----------------------------
    Server Disk Usage
    ----------------------------
    Filesystem     Type   Size  Used Avail Use% Mounted on
    /dev/md2       ext4   504G  102G  377G  22% /
    tmpfs          tmpfs  7.7G     0  7.7G   0% /dev/shm
    /dev/md1       ext3   496M   72M  399M  16% /boot
    /dev/md3       ext4   2.0T   25G  1.9T   2% /home
    /usr/tmpDSK    ext3   4.0G  1.2G  2.6G  32% /tmp
    
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 5053156 kilobytes of disk space
    
    ----------------------------
    ulimit -aH
    ----------------------------
    core file size          (blocks, -c) unlimited
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 124984
    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) unlimited
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 124984
    virtual memory          (kbytes, -v) unlimited
    file locks                      (-x) unlimited
    
    ----------------------------------------------------------
    tail -15 /etc/security/limits.conf
    ----------------------------------------------------------
    #<domain>      <type>  <item>         <value>
    #
    
    kiskaqin - nice 15
    
    #*               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
    nginx		soft 	nofile		300000
    nginx		hard	nofile		300000
    # End of file
    
    ----------------------------------------------------------
    mysqld process limits: 
    cat /proc/740/limits
    ----------------------------------------------------------
    Limit                     Soft Limit           Hard Limit           Units     
    Max cpu time              unlimited            unlimited            seconds   
    Max file size             unlimited            unlimited            bytes     
    Max data size             unlimited            unlimited            bytes     
    Max stack size            10485760             unlimited            bytes     
    Max core file size        0                    unlimited            bytes     
    Max resident set          unlimited            unlimited            bytes     
    Max processes             124984               124984               processes 
    Max open files            100000               100000               files     
    Max locked memory         65536                65536                bytes     
    Max address space         unlimited            unlimited            bytes     
    Max file locks            unlimited            unlimited            locks     
    Max pending signals       124984               124984               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.42.0.12
    
    WHM's PHP Handler config:
    /usr/local/cpanel/bin/rebuild_phpconf --current
    Available handlers: dso cgi none
    DEFAULT PHP: 5
    PHP4 SAPI: none
    PHP5 SAPI: dso
    SUEXEC: not installed
    RUID2: enabled
    
    PHP 5.4.25 (cli) (built: Feb 22 2014 15:21:20) 
    Copyright (c) 1997-2014 The PHP Group
    Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
        with eAccelerator v0.9.6.1-ea, Copyright (c) 2004-2012 eAccelerator, by eAccelerator
        with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd., and
        with Zend Guard Loader v3.3, Copyright (c) 1998-2013, by Zend Technologies
    
    System => Linux yourserverhostname 2.6.32-431.3.1.el6.x86_64 #1 SMP Fri Jan 3 21:39:27 UTC 2014 x86_64
    Build Date => Feb 22 2014 15:20:48
    
    Configure Command =>  './configure'  '--disable-posix' '--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-wddx' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-bz2' '--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-mm=/opt/mm/' '--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-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
    PHP API | 20100412
    Zend Extension Build | API220100525,NTS
    PHP Extension Build | API20100525,NTS
    DOM/XML API Version | 20031129
    Client API version | 5.6.16
    Client API library version | 5.6.16
    Client API header version | 5.6.16
    API Extensions | pdo_mysql
    Client API version | mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
    Phar API version | 1.1.1
    
    display_errors | Off | Off
    error_log | php_error_log | php_error_log
    extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20100525 | /usr/local/lib/php/extensions/no-debug-non-zts-20100525
    file_uploads | On | On
    log_errors | Off | Off
    log_errors_max_len | 192 | 192
    max_execution_time | 0 | 0
    max_file_uploads | 20 | 20
    memory_limit | 192M | 192M
    open_basedir | no value | no value
    post_max_size | 512M | 512M
    realpath_cache_size | 16K | 16K
    realpath_cache_ttl | 120 | 120
    sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
    sql.safe_mode | Off | Off
    upload_max_filesize | 512M | 512M
    upload_tmp_dir | no value | no value
    sqlite3.extension_dir | no value | no value
    
    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
    
    
    PCRE (Perl Compatible Regular Expressions) Support => enabled
    PCRE Library Version => 8.21 2011-12-12
    
    Directive => Local Value => Master Value
    pcre.backtrack_limit => 1000000 => 1000000
    pcre.recursion_limit => 100000 => 100000
    
    PDO support => enabled
    PDO drivers => sqlite, mysql
    
    PDO Driver for MySQL => enabled
    Client API version => mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
    
    PDO Driver for SQLite 3.x => enabled
    SQLite Library => 3.7.7.1
    
    Phar: PHP Archive support => enabled
    Phar EXT version => 2.0.1
    Phar API version => 1.1.1
    SVN revision => $Id: ec823514107160b7e6fabc519594012657a2db91 $
    Phar-based phar archives => enabled
    Tar-based phar archives => enabled
    ZIP-based phar archives => enabled
    gzip compression => enabled
    bzip2 compression => enabled
    OpenSSL support => enabled
    
    
    Phar based on pear/PHP_Archive, original concept by Davey Shafik.
    Phar fully realized by Gregory Beaver and Marcus Boerger.
    Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
    Directive => Local Value => Master Value
    phar.cache_list => no value => no value
    phar.readonly => On => On
    phar.require_hash => On => On
    
    
    
    
    
    
    Server version: Apache/2.2.26 (Unix)
    Server built:   Feb 22 2014 15:18:23
    Cpanel::Easy::Apache v3.24.11 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 disabled)
     -D APR_USE_SYSVSEM_SERIALIZE
     -D APR_USE_PTHREAD_SERIALIZE
     -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
     -D APR_HAS_OTHER_CHILD
     -D AP_HAVE_RELIABLE_PIPED_LOGS
     -D DYNAMIC_MODULE_LIMIT=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)
     authn_dbm_module (static)
     authn_anon_module (static)
     authn_dbd_module (static)
     authn_default_module (static)
     authn_alias_module (static)
     authz_host_module (static)
     authz_groupfile_module (static)
     authz_user_module (static)
     authz_dbm_module (static)
     authz_owner_module (static)
     authnz_ldap_module (static)
     authz_default_module (static)
     auth_basic_module (static)
     auth_digest_module (static)
     file_cache_module (static)
     cache_module (static)
     dbd_module (static)
     echo_module (static)
     ext_filter_module (static)
     include_module (static)
     filter_module (static)
     deflate_module (static)
     ldap_module (static)
     log_config_module (static)
     log_forensic_module (static)
     logio_module (static)
     env_module (static)
     mime_magic_module (static)
     expires_module (static)
     headers_module (static)
     ident_module (static)
     unique_id_module (static)
     setenvif_module (static)
     version_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)
     asis_module (static)
     info_module (static)
     suexec_module (static)
     cgi_module (static)
     vhost_alias_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)
     rpaf_module (shared)
     bwlimited_module (shared)
     bw_module (shared)
     geoip_module (shared)
     ruid2_module (shared)
     disable_suexec_module (shared)
     php5_module (shared)
     ispmgr_module (shared)
     security2_module (shared)
    
    Compiled in modules:
      core.c
      mod_authn_file.c
      mod_authn_dbm.c
      mod_authn_anon.c
      mod_authn_dbd.c
      mod_authn_default.c
      mod_authn_alias.c
      mod_authz_host.c
      mod_authz_groupfile.c
      mod_authz_user.c
      mod_authz_dbm.c
      mod_authz_owner.c
      mod_authnz_ldap.c
      mod_authz_default.c
      mod_auth_basic.c
      mod_auth_digest.c
      mod_file_cache.c
      mod_cache.c
      mod_dbd.c
      mod_echo.c
      mod_ext_filter.c
      mod_include.c
      mod_filter.c
      mod_deflate.c
      util_ldap.c
      mod_log_config.c
      mod_log_forensic.c
      mod_logio.c
      mod_env.c
      mod_mime_magic.c
      mod_expires.c
      mod_headers.c
      mod_ident.c
      mod_unique_id.c
      mod_setenvif.c
      mod_version.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_asis.c
      mod_info.c
      mod_suexec.c
      mod_cgi.c
      mod_vhost_alias.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 30
    KeepAlive Off
    MaxKeepAliveRequests 1000000
    KeepAliveTimeout 5
    
    </IfModule>
    StartServers 5
    <IfModule prefork.c>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    ServerLimit 256
    MaxClients 150
    MaxRequestsPerChild 1000000
    </IfModule>
    
    
    ---------------
    You are running Nginx
    ---------------
    
    
    user  nobody;
    # no need for more workers in the proxy mode
    worker_processes  8;
    worker_rlimit_nofile 10240;
     worker_connections 10240; # increase for busier servers
     use epoll; # you should use epoll here for Linux kernels 2.6.x
     sendfile on;
     keepalive_timeout  5;
     gzip on;
     gzip_vary on;
     gzip_disable "MSIE [1-6]\.";
     gzip_proxied any;
     gzip_http_version 1.1;
     gzip_min_length  1000;
     gzip_comp_level  6;
     gzip_buffers  16 8k;
     gzip_types    text/plain text/xml text/css application/x-javascript application/xml image/png image/x-icon image/gif image/jpeg application/javascript application/xml+rss text/javascript application/atom+xml;
     client_header_timeout  3m;
     client_body_timeout 3m;
     client_header_buffer_size 256k;
     large_client_header_buffers 4 256k;
     client_max_body_size 100M; 
     client_body_buffer_size 128k;
    proxy_buffers 8 64k;
    proxy_intercept_errors on;
    proxy_connect_timeout 1s;
    proxy_read_timeout 3s;
    proxy_send_timeout 3s;
     proxy_temp_path  /tmp/nginx_proxy/;
     proxy_cache_path /var/cache/nginx levels=1:2 keys_zone=microcache:5m max_size=1000m;
     client_body_in_file_only on;
     log_format custom_microcache '$remote_addr - $remote_user [$time_local] '
            '"$http_referer" "$http_user_agent" nocache:$no_cache';
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MySQL 5.6.16             uptime 0 0:11:54       Tue Feb 25 23:32:04 2014
    
    __ Key _________________________________________________________________
    Buffer used    23.40M of   2.00G  %Used:   1.14
      Current     396.85M            %Usage:  19.38
    Write hit      69.81%
    Read hit       98.05%
    
    __ Questions ___________________________________________________________
    Total          41.92k    58.7/s
      QC Hits      19.73k    27.6/s  %Total:  47.06
      DMS          17.87k    25.0/s           42.63
      Com_         15.11k    21.2/s           36.04
      -Unknown     12.07k    16.9/s           28.81
      COM_QUIT      1.29k     1.8/s            3.08
    Slow 10 s           1     0.0/s            0.00  %DMS:   0.01  Log:
    DMS            17.87k    25.0/s           42.63
      INSERT       11.91k    16.7/s           28.41         66.63
      SELECT        5.44k     7.6/s           12.99         30.46
      UPDATE          330     0.5/s            0.79          1.85
      DELETE          187     0.3/s            0.45          1.05
      REPLACE           2     0.0/s            0.00          0.01
    Com_           15.11k    21.2/s           36.04
      stmt_execut  11.75k    16.5/s           28.04
      set_option    1.97k     2.8/s            4.69
      show_fields     458     0.6/s            1.09
    
    __ SELECT and Sort _____________________________________________________
    Scan              910     1.3/s %SELECT:  16.72
    Range             934     1.3/s           17.16
    Full join         189     0.3/s            3.47
    Range check         2     0.0/s            0.04
    Full rng join       0       0/s            0.00
    Sort scan         615     0.9/s
    Sort range        367     0.5/s
    Sort mrg pass       0       0/s
    
    __ Query Cache _________________________________________________________
    Memory usage   19.52M of 128.00M  %Used:  15.25
    Block Fragmnt   0.18%
    Hits           19.73k    27.6/s
    Inserts         5.17k     7.2/s
    Insrt:Prune   5.17k:1     7.2/s
    Hit:Insert     3.82:1
    
    __ Table Locks _________________________________________________________
    Waited              0       0/s  %Total:   0.00
    Immediate      31.83k    44.6/s
    
    __ Tables ______________________________________________________________
    Open             8137 of 3000    %Cache:  27.12
    Opened          8.15k    11.4/s
    
    __ Connections _________________________________________________________
    Max used           10 of  100      %Max:  10.00
    Total           1.30k     1.8/s
    
    __ Created Temp ________________________________________________________
    Disk table        605     0.8/s
    Table          13.04k    18.3/s    Size:  64.0M
    File                6     0.0/s
    
    __ Threads _____________________________________________________________
    Running             1 of    3
    Cached              7 of   32      %Hit:  99.23
    Created            10     0.0/s
    Slow                0       0/s
    
    __ Aborted _____________________________________________________________
    Clients            24     0.0/s
    Connects            0       0/s
    
    __ Bytes _______________________________________________________________
    Sent           65.70M   92.0k/s
    Received        5.65M    7.9k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage         101.30M of   5.00G  %Used:   1.98
    Read hit       96.62%
    Pages
      Free        321.19k            %Total:  98.02
      Data          6.46k                      1.97 %Drty:   0.00
      Misc             26                      0.01
      Latched                                  0.00
    Reads         189.57k   265.5/s
      From file     6.41k     9.0/s            3.38
      Ahead Rnd         0       0/s
      Ahead Sql                 0/s
    Writes          4.51k     6.3/s
    Flushes         1.57k     2.2/s
    Wait Free           0       0/s
    
    __ InnoDB Lock _________________________________________________________
    Waits               0       0/s
    Current             0
    Time acquiring
      Total             0 ms
      Average           0 ms
      Max               0 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads         8.62k    12.1/s
      Writes        2.34k     3.3/s
      fsync         1.35k     1.9/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created          47     0.1/s
      Read          6.41k     9.0/s
      Written       1.57k     2.2/s
    
    Rows
      Deleted          17     0.0/s
      Inserted         26     0.0/s
      Read         33.75k    47.3/s
      Updated         145     0.2/s
    
    ----------------------------
    Total Server MyISAM and InnoDB Size
    ----------------------------
    *************************** 1. row ***************************
    innodb_tablespace_utilization_perc: 100
                         total_size_gb: 3.116069179959595
                         index_size_gb: 1.0456981658935547
                          data_size_gb: 2.0703710140660405
                  innodb_total_size_gb: 0.7135772705078125
                   innodb_data_size_gb: 0.37530517578125
                  innodb_index_size_gb: 0.3382720947265625
                  myisam_total_size_gb: 2.4024919094517827
                   myisam_data_size_gb: 1.6950658382847905
                  myisam_index_size_gb: 0.7074260711669922
                            perc_index: 33.558246100
                             perc_data: 66.441753800
                     innodb_perc_index: 47.405110600
                      innodb_perc_data: 52.594889300
                     myisam_perc_index: 29.445513100
                      myisam_perc_data: 70.554486800
               innodb_perc_total_index: 32.348923000
                innodb_perc_total_data: 18.127435700
               myisam_perc_total_index: 67.651076900
                myisam_perc_total_data: 81.872564200
    
    ----------------------------
    MySQL settings
    ----------------------------
    [mysqld]
    open_files_limit=100000
    innodb_data_home_dir=/var/lib/mysql
    innodb_log_group_home_dir=/var/lib/mysql
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    port=3306
    user=mysql
    
    max_allowed_packet = 64M
    
    innodb_lock_wait_timeout=30
    innodb_log_file_size=256M
    innodb_log_buffer_size=8M
    key_buffer_size=2G
    innodb_log_files_in_group=3
    skip-innodb_checksums
    skip-innodb_doublewrite
    
    innodb_additional_mem_pool_size=20M
    innodb_buffer_pool_size=5G
    innodb_buffer_pool_instances = 5
    innodb_thread_concurrency = 16
    innodb_max_dirty_pages_pct = 90
    
    read_buffer_size=2M
    innodb_file_io_threads = 4
    innodb_write_io_threads = 4
    innodb_read_io_threads = 4
    
    default-storage-engine=MyISAM
    innodb_file_per_table=1
    query_cache_size=128M
    query_cache_limit=2M
    query_cache_type=1
    query_cache_min_res_unit=512K
    table_open_cache=30000
    table_definition_cache=30000
    join_buffer_size=8M
    myisam_sort_buffer_size=1200M
    max_heap_table_size=128M
    sort_buffer_size=12M
    innodb_flush_method=O_DIRECT
    innodb_log_buffer_size=16M
    tmp_table_size=64M
    read_rnd_buffer_size=32M
    innodb_flush_log_at_trx_commit=1
    max_connections=100
    max_connect_errors = 10000
    
    wait_timeout=30
    net_read_timeout=30
    net_write_timeout=30
    
    thread_cache_size=32
    thread_concurrency=10
    thread_stack = 256K
    
    tmpdir = /dev/shm
    transaction_isolation = REPEATABLE-READ
    ---
    +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Variable_name | Value |
    +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | auto_increment_increment | 1 |
    | auto_increment_offset | 1 |
    | autocommit | ON |
    | automatic_sp_privileges | ON |
    | back_log | 70 |
    | basedir | /usr |
    | big_tables | OFF |
    | bind_address | * |
    | binlog_cache_size | 32768 |
    | binlog_checksum | CRC32 |
    | binlog_direct_non_transactional_updates | OFF |
    | binlog_format | STATEMENT |
    | binlog_max_flush_queue_time | 0 |
    | binlog_order_commits | ON |
    | binlog_row_image | FULL |
    | binlog_rows_query_log_events | OFF |
    | 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 |
    | core_file | OFF |
    | datadir | /var/lib/mysql/ |
    | date_format | %Y-%m-%d |
    | datetime_format | %Y-%m-%d %H:%i:%s |
    | default_storage_engine | MyISAM |
    | default_tmp_storage_engine | InnoDB |
    | default_week_format | 0 |
    | delay_key_write | ON |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout | 300 |
    | delayed_queue_size | 1000 |
    | disconnect_on_expired_password | ON |
    | div_precision_increment | 4 |
    | end_markers_in_json | OFF |
    | enforce_gtid_consistency | OFF |
    | eq_range_index_dive_limit | 10 |
    | event_scheduler | OFF |
    | expire_logs_days | 0 |
    | explicit_defaults_for_timestamp | OFF |
    | 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/sv-1.log |
    | group_concat_max_len | 1024 |
    | gtid_executed | |
    | gtid_mode | OFF |
    | gtid_owned | |
    | gtid_purged | |
    | have_compress | YES |
    | have_crypt | YES |
    | have_dynamic_loading | YES |
    | have_geometry | YES |
    | have_openssl | DISABLED |
    | have_profiling | YES |
    | have_query_cache | YES |
    | have_rtree_keys | YES |
    | have_ssl | DISABLED |
    | have_symlink | YES |
    | host_cache_size | 228 |
    | hostname | yourserverhostname |
    | ignore_builtin_innodb | OFF |
    | ignore_db_dirs | |
    | init_connect | |
    | init_file | |
    | init_slave | |
    | innodb_adaptive_flushing | ON |
    | innodb_adaptive_flushing_lwm | 10 |
    | innodb_adaptive_hash_index | ON |
    | innodb_adaptive_max_sleep_delay | 150000 |
    | innodb_additional_mem_pool_size | 20971520 |
    | innodb_api_bk_commit_interval | 5 |
    | innodb_api_disable_rowlock | OFF |
    | innodb_api_enable_binlog | OFF |
    | innodb_api_enable_mdl | OFF |
    | innodb_api_trx_level | 0 |
    | innodb_autoextend_increment | 64 |
    | innodb_autoinc_lock_mode | 1 |
    | innodb_buffer_pool_dump_at_shutdown | OFF |
    | innodb_buffer_pool_dump_now | OFF |
    | innodb_buffer_pool_filename | ib_buffer_pool |
    | innodb_buffer_pool_instances | 5 |
    | innodb_buffer_pool_load_abort | OFF |
    | innodb_buffer_pool_load_at_startup | OFF |
    | innodb_buffer_pool_load_now | OFF |
    | innodb_buffer_pool_size | 5368709120 |
    | innodb_change_buffer_max_size | 25 |
    | innodb_change_buffering | all |
    | innodb_checksum_algorithm | none |
    | innodb_checksums | OFF |
    | innodb_cmp_per_index_enabled | OFF |
    | innodb_commit_concurrency | 0 |
    | innodb_compression_failure_threshold_pct | 5 |
    | innodb_compression_level | 6 |
    | innodb_compression_pad_pct_max | 50 |
    | innodb_concurrency_tickets | 5000 |
    | innodb_data_file_path | ibdata1:12M:autoextend |
    | innodb_data_home_dir | /var/lib/mysql |
    | innodb_disable_sort_file_cache | OFF |
    | innodb_doublewrite | OFF |
    | 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_timeout | 1 |
    | innodb_flush_log_at_trx_commit | 1 |
    | innodb_flush_method | O_DIRECT |
    | innodb_flush_neighbors | 1 |
    | innodb_flushing_avg_loops | 30 |
    | innodb_force_load_corrupted | OFF |
    | innodb_force_recovery | 0 |
    | innodb_ft_aux_table | |
    | innodb_ft_cache_size | 8000000 |
    | innodb_ft_enable_diag_print | OFF |
    | innodb_ft_enable_stopword | ON |
    | innodb_ft_max_token_size | 84 |
    | innodb_ft_min_token_size | 3 |
    | innodb_ft_num_word_optimize | 2000 |
    | innodb_ft_result_cache_limit | 2000000000 |
    | innodb_ft_server_stopword_table | |
    | innodb_ft_sort_pll_degree | 2 |
    | innodb_ft_total_cache_size | 640000000 |
    | innodb_ft_user_stopword_table | |
    | innodb_io_capacity | 200 |
    | innodb_io_capacity_max | 2000 |
    | innodb_large_prefix | OFF |
    | innodb_lock_wait_timeout | 30 |
    | innodb_locks_unsafe_for_binlog | OFF |
    | innodb_log_buffer_size | 16777216 |
    | innodb_log_compressed_pages | ON |
    | innodb_log_file_size | 268435456 |
    | innodb_log_files_in_group | 3 |
    | innodb_log_group_home_dir | /var/lib/mysql |
    | innodb_lru_scan_depth | 1024 |
    | innodb_max_dirty_pages_pct | 90 |
    | innodb_max_dirty_pages_pct_lwm | 0 |
    | innodb_max_purge_lag | 0 |
    | innodb_max_purge_lag_delay | 0 |
    | innodb_mirrored_log_groups | 1 |
    | innodb_monitor_disable | |
    | innodb_monitor_enable | |
    | innodb_monitor_reset | |
    | innodb_monitor_reset_all | |
    | innodb_old_blocks_pct | 37 |
    | innodb_old_blocks_time | 1000 |
    | innodb_online_alter_log_max_size | 134217728 |
    | innodb_open_files | 30000 |
    | innodb_optimize_fulltext_only | OFF |
    | innodb_page_size | 16384 |
    | innodb_print_all_deadlocks | OFF |
    | innodb_purge_batch_size | 300 |
    | innodb_purge_threads | 1 |
    | innodb_random_read_ahead | OFF |
    | innodb_read_ahead_threshold | 56 |
    | innodb_read_io_threads | 4 |
    | innodb_read_only | OFF |
    | innodb_replication_delay | 0 |
    | innodb_rollback_on_timeout | OFF |
    | innodb_rollback_segments | 128 |
    | innodb_sort_buffer_size | 1048576 |
    | innodb_spin_wait_delay | 6 |
    | innodb_stats_auto_recalc | ON |
    | innodb_stats_method | nulls_equal |
    | innodb_stats_on_metadata | OFF |
    | innodb_stats_persistent | ON |
    | innodb_stats_persistent_sample_pages | 20 |
    | innodb_stats_sample_pages | 8 |
    | innodb_stats_transient_sample_pages | 8 |
    | innodb_status_output | OFF |
    | innodb_status_output_locks | OFF |
    | innodb_strict_mode | OFF |
    | innodb_support_xa | ON |
    | innodb_sync_array_size | 1 |
    | innodb_sync_spin_loops | 30 |
    | innodb_table_locks | ON |
    | innodb_thread_concurrency | 16 |
    | innodb_thread_sleep_delay | 0 |
    | innodb_undo_directory | . |
    | innodb_undo_logs | 128 |
    | innodb_undo_tablespaces | 0 |
    | innodb_use_native_aio | ON |
    | innodb_use_sys_malloc | ON |
    | innodb_version | 5.6.16 |
    | innodb_write_io_threads | 4 |
    | interactive_timeout | 28800 |
    | join_buffer_size | 8388608 |
    | keep_files_on_create | OFF |
    | key_buffer_size | 2147483648 |
    | 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_bin | OFF |
    | log_bin_basename | |
    | log_bin_index | |
    | log_bin_trust_function_creators | OFF |
    | log_bin_use_v1_row_events | OFF |
    | log_error | /var/lib/mysql/yourserverhostname.err |
    | log_output | FILE |
    | log_queries_not_using_indexes | OFF |
    | log_slave_updates | OFF |
    | log_slow_admin_statements | OFF |
    | log_slow_slave_statements | OFF |
    | log_throttle_queries_not_using_indexes | 0 |
    | log_warnings | 1 |
    | long_query_time | 10.000000 |
    | low_priority_updates | OFF |
    | lower_case_file_system | OFF |
    | lower_case_table_names | 0 |
    | master_info_repository | FILE |
    | master_verify_checksum | OFF |
    | max_allowed_packet | 67108864 |
    | max_binlog_cache_size | 18446744073709547520 |
    | max_binlog_size | 1073741824 |
    | max_binlog_stmt_cache_size | 18446744073709547520 |
    | max_connect_errors | 10000 |
    | max_connections | 100 |
    | max_delayed_threads | 20 |
    | max_error_count | 64 |
    | max_heap_table_size | 134217728 |
    | max_insert_delayed_threads | 20 |
    | max_join_size | 18446744073709551615 |
    | max_length_for_sort_data | 1024 |
    | 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 |
    | metadata_locks_hash_instances | 8 |
    | 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 | 1258291200 |
    | myisam_stats_method | nulls_unequal |
    | myisam_use_mmap | OFF |
    | net_buffer_length | 16384 |
    | net_read_timeout | 30 |
    | net_retry_count | 10 |
    | net_write_timeout | 30 |
    | new | OFF |
    | old | OFF |
    | old_alter_table | OFF |
    | old_passwords | 0 |
    | open_files_limit | 100000 |
    | 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,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on |
    | optimizer_trace | enabled=off,one_line=off |
    | optimizer_trace_features | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on |
    | optimizer_trace_limit | 1 |
    | optimizer_trace_max_mem_size | 16384 |
    | optimizer_trace_offset | -1 |
    | performance_schema | ON |
    | performance_schema_accounts_size | 100 |
    | performance_schema_digests_size | 10000 |
    | performance_schema_events_stages_history_long_size | 10000 |
    | performance_schema_events_stages_history_size | 10 |
    | performance_schema_events_statements_history_long_size | 10000 |
    | performance_schema_events_statements_history_size | 10 |
    | performance_schema_events_waits_history_long_size | 10000 |
    | performance_schema_events_waits_history_size | 10 |
    | performance_schema_hosts_size | 100 |
    | performance_schema_max_cond_classes | 80 |
    | performance_schema_max_cond_instances | 60500 |
    | performance_schema_max_file_classes | 50 |
    | performance_schema_max_file_handles | 32768 |
    | performance_schema_max_file_instances | 153847 |
    | performance_schema_max_mutex_classes | 200 |
    | performance_schema_max_mutex_instances | 301600 |
    | performance_schema_max_rwlock_classes | 40 |
    | performance_schema_max_rwlock_instances | 180600 |
    | performance_schema_max_socket_classes | 10 |
    | performance_schema_max_socket_instances | 220 |
    | performance_schema_max_stage_classes | 150 |
    | performance_schema_max_statement_classes | 168 |
    | performance_schema_max_table_handles | 60000 |
    | performance_schema_max_table_instances | 37500 |
    | performance_schema_max_thread_classes | 50 |
    | performance_schema_max_thread_instances | 300 |
    | performance_schema_session_connect_attrs_size | 512 |
    | performance_schema_setup_actors_size | 100 |
    | performance_schema_setup_objects_size | 100 |
    | performance_schema_users_size | 100 |
    | 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 | 2097152 |
    | query_cache_min_res_unit | 524288 |
    | query_cache_size | 134217728 |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    | query_prealloc_size | 8192 |
    | range_alloc_block_size | 4096 |
    | read_buffer_size | 2097152 |
    | read_only | OFF |
    | read_rnd_buffer_size | 33554432 |
    | relay_log | |
    | relay_log_basename | |
    | relay_log_index | |
    | relay_log_info_file | relay-log.info |
    | relay_log_info_repository | FILE |
    | relay_log_purge | ON |
    | relay_log_recovery | OFF |
    | relay_log_space_limit | 0 |
    | report_host | |
    | report_password | |
    | report_port | 3306 |
    | report_user | |
    | rpl_stop_slave_timeout | 31536000 |
    | secure_auth | ON |
    | secure_file_priv | |
    | server_id | 0 |
    | server_id_bits | 32 |
    | server_uuid | 08bb913f-7de8-11e3-b7df-50465da329f2 |
    | skip_external_locking | ON |
    | skip_name_resolve | OFF |
    | skip_networking | OFF |
    | skip_show_database | OFF |
    | slave_allow_batching | OFF |
    | slave_checkpoint_group | 512 |
    | slave_checkpoint_period | 300 |
    | slave_compressed_protocol | OFF |
    | slave_exec_mode | STRICT |
    | slave_load_tmpdir | /dev/shm |
    | slave_max_allowed_packet | 1073741824 |
    | slave_net_timeout | 3600 |
    | slave_parallel_workers | 0 |
    | slave_pending_jobs_size_max | 16777216 |
    | slave_rows_search_algorithms | TABLE_SCAN,INDEX_SCAN |
    | slave_skip_errors | OFF |
    | slave_sql_verify_checksum | ON |
    | slave_transaction_retries | 10 |
    | slave_type_conversions | |
    | slow_launch_time | 2 |
    | slow_query_log | OFF |
    | slow_query_log_file | /var/lib/mysql/sv-1-slow.log |
    | socket | /var/lib/mysql/mysql.sock |
    | sort_buffer_size | 12582912 |
    | sql_auto_is_null | OFF |
    | sql_big_selects | ON |
    | sql_buffer_result | OFF |
    | sql_log_bin | ON |
    | sql_log_off | OFF |
    | sql_mode | NO_ENGINE_SUBSTITUTION |
    | 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_crl | |
    | ssl_crlpath | |
    | ssl_key | |
    | storage_engine | MyISAM |
    | stored_program_cache | 256 |
    | sync_binlog | 0 |
    | sync_frm | ON |
    | sync_master_info | 10000 |
    | sync_relay_log | 10000 |
    | sync_relay_log_info | 10000 |
    | system_time_zone | CET |
    | table_definition_cache | 30000 |
    | table_open_cache | 30000 |
    | table_open_cache_instances | 1 |
    | thread_cache_size | 32 |
    | thread_concurrency | 10 |
    | thread_handling | one-thread-per-connection |
    | thread_stack | 262144 |
    | time_format | %H:%i:%s |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | tmp_table_size | 67108864 |
    | tmpdir | /dev/shm |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_isolation | REPEATABLE-READ |
    | tx_read_only | OFF |
    | unique_checks | ON |
    | updatable_views_with_limit | YES |
    | version | 5.6.16 |
    | version_comment | MySQL Community Server (GPL) |
    | version_compile_machine | x86_64 |
    | version_compile_os | Linux |
    | wait_timeout | 30 |
    +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    +-----------------------------------------------+-------------+
    | Variable_name | Value |
    +-----------------------------------------------+-------------+
    | Aborted_clients | 24 |
    | Aborted_connects | 0 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Binlog_stmt_cache_disk_use | 0 |
    | Binlog_stmt_cache_use | 0 |
    | Bytes_received | 5655607 |
    | Bytes_sent | 65736062 |
    | Com_admin_commands | 152 |
    | Com_assign_to_keycache | 0 |
    | Com_alter_db | 0 |
    | Com_alter_db_upgrade | 0 |
    | Com_alter_event | 0 |
    | Com_alter_function | 0 |
    | Com_alter_procedure | 0 |
    | Com_alter_server | 0 |
    | Com_alter_table | 0 |
    | Com_alter_tablespace | 0 |
    | Com_alter_user | 0 |
    | Com_analyze | 0 |
    | Com_begin | 0 |
    | Com_binlog | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 442 |
    | Com_change_master | 0 |
    | Com_check | 0 |
    | Com_checksum | 0 |
    | Com_commit | 0 |
    | Com_create_db | 0 |
    | Com_create_event | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_procedure | 0 |
    | Com_create_server | 0 |
    | Com_create_table | 3 |
    | Com_create_trigger | 0 |
    | Com_create_udf | 0 |
    | Com_create_user | 0 |
    | Com_create_view | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 187 |
    | Com_delete_multi | 0 |
    | Com_do | 0 |
    | Com_drop_db | 0 |
    | Com_drop_event | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_procedure | 0 |
    | Com_drop_server | 0 |
    | Com_drop_table | 0 |
    | Com_drop_trigger | 0 |
    | Com_drop_user | 0 |
    | Com_drop_view | 0 |
    | Com_empty_query | 0 |
    | Com_execute_sql | 0 |
    | Com_flush | 0 |
    | Com_get_diagnostics | 0 |
    | Com_grant | 0 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 195 |
    | Com_insert_select | 11712 |
    | Com_install_plugin | 0 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_lock_tables | 0 |
    | Com_optimize | 0 |
    | Com_preload_keys | 0 |
    | Com_prepare_sql | 0 |
    | Com_purge | 0 |
    | Com_purge_before_date | 0 |
    | Com_release_savepoint | 0 |
    | Com_rename_table | 0 |
    | Com_rename_user | 0 |
    | Com_repair | 0 |
    | Com_replace | 2 |
    | 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 | 5446 |
    | Com_set_option | 1968 |
    | Com_signal | 0 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 0 |
    | Com_show_charsets | 1 |
    | Com_show_collations | 0 |
    | Com_show_create_db | 0 |
    | Com_show_create_event | 0 |
    | Com_show_create_func | 0 |
    | Com_show_create_proc | 0 |
    | Com_show_create_table | 0 |
    | Com_show_create_trigger | 0 |
    | Com_show_databases | 22 |
    | 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 | 458 |
    | Com_show_function_code | 0 |
    | Com_show_function_status | 0 |
    | Com_show_grants | 0 |
    | Com_show_keys | 1 |
    | Com_show_master_status | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_plugins | 0 |
    | Com_show_privileges | 0 |
    | Com_show_procedure_code | 0 |
    | Com_show_procedure_status | 0 |
    | Com_show_processlist | 17 |
    | 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 | 48 |
    | Com_show_storage_engines | 2 |
    | Com_show_table_status | 0 |
    | Com_show_tables | 7 |
    | Com_show_triggers | 0 |
    | Com_show_variables | 92 |
    | Com_show_warnings | 0 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_stmt_close | 50 |
    | Com_stmt_execute | 11753 |
    | Com_stmt_fetch | 0 |
    | Com_stmt_prepare | 51 |
    | Com_stmt_reprepare | 0 |
    | Com_stmt_reset | 41 |
    | Com_stmt_send_long_data | 0 |
    | Com_truncate | 0 |
    | Com_uninstall_plugin | 0 |
    | Com_unlock_tables | 0 |
    | Com_update | 329 |
    | Com_update_multi | 1 |
    | 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 |
    | Connection_errors_accept | 0 |
    | Connection_errors_internal | 0 |
    | Connection_errors_max_connections | 0 |
    | Connection_errors_peer_address | 0 |
    | Connection_errors_select | 0 |
    | Connection_errors_tcpwrap | 0 |
    | Connections | 1306 |
    | Created_tmp_disk_tables | 616 |
    | Created_tmp_files | 6 |
    | Created_tmp_tables | 13112 |
    | Delayed_errors | 0 |
    | Delayed_insert_threads | 2 |
    | Delayed_writes | 35 |
    | Flush_commands | 1 |
    | Handler_commit | 878 |
    | Handler_delete | 141 |
    | Handler_discover | 0 |
    | Handler_external_lock | 63714 |
    | Handler_mrr_init | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 1168 |
    | Handler_read_key | 421323 |
    | Handler_read_last | 16 |
    | Handler_read_next | 1382050 |
    | Handler_read_prev | 11136 |
    | Handler_read_rnd | 539775 |
    | Handler_read_rnd_next | 1660090 |
    | Handler_rollback | 0 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_update | 18177 |
    | Handler_write | 1124391 |
    | Innodb_buffer_pool_dump_status | not started |
    | Innodb_buffer_pool_load_status | not started |
    | Innodb_buffer_pool_pages_data | 6457 |
    | Innodb_buffer_pool_bytes_data | 105791488 |
    | Innodb_buffer_pool_pages_dirty | 0 |
    | Innodb_buffer_pool_bytes_dirty | 0 |
    | Innodb_buffer_pool_pages_flushed | 1575 |
    | Innodb_buffer_pool_pages_free | 321194 |
    | Innodb_buffer_pool_pages_misc | 26 |
    | Innodb_buffer_pool_pages_total | 327677 |
    | Innodb_buffer_pool_read_ahead_rnd | 0 |
    | Innodb_buffer_pool_read_ahead | 3 |
    | Innodb_buffer_pool_read_ahead_evicted | 0 |
    | Innodb_buffer_pool_read_requests | 191770 |
    | Innodb_buffer_pool_reads | 6408 |
    | Innodb_buffer_pool_wait_free | 0 |
    | Innodb_buffer_pool_write_requests | 4514 |
    | Innodb_data_fsyncs | 1354 |
    | Innodb_data_pending_fsyncs | 0 |
    | Innodb_data_pending_reads | 0 |
    | Innodb_data_pending_writes | 0 |
    | Innodb_data_read | 107220992 |
    | Innodb_data_reads | 8621 |
    | Innodb_data_writes | 2343 |
    | Innodb_data_written | 26831872 |
    | Innodb_dblwr_pages_written | 0 |
    | Innodb_dblwr_writes | 0 |
    | Innodb_have_atomic_builtins | ON |
    | Innodb_log_waits | 0 |
    | Innodb_log_write_requests | 1711 |
    | Innodb_log_writes | 650 |
    | Innodb_os_log_fsyncs | 759 |
    | Innodb_os_log_pending_fsyncs | 0 |
    | Innodb_os_log_pending_writes | 0 |
    | Innodb_os_log_written | 971264 |
    | Innodb_page_size | 16384 |
    | Innodb_pages_created | 47 |
    | Innodb_pages_read | 6410 |
    | Innodb_pages_written | 1575 |
    | 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 | 17 |
    | Innodb_rows_inserted | 26 |
    | Innodb_rows_read | 33746 |
    | Innodb_rows_updated | 145 |
    | Innodb_num_open_files | 2207 |
    | Innodb_truncated_status_writes | 0 |
    | Innodb_available_undo_logs | 128 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 1690776 |
    | Key_blocks_used | 23960 |
    | Key_read_requests | 1230170 |
    | Key_reads | 23944 |
    | Key_write_requests | 7095 |
    | Key_writes | 2142 |
    | Last_query_cost | 0.000000 |
    | Last_query_partial_plans | 0 |
    | Max_used_connections | 10 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 11557 |
    | Open_streams | 0 |
    | Open_table_definitions | 8113 |
    | Open_tables | 8137 |
    | Opened_files | 22323 |
    | Opened_table_definitions | 8116 |
    | Opened_tables | 8147 |
    | Performance_schema_accounts_lost | 0 |
    | Performance_schema_cond_classes_lost | 0 |
    | Performance_schema_cond_instances_lost | 0 |
    | Performance_schema_digest_lost | 0 |
    | Performance_schema_file_classes_lost | 0 |
    | Performance_schema_file_handles_lost | 0 |
    | Performance_schema_file_instances_lost | 0 |
    | Performance_schema_hosts_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_session_connect_attrs_lost | 0 |
    | Performance_schema_socket_classes_lost | 0 |
    | Performance_schema_socket_instances_lost | 0 |
    | Performance_schema_stage_classes_lost | 0 |
    | Performance_schema_statement_classes_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 |
    | Performance_schema_users_lost | 0 |
    | Prepared_stmt_count | 1 |
    | Qcache_free_blocks | 16 |
    | Qcache_free_memory | 113747552 |
    | Qcache_hits | 19727 |
    | Qcache_inserts | 5167 |
    | Qcache_lowmem_prunes | 0 |
    | Qcache_not_cached | 268 |
    | Qcache_queries_in_cache | 4149 |
    | Qcache_total_blocks | 8747 |
    | Queries | 42229 |
    | Questions | 41924 |
    | Select_full_join | 189 |
    | Select_full_range_join | 0 |
    | Select_range | 934 |
    | Select_range_check | 2 |
    | Select_scan | 914 |
    | Slave_heartbeat_period | |
    | Slave_last_heartbeat | |
    | Slave_open_temp_tables | 0 |
    | Slave_received_heartbeats | |
    | Slave_retried_transactions | |
    | Slave_running | OFF |
    | Slow_launch_threads | 0 |
    | Slow_queries | 1 |
    | Sort_merge_passes | 0 |
    | Sort_range | 367 |
    | Sort_rows | 544473 |
    | Sort_scan | 615 |
    | 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_server_not_after | |
    | Ssl_server_not_before | |
    | 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 | 31830 |
    | Table_locks_waited | 0 |
    | Table_open_cache_hits | 121400 |
    | Table_open_cache_misses | 8144 |
    | Table_open_cache_overflows | 0 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 0 |
    | Tc_log_page_waits | 0 |
    | Threads_cached | 7 |
    | Threads_connected | 3 |
    | Threads_created | 10 |
    | Threads_running | 1 |
    | Uptime | 714 |
    | Uptime_since_flush_status | 714 |
    +-----------------------------------------------+-------------+
    +------+-----------+-----------+---------------+----------------+------+--------------------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +------+-----------+-----------+---------------+----------------+------+--------------------+------------------+
    | 393 | DELAYED | localhost | eximstats | Delayed insert | 16 | Waiting for INSERT | |
    | 908 | DELAYED | localhost | eximstats | Delayed insert | 28 | Waiting for INSERT | |
    | 1250 | eximstats | localhost | eximstats | Sleep | 16 | | |
    | 1299 | user138 | localhost | user138_trend | Sleep | 1 | | |
    | 1305 | root | localhost | | Query | 0 | init | show processlist |
    +------+-----------+-----------+---------------+----------------+------+--------------------+------------------+
    
    ----------------------------
    MySQL Error Log
    ----------------------------
    
    2014-02-25 23:20:10 740 [Note] InnoDB: Using Linux native AIO
    2014-02-25 23:20:10 740 [Note] InnoDB: Using CPU crc32 instructions
    2014-02-25 23:20:10 740 [Note] InnoDB: Initializing buffer pool, size = 5.0G
    2014-02-25 23:20:11 740 [Note] InnoDB: Completed initialization of buffer pool
    2014-02-25 23:20:11 740 [Note] InnoDB: Highest supported file format is Barracuda.
    2014-02-25 23:20:12 740 [Note] InnoDB: 128 rollback segment(s) are active.
    2014-02-25 23:20:12 740 [Note] InnoDB: Waiting for purge to start
    2014-02-25 23:20:12 740 [Note] InnoDB: 5.6.16 started; log sequence number 6744475055
    2014-02-25 23:20:12 740 [Note] Server hostname (bind-address): '*'; port: 3306
    2014-02-25 23:20:12 740 [Note] IPv6 is available.
    2014-02-25 23:20:12 740 [Note]   - '::' resolves to '::';
    2014-02-25 23:20:12 740 [Note] Server socket created on IP: '::'.
    2014-02-25 23:20:12 740 [Note] Event Scheduler: Loaded 0 events
    2014-02-25 23:20:12 740 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.6.16'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    
    Report Complete:
    Tue Feb 25 23:32:04 CET 2014
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    nyanhost Active Member

    Joined:
    Nov 4, 2013
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Okay.
    Uptime now: 1 day 4 hours 31 min 59 sec
    [root@sv-1 centos_whm]# ./mysqlmymonlite.sh run > main.txt

    main.txt:
    Code:
    
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 WHM mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Thu Feb 27 11:39:07 CET 2014
    
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started 2014-02-26 07:07:08.000000
    Uptime: 1 day 4 hours 31 min 59 sec
    Uptime 102719
    Uptime_since_flush_status 102719
    
    Max Used Connections:      26/100 (26.00%)
    Key Buffer Used:           202.07M/2.00G (9.87%)
    Current Key Buffer Usage:  572.32M (27.95%)
    Query Cache:               28.84M/128.00M (22.53%)
    Table Locks Waited:        3.47k Rate: 0.0/s (0.05%)
    --------------------
    Query Cache Limit (bytes): 2097152
    Query Cache Min Unit (bytes): 524288
    Query Cache Size (bytes): 134217728
    Query Cache Free Mem (bytes): 103976200
    Query Cache Used Mem (bytes): 30241528
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 30241528
    
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 1, cores = 4, virtual = 8, hyperthreading = yes
          8  1600.000
          8  Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz
          8  8192 KB
    
    
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 2.6.32-431.3.1.el6.x86_64 ((yourserverhostname)) 	02/27/2014 	_x86_64_	(8 CPU)
    
    11:39:07 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    11:39:09 AM  all    1.63    0.00    0.44    8.39    0.00    0.06    0.00    0.00   89.49
    11:39:09 AM    0    6.06    0.00    1.52   40.91    0.00    0.00    0.00    0.00   51.52
    11:39:09 AM    1    2.49    0.00    0.50    0.00    0.00    0.00    0.00    0.00   97.01
    11:39:09 AM    2    1.00    0.00    0.50    0.00    0.00    0.00    0.00    0.00   98.50
    11:39:09 AM    3    0.50    0.00    0.00    2.49    0.00    0.00    0.00    0.00   97.01
    11:39:09 AM    4    3.02    0.00    2.01   24.12    0.00    0.00    0.00    0.00   70.85
    11:39:09 AM    5    0.50    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.50
    11:39:09 AM    6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    11:39:09 AM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    11:39:09 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    11:39:11 AM  all    2.25    0.00    0.56    2.25    0.00    0.00    0.00    0.00   94.93
    11:39:11 AM    0    6.60    0.00    1.02   16.24    0.00    0.00    0.00    0.00   76.14
    11:39:11 AM    1    0.50    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.50
    11:39:11 AM    2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    11:39:11 AM    3    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    11:39:11 AM    4   10.55    0.00    2.51    2.01    0.00    0.00    0.00    0.00   84.92
    11:39:11 AM    5    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    11:39:11 AM    6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    11:39:11 AM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    Average:     all    1.94    0.00    0.50    5.32    0.00    0.03    0.00    0.00   92.21
    Average:       0    6.33    0.00    1.27   28.61    0.00    0.00    0.00    0.00   63.80
    Average:       1    1.50    0.00    0.25    0.00    0.00    0.00    0.00    0.00   98.25
    Average:       2    0.50    0.00    0.25    0.00    0.00    0.00    0.00    0.00   99.25
    Average:       3    0.25    0.00    0.00    1.25    0.00    0.00    0.00    0.00   98.50
    Average:       4    6.78    0.00    2.26   13.07    0.00    0.00    0.00    0.00   77.89
    Average:       5    0.25    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.75
    Average:       6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    Average:       7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    top - 11:39:12 up 1 day,  4:32,  1 user,  load average: 1.29, 1.10, 1.22
    Tasks: 686 total,   1 running, 683 sleeping,   2 stopped,   0 zombie
    Cpu(s):  2.0%us,  0.7%sy,  0.5%ni, 92.4%id,  4.5%wa,  0.0%hi,  0.0%si,  0.0%st
    Mem:  16016076k total,  9709588k used,  6306488k free,   322976k buffers
    Swap: 33554296k total,   269156k used, 33285140k free,  3183396k cached
    
      PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                    
    15440 user293   20   0  449m  56m  12m S 13.5  0.4   0:09.37 httpd                                                                                      
     2721 mysql     20   0 12.1g 3.7g 9132 S  1.9 24.1  48:01.58 mysqld                                                                                     
    16550 user138   20   0  411m  15m 9648 S  1.9  0.1   0:00.08 php                                                                                        
    16752 root      20   0 15420 1660  880 R  1.9  0.0   0:00.01 top                                                                                        
        1 root      20   0 19232 1036  856 S  0.0  0.0   0:01.69 init                                                                                       
        2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthreadd                                                                                   
        3 root      RT   0     0    0    0 S  0.0  0.0   0:00.73 migration/0                                                                                
        4 root      20   0     0    0    0 S  0.0  0.0   0:01.02 ksoftirqd/0                                                                                
        5 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/0                                                                                
        6 root      RT   0     0    0    0 S  0.0  0.0   0:00.08 watchdog/0                                                                                 
        7 root      RT   0     0    0    0 S  0.0  0.0   0:00.30 migration/1                                                                                
        8 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/1                                                                                
        9 root      20   0     0    0    0 S  0.0  0.0   0:00.47 ksoftirqd/1                                                                                
       10 root      RT   0     0    0    0 S  0.0  0.0   0:00.06 watchdog/1                                                                                 
       11 root      RT   0     0    0    0 S  0.0  0.0   0:00.14 migration/2                                                                                
       12 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/2                                                                                
       13 root      20   0     0    0    0 S  0.0  0.0   0:00.56 ksoftirqd/2                                                                                
       14 root      RT   0     0    0    0 S  0.0  0.0   0:00.06 watchdog/2                                                                                 
       15 root      RT   0     0    0    0 S  0.0  0.0   0:00.09 migration/3                                                                                
       16 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/3                                                                                
       17 root      20   0     0    0    0 S  0.0  0.0   0:00.60 ksoftirqd/3                                                                                
       18 root      RT   0     0    0    0 S  0.0  0.0   0:00.06 watchdog/3                                                                                 
       19 root      RT   0     0    0    0 S  0.0  0.0   0:01.09 migration/4                                                                                
       20 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/4                                                                                
       21 root      20   0     0    0    0 S  0.0  0.0   0:00.72 ksoftirqd/4                                                                                
       22 root      RT   0     0    0    0 S  0.0  0.0   0:00.06 watchdog/4                                                                                 
       23 root      RT   0     0    0    0 S  0.0  0.0   0:00.30 migration/5                                                                                
       24 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/5                                                                                
       25 root      20   0     0    0    0 S  0.0  0.0   0:00.33 ksoftirqd/5                                                                                
       26 root      RT   0     0    0    0 S  0.0  0.0   0:00.06 watchdog/5                                                                                 
       27 root      RT   0     0    0    0 S  0.0  0.0   0:00.23 migration/6                                                                                
       28 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/6                                                                                
       29 root      20   0     0    0    0 S  0.0  0.0   0:00.52 ksoftirqd/6                                                                                
       30 root      RT   0     0    0    0 S  0.0  0.0   0:00.06 watchdog/6                                                                                 
       31 root      RT   0     0    0    0 S  0.0  0.0   0:00.08 migration/7                                                                                
       32 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/7                                                                                
       33 root      20   0     0    0    0 S  0.0  0.0   0:00.50 ksoftirqd/7                                                                                
       34 root      RT   0     0    0    0 S  0.0  0.0   0:00.06 watchdog/7                                                                                 
       35 root      20   0     0    0    0 S  0.0  0.0   0:03.41 events/0                                                                                   
       36 root      20   0     0    0    0 S  0.0  0.0   0:02.86 events/1                                                                                   
       37 root      20   0     0    0    0 S  0.0  0.0   0:02.82 events/2                                                                                   
       38 root      20   0     0    0    0 S  0.0  0.0   0:02.64 events/3                                                                                   
       39 root      20   0     0    0    0 S  0.0  0.0   0:02.82 events/4                                                                                   
       40 root      20   0     0    0    0 S  0.0  0.0   0:02.99 events/5                                                                                   
       41 root      20   0     0    0    0 S  0.0  0.0   0:03.12 events/6                                                                                   
       42 root      20   0     0    0    0 S  0.0  0.0   0:04.16 events/7                                                                                   
       43 root      20   0     0    0    0 S  0.0  0.0   0:00.00 cgroup                                                                                     
       44 root      20   0     0    0    0 S  0.0  0.0   0:00.00 khelper                                                                                    
       45 root      20   0     0    0    0 S  0.0  0.0   0:00.00 netns                                                                                      
       46 root      20   0     0    0    0 S  0.0  0.0   0:00.00 async/mgr                                                                                  
       47 root      20   0     0    0    0 S  0.0  0.0   0:00.00 pm                                                                                         
       48 root      20   0     0    0    0 S  0.0  0.0   0:00.35 sync_supers                                                                                
       49 root      20   0     0    0    0 S  0.0  0.0   0:00.28 bdi-default                                                                                
       50 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/0                                                                              
       51 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/1                                                                              
       52 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/2                                                                              
       53 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/3                                                                              
       54 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/4                                                                              
       55 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/5                                                                              
       56 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/6                                                                              
       57 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kintegrityd/7                                                                              
       58 root      20   0     0    0    0 S  0.0  0.0   2:13.91 kblockd/0                                                                                  
       59 root      20   0     0    0    0 S  0.0  0.0   0:00.09 kblockd/1                                                                                  
       60 root      20   0     0    0    0 S  0.0  0.0   0:00.03 kblockd/2                                                                                  
       61 root      20   0     0    0    0 S  0.0  0.0   0:00.02 kblockd/3                                                                                  
       62 root      20   0     0    0    0 S  0.0  0.0   0:00.26 kblockd/4                                                                                  
       63 root      20   0     0    0    0 S  0.0  0.0   0:00.03 kblockd/5                                                                                  
       64 root      20   0     0    0    0 S  0.0  0.0   0:00.03 kblockd/6                                                                                  
       65 root      20   0     0    0    0 S  0.0  0.0   0:00.01 kblockd/7                                                                                  
       66 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kacpid                                                                                     
       67 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kacpi_notify                                                                               
       68 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kacpi_hotplug                                                                              
       69 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_aux                                                                                    
       70 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/0                                                                                  
       71 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/1                                                                                  
       72 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/2                                                                                  
       73 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/3                                                                                  
       74 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/4                                                                                  
       75 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/5                                                                                  
       76 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/6                                                                                  
       77 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ata_sff/7                                                                                  
       78 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ksuspend_usbd                                                                              
       79 root      20   0     0    0    0 S  0.0  0.0   0:00.00 khubd                                                                                      
       80 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kseriod                                                                                    
       81 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/0                                                                                       
       82 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/1                                                                                       
       83 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/2                                                                                       
       84 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/3                                                                                       
       85 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/4                                                                                       
       86 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/5                                                                                       
       87 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/6                                                                                       
       88 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md/7                                                                                       
       89 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/0                                                                                  
       90 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/1                                                                                  
       91 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/2                                                                                  
       92 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/3                                                                                  
       93 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/4                                                                                  
       94 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/5                                                                                  
       95 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/6                                                                                  
       96 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md_misc/7                                                                                  
       97 root      20   0     0    0    0 S  0.0  0.0   0:00.00 linkwatch                                                                                  
       98 root      20   0     0    0    0 S  0.0  0.0   0:00.04 khungtaskd                                                                                 
       99 root      20   0     0    0    0 S  0.0  0.0   0:24.46 kswapd0                                                                                    
      100 root      25   5     0    0    0 S  0.0  0.0   0:00.00 ksmd                                                                                       
      101 root      39  19     0    0    0 S  0.0  0.0   0:07.23 khugepaged                                                                                 
      102 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/0                                                                                      
      103 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/1                                                                                      
      104 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/2                                                                                      
      105 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/3                                                                                      
      106 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/4                                                                                      
      107 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/5                                                                                      
      108 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/6                                                                                      
      109 root      20   0     0    0    0 S  0.0  0.0   0:00.00 aio/7                                                                                      
      110 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/0                                                                                   
      111 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/1                                                                                   
      112 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/2                                                                                   
      113 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/3                                                                                   
      114 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/4                                                                                   
      115 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/5                                                                                   
      116 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/6                                                                                   
      117 root      20   0     0    0    0 S  0.0  0.0   0:00.00 crypto/7                                                                                   
      122 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/0                                                                                 
      123 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/1                                                                                 
      124 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/2                                                                                 
      125 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/3                                                                                 
      126 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/4                                                                                 
      127 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/5                                                                                 
      128 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/6                                                                                 
      129 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthrotld/7                                                                                 
      131 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kpsmoused                                                                                  
      132 root      20   0     0    0    0 S  0.0  0.0   0:00.00 usbhid_resumer                                                                             
      162 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kstriped                                                                                   
      340 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0                                                                                  
      341 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_1                                                                                  
      342 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_2                                                                                  
      343 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_3                                                                                  
      344 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_4                                                                                  
      345 root      20   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_5                                                                                  
      393 root      20   0  138m 1504 1012 S  0.0  0.0   0:00.00 crond                                                                                      
      399 root      20   0  6184  660  648 S  0.0  0.0   0:00.00 jailshell                                                                                  
      407 user138   20   0  6184  264  240 S  0.0  0.0   0:00.28 jailshell                                                                                  
      408 user138   20   0  410m  11m 8896 S  0.0  0.1   0:00.05 php                                                                                        
      413 root      20   0  138m 1788 1012 S  0.0  0.0   0:00.00 crond                                                                                      
      428 root      20   0  6184  828  648 S  0.0  0.0   0:00.00 jailshell                                                                                  
      466 user138   20   0  6184  420  240 S  0.0  0.0   0:00.27 jailshell                                                                                  
      467 user138   20   0  410m  14m 8896 S  0.0  0.1   0:00.07 php                                                                                        
      468 root      20   0     0    0    0 S  0.0  0.0   0:34.01 md3_raid1                                                                                  
      473 root      20   0     0    0    0 S  0.0  0.0   4:12.14 md2_raid1                                                                                  
      480 root      20   0     0    0    0 S  0.0  0.0   0:00.40 md0_raid1                                                                                  
      488 root      20   0     0    0    0 S  0.0  0.0   0:00.00 md1_raid1                                                                                  
      515 root      20   0     0    0    0 S  0.0  0.0   1:06.66 jbd2/md2-8                                                                                 
      516 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ext4-dio-unwrit                                                                            
      531 root      20   0  138m 1784 1012 S  0.0  0.0   0:00.00 crond                                                                                      
      541 root      20   0  6184  828  648 S  0.0  0.0   0:00.00 jailshell                                                                                  
      546 user138   20   0  6184  420  240 S  0.0  0.0   0:00.29 jailshell                                                                                  
      548 root      20   0     0    0    0 S  0.0  0.0   0:48.28 flush-9:2                                                                                  
      549 user138   20   0  410m  14m 8896 S  0.0  0.1   0:00.06 php                                                                                        
      594 root      16  -4 10892  348  256 S  0.0  0.0   0:00.17 udevd                                                                                      
      929 root      20   0     0    0    0 S  0.0  0.0   0:53.62 kondemand/0                                                                                
      930 root      20   0     0    0    0 S  0.0  0.0   0:10.61 kondemand/1                                                                                
      931 root      20   0     0    0    0 S  0.0  0.0   0:06.11 kondemand/2                                                                                
      932 root      20   0     0    0    0 S  0.0  0.0   0:04.56 kondemand/3                                                                                
      933 root      20   0     0    0    0 S  0.0  0.0   0:26.91 kondemand/4                                                                                
      934 root      20   0     0    0    0 S  0.0  0.0   0:07.67 kondemand/5                                                                                
      935 root      20   0     0    0    0 S  0.0  0.0   0:06.07 kondemand/6                                                                                
      936 root      20   0     0    0    0 S  0.0  0.0   0:04.81 kondemand/7                                                                                
      970 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kjournald                                                                                  
      971 root      20   0     0    0    0 S  0.0  0.0   0:06.71 jbd2/md3-8                                                                                 
      972 root      20   0     0    0    0 S  0.0  0.0   0:00.00 ext4-dio-unwrit                                                                            
     1115 root      20   0     0    0    0 S  0.0  0.0   0:00.62 kauditd                                                                                    
     1126 root      20   0     0    0    0 S  0.0  0.0   0:15.73 flush-9:3                                                                                  
     1147 root       0 -20     0    0    0 S  0.0  0.0   0:33.82 loop0                                                                                      
     1148 root      20   0     0    0    0 S  0.0  0.0   0:04.23 kjournald                                                                                  
     1270 root      18  -2 11032  388  236 S  0.0  0.0   0:00.00 udevd                                                                                      
     1274 root      20   0  138m 1788 1012 S  0.0  0.0   0:00.00 crond                                                                                      
     1275 root      18  -2 11032  380  232 S  0.0  0.0   0:00.00 udevd                                                                                      
     1279 root      20   0     0    0    0 S  0.0  0.0   0:02.06 flush-7:0                                                                                                                                                                     
    
                 total       used       free     shared    buffers     cached
    Mem:         15640       9482       6158          0        315       3108
    Low:         15640       9482       6158
    High:            0          0          0
    -/+ buffers/cache:       6057       9582
    Swap:        32767        262      32505
    
    MemTotal:       16016076 kB
    MemFree:         6306860 kB
    Buffers:          322976 kB
    Cached:          3183396 kB
    SwapCached:        12588 kB
    Active:          5886300 kB
    Inactive:        3305436 kB
    Active(anon):    4511680 kB
    Inactive(anon):  1213908 kB
    Active(file):    1374620 kB
    Inactive(file):  2091528 kB
    Unevictable:           0 kB
    Mlocked:               0 kB
    SwapTotal:      33554296 kB
    SwapFree:       33285140 kB
    Dirty:              1060 kB
    Writeback:             0 kB
    AnonPages:       5674152 kB
    Mapped:            78940 kB
    Shmem:             40216 kB
    Slab:             266028 kB
    SReclaimable:     185820 kB
    SUnreclaim:        80208 kB
    KernelStack:        6064 kB
    PageTables:        88476 kB
    NFS_Unstable:          0 kB
    Bounce:                0 kB
    WritebackTmp:          0 kB
    CommitLimit:    41562332 kB
    Committed_AS:   21337060 kB
    VmallocTotal:   34359738367 kB
    VmallocUsed:      115244 kB
    VmallocChunk:   34359545876 kB
    HardwareCorrupted:     0 kB
    AnonHugePages:   4311040 kB
    HugePages_Total:       0
    HugePages_Free:        0
    HugePages_Rsvd:        0
    HugePages_Surp:        0
    Hugepagesize:       2048 kB
    DirectMap4k:        6144 kB
    DirectMap2M:    16474112 kB
    
    --------------------------
    ps_mem.py output:
    http://www.pixelbeat.org/scripts/ps_mem.py
    --------------------------
     Private  +   Shared  =  RAM used	Program 
    
     32.0 KiB +  10.5 KiB =  42.5 KiB	acpid
    112.0 KiB +  57.0 KiB = 169.0 KiB	anvil
      4.0 KiB + 194.0 KiB = 198.0 KiB	mysqld_safe
    204.0 KiB +  27.5 KiB = 231.5 KiB	atd
    184.0 KiB +  58.0 KiB = 242.0 KiB	log
    216.0 KiB +  50.5 KiB = 266.5 KiB	dovecot
    260.0 KiB +  28.0 KiB = 288.0 KiB	init
    260.0 KiB +  29.0 KiB = 289.0 KiB	auditd
    248.0 KiB + 113.5 KiB = 361.5 KiB	udevd (3)
    404.0 KiB +  53.0 KiB = 457.0 KiB	crontab
    496.0 KiB +  46.0 KiB = 542.0 KiB	pure-authd
    488.0 KiB +  63.0 KiB = 551.0 KiB	mingetty (6)
    576.0 KiB + 215.0 KiB = 791.0 KiB	bash
    732.0 KiB +  69.0 KiB = 801.0 KiB	pure-ftpd
    652.0 KiB + 194.5 KiB = 846.5 KiB	ihttpd
    788.0 KiB +  96.0 KiB = 884.0 KiB	auth
    828.0 KiB +  68.0 KiB = 896.0 KiB	config
    880.0 KiB +  62.0 KiB = 942.0 KiB	vi
    760.0 KiB + 189.0 KiB = 949.0 KiB	mysqlmymonlite.
    548.0 KiB + 480.0 KiB =   1.0 MiB	splitlogs (2)
    868.0 KiB + 327.0 KiB =   1.2 MiB	pop3-login (2)
    944.0 KiB + 338.0 KiB =   1.3 MiB	imap-login (2)
      1.6 MiB +  37.0 KiB =   1.7 MiB	rsyslogd
      1.4 MiB + 252.0 KiB =   1.7 MiB	sshd (2)
      2.2 MiB +  76.0 KiB =   2.3 MiB	cpanellogd - sl
      2.4 MiB +  67.5 KiB =   2.4 MiB	exim
      5.1 MiB + 143.0 KiB =   5.2 MiB	queueprocd - wa
      5.2 MiB + 284.0 KiB =   5.5 MiB	cPhulkd - proce
      7.5 MiB + 330.0 KiB =   7.8 MiB	leechprotect
     11.0 MiB + 270.5 KiB =  11.3 MiB	tailwatchd
     11.5 MiB + 147.0 KiB =  11.6 MiB	lfd - sleeping
     14.2 MiB + 105.5 KiB =  14.3 MiB	cpsrvd-ssl
     16.0 MiB + 131.5 KiB =  16.1 MiB	cpdavd - accept
      2.5 MiB +  15.2 MiB =  17.7 MiB	/usr/local/cpan
     13.4 MiB +  14.9 MiB =  28.3 MiB	jailshell (228)
      4.7 MiB +  30.2 MiB =  34.9 MiB	spamd child (2)
     34.2 MiB +   6.4 MiB =  40.6 MiB	crond (115)
     80.9 MiB + 101.5 KiB =  81.0 MiB	named
     80.9 MiB +  33.4 MiB = 114.3 MiB	nginx (10)
    193.1 MiB + 291.0 KiB = 193.4 MiB	billmgr
    257.1 MiB +  87.5 KiB = 257.2 MiB	clamd
    289.7 MiB +  48.2 MiB = 337.9 MiB	httpd (11)
    655.6 MiB +  19.6 MiB = 675.3 MiB	php (114)
      3.7 GiB + 172.0 KiB =   3.7 GiB	mysqld
    ---------------------------------
                              5.5 GiB
    =================================
    
     Private  +   Shared  =  RAM used	Program 
    
    
    smem -uk
    User     Count     Swap      USS      PSS      RSS 
    dovecot      2    92.0K   900.0K  1002.0K     2.9M 
    dovenull     4     1.5M     1.8M     2.2M    12.2M 
    mailnull     1        0     2.4M     2.4M     2.9M 
    named        1     3.9M    80.9M    81.0M    82.0M 
    nobody      19        0   364.2M   436.3M   951.1M 
    root       274     6.1M   595.5M   657.4M     1.1G 
    user138    228    29.0M   662.4M   674.4M     1.6G 
    mysql        1   222.2M     3.7G     3.7G     3.7G 
    
    smem -t -p
      PID User     Command                         Swap      USS      PSS      RSS 
    ~CUT, long characters~
    
    smem -wk
    Area                           Used      Cache   Noncache 
    firmware/hardware                 0          0          0 
    kernel image                      0          0          0 
    kernel dynamic memory          3.8G       3.4G     334.5M 
    userspace memory               5.5G      78.1M       5.4G 
    free memory                    6.0G       6.0G          0 
    
    
    ----------------------------
    Server Disk Usage
    ----------------------------
    Filesystem     Type   Size  Used Avail Use% Mounted on
    /dev/md2       ext4   504G  132G  347G  28% /
    tmpfs          tmpfs  7.7G  8.0K  7.7G   1% /dev/shm
    /dev/md1       ext3   496M   72M  399M  16% /boot
    /dev/md3       ext4   2.0T   29G  1.9T   2% /home
    /usr/tmpDSK    ext3   4.0G  1.2G  2.6G  31% /tmp
    
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 5054044 kilobytes of disk space
    
    ----------------------------
    ulimit -aH
    ----------------------------
    core file size          (blocks, -c) unlimited
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 124984
    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) unlimited
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 124984
    virtual memory          (kbytes, -v) unlimited
    file locks                      (-x) unlimited
    
    ----------------------------------------------------------
    tail -15 /etc/security/limits.conf
    ----------------------------------------------------------
    #<domain>      <type>  <item>         <value>
    #
    
    kiskaqin - nice 15
    
    #*               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
    nginx		soft 	nofile		300000
    nginx		hard	nofile		300000
    # End of file
    
    ----------------------------------------------------------
    mysqld process limits: 
    cat /proc/2721/limits
    ----------------------------------------------------------
    Limit                     Soft Limit           Hard Limit           Units     
    Max cpu time              unlimited            unlimited            seconds   
    Max file size             unlimited            unlimited            bytes     
    Max data size             unlimited            unlimited            bytes     
    Max stack size            10485760             unlimited            bytes     
    Max core file size        0                    unlimited            bytes     
    Max resident set          unlimited            unlimited            bytes     
    Max processes             124984               124984               processes 
    Max open files            100000               100000               files     
    Max locked memory         65536                65536                bytes     
    Max address space         unlimited            unlimited            bytes     
    Max file locks            unlimited            unlimited            locks     
    Max pending signals       124984               124984               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.42.0.12
    
    WHM's PHP Handler config:
    /usr/local/cpanel/bin/rebuild_phpconf --current
    Available handlers: dso cgi none
    DEFAULT PHP: 5
    PHP4 SAPI: none
    PHP5 SAPI: dso
    SUEXEC: not installed
    RUID2: enabled
    
    PHP 5.4.25 (cli) (built: Feb 22 2014 15:21:20) 
    Copyright (c) 1997-2014 The PHP Group
    Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
        with eAccelerator v0.9.6.1-ea, Copyright (c) 2004-2012 eAccelerator, by eAccelerator
        with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd., and
        with Zend Guard Loader v3.3, Copyright (c) 1998-2013, by Zend Technologies
    
    System => Linux yourserverhostname 2.6.32-431.3.1.el6.x86_64 #1 SMP Fri Jan 3 21:39:27 UTC 2014 x86_64
    Build Date => Feb 22 2014 15:20:48
    
    Configure Command =>  './configure'  '--disable-posix' '--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-wddx' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-bz2' '--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-mm=/opt/mm/' '--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-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
    PHP API | 20100412
    Zend Extension Build | API220100525,NTS
    PHP Extension Build | API20100525,NTS
    DOM/XML API Version | 20031129
    Client API version | 5.6.16
    Client API library version | 5.6.16
    Client API header version | 5.6.16
    API Extensions | pdo_mysql
    Client API version | mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
    Phar API version | 1.1.1
    
    display_errors | Off | Off
    error_log | php_error_log | php_error_log
    extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20100525 | /usr/local/lib/php/extensions/no-debug-non-zts-20100525
    file_uploads | On | On
    log_errors | Off | Off
    log_errors_max_len | 192 | 192
    max_execution_time | 0 | 0
    max_file_uploads | 20 | 20
    memory_limit | 192M | 192M
    open_basedir | no value | no value
    post_max_size | 512M | 512M
    realpath_cache_size | 16K | 16K
    realpath_cache_ttl | 120 | 120
    sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
    sql.safe_mode | Off | Off
    upload_max_filesize | 512M | 512M
    upload_tmp_dir | no value | no value
    sqlite3.extension_dir | no value | no value
    
    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
    
    
    PCRE (Perl Compatible Regular Expressions) Support => enabled
    PCRE Library Version => 8.21 2011-12-12
    
    Directive => Local Value => Master Value
    pcre.backtrack_limit => 1000000 => 1000000
    pcre.recursion_limit => 100000 => 100000
    
    PDO support => enabled
    PDO drivers => sqlite, mysql
    
    PDO Driver for MySQL => enabled
    Client API version => mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
    
    PDO Driver for SQLite 3.x => enabled
    SQLite Library => 3.7.7.1
    
    Phar: PHP Archive support => enabled
    Phar EXT version => 2.0.1
    Phar API version => 1.1.1
    SVN revision => $Id: ec823514107160b7e6fabc519594012657a2db91 $
    Phar-based phar archives => enabled
    Tar-based phar archives => enabled
    ZIP-based phar archives => enabled
    gzip compression => enabled
    bzip2 compression => enabled
    OpenSSL support => enabled
    
    
    Phar based on pear/PHP_Archive, original concept by Davey Shafik.
    Phar fully realized by Gregory Beaver and Marcus Boerger.
    Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
    Directive => Local Value => Master Value
    phar.cache_list => no value => no value
    phar.readonly => On => On
    phar.require_hash => On => On
    
    
    
    
    
    
    Server version: Apache/2.2.26 (Unix)
    Server built:   Feb 22 2014 15:18:23
    Cpanel::Easy::Apache v3.24.11 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 disabled)
     -D APR_USE_SYSVSEM_SERIALIZE
     -D APR_USE_PTHREAD_SERIALIZE
     -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
     -D APR_HAS_OTHER_CHILD
     -D AP_HAVE_RELIABLE_PIPED_LOGS
     -D DYNAMIC_MODULE_LIMIT=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)
     authn_dbm_module (static)
     authn_anon_module (static)
     authn_dbd_module (static)
     authn_default_module (static)
     authn_alias_module (static)
     authz_host_module (static)
     authz_groupfile_module (static)
     authz_user_module (static)
     authz_dbm_module (static)
     authz_owner_module (static)
     authnz_ldap_module (static)
     authz_default_module (static)
     auth_basic_module (static)
     auth_digest_module (static)
     file_cache_module (static)
     cache_module (static)
     dbd_module (static)
     echo_module (static)
     ext_filter_module (static)
     include_module (static)
     filter_module (static)
     deflate_module (static)
     ldap_module (static)
     log_config_module (static)
     log_forensic_module (static)
     logio_module (static)
     env_module (static)
     mime_magic_module (static)
     expires_module (static)
     headers_module (static)
     ident_module (static)
     unique_id_module (static)
     setenvif_module (static)
     version_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)
     asis_module (static)
     info_module (static)
     suexec_module (static)
     cgi_module (static)
     vhost_alias_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)
     rpaf_module (shared)
     bwlimited_module (shared)
     bw_module (shared)
     geoip_module (shared)
     ruid2_module (shared)
     disable_suexec_module (shared)
     php5_module (shared)
     ispmgr_module (shared)
     security2_module (shared)
    
    Compiled in modules:
      core.c
      mod_authn_file.c
      mod_authn_dbm.c
      mod_authn_anon.c
      mod_authn_dbd.c
      mod_authn_default.c
      mod_authn_alias.c
      mod_authz_host.c
      mod_authz_groupfile.c
      mod_authz_user.c
      mod_authz_dbm.c
      mod_authz_owner.c
      mod_authnz_ldap.c
      mod_authz_default.c
      mod_auth_basic.c
      mod_auth_digest.c
      mod_file_cache.c
      mod_cache.c
      mod_dbd.c
      mod_echo.c
      mod_ext_filter.c
      mod_include.c
      mod_filter.c
      mod_deflate.c
      util_ldap.c
      mod_log_config.c
      mod_log_forensic.c
      mod_logio.c
      mod_env.c
      mod_mime_magic.c
      mod_expires.c
      mod_headers.c
      mod_ident.c
      mod_unique_id.c
      mod_setenvif.c
      mod_version.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_asis.c
      mod_info.c
      mod_suexec.c
      mod_cgi.c
      mod_vhost_alias.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 30
    KeepAlive Off
    MaxKeepAliveRequests 1000000
    KeepAliveTimeout 5
    
    </IfModule>
    StartServers 5
    <IfModule prefork.c>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    ServerLimit 256
    MaxClients 150
    MaxRequestsPerChild 1000000
    </IfModule>
    
    
    ---------------
    You are running Nginx
    ---------------
    
    
    user  nobody;
    # no need for more workers in the proxy mode
    worker_processes  8;
    worker_rlimit_nofile 10240;
     worker_connections 10240; # increase for busier servers
     use epoll; # you should use epoll here for Linux kernels 2.6.x
     sendfile on;
     keepalive_timeout  5;
     gzip on;
     gzip_vary on;
     gzip_disable "MSIE [1-6]\.";
     gzip_proxied any;
     gzip_http_version 1.1;
     gzip_min_length  1000;
     gzip_comp_level  6;
     gzip_buffers  16 8k;
     gzip_types    text/plain text/xml text/css application/x-javascript application/xml image/png image/x-icon image/gif image/jpeg application/javascript application/xml+rss text/javascript application/atom+xml;
     client_header_timeout  3m;
     client_body_timeout 3m;
     client_header_buffer_size 256k;
     large_client_header_buffers 4 256k;
     client_max_body_size 100M; 
     client_body_buffer_size 128k;
    proxy_buffers 8 64k;
    proxy_intercept_errors on;
    proxy_connect_timeout 1s;
    proxy_read_timeout 3s;
    proxy_send_timeout 3s;
     proxy_temp_path  /tmp/nginx_proxy/;
     proxy_cache_path /var/cache/nginx levels=1:2 keys_zone=microcache:5m max_size=1000m;
     client_body_in_file_only on;
     log_format custom_microcache '$remote_addr - $remote_user [$time_local] '
            '"$http_referer" "$http_user_agent" nocache:$no_cache';
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MySQL 5.6.16             uptime 1 4:32:16       Thu Feb 27 11:39:24 2014
    
    __ Key _________________________________________________________________
    Buffer used   202.07M of   2.00G  %Used:   9.87
      Current     572.32M            %Usage:  27.95
    Write hit      67.42%
    Read hit       99.88%
    
    __ Questions ___________________________________________________________
    Total          10.04M    97.7/s
      QC Hits       5.17M    50.4/s  %Total:  51.51
      DMS           3.85M    37.5/s           38.33
      Com_          3.21M    31.2/s           31.94
      -Unknown      2.36M    23.0/s           23.51
      COM_QUIT    173.31k     1.7/s            1.73
    Slow 10 s         184     0.0/s            0.00  %DMS:   0.00  Log:
    DMS             3.85M    37.5/s           38.33
      INSERT        2.45M    23.8/s           24.40         63.65
      SELECT        1.19M    11.5/s           11.81         30.81
      UPDATE      135.93k     1.3/s            1.35          3.53
      DELETE       76.08k     0.7/s            0.76          1.98
      REPLACE       1.08k     0.0/s            0.01          0.03
    Com_            3.21M    31.2/s           31.94
      stmt_execut   2.18M    21.2/s           21.70
      set_option  523.66k     5.1/s            5.21
      change_db   161.43k     1.6/s            1.61
    
    __ SELECT and Sort _____________________________________________________
    Scan          284.76k     2.8/s %SELECT:  24.01
    Range         141.38k     1.4/s           11.92
    Full join      23.82k     0.2/s            2.01
    Range check     1.58k     0.0/s            0.13
    Full rng join       4     0.0/s            0.00
    Sort scan     109.20k     1.1/s
    Sort range    140.87k     1.4/s
    Sort mrg pass       0       0/s
    
    __ Query Cache _________________________________________________________
    Memory usage   28.55M of 128.00M  %Used:  22.30
    Block Fragmnt   7.90%
    Hits            5.17M    50.4/s
    Inserts         1.09M    10.6/s
    Insrt:Prune    1.46:1     3.3/s
    Hit:Insert     4.77:1
    
    __ Table Locks _________________________________________________________
    Waited          3.47k     0.0/s  %Total:   0.05
    Immediate       6.55M    63.7/s
    
    __ Tables ______________________________________________________________
    Open            16242 of 3000    %Cache:  54.14
    Opened         19.60k     0.2/s
    
    __ Connections _________________________________________________________
    Max used           26 of  100      %Max:  26.00
    Total         175.82k     1.7/s
    
    __ Created Temp ________________________________________________________
    Disk table    165.58k     1.6/s
    Table           2.42M    23.5/s    Size:  64.0M
    File                8     0.0/s
    
    __ Threads _____________________________________________________________
    Running             1 of    4
    Cached             22 of   32      %Hit:  99.99
    Created            26     0.0/s
    Slow                0       0/s
    
    __ Aborted _____________________________________________________________
    Clients         5.01k     0.0/s
    Connects          135     0.0/s
    
    __ Bytes _______________________________________________________________
    Sent           77.80G  757.3k/s
    Received        1.51G   14.7k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage         616.75M of   5.00G  %Used:  12.05
    Read hit       99.94%
    Pages
      Free        288.20k            %Total:  87.95
      Data         39.09k                     11.93 %Drty:   0.09
      Misc            382                      0.12
      Latched                                  0.00
    Reads          36.92M   359.4/s
      From file    23.77k     0.2/s            0.06
      Ahead Rnd         0       0/s
      Ahead Sql                 0/s
    Writes          2.05M    19.9/s
    Flushes       435.04k     4.2/s
    Wait Free           0       0/s
    
    __ InnoDB Lock _________________________________________________________
    Waits             300     0.0/s
    Current             0
    Time acquiring
      Total        111874 ms
      Average         372 ms
      Max           25433 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads        36.51k     0.4/s
      Writes      655.46k     6.4/s
      fsync       340.02k     3.3/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created       7.18k     0.1/s
      Read         31.97k     0.3/s
      Written     435.04k     4.2/s
    
    Rows
      Deleted      23.41k     0.2/s
      Inserted     38.96k     0.4/s
      Read         28.58M   278.1/s
      Updated      98.04k     1.0/s
    
    ----------------------------
    Total Server MyISAM and InnoDB Size
    ----------------------------
    *************************** 1. row ***************************
    innodb_tablespace_utilization_perc: 100
                         total_size_gb: 3.14360629953444
                         index_size_gb: 1.0571941882371902
                          data_size_gb: 2.08641211129725
                  innodb_total_size_gb: 0.7071533203125
                   innodb_data_size_gb: 0.3700408935546875
                  innodb_index_size_gb: 0.3371124267578125
                  myisam_total_size_gb: 2.4206725377589464
                   myisam_data_size_gb: 1.7085734624415636
                  myisam_index_size_gb: 0.7120990753173828
                            perc_index: 33.629980500
                             perc_data: 66.370019400
                     innodb_perc_index: 47.671759000
                      innodb_perc_data: 52.328240900
                     myisam_perc_index: 29.417406200
                      myisam_perc_data: 70.582593700
               innodb_perc_total_index: 31.887465000
                innodb_perc_total_data: 17.735752700
               myisam_perc_total_index: 67.357452700
                myisam_perc_total_data: 81.890507300
    
    ----------------------------
    MySQL settings
    ----------------------------
    [mysqld]
    open_files_limit=100000
    innodb_data_home_dir=/var/lib/mysql
    innodb_log_group_home_dir=/var/lib/mysql
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    port=3306
    user=mysql
    
    max_allowed_packet = 64M
    
    innodb_lock_wait_timeout=30
    innodb_log_file_size=256M
    innodb_log_buffer_size=8M
    key_buffer_size=2G
    innodb_log_files_in_group=3
    skip-innodb_checksums
    skip-innodb_doublewrite
    
    innodb_additional_mem_pool_size=20M
    innodb_buffer_pool_size=5G
    innodb_buffer_pool_instances = 5
    innodb_thread_concurrency = 16
    innodb_max_dirty_pages_pct = 90
    
    read_buffer_size=2M
    innodb_file_io_threads = 4
    innodb_write_io_threads = 4
    innodb_read_io_threads = 4
    
    default-storage-engine=MyISAM
    innodb_file_per_table=1
    query_cache_size=128M
    query_cache_limit=2M
    query_cache_type=1
    query_cache_min_res_unit=512K
    table_open_cache=30000
    table_definition_cache=30000
    join_buffer_size=8M
    myisam_sort_buffer_size=1200M
    max_heap_table_size=128M
    sort_buffer_size=12M
    innodb_flush_method=O_DIRECT
    innodb_log_buffer_size=16M
    tmp_table_size=64M
    read_rnd_buffer_size=32M
    innodb_flush_log_at_trx_commit=1
    max_connections=100
    max_connect_errors = 10000
    
    wait_timeout=30
    net_read_timeout=30
    net_write_timeout=30
    
    thread_cache_size=32
    thread_concurrency=10
    thread_stack = 256K
    
    tmpdir = /dev/shm
    transaction_isolation = REPEATABLE-READ
    ---
    +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Variable_name | Value |
    +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | auto_increment_increment | 1 |
    | auto_increment_offset | 1 |
    | autocommit | ON |
    | automatic_sp_privileges | ON |
    | back_log | 70 |
    | basedir | /usr |
    | big_tables | OFF |
    | bind_address | * |
    | binlog_cache_size | 32768 |
    | binlog_checksum | CRC32 |
    | binlog_direct_non_transactional_updates | OFF |
    | binlog_format | STATEMENT |
    | binlog_max_flush_queue_time | 0 |
    | binlog_order_commits | ON |
    | binlog_row_image | FULL |
    | binlog_rows_query_log_events | OFF |
    | 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 |
    | core_file | OFF |
    | datadir | /var/lib/mysql/ |
    | date_format | %Y-%m-%d |
    | datetime_format | %Y-%m-%d %H:%i:%s |
    | default_storage_engine | MyISAM |
    | default_tmp_storage_engine | InnoDB |
    | default_week_format | 0 |
    | delay_key_write | ON |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout | 300 |
    | delayed_queue_size | 1000 |
    | disconnect_on_expired_password | ON |
    | div_precision_increment | 4 |
    | end_markers_in_json | OFF |
    | enforce_gtid_consistency | OFF |
    | eq_range_index_dive_limit | 10 |
    | event_scheduler | OFF |
    | expire_logs_days | 0 |
    | explicit_defaults_for_timestamp | OFF |
    | 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/sv-1.log |
    | group_concat_max_len | 1024 |
    | gtid_executed | |
    | gtid_mode | OFF |
    | gtid_owned | |
    | gtid_purged | |
    | have_compress | YES |
    | have_crypt | YES |
    | have_dynamic_loading | YES |
    | have_geometry | YES |
    | have_openssl | DISABLED |
    | have_profiling | YES |
    | have_query_cache | YES |
    | have_rtree_keys | YES |
    | have_ssl | DISABLED |
    | have_symlink | YES |
    | host_cache_size | 228 |
    | hostname | yourserverhostname |
    | ignore_builtin_innodb | OFF |
    | ignore_db_dirs | |
    | init_connect | |
    | init_file | |
    | init_slave | |
    | innodb_adaptive_flushing | ON |
    | innodb_adaptive_flushing_lwm | 10 |
    | innodb_adaptive_hash_index | ON |
    | innodb_adaptive_max_sleep_delay | 150000 |
    | innodb_additional_mem_pool_size | 20971520 |
    | innodb_api_bk_commit_interval | 5 |
    | innodb_api_disable_rowlock | OFF |
    | innodb_api_enable_binlog | OFF |
    | innodb_api_enable_mdl | OFF |
    | innodb_api_trx_level | 0 |
    | innodb_autoextend_increment | 64 |
    | innodb_autoinc_lock_mode | 1 |
    | innodb_buffer_pool_dump_at_shutdown | OFF |
    | innodb_buffer_pool_dump_now | OFF |
    | innodb_buffer_pool_filename | ib_buffer_pool |
    | innodb_buffer_pool_instances | 5 |
    | innodb_buffer_pool_load_abort | OFF |
    | innodb_buffer_pool_load_at_startup | OFF |
    | innodb_buffer_pool_load_now | OFF |
    | innodb_buffer_pool_size | 5368709120 |
    | innodb_change_buffer_max_size | 25 |
    | innodb_change_buffering | all |
    | innodb_checksum_algorithm | none |
    | innodb_checksums | OFF |
    | innodb_cmp_per_index_enabled | OFF |
    | innodb_commit_concurrency | 0 |
    | innodb_compression_failure_threshold_pct | 5 |
    | innodb_compression_level | 6 |
    | innodb_compression_pad_pct_max | 50 |
    | innodb_concurrency_tickets | 5000 |
    | innodb_data_file_path | ibdata1:12M:autoextend |
    | innodb_data_home_dir | /var/lib/mysql |
    | innodb_disable_sort_file_cache | OFF |
    | innodb_doublewrite | OFF |
    | 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_timeout | 1 |
    | innodb_flush_log_at_trx_commit | 1 |
    | innodb_flush_method | O_DIRECT |
    | innodb_flush_neighbors | 1 |
    | innodb_flushing_avg_loops | 30 |
    | innodb_force_load_corrupted | OFF |
    | innodb_force_recovery | 0 |
    | innodb_ft_aux_table | |
    | innodb_ft_cache_size | 8000000 |
    | innodb_ft_enable_diag_print | OFF |
    | innodb_ft_enable_stopword | ON |
    | innodb_ft_max_token_size | 84 |
    | innodb_ft_min_token_size | 3 |
    | innodb_ft_num_word_optimize | 2000 |
    | innodb_ft_result_cache_limit | 2000000000 |
    | innodb_ft_server_stopword_table | |
    | innodb_ft_sort_pll_degree | 2 |
    | innodb_ft_total_cache_size | 640000000 |
    | innodb_ft_user_stopword_table | |
    | innodb_io_capacity | 200 |
    | innodb_io_capacity_max | 2000 |
    | innodb_large_prefix | OFF |
    | innodb_lock_wait_timeout | 30 |
    | innodb_locks_unsafe_for_binlog | OFF |
    | innodb_log_buffer_size | 16777216 |
    | innodb_log_compressed_pages | ON |
    | innodb_log_file_size | 268435456 |
    | innodb_log_files_in_group | 3 |
    | innodb_log_group_home_dir | /var/lib/mysql |
    | innodb_lru_scan_depth | 1024 |
    | innodb_max_dirty_pages_pct | 90 |
    | innodb_max_dirty_pages_pct_lwm | 0 |
    | innodb_max_purge_lag | 0 |
    | innodb_max_purge_lag_delay | 0 |
    | innodb_mirrored_log_groups | 1 |
    | innodb_monitor_disable | |
    | innodb_monitor_enable | |
    | innodb_monitor_reset | |
    | innodb_monitor_reset_all | |
    | innodb_old_blocks_pct | 37 |
    | innodb_old_blocks_time | 1000 |
    | innodb_online_alter_log_max_size | 134217728 |
    | innodb_open_files | 30000 |
    | innodb_optimize_fulltext_only | OFF |
    | innodb_page_size | 16384 |
    | innodb_print_all_deadlocks | OFF |
    | innodb_purge_batch_size | 300 |
    | innodb_purge_threads | 1 |
    | innodb_random_read_ahead | OFF |
    | innodb_read_ahead_threshold | 56 |
    | innodb_read_io_threads | 4 |
    | innodb_read_only | OFF |
    | innodb_replication_delay | 0 |
    | innodb_rollback_on_timeout | OFF |
    | innodb_rollback_segments | 128 |
    | innodb_sort_buffer_size | 1048576 |
    | innodb_spin_wait_delay | 6 |
    | innodb_stats_auto_recalc | ON |
    | innodb_stats_method | nulls_equal |
    | innodb_stats_on_metadata | OFF |
    | innodb_stats_persistent | ON |
    | innodb_stats_persistent_sample_pages | 20 |
    | innodb_stats_sample_pages | 8 |
    | innodb_stats_transient_sample_pages | 8 |
    | innodb_status_output | OFF |
    | innodb_status_output_locks | OFF |
    | innodb_strict_mode | OFF |
    | innodb_support_xa | ON |
    | innodb_sync_array_size | 1 |
    | innodb_sync_spin_loops | 30 |
    | innodb_table_locks | ON |
    | innodb_thread_concurrency | 16 |
    | innodb_thread_sleep_delay | 0 |
    | innodb_undo_directory | . |
    | innodb_undo_logs | 128 |
    | innodb_undo_tablespaces | 0 |
    | innodb_use_native_aio | ON |
    | innodb_use_sys_malloc | ON |
    | innodb_version | 5.6.16 |
    | innodb_write_io_threads | 4 |
    | interactive_timeout | 28800 |
    | join_buffer_size | 8388608 |
    | keep_files_on_create | OFF |
    | key_buffer_size | 2147483648 |
    | 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_bin | OFF |
    | log_bin_basename | |
    | log_bin_index | |
    | log_bin_trust_function_creators | OFF |
    | log_bin_use_v1_row_events | OFF |
    | log_error | /var/lib/mysql/yourserverhostname.err |
    | log_output | FILE |
    | log_queries_not_using_indexes | OFF |
    | log_slave_updates | OFF |
    | log_slow_admin_statements | OFF |
    | log_slow_slave_statements | OFF |
    | log_throttle_queries_not_using_indexes | 0 |
    | log_warnings | 1 |
    | long_query_time | 10.000000 |
    | low_priority_updates | OFF |
    | lower_case_file_system | OFF |
    | lower_case_table_names | 0 |
    | master_info_repository | FILE |
    | master_verify_checksum | OFF |
    | max_allowed_packet | 67108864 |
    | max_binlog_cache_size | 18446744073709547520 |
    | max_binlog_size | 1073741824 |
    | max_binlog_stmt_cache_size | 18446744073709547520 |
    | max_connect_errors | 10000 |
    | max_connections | 100 |
    | max_delayed_threads | 20 |
    | max_error_count | 64 |
    | max_heap_table_size | 134217728 |
    | max_insert_delayed_threads | 20 |
    | max_join_size | 18446744073709551615 |
    | max_length_for_sort_data | 1024 |
    | 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 |
    | metadata_locks_hash_instances | 8 |
    | 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 | 1258291200 |
    | myisam_stats_method | nulls_unequal |
    | myisam_use_mmap | OFF |
    | net_buffer_length | 16384 |
    | net_read_timeout | 30 |
    | net_retry_count | 10 |
    | net_write_timeout | 30 |
    | new | OFF |
    | old | OFF |
    | old_alter_table | OFF |
    | old_passwords | 0 |
    | open_files_limit | 100000 |
    | 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,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on |
    | optimizer_trace | enabled=off,one_line=off |
    | optimizer_trace_features | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on |
    | optimizer_trace_limit | 1 |
    | optimizer_trace_max_mem_size | 16384 |
    | optimizer_trace_offset | -1 |
    | performance_schema | ON |
    | performance_schema_accounts_size | 100 |
    | performance_schema_digests_size | 10000 |
    | performance_schema_events_stages_history_long_size | 10000 |
    | performance_schema_events_stages_history_size | 10 |
    | performance_schema_events_statements_history_long_size | 10000 |
    | performance_schema_events_statements_history_size | 10 |
    | performance_schema_events_waits_history_long_size | 10000 |
    | performance_schema_events_waits_history_size | 10 |
    | performance_schema_hosts_size | 100 |
    | performance_schema_max_cond_classes | 80 |
    | performance_schema_max_cond_instances | 60500 |
    | performance_schema_max_file_classes | 50 |
    | performance_schema_max_file_handles | 32768 |
    | performance_schema_max_file_instances | 153847 |
    | performance_schema_max_mutex_classes | 200 |
    | performance_schema_max_mutex_instances | 301600 |
    | performance_schema_max_rwlock_classes | 40 |
    | performance_schema_max_rwlock_instances | 180600 |
    | performance_schema_max_socket_classes | 10 |
    | performance_schema_max_socket_instances | 220 |
    | performance_schema_max_stage_classes | 150 |
    | performance_schema_max_statement_classes | 168 |
    | performance_schema_max_table_handles | 60000 |
    | performance_schema_max_table_instances | 37500 |
    | performance_schema_max_thread_classes | 50 |
    | performance_schema_max_thread_instances | 300 |
    | performance_schema_session_connect_attrs_size | 512 |
    | performance_schema_setup_actors_size | 100 |
    | performance_schema_setup_objects_size | 100 |
    | performance_schema_users_size | 100 |
    | 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 | 2097152 |
    | query_cache_min_res_unit | 524288 |
    | query_cache_size | 134217728 |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    | query_prealloc_size | 8192 |
    | range_alloc_block_size | 4096 |
    | read_buffer_size | 2097152 |
    | read_only | OFF |
    | read_rnd_buffer_size | 33554432 |
    | relay_log | |
    | relay_log_basename | |
    | relay_log_index | |
    | relay_log_info_file | relay-log.info |
    | relay_log_info_repository | FILE |
    | relay_log_purge | ON |
    | relay_log_recovery | OFF |
    | relay_log_space_limit | 0 |
    | report_host | |
    | report_password | |
    | report_port | 3306 |
    | report_user | |
    | rpl_stop_slave_timeout | 31536000 |
    | secure_auth | ON |
    | secure_file_priv | |
    | server_id | 0 |
    | server_id_bits | 32 |
    | server_uuid | 08bb913f-7de8-11e3-b7df-50465da329f2 |
    | skip_external_locking | ON |
    | skip_name_resolve | OFF |
    | skip_networking | OFF |
    | skip_show_database | OFF |
    | slave_allow_batching | OFF |
    | slave_checkpoint_group | 512 |
    | slave_checkpoint_period | 300 |
    | slave_compressed_protocol | OFF |
    | slave_exec_mode | STRICT |
    | slave_load_tmpdir | /dev/shm |
    | slave_max_allowed_packet | 1073741824 |
    | slave_net_timeout | 3600 |
    | slave_parallel_workers | 0 |
    | slave_pending_jobs_size_max | 16777216 |
    | slave_rows_search_algorithms | TABLE_SCAN,INDEX_SCAN |
    | slave_skip_errors | OFF |
    | slave_sql_verify_checksum | ON |
    | slave_transaction_retries | 10 |
    | slave_type_conversions | |
    | slow_launch_time | 2 |
    | slow_query_log | OFF |
    | slow_query_log_file | /var/lib/mysql/sv-1-slow.log |
    | socket | /var/lib/mysql/mysql.sock |
    | sort_buffer_size | 12582912 |
    | sql_auto_is_null | OFF |
    | sql_big_selects | ON |
    | sql_buffer_result | OFF |
    | sql_log_bin | ON |
    | sql_log_off | OFF |
    | sql_mode | NO_ENGINE_SUBSTITUTION |
    | 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_crl | |
    | ssl_crlpath | |
    | ssl_key | |
    | storage_engine | MyISAM |
    | stored_program_cache | 256 |
    | sync_binlog | 0 |
    | sync_frm | ON |
    | sync_master_info | 10000 |
    | sync_relay_log | 10000 |
    | sync_relay_log_info | 10000 |
    | system_time_zone | CET |
    | table_definition_cache | 30000 |
    | table_open_cache | 30000 |
    | table_open_cache_instances | 1 |
    | thread_cache_size | 32 |
    | thread_concurrency | 10 |
    | thread_handling | one-thread-per-connection |
    | thread_stack | 262144 |
    | time_format | %H:%i:%s |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | tmp_table_size | 67108864 |
    | tmpdir | /dev/shm |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_isolation | REPEATABLE-READ |
    | tx_read_only | OFF |
    | unique_checks | ON |
    | updatable_views_with_limit | YES |
    | version | 5.6.16 |
    | version_comment | MySQL Community Server (GPL) |
    | version_compile_machine | x86_64 |
    | version_compile_os | Linux |
    | wait_timeout | 30 |
    +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    +-----------------------------------------------+-------------+
    | Variable_name | Value |
    +-----------------------------------------------+-------------+
    | Aborted_clients | 5012 |
    | Aborted_connects | 135 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Binlog_stmt_cache_disk_use | 0 |
    | Binlog_stmt_cache_use | 0 |
    | Bytes_received | 1507652092 |
    | Bytes_sent | 77802378778 |
    | Com_admin_commands | 58357 |
    | 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 | 111 |
    | Com_alter_tablespace | 0 |
    | Com_alter_user | 0 |
    | Com_analyze | 92 |
    | Com_begin | 388 |
    | Com_binlog | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 161433 |
    | Com_change_master | 0 |
    | Com_check | 0 |
    | Com_checksum | 0 |
    | Com_commit | 396 |
    | Com_create_db | 8 |
    | Com_create_event | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_procedure | 0 |
    | Com_create_server | 0 |
    | Com_create_table | 1456 |
    | Com_create_trigger | 0 |
    | Com_create_udf | 0 |
    | Com_create_user | 0 |
    | Com_create_view | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 76075 |
    | Com_delete_multi | 6 |
    | Com_do | 0 |
    | Com_drop_db | 7 |
    | Com_drop_event | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_procedure | 0 |
    | Com_drop_server | 0 |
    | Com_drop_table | 472 |
    | Com_drop_trigger | 0 |
    | Com_drop_user | 1 |
    | Com_drop_view | 0 |
    | Com_empty_query | 85 |
    | Com_execute_sql | 0 |
    | Com_flush | 32 |
    | Com_get_diagnostics | 0 |
    | Com_grant | 142 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 309187 |
    | Com_insert_select | 2140859 |
    | Com_install_plugin | 0 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_lock_tables | 1005 |
    | Com_optimize | 148 |
    | Com_preload_keys | 0 |
    | Com_prepare_sql | 0 |
    | Com_purge | 0 |
    | Com_purge_before_date | 0 |
    | Com_release_savepoint | 85 |
    | Com_rename_table | 0 |
    | Com_rename_user | 0 |
    | Com_repair | 1 |
    | Com_replace | 1085 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_resignal | 0 |
    | Com_revoke | 1 |
    | Com_revoke_all | 0 |
    | Com_rollback | 9 |
    | Com_rollback_to_savepoint | 36 |
    | Com_savepoint | 85 |
    | Com_select | 1185811 |
    | Com_set_option | 523657 |
    | Com_signal | 0 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 18 |
    | Com_show_charsets | 479 |
    | Com_show_collations | 206 |
    | Com_show_create_db | 247 |
    | Com_show_create_event | 0 |
    | Com_show_create_func | 0 |
    | Com_show_create_proc | 0 |
    | Com_show_create_table | 16145 |
    | Com_show_create_trigger | 0 |
    | Com_show_databases | 1143 |
    | Com_show_engine_logs | 0 |
    | Com_show_engine_mutex | 0 |
    | Com_show_engine_status | 0 |
    | Com_show_events | 12 |
    | Com_show_errors | 0 |
    | Com_show_fields | 83987 |
    | Com_show_function_code | 0 |
    | Com_show_function_status | 321 |
    | Com_show_grants | 627 |
    | Com_show_keys | 433 |
    | Com_show_master_status | 6 |
    | Com_show_open_tables | 0 |
    | Com_show_plugins | 0 |
    | Com_show_privileges | 0 |
    | Com_show_procedure_code | 0 |
    | Com_show_procedure_status | 321 |
    | Com_show_processlist | 355 |
    | Com_show_profile | 0 |
    | Com_show_profiles | 654 |
    | Com_show_relaylog_events | 0 |
    | Com_show_slave_hosts | 0 |
    | Com_show_slave_status | 6 |
    | Com_show_status | 32 |
    | Com_show_storage_engines | 0 |
    | Com_show_table_status | 32686 |
    | Com_show_tables | 3120 |
    | Com_show_triggers | 15803 |
    | Com_show_variables | 2146 |
    | Com_show_warnings | 2 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_stmt_close | 41151 |
    | Com_stmt_execute | 2179023 |
    | Com_stmt_fetch | 0 |
    | Com_stmt_prepare | 41375 |
    | Com_stmt_reprepare | 0 |
    | Com_stmt_reset | 38081 |
    | Com_stmt_send_long_data | 0 |
    | Com_truncate | 207 |
    | Com_uninstall_plugin | 0 |
    | Com_unlock_tables | 1029 |
    | Com_update | 133698 |
    | Com_update_multi | 2236 |
    | 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 |
    | Connection_errors_accept | 0 |
    | Connection_errors_internal | 0 |
    | Connection_errors_max_connections | 0 |
    | Connection_errors_peer_address | 0 |
    | Connection_errors_select | 0 |
    | Connection_errors_tcpwrap | 0 |
    | Connections | 175819 |
    | Created_tmp_disk_tables | 165587 |
    | Created_tmp_files | 8 |
    | Created_tmp_tables | 2419175 |
    | Delayed_errors | 0 |
    | Delayed_insert_threads | 2 |
    | Delayed_writes | 9630 |
    | Flush_commands | 1 |
    | Handler_commit | 298192 |
    | Handler_delete | 191979 |
    | Handler_discover | 0 |
    | Handler_external_lock | 13118022 |
    | Handler_mrr_init | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 354051 |
    | Handler_read_key | 56326412 |
    | Handler_read_last | 2895 |
    | Handler_read_next | 161701177 |
    | Handler_read_prev | 6345641 |
    | Handler_read_rnd | 14816254 |
    | Handler_read_rnd_next | 215545508 |
    | Handler_rollback | 10 |
    | Handler_savepoint | 43 |
    | Handler_savepoint_rollback | 36 |
    | Handler_update | 938767 |
    | Handler_write | 26701008 |
    | Innodb_buffer_pool_dump_status | not started |
    | Innodb_buffer_pool_load_status | not started |
    | Innodb_buffer_pool_pages_data | 39090 |
    | Innodb_buffer_pool_bytes_data | 640450560 |
    | Innodb_buffer_pool_pages_dirty | 37 |
    | Innodb_buffer_pool_bytes_dirty | 606208 |
    | Innodb_buffer_pool_pages_flushed | 435039 |
    | Innodb_buffer_pool_pages_free | 288203 |
    | Innodb_buffer_pool_pages_misc | 382 |
    | Innodb_buffer_pool_pages_total | 327675 |
    | Innodb_buffer_pool_read_ahead_rnd | 0 |
    | Innodb_buffer_pool_read_ahead | 5751 |
    | Innodb_buffer_pool_read_ahead_evicted | 0 |
    | Innodb_buffer_pool_read_requests | 36920564 |
    | Innodb_buffer_pool_reads | 23767 |
    | Innodb_buffer_pool_wait_free | 0 |
    | Innodb_buffer_pool_write_requests | 2045435 |
    | Innodb_data_fsyncs | 340018 |
    | Innodb_data_pending_fsyncs | 0 |
    | Innodb_data_pending_reads | 0 |
    | Innodb_data_pending_writes | 0 |
    | Innodb_data_read | 528027648 |
    | Innodb_data_reads | 36511 |
    | Innodb_data_writes | 655455 |
    | Innodb_data_written | 7494143488 |
    | Innodb_dblwr_pages_written | 0 |
    | Innodb_dblwr_writes | 0 |
    | Innodb_have_atomic_builtins | ON |
    | Innodb_log_waits | 0 |
    | Innodb_log_write_requests | 695781 |
    | Innodb_log_writes | 194404 |
    | Innodb_os_log_fsyncs | 215562 |
    | Innodb_os_log_pending_fsyncs | 0 |
    | Innodb_os_log_pending_writes | 0 |
    | Innodb_os_log_written | 355868672 |
    | Innodb_page_size | 16384 |
    | Innodb_pages_created | 7184 |
    | Innodb_pages_read | 31967 |
    | Innodb_pages_written | 435039 |
    | Innodb_row_lock_current_waits | 0 |
    | Innodb_row_lock_time | 111874 |
    | Innodb_row_lock_time_avg | 372 |
    | Innodb_row_lock_time_max | 25433 |
    | Innodb_row_lock_waits | 300 |
    | Innodb_rows_deleted | 23414 |
    | Innodb_rows_inserted | 38962 |
    | Innodb_rows_read | 28575746 |
    | Innodb_rows_updated | 98040 |
    | Innodb_num_open_files | 2192 |
    | Innodb_truncated_status_writes | 0 |
    | Innodb_available_undo_logs | 128 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 1511096 |
    | Key_blocks_used | 206924 |
    | Key_read_requests | 177655495 |
    | Key_reads | 207168 |
    | Key_write_requests | 3998612 |
    | Key_writes | 1302743 |
    | Last_query_cost | 0.000000 |
    | Last_query_partial_plans | 0 |
    | Max_used_connections | 26 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 17629 |
    | Open_streams | 0 |
    | Open_table_definitions | 8179 |
    | Open_tables | 16252 |
    | Opened_files | 705645 |
    | Opened_table_definitions | 11443 |
    | Opened_tables | 19612 |
    | Performance_schema_accounts_lost | 0 |
    | Performance_schema_cond_classes_lost | 0 |
    | Performance_schema_cond_instances_lost | 0 |
    | Performance_schema_digest_lost | 0 |
    | Performance_schema_file_classes_lost | 0 |
    | Performance_schema_file_handles_lost | 0 |
    | Performance_schema_file_instances_lost | 0 |
    | Performance_schema_hosts_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_session_connect_attrs_lost | 0 |
    | Performance_schema_socket_classes_lost | 0 |
    | Performance_schema_socket_instances_lost | 0 |
    | Performance_schema_stage_classes_lost | 0 |
    | Performance_schema_statement_classes_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 |
    | Performance_schema_users_lost | 0 |
    | Prepared_stmt_count | 1 |
    | Qcache_free_blocks | 414 |
    | Qcache_free_memory | 104282840 |
    | Qcache_hits | 5172998 |
    | Qcache_inserts | 1085215 |
    | Qcache_lowmem_prunes | 742015 |
    | Qcache_not_cached | 62891 |
    | Qcache_queries_in_cache | 2224 |
    | Qcache_total_blocks | 5239 |
    | Queries | 10221173 |
    | Questions | 10042201 |
    | Select_full_join | 23816 |
    | Select_full_range_join | 4 |
    | Select_range | 141376 |
    | Select_range_check | 1576 |
    | Select_scan | 284762 |
    | Slave_heartbeat_period | |
    | Slave_last_heartbeat | |
    | Slave_open_temp_tables | 0 |
    | Slave_received_heartbeats | |
    | Slave_retried_transactions | |
    | Slave_running | OFF |
    | Slow_launch_threads | 0 |
    | Slow_queries | 184 |
    | Sort_merge_passes | 0 |
    | Sort_range | 140871 |
    | Sort_rows | 15928237 |
    | Sort_scan | 109203 |
    | 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_server_not_after | |
    | Ssl_server_not_before | |
    | 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 | 6549377 |
    | Table_locks_waited | 3470 |
    | Table_open_cache_hits | 6864304 |
    | Table_open_cache_misses | 17092 |
    | Table_open_cache_overflows | 0 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 0 |
    | Tc_log_page_waits | 0 |
    | Threads_cached | 22 |
    | Threads_connected | 4 |
    | Threads_created | 26 |
    | Threads_running | 1 |
    | Uptime | 102736 |
    | Uptime_since_flush_status | 102736 |
    +-----------------------------------------------+-------------+
    +--------+-----------+-----------+---------------+----------------+------+--------------------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+-----------+-----------+---------------+----------------+------+--------------------+------------------+
    | 61 | DELAYED | localhost | eximstats | Delayed insert | 57 | Waiting for INSERT | |
    | 172627 | DELAYED | localhost | eximstats | Delayed insert | 6 | Waiting for INSERT | |
    | 175443 | eximstats | localhost | eximstats | Sleep | 6 | | |
    | 175762 | user138 | localhost | user138_trend | Sleep | 0 | | |
    | 175805 | root | localhost | billmgr | Sleep | 2 | | |
    | 175818 | root | localhost | | Query | 0 | init | show processlist |
    +--------+-----------+-----------+---------------+----------------+------+--------------------+------------------+
    
    ----------------------------
    MySQL Error Log
    ----------------------------
    
    2014-02-27 10:17:25 2721 [Warning] Host name 'static.doratelekom.com' could not be resolved: Name or service not known
    2014-02-27 10:17:25 2721 [Warning] IP address '179.43.128.240' could not be resolved: Name or service not known
    2014-02-27 10:17:25 2721 [Warning] IP address '77.221.140.163' has been resolved to the host name '77.221.140.163.addr.datapoint.ru', which resembles IPv4-address itself.
    2014-02-27 10:17:25 2721 [Warning] IP address '92.46.52.126' could not be resolved: Name or service not known
    2014-02-27 10:17:25 2721 [Warning] Hostname 'dns1.hostingcentar.com' does not resolve to '217.14.208.54'.
    2014-02-27 10:17:25 2721 [Note] Hostname 'dns1.hostingcentar.com' has the following IP addresses:
    2014-02-27 10:17:25 2721 [Note]  - 212.92.219.20
    2014-02-27 10:17:27 2721 [Warning] Hostname '111-118-190-139.Noida.Datacenter.Terapeer.com' does not resolve to '111.118.183.139'.
    2014-02-27 10:17:27 2721 [Note] Hostname '111-118-190-139.Noida.Datacenter.Terapeer.com' has the following IP addresses:
    2014-02-27 10:17:27 2721 [Note]  - 111.118.190.139
    2014-02-27 10:17:27 2721 [Warning] IP address '93.158.201.149' could not be resolved: Name or service not known
    2014-02-27 10:17:28 2721 [Warning] IP address '23.229.114.180' could not be resolved: Name or service not known
    2014-02-27 10:17:28 2721 [Warning] IP address '124.217.249.254' could not be resolved: Name or service not known
    2014-02-27 10:17:28 2721 [Warning] Host name '.' could not be resolved: No address associated with hostname
    2014-02-27 11:17:52 2721 [Warning] IP address '121.187.191.60' could not be resolved: Name or service not known
    
    Report Complete:
    Thu Feb 27 11:39:24 CET 2014
    
     
  6. nyanhost

    nyanhost Active Member

    Joined:
    Nov 4, 2013
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I don't have such delays if used MySQL "Source distribution version" in another host...
    Maybe I can exchange it?
     
    #6 nyanhost, Mar 1, 2014
    Last edited: Mar 1, 2014
  7. nyanhost

    nyanhost Active Member

    Joined:
    Nov 4, 2013
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    top: sensor %wa up to 20% for php script: 500 time CREATE TABLE :(

    iostat
    Code:
    avg-cpu:  %user   %nice %system %iowait  %steal   %idle
               2.28    0.19    1.17    5.90    0.00   90.47
    
    Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
    sdb             158.53     12915.90      4035.46 5608223820 1752241823
    sda             174.25     16609.04      1562.61 7211824402  678500391
    md0               0.29         0.43         1.89     186040     822696
    md2             187.72      1344.51      1320.04  583800556  573174712
    md3              50.33       668.30       238.40  290183250  103515536
    md1               0.05         0.00         0.10       1816      43056
    
    
    md3 - software raid1, mount`/home`
    md2 - software raid1, mount`/` (MySQL Databases)


    iotop
    Code:
    515 be/3 root        0.00 B/s   11.40 K/s  0.00 % 24.05 % [jbd2/md2-8]
    
    10-70%
     
    #7 nyanhost, Mar 3, 2014
    Last edited: Mar 3, 2014
  8. nyanhost

    nyanhost Active Member

    Joined:
    Nov 4, 2013
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Okay. I know reason for it now...

    iotop:
    Code:
    1137 be/4 root        0.00 B/s   74.34 K/s  0.00 % 25.83 % [kjournald]
      517 be/3 root        0.00 B/s    3.91 K/s  0.00 % 15.88 % [jbd2/md2-8]
     1136 be/0 root        0.00 B/s  645.55 K/s  0.00 %  9.14 % [loop0]
    
    Guys, How I can disable journaling without reboot my server?
     
  9. nyanhost

    nyanhost Active Member

    Joined:
    Nov 4, 2013
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Solved. I disabled journaling.

    Code:
    mysql> CREATE TABLE Meme8 ( maiy CHAR(20)) ENGINE=InnoDB;
    Query OK, 0 rows affected (0.04 sec)
    
    mysql> CREATE TABLE Meme9 ( maiy CHAR(20)) ENGINE=InnoDB;
    Query OK, 0 rows affected (0.04 sec)
    
    mysql> CREATE TABLE Meme10 ( maiy CHAR(20)) ENGINE=InnoDB;
    Query OK, 0 rows affected (0.08 sec)
    
    mysql> CREATE TABLE Meme11 ( maiy CHAR(20)) ENGINE=InnoDB;
    Query OK, 0 rows affected (0.05 sec)
    
    mysql> CREATE TABLE Meme12 ( maiy CHAR(20)) ENGINE=InnoDB;
    Query OK, 0 rows affected (0.04 sec)
    Code:
    
    mysql> CREATE TABLE MyI1 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.02 sec)
    
    mysql> CREATE TABLE MyI2 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> CREATE TABLE MyI3 ( maiy CHAR(20)) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.03 sec)
    
    
    
     
  10. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Glad to hear the issue is solved. Thank you for updating this thread with the outcome.
     
Loading...

Share This Page