Very slow MySQL CREATE TABLE

nyanhost · Feb 25, 2014

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?

cPanelMichael · Feb 25, 2014

Hello

I have moved this thread to the "Optimization" forum. You should receive more user feedback here. The following post should help you to provide us with the best possible information:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.

nyanhost · Feb 25, 2014

Hello! Thank you

./mysqlmymonlite.sh run

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: [email protected]/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

cPanelMichael · Feb 26, 2014

Ensure you let MySQL run for at least 24 hours before using a tuning utility such as the mysqlmymonlite.sh script.

Thank you.

nyanhost · Feb 27, 2014

cPanelMichael said:
Ensure you let MySQL run for at least 24 hours before using a tuning utility such as the mysqlmymonlite.sh script.

Thank you.

Okay.
Uptime now: 1 day 4 hours 31 min 59 sec
[[email protected] 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

nyanhost · Mar 1, 2014

I don't have such delays if used MySQL "Source distribution version" in another host...
Maybe I can exchange it?

nyanhost · Mar 3, 2014

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%

nyanhost · Mar 3, 2014

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?

nyanhost · Mar 7, 2014

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)

cPanelPeter · Mar 7, 2014

Hello,

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

Thread starter	Similar threads	Forum	Replies	Date
T	Wordpress Admin Very Slow	Workarounds and Optimization	3	May 11, 2020
V	Site loading very slow	Workarounds and Optimization	2	Jun 17, 2018
K	Server Very Slow (Cpu, Load Fine)	Workarounds and Optimization	1	Aug 14, 2017
M	Very slow mysql queryies	Workarounds and Optimization	5	Feb 9, 2016
C	MySQL Optimisation , its hangs , very very slow performance	Workarounds and Optimization	1	Jan 5, 2014

Search

Search

Very slow MySQL CREATE TABLE

nyanhost

Active Member

cPanelMichael

Administrator

nyanhost

Active Member

cPanelMichael

Administrator

nyanhost

Active Member

nyanhost

Active Member

nyanhost

Active Member

nyanhost

Active Member

nyanhost

Active Member

cPanelPeter

Senior Technical Analyst