Very slow MySQL CREATE TABLE
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...
MyISAM ~0.10 sec. average:
Configuration file: /etc/my.cnf
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?
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:
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
[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?
-
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. 0 -
Hello! Thank you ./mysqlmymonlite.sh run:confused: ------------------------------------------------------------- System MySQL monitoring stats mysqlmymonlite.sh - 0.5.2 WHM mysqlmymon.com compiled by George Liu (eva2000) vbtechsupport.com ------------------------------------------------------------- Report Generated: Tue Feb 25 23:31:56 CET 2014 ---------------------------- MySQL Uptime: ---------------------------- MySQL server was started 2014-02-25 23:20:10.000000 Uptime: 11 min 46 sec Uptime 706 Uptime_since_flush_status 706 Max Used Connections: 10/100 (10.00%) Key Buffer Used: 23.03M/2.00G (1.12%) Current Key Buffer Usage: 396.48M (19.36%) Query Cache: 19.45M/128.00M (15.19%) Table Locks Waited: 0 Rate: 0/s (0.00%) -------------------- Query Cache Limit (bytes): 2097152 Query Cache Min Unit (bytes): 524288 Query Cache Size (bytes): 134217728 Query Cache Free Mem (bytes): 113813688 Query Cache Used Mem (bytes): 20404040 Queries in Query Cache: 1 Query Cache Avg Size (bytes): 20404040 ---------------------------- Hardware Info: ---------------------------- Processors physical = 1, cores = 4, virtual = 8, hyperthreading = yes 5 1600.000 1 2800.000 1 3000.000 1 3401.000 8 Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz 8 8192 KB ---------------------------- TOP stats ---------------------------- Linux 2.6.32-431.3.1.el6.x86_64 ((yourserverhostname)) 02/25/2014 _x86_64_ (8 CPU) 11:31:56 PM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle 11:31:58 PM all 1.07 0.00 0.82 23.15 0.00 0.06 0.00 0.00 74.91 11:31:58 PM 0 2.04 0.00 2.04 88.27 0.00 0.51 0.00 0.00 7.14 11:31:58 PM 1 2.02 0.00 2.02 72.22 0.00 0.00 0.00 0.00 23.74 11:31:58 PM 2 0.50 0.00 0.50 3.00 0.00 0.00 0.00 0.00 96.00 11:31:58 PM 3 0.50 0.00 0.50 12.50 0.00 0.00 0.00 0.00 86.50 11:31:58 PM 4 3.00 0.00 1.50 1.00 0.00 0.00 0.00 0.00 94.50 11:31:58 PM 5 0.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 99.50 11:31:58 PM 6 0.50 0.00 0.00 9.50 0.00 0.00 0.00 0.00 90.00 11:31:58 PM 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 11:31:58 PM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle 11:32:00 PM all 0.56 0.00 0.31 29.34 0.00 0.00 0.00 0.00 69.78 11:32:00 PM 0 2.53 0.00 1.52 91.92 0.00 0.00 0.00 0.00 4.04 11:32:00 PM 1 1.00 0.00 1.00 79.60 0.00 0.00 0.00 0.00 18.41 11:32:00 PM 2 0.00 0.00 0.00 19.10 0.00 0.00 0.00 0.00 80.90 11:32:00 PM 3 0.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 99.50 11:32:00 PM 4 0.50 0.00 0.00 25.50 0.00 0.00 0.00 0.00 74.00 11:32:00 PM 5 0.00 0.00 0.00 0.50 0.00 0.00 0.00 0.00 99.50 11:32:00 PM 6 0.00 0.00 0.50 18.09 0.00 0.00 0.00 0.00 81.41 11:32:00 PM 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle Average: all 0.82 0.00 0.56 26.25 0.00 0.03 0.00 0.00 72.34 Average: 0 2.28 0.00 1.78 90.10 0.00 0.25 0.00 0.00 5.58 Average: 1 1.50 0.00 1.50 75.94 0.00 0.00 0.00 0.00 21.05 Average: 2 0.25 0.00 0.25 11.03 0.00 0.00 0.00 0.00 88.47 Average: 3 0.50 0.00 0.25 6.25 0.00 0.00 0.00 0.00 93.00 Average: 4 1.75 0.00 0.75 13.25 0.00 0.00 0.00 0.00 84.25 Average: 5 0.25 0.00 0.00 0.25 0.00 0.00 0.00 0.00 99.50 Average: 6 0.25 0.00 0.25 13.78 0.00 0.00 0.00 0.00 85.71 Average: 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 top - 23:32:01 up 8 days, 4:36, 1 user, load average: 1.18, 1.48, 1.71 Tasks: 241 total, 1 running, 236 sleeping, 4 stopped, 0 zombie Cpu(s): 1.6%us, 0.6%sy, 0.1%ni, 95.1%id, 2.6%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 16016076k total, 5667556k used, 10348520k free, 127000k buffers Swap: 33554296k total, 42168k used, 33512128k free, 1102304k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 32005 user294 20 0 450m 71m 26m D 7.9 0.5 0:06.31 httpd 740 mysql 20 0 10.7g 2.9g 8672 S 2.0 18.8 0:27.79 mysqld 3893 user138 20 0 379m 15m 9636 S 2.0 0.1 0:00.22 php 3976 root 20 0 148m 12m 796 D 2.0 0.1 0:00.24 lfd - checking 16949 nobody 20 0 450m 72m 26m S 2.0 0.5 0:16.06 httpd 17842 nobody 20 0 448m 69m 26m S 2.0 0.4 0:11.57 httpd 1 root 20 0 19232 1052 860 S 0.0 0.0 0:04.88 init 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd 3 root RT 0 0 0 0 S 0.0 0.0 0:03.10 migration/0 4 root 20 0 0 0 0 S 0.0 0.0 0:17.57 ksoftirqd/0 5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0 6 root RT 0 0 0 0 S 0.0 0.0 0:00.64 watchdog/0 7 root RT 0 0 0 0 S 0.0 0.0 0:02.43 migration/1 8 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1 9 root 20 0 0 0 0 S 0.0 0.0 0:02.82 ksoftirqd/1 10 root RT 0 0 0 0 S 0.0 0.0 0:00.46 watchdog/1 11 root RT 0 0 0 0 S 0.0 0.0 0:00.88 migration/2 12 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/2 13 root 20 0 0 0 0 S 0.0 0.0 0:02.85 ksoftirqd/2 14 root RT 0 0 0 0 S 0.0 0.0 0:00.48 watchdog/2 15 root RT 0 0 0 0 S 0.0 0.0 0:00.57 migration/3 16 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/3 17 root 20 0 0 0 0 S 0.0 0.0 0:03.01 ksoftirqd/3 18 root RT 0 0 0 0 S 0.0 0.0 0:00.47 watchdog/3 19 root RT 0 0 0 0 S 0.0 0.0 0:06.34 migration/4 20 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/4 21 root 20 0 0 0 0 S 0.0 0.0 0:04.96 ksoftirqd/4 22 root RT 0 0 0 0 S 0.0 0.0 0:00.50 watchdog/4 23 root RT 0 0 0 0 S 0.0 0.0 0:02.91 migration/5 24 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/5 25 root 20 0 0 0 0 S 0.0 0.0 0:01.79 ksoftirqd/5 26 root RT 0 0 0 0 S 0.0 0.0 0:00.49 watchdog/5 27 root RT 0 0 0 0 S 0.0 0.0 0:01.55 migration/6 28 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/6 29 root 20 0 0 0 0 S 0.0 0.0 0:03.50 ksoftirqd/6 30 root RT 0 0 0 0 S 0.0 0.0 0:00.47 watchdog/6 31 root RT 0 0 0 0 S 0.0 0.0 0:01.33 migration/7 32 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/7 33 root 20 0 0 0 0 S 0.0 0.0 0:02.83 ksoftirqd/7 34 root RT 0 0 0 0 S 0.0 0.0 0:00.47 watchdog/7 35 root 20 0 0 0 0 S 0.0 0.0 0:30.68 events/0 36 root 20 0 0 0 0 S 0.0 0.0 0:26.43 events/1 37 root 20 0 0 0 0 S 0.0 0.0 0:19.09 events/2 38 root 20 0 0 0 0 S 0.0 0.0 0:16.66 events/3 39 root 20 0 0 0 0 S 0.0 0.0 0:20.51 events/4 40 root 20 0 0 0 0 S 0.0 0.0 0:23.32 events/5 41 root 20 0 0 0 0 S 0.0 0.0 0:27.43 events/6 42 root 20 0 0 0 0 S 0.0 0.0 0:26.39 events/7 43 root 20 0 0 0 0 S 0.0 0.0 0:00.00 cgroup 44 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khelper 45 root 20 0 0 0 0 S 0.0 0.0 0:00.00 netns 46 root 20 0 0 0 0 S 0.0 0.0 0:00.00 async/mgr 47 root 20 0 0 0 0 S 0.0 0.0 0:00.00 pm 48 root 20 0 0 0 0 S 0.0 0.0 0:04.72 sync_supers 49 root 20 0 0 0 0 S 0.0 0.0 0:01.98 bdi-default 50 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kintegrityd/0 51 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kintegrityd/1 52 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kintegrityd/2 53 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kintegrityd/3 54 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kintegrityd/4 55 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kintegrityd/5 56 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kintegrityd/6 57 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kintegrityd/7 58 root 20 0 0 0 0 S 0.0 0.0 7:45.74 kblockd/0 59 root 20 0 0 0 0 S 0.0 0.0 0:00.23 kblockd/1 60 root 20 0 0 0 0 S 0.0 0.0 0:00.10 kblockd/2 61 root 20 0 0 0 0 S 0.0 0.0 0:00.07 kblockd/3 62 root 20 0 0 0 0 S 0.0 0.0 0:00.77 kblockd/4 63 root 20 0 0 0 0 S 0.0 0.0 0:00.12 kblockd/5 64 root 20 0 0 0 0 S 0.0 0.0 0:00.07 kblockd/6 65 root 20 0 0 0 0 S 0.0 0.0 0:00.03 kblockd/7 66 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kacpid 67 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kacpi_notify 68 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kacpi_hotplug 69 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_aux 70 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_sff/0 71 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_sff/1 72 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_sff/2 73 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_sff/3 74 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_sff/4 75 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_sff/5 76 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_sff/6 77 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ata_sff/7 78 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ksuspend_usbd 79 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khubd 80 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kseriod 81 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md/0 82 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md/1 83 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md/2 84 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md/3 85 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md/4 86 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md/5 87 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md/6 88 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md/7 89 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md_misc/0 90 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md_misc/1 91 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md_misc/2 92 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md_misc/3 93 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md_misc/4 94 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md_misc/5 95 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md_misc/6 96 root 20 0 0 0 0 S 0.0 0.0 0:00.00 md_misc/7 97 root 20 0 0 0 0 S 0.0 0.0 0:00.00 linkwatch 98 root 20 0 0 0 0 S 0.0 0.0 0:00.53 khungtaskd 99 root 20 0 0 0 0 S 0.0 0.0 0:28.87 kswapd0 100 root 25 5 0 0 0 S 0.0 0.0 0:00.00 ksmd 101 root 39 19 0 0 0 S 0.0 0.0 0:24.52 khugepaged 102 root 20 0 0 0 0 S 0.0 0.0 0:00.00 aio/0 103 root 20 0 0 0 0 S 0.0 0.0 0:00.00 aio/1 104 root 20 0 0 0 0 S 0.0 0.0 0:00.00 aio/2 105 root 20 0 0 0 0 S 0.0 0.0 0:00.00 aio/3 106 root 20 0 0 0 0 S 0.0 0.0 0:00.00 aio/4 107 root 20 0 0 0 0 S 0.0 0.0 0:00.00 aio/5 108 root 20 0 0 0 0 S 0.0 0.0 0:00.00 aio/6 109 root 20 0 0 0 0 S 0.0 0.0 0:00.00 aio/7 110 root 20 0 0 0 0 S 0.0 0.0 0:00.00 crypto/0 111 root 20 0 0 0 0 S 0.0 0.0 0:00.00 crypto/1 112 root 20 0 0 0 0 S 0.0 0.0 0:00.00 crypto/2 113 root 20 0 0 0 0 S 0.0 0.0 0:00.00 crypto/3 114 root 20 0 0 0 0 S 0.0 0.0 0:00.00 crypto/4 115 root 20 0 0 0 0 S 0.0 0.0 0:00.00 crypto/5 116 root 20 0 0 0 0 S 0.0 0.0 0:00.00 crypto/6 117 root 20 0 0 0 0 S 0.0 0.0 0:00.00 crypto/7 122 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthrotld/0 123 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthrotld/1 124 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthrotld/2 125 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthrotld/3 126 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthrotld/4 127 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthrotld/5 128 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthrotld/6 129 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthrotld/7 131 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kpsmoused 132 root 20 0 0 0 0 S 0.0 0.0 0:00.00 usbhid_resumer 162 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kstriped 342 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0 343 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1 344 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_2 345 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_3 346 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_4 347 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_5 469 root 20 0 0 0 0 S 0.0 0.0 22:42.53 md2_raid1 474 root 20 0 0 0 0 S 0.0 0.0 0:00.84 md1_raid1 480 root 20 0 0 0 0 S 0.0 0.0 62:40.81 md3_raid1 487 root 20 0 0 0 0 S 0.0 0.0 1:54.07 md0_raid1 515 root 20 0 0 0 0 S 0.0 0.0 3:49.37 jbd2/md2-8 516 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ext4-dio-unwrit 591 root 16 -4 10672 484 320 S 0.0 0.0 0:00.15 udevd 889 root 20 0 0 0 0 S 0.0 0.0 1:28.38 flush-9:2 929 root 20 0 0 0 0 S 0.0 0.0 5:44.35 kondemand/0 930 root 20 0 0 0 0 S 0.0 0.0 1:12.33 kondemand/1 931 root 20 0 0 0 0 S 0.0 0.0 0:41.40 kondemand/2 932 root 20 0 0 0 0 S 0.0 0.0 0:30.69 kondemand/3 933 root 20 0 0 0 0 S 0.0 0.0 3:46.78 kondemand/4 934 root 20 0 0 0 0 S 0.0 0.0 0:47.09 kondemand/5 935 root 20 0 0 0 0 S 0.0 0.0 0:33.31 kondemand/6 936 root 20 0 0 0 0 S 0.0 0.0 0:25.46 kondemand/7 970 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kjournald 971 root 20 0 0 0 0 S 0.0 0.0 0:32.98 jbd2/md3-8 972 root 20 0 0 0 0 S 0.0 0.0 0:00.00 ext4-dio-unwrit 1083 root 20 0 0 0 0 S 0.0 0.0 0:04.54 kauditd 1113 root 0 -20 0 0 0 D 0.0 0.0 3:04.45 loop0 1114 root 20 0 0 0 0 S 0.0 0.0 0:31.22 kjournald 1245 root 20 0 0 0 0 S 0.0 0.0 0:14.26 flush-7:0 1247 root 20 0 0 0 0 S 0.0 0.0 0:57.77 flush-9:3 1347 root 16 -4 93200 736 560 S 0.0 0.0 0:17.20 auditd 1404 root 20 0 148m 12m 1308 S 0.0 0.1 0:43.48 lfd - sleeping 1455 root 20 0 243m 4784 840 S 0.0 0.0 0:55.56 rsyslogd 1469 named 20 0 689m 96m 2800 S 0.0 0.6 3:32.02 named 2134 root 20 0 4080 472 468 S 0.0 0.0 0:00.00 acpid 2170 root 20 0 66608 532 444 S 0.0 0.0 0:00.00 sshd 2271 nobody 20 0 453m 72m 25m S 0.0 0.5 0:03.00 httpd 2316 root 20 0 138m 1448 1084 T 0.0 0.0 0:00.00 crontab 2317 root 20 0 116m 1736 1392 T 0.0 0.0 0:00.00 vi 2385 root 20 0 138m 1448 1084 T 0.0 0.0 0:00.00 crontab 2392 root 20 0 116m 1724 1384 T 0.0 0.0 0:00.00 vi 2848 root 20 0 114m 1108 648 S 0.0 0.0 0:27.89 crond 2859 root 20 0 21540 420 368 S 0.0 0.0 0:00.00 atd 2938 root 20 0 98876 18m 5796 S 0.0 0.1 0:29.72 cpsrvd-ssl 3069 dovecot 20 0 29428 1916 1420 S 0.0 0.0 0:00.00 auth 3083 root 20 0 39620 1096 1056 S 0.0 0.0 0:00.00 ihttpd 3094 root 20 0 4064 488 484 S 0.0 0.0 0:00.00 mingetty 3096 root 20 0 4064 488 484 S 0.0 0.0 0:00.00 mingetty 3098 root 20 0 4064 488 484 S 0.0 0.0 0:00.00 mingetty 3100 root 20 0 4064 488 484 S 0.0 0.0 0:00.00 mingetty 3102 root 20 0 4064 488 484 S 0.0 0.0 0:00.00 mingetty 3104 root 20 0 4064 488 484 S 0.0 0.0 0:00.00 mingetty 3876 root 20 0 138m 1672 1012 S 0.0 0.0 0:00.00 crond 3877 root 20 0 138m 1668 1012 S 0.0 0.0 0:00.00 crond 3882 root 20 0 6184 820 648 S 0.0 0.0 0:00.00 jailshell 3884 root 20 0 6184 820 648 S 0.0 0.0 0:00.00 jailshell 3890 user138 20 0 6184 412 240 S 0.0 0.0 0:00.00 jailshell 3891 user138 20 0 410m 14m 8888 S 0.0 0.1 0:00.04 php 3892 user138 20 0 6184 412 240 S 0.0 0.0 0:00.00 jailshell 3978 root 20 0 104m 1976 1228 S 0.0 0.0 0:00.01 mysqlmymonlite. 4166 root 20 0 15024 1288 880 R 0.0 0.0 0:00.00 top 5240 root 20 0 36272 3564 1428 S 0.0 0.0 0:03.25 queueprocd - wa 5312 root 20 0 71492 3068 2588 S 0.0 0.0 0:03.96 cPhulkd - proce 5348 root 20 0 110m 2816 660 S 0.0 0.0 0:00.96 cpdavd - accept 5349 root 38 18 27252 2592 1164 S 0.0 0.0 0:00.73 cpanellogd - sl 5416 root 20 0 19596 1116 820 S 0.0 0.0 0:00.43 dovecot 5420 dovenull 20 0 42464 3596 2692 S 0.0 0.0 0:01.65 pop3-login 5421 dovenull 20 0 42356 3516 2692 S 0.0 0.0 0:00.19 imap-login 5422 dovecot 20 0 13300 1120 932 S 0.0 0.0 0:00.14 anvil 5423 root 20 0 13432 1300 968 S 0.0 0.0 0:00.17 log 5425 dovenull 20 0 42340 3448 2648 S 0.0 0.0 0:00.01 pop3-login 5426 dovenull 20 0 42480 3592 2700 S 0.0 0.0 0:00.25 imap-login 5427 root 20 0 16408 2104 1100 S 0.0 0.0 0:00.37 config 5463 root 18 -2 10668 380 196 S 0.0 0.0 0:00.00 udevd 5533 root 20 0 585m 249m 1848 S 0.0 1.6 3:09.43 clamd 5540 mailnull 20 0 71536 2984 704 S 0.0 0.0 0:01.98 exim 5558 root 20 0 161m 49m 3032 S 0.0 0.3 0:12.47 /usr/local/cpan 5575 root 20 0 161m 48m 1156 S 0.0 0.3 0:00.06 spamd child 5576 root 20 0 161m 48m 1156 S 0.0 0.3 0:00.08 spamd child 7002 root 20 0 135m 2084 1380 S 0.0 0.0 0:00.19 pure-ftpd 7004 root 20 0 133m 1792 1308 S 0.0 0.0 0:00.13 pure-authd 12714 root 20 0 79524 9676 1644 S 0.0 0.1 0:28.39 tailwatchd 14301 root 20 0 326m 31m 10m S 0.0 0.2 0:25.61 httpd 15969 nobody 20 0 458m 86m 33m S 0.0 0.6 0:21.24 httpd 17704 root 20 0 19404 1524 1180 S 0.0 0.0 0:00.00 ssl-params 22628 root 20 0 82032 33m 352 S 0.0 0.2 0:00.00 nginx 22629 nobody 20 0 85032 37m 952 S 0.0 0.2 0:05.91 nginx 22630 nobody 20 0 85104 37m 956 S 0.0 0.2 0:08.13 nginx 22631 nobody 20 0 84968 37m 952 S 0.0 0.2 0:04.76 nginx 22632 nobody 20 0 85096 37m 952 S 0.0 0.2 0:05.48 nginx 22633 nobody 20 0 84888 37m 948 S 0.0 0.2 0:04.33 nginx 22634 nobody 20 0 84888 37m 952 S 0.0 0.2 0:06.02 nginx 22637 nobody 20 0 84816 37m 948 S 0.0 0.2 0:04.47 nginx 22638 nobody 20 0 84840 37m 952 S 0.0 0.2 0:05.50 nginx 22639 nobody 20 0 82032 33m 516 S 0.0 0.2 0:00.02 nginx 22756 root 20 0 1972 1036 472 S 0.0 0.0 0:01.03 splitlogs 22757 root 20 0 1984 1052 472 S 0.0 0.0 0:01.11 splitlogs 22767 root 20 0 79900 10m 2948 S 0.0 0.1 0:00.04 leechprotect 23516 nobody 20 0 448m 69m 26m S 0.0 0.4 0:09.67 httpd 24014 nobody 20 0 449m 76m 32m S 0.0 0.5 0:09.52 httpd 24624 root 20 0 100m 3984 2956 S 0.0 0.0 0:00.83 sshd 24630 root 20 0 105m 2012 1532 S 0.0 0.0 0:01.34 bash 25255 root 20 0 619m 189m 7536 S 0.0 1.2 1:52.17 billmgr 30015 nobody 20 0 454m 74m 25m S 0.0 0.5 0:06.25 httpd 32004 nobody 20 0 454m 74m 25m S 0.0 0.5 0:06.59 httpd 32066 nobody 20 0 445m 64m 24m S 0.0 0.4 0:04.17 httpd 32459 root 20 0 103m 1524 1240 S 0.0 0.0 0:00.04 mysqld_safe total used free shared buffers cached Mem: 15640 5534 10105 0 124 1076 Low: 15640 5534 10105 High: 0 0 0 -/+ buffers/cache: 4334 11306 Swap: 32767 41 32726 MemTotal: 16016076 kB MemFree: 10348396 kB Buffers: 127000 kB Cached: 1102304 kB SwapCached: 28760 kB Active: 4652552 kB Inactive: 693628 kB Active(anon): 4098184 kB Inactive(anon): 52016 kB Active(file): 554368 kB Inactive(file): 641612 kB Unevictable: 0 kB Mlocked: 0 kB SwapTotal: 33554296 kB SwapFree: 33512128 kB Dirty: 1768 kB Writeback: 0 kB AnonPages: 4089500 kB Mapped: 70168 kB Shmem: 33028 kB Slab: 149980 kB SReclaimable: 79596 kB SUnreclaim: 70384 kB KernelStack: 2376 kB PageTables: 22936 kB NFS_Unstable: 0 kB Bounce: 0 kB WritebackTmp: 0 kB CommitLimit: 41562332 kB Committed_AS: 11798192 kB VmallocTotal: 34359738367 kB VmallocUsed: 115296 kB VmallocChunk: 34359527432 kB HardwareCorrupted: 0 kB AnonHugePages: 3217408 kB HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB DirectMap4k: 6144 kB DirectMap2M: 16474112 kB -------------------------- ps_mem.py output: http://www.pixelbeat.org/scripts/ps_mem.py -------------------------- Private + Shared = RAM used Program 4.0 KiB + 17.5 KiB = 21.5 KiB acpid 68.0 KiB + 32.5 KiB = 100.5 KiB atd 24.0 KiB + 93.0 KiB = 117.0 KiB mingetty (6) 200.0 KiB + 60.0 KiB = 260.0 KiB anvil 248.0 KiB + 35.0 KiB = 283.0 KiB auditd 64.0 KiB + 221.5 KiB = 285.5 KiB ihttpd 148.0 KiB + 140.5 KiB = 288.5 KiB udevd (2) 272.0 KiB + 40.0 KiB = 312.0 KiB init 344.0 KiB + 62.0 KiB = 406.0 KiB log 352.0 KiB + 56.5 KiB = 408.5 KiB dovecot 356.0 KiB + 76.5 KiB = 432.5 KiB ssl-params 296.0 KiB + 202.0 KiB = 498.0 KiB mysqld_safe 248.0 KiB + 302.0 KiB = 550.0 KiB jailshell (4) 492.0 KiB + 82.0 KiB = 574.0 KiB pure-authd 480.0 KiB + 315.0 KiB = 795.0 KiB cPhulkd - proce 608.0 KiB + 225.0 KiB = 833.0 KiB bash 772.0 KiB + 99.0 KiB = 871.0 KiB pure-ftpd 784.0 KiB + 100.0 KiB = 884.0 KiB auth 728.0 KiB + 206.0 KiB = 934.0 KiB crontab (2) 752.0 KiB + 200.0 KiB = 952.0 KiB mysqlmymonlite. 1.0 MiB + 72.0 KiB = 1.1 MiB config 720.0 KiB + 423.5 KiB = 1.1 MiB crond (3) 692.0 KiB + 644.0 KiB = 1.3 MiB vi (2) 1.4 MiB + 115.5 KiB = 1.5 MiB cpanellogd - sl 1.1 MiB + 480.0 KiB = 1.6 MiB splitlogs (2) 1.7 MiB + 367.0 KiB = 2.0 MiB sshd (2) 1.7 MiB + 429.0 KiB = 2.1 MiB pop3-login (2) 1.7 MiB + 442.0 KiB = 2.1 MiB imap-login (2) 2.1 MiB + 129.5 KiB = 2.2 MiB cpdavd - accept 2.2 MiB + 137.0 KiB = 2.3 MiB queueprocd - wa 2.4 MiB + 72.5 KiB = 2.5 MiB exim 4.1 MiB + 46.0 KiB = 4.1 MiB rsyslogd 1.1 MiB + 5.3 MiB = 6.4 MiB lfd - sleeping 1.4 MiB + 5.3 MiB = 6.7 MiB lfd - checking 7.5 MiB + 359.0 KiB = 7.8 MiB leechprotect 7.9 MiB + 260.5 KiB = 8.1 MiB tailwatchd 12.9 MiB + 3.2 MiB = 16.1 MiB php (2) 16.4 MiB + 174.0 KiB = 16.6 MiB cpsrvd-ssl 2.5 MiB + 15.2 MiB = 17.7 MiB /usr/local/cpan 4.6 MiB + 30.2 MiB = 34.7 MiB spamd child (2) 95.7 MiB + 119.5 KiB = 95.8 MiB named 80.3 MiB + 32.4 MiB = 112.7 MiB nginx (10) 187.8 MiB + 393.5 KiB = 188.2 MiB billmgr 248.6 MiB + 102.5 KiB = 248.7 MiB clamd 286.2 MiB + 52.1 MiB = 338.3 MiB httpd (11) 2.9 GiB + 229.5 KiB = 2.9 GiB mysqld --------------------------------- 4.0 GiB ================================= Private + Shared = RAM used Program smem -uk User Count Swap USS PSS RSS dovecot 2 0 984.0K 1.1M 3.0M mailnull 1 0 2.4M 2.4M 2.9M dovenull 4 0 3.3M 4.0M 13.8M user138 8 0 25.3M 31.0M 61.9M user294 1 292.0K 27.1M 31.2M 71.0M named 1 10.4M 95.7M 95.8M 96.8M nobody 18 2.9M 333.0M 402.9M 997.4M root 57 30.1M 512.9M 580.8M 783.9M mysql 1 0 2.9G 2.9G 2.9G smem -t -p PID User Command Swap USS PSS RSS 2134 root /usr/sbin/acpid 0.00% 0.00% 0.00% 0.00% 3094 root /sbin/mingetty /dev/tty1 0.00% 0.00% 0.00% 0.00% 3096 root /sbin/mingetty /dev/tty2 0.00% 0.00% 0.00% 0.00% 3098 root /sbin/mingetty /dev/tty3 0.00% 0.00% 0.00% 0.00% 3100 root /sbin/mingetty /dev/tty4 0.00% 0.00% 0.00% 0.00% 3102 root /sbin/mingetty /dev/tty5 0.00% 0.00% 0.00% 0.00% 3104 root /sbin/mingetty /dev/tty6 0.00% 0.00% 0.00% 0.00% 2859 root /usr/sbin/atd 0.00% 0.00% 0.00% 0.00% 591 root /sbin/udevd -d 0.00% 0.00% 0.00% 0.00% 3890 user138 jailshell (user138) [init] 0.00% 0.00% 0.00% 0.00% 4183 user138 jailshell (user138) [init] 0.00% 0.00% 0.00% 0.00% 4186 user138 jailshell (user138) [init] 0.00% 0.00% 0.00% 0.00% 3892 user138 jailshell (user138) [init] 0.00% 0.00% 0.00% 0.00% 3882 root jailshell (user138) [3890] 0.00% 0.00% 0.00% 0.01% 4174 root jailshell (user138) [4183] 0.00% 0.00% 0.00% 0.01% 4178 root jailshell (user138) [4186] 0.00% 0.00% 0.00% 0.01% 3884 root jailshell (user138) [3892] 0.00% 0.00% 0.00% 0.01% 5463 root /sbin/udevd -d 0.00% 0.00% 0.00% 0.00% 2170 root /usr/sbin/sshd 0.00% 0.00% 0.00% 0.00% 2848 root crond 0.00% 0.00% 0.00% 0.01% 5422 dovecot dovecot/anvil 0.00% 0.00% 0.00% 0.01% 3083 root /usr/local/ispmgr/sbin/ihtt 0.00% 0.00% 0.00% 0.01% 1347 root auditd 0.00% 0.00% 0.00% 0.00% 1 root /sbin/init 0.00% 0.00% 0.00% 0.01% 5416 root /usr/sbin/dovecot 0.00% 0.00% 0.00% 0.01% 5423 root dovecot/log 0.00% 0.00% 0.00% 0.01% 4170 root CROND 0.00% 0.00% 0.00% 0.01% 4171 root CROND 0.00% 0.00% 0.00% 0.01% 3877 root CROND 0.00% 0.00% 0.00% 0.01% 17704 root dovecot/ssl-params 0.00% 0.00% 0.00% 0.01% 3876 root CROND 0.00% 0.00% 0.00% 0.01% 2316 root /usr/bin/crontab -e 0.00% 0.00% 0.00% 0.01% 2385 root /usr/bin/crontab -e 0.00% 0.00% 0.00% 0.01% 32459 root /bin/sh /usr/bin/mysqld_saf 0.00% 0.00% 0.00% 0.01% 7004 root /usr/sbin/pure-authd -s /va 0.00% 0.00% 0.00% 0.01% 2392 root /bin/vi /tmp/crontab.bAr1CY 0.00% 0.00% 0.00% 0.01% 2317 root /bin/vi /tmp/crontab.wqUNGX 0.00% 0.00% 0.00% 0.01% 5312 root cPhulkd - processo 0.01% 0.00% 0.00% 0.02% 22756 root /usr/local/cpanel/bin/split 0.00% 0.00% 0.00% 0.01% 22757 root /usr/local/cpanel/bin/split 0.00% 0.00% 0.01% 0.01% 24630 root -bash 0.00% 0.00% 0.01% 0.01% 7002 root pure-ftpd (SERVER) 0.00% 0.00% 0.01% 0.01% 3069 dovecot dovecot/auth 0.00% 0.00% 0.01% 0.01% 3978 root /bin/bash ./mysqlmymonlite. 0.00% 0.00% 0.01% 0.01% 5425 dovenull dovecot/pop3-login 0.00% 0.01% 0.01% 0.02% 5421 dovenull dovecot/imap-login 0.00% 0.01% 0.01% 0.02% 5426 dovenull dovecot/imap-login 0.00% 0.01% 0.01% 0.02% 5420 dovenull dovecot/pop3-login 0.00% 0.01% 0.01% 0.02% 5427 root dovecot/config 0.00% 0.01% 0.01% 0.01% 5349 root cpanellogd - sleeping for l 0.00% 0.01% 0.01% 0.02% 24624 root sshd: root@pts/1 0.00% 0.01% 0.01% 0.02% 5348 root cpdavd - accepting connecti 0.04% 0.01% 0.01% 0.02% 5240 root queueprocd - wait to proces 0.01% 0.01% 0.01% 0.02% 5540 mailnull /usr/sbin/exim -bd -q60m 0.00% 0.02% 0.02% 0.02% 1455 root /sbin/rsyslogd -i /var/run/ 0.00% 0.03% 0.03% 0.03% 22628 root nginx: master process /usr/ 0.00% 0.01% 0.04% 0.21% 22639 nobody nginx: cache manager proces 0.00% 0.01% 0.04% 0.21% 1404 root lfd - sleepin 0.00% 0.01% 0.04% 0.08% 4191 root python /usr/bin/smem -t -p 0.00% 0.04% 0.04% 0.05% 3976 root lfd - checking directorie 0.00% 0.01% 0.04% 0.08% 4187 user138 /usr/bin/php /home/user138/ 0.00% 0.04% 0.05% 0.09% 3891 user138 /usr/bin/php /home/user138/ 0.00% 0.04% 0.05% 0.09% 22767 root /usr/local/cpanel/3rdparty/ 0.00% 0.05% 0.05% 0.07% 14301 root /usr/local/apache/bin/httpd 0.00% 0.03% 0.05% 0.20% 4184 user138 /usr/bin/php /home/user138/ 0.00% 0.04% 0.05% 0.10% 12714 root tailwatch 0.01% 0.05% 0.05% 0.06% 3893 user138 /usr/bin/php /home/user138/ 0.00% 0.04% 0.05% 0.10% 22638 nobody nginx: worker process 0.00% 0.06% 0.08% 0.24% 22633 nobody nginx: worker process 0.00% 0.06% 0.08% 0.24% 22632 nobody nginx: worker process 0.00% 0.06% 0.08% 0.24% 22629 nobody nginx: worker process 0.00% 0.06% 0.08% 0.24% 22637 nobody nginx: worker process 0.00% 0.06% 0.08% 0.24% 22634 nobody nginx: worker process 0.00% 0.06% 0.08% 0.24% 22631 nobody nginx: worker process 0.00% 0.06% 0.08% 0.24% 22630 nobody nginx: worker process 0.00% 0.06% 0.08% 0.24% 2938 root cpsrvd (SSL) - waiting for 0.00% 0.11% 0.11% 0.12% 5576 root spamd chil 0.00% 0.01% 0.11% 0.31% 5575 root spamd chil 0.00% 0.02% 0.11% 0.31% 5558 root /usr/local/cpanel/3rdparty/ 0.00% 0.02% 0.11% 0.32% 32066 nobody /usr/local/apache/bin/httpd 0.00% 0.14% 0.17% 0.42% 17842 nobody /usr/local/apache/bin/httpd 0.00% 0.16% 0.19% 0.44% 23516 nobody /usr/local/apache/bin/httpd 0.00% 0.16% 0.19% 0.45% 32005 user294 /usr/local/apache/bin/httpd 0.00% 0.17% 0.20% 0.45% 16949 nobody /usr/local/apache/bin/httpd 0.00% 0.18% 0.20% 0.46% 24014 nobody /usr/local/apache/bin/httpd 0.00% 0.17% 0.21% 0.49% 2271 nobody /usr/local/apache/bin/httpd 0.00% 0.19% 0.22% 0.47% 30015 nobody /usr/local/apache/bin/httpd 0.00% 0.20% 0.22% 0.48% 32004 nobody /usr/local/apache/bin/httpd 0.00% 0.20% 0.23% 0.48% 15969 nobody /usr/local/apache/bin/httpd 0.00% 0.23% 0.27% 0.55% 1469 named /usr/sbin/named -u named 0.03% 0.61% 0.61% 0.62% 25255 root /usr/local/ispmgr/bin/billm 0.00% 1.20% 1.20% 1.21% 5533 root /usr/local/cpanel/3rdparty/ 0.00% 1.59% 1.59% 1.60% 740 mysql /usr/sbin/mysqld --basedir= 0.00% 18.74% 18.74% 18.75% ------------------------------------------------------------------------------- 93 9 0.13% 25.13% 26.09% 31.73% smem -wk Area Used Cache Noncache firmware/hardware 0 0 0 kernel image 0 0 0 kernel dynamic memory 1.4G 1.2G 263.7M userspace memory 4.0G 69.6M 3.9G free memory 9.8G 9.8G 0 ---------------------------- Server Disk Usage ---------------------------- Filesystem Type Size Used Avail Use% Mounted on /dev/md2 ext4 504G 102G 377G 22% / tmpfs tmpfs 7.7G 0 7.7G 0% /dev/shm /dev/md1 ext3 496M 72M 399M 16% /boot /dev/md3 ext4 2.0T 25G 1.9T 2% /home /usr/tmpDSK ext3 4.0G 1.2G 2.6G 32% /tmp ---------------------------- MySQL datadir disk usage ---------------------------- /var/lib/mysql/ uses 5053156 kilobytes of disk space ---------------------------- ulimit -aH ---------------------------- core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 124984 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 4096 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 124984 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited ---------------------------------------------------------- tail -15 /etc/security/limits.conf ---------------------------------------------------------- # # 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 StartServers 5 MinSpareServers 5 MaxSpareServers 10 MinSpareServers 5 MaxSpareServers 10 ServerLimit 256 MaxClients 150 MaxRequestsPerChild 1000000 --------------- 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 20140 -
Ensure you let MySQL run for at least 24 hours before using a tuning utility such as the mysqlmymonlite.sh script. Thank you. 0 -
[quote="cPanelMichael, post: 1582411">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 [root@sv-1 centos_whm]# ./mysqlmymonlite.sh run > main.txt main.txt:------------------------------------------------------------- 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 ---------------------------------------------------------- # # 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 StartServers 5 MinSpareServers 5 MaxSpareServers 10 MinSpareServers 5 MaxSpareServers 10 ServerLimit 256 MaxClients 150 MaxRequestsPerChild 1000000 --------------- 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 20140 -
I don't have such delays if used MySQL "Source distribution version" in another host... Maybe I can exchange it? 0 -
top: sensor %wa up to 20% for php script: 500 time CREATE TABLE :( iostat 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) iotop515 be/3 root 0.00 B/s 11.40 K/s 0.00 % 24.05 % [jbd2/md2-8]
10-70%0 -
Okay. I know reason for it now... iotop: 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?0 -
Solved. I disabled journaling. 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)
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)0 -
Hello, Glad to hear the issue is solved. Thank you for updating this thread with the outcome. 0
Please sign in to leave a comment.
Comments
9 comments