Help with my cnf
Hello
Please, I need help optimize mysql purchase, all data attached.
mysqltuner.pl:
thanks
-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.0 WHM mysqlmymon.com
compiled by George Liu (eva2000) vbtechsupport.com
-------------------------------------------------------------
Report Generated:
mi"" nov 6 12:23:46 CET 2013
----------------------------
MySQL Uptime:
----------------------------
MySQL server was started 2013-10-06 10:38:43
Uptime: 31 days 2 hours 45 min 3 sec
Uptime 2688303
Uptime_since_flush_status 2688303
Max Used Connections: 152/151 (100.66%)
Key Buffer Used: 6.54M/8.00M (81.76%)
Current Key Buffer Usage: 8.00M (100.00%)
InnoDB Buffer Pool: 21.84M/127.98M (17.07%)
Table Locks Waited: 782.09k Rate: 0.3/s (0.41%)
--------------------
Query Cache Limit (bytes): 1048576
Query Cache Min Unit (bytes): 4096
Query Cache Size (bytes): 0
Query Cache Free Mem (bytes): 0
Query Cache Used Mem (bytes): 0
Queries in Query Cache: 1
Query Cache Avg Size (bytes): 0
----------------------------
Hardware Info:
----------------------------
Processors physical = 1, cores = 4, virtual = 8, hyperthreading = yes
8 2668.000
8 Intel(R) Xeon(R) CPU W3520 @ 2.67GHz
8 8192 KB
----------------------------
TOP stats
----------------------------
Linux 3.10.9-xxxx-grs-ipv6-64 ((yourserverhostname)) 06/11/13 _x86_64_ (8 CPU)
12:23:47 CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
12:23:49 all 22,97 0,00 1,13 0,38 0,00 0,00 0,00 0,00 75,53
12:23:49 0 100,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00
12:23:49 1 19,50 0,00 0,50 0,00 0,00 0,00 0,00 0,00 80,00
12:23:49 2 27,50 0,00 1,00 1,50 0,00 0,00 0,00 0,00 70,00
12:23:49 3 1,00 0,00 0,50 0,00 0,00 0,00 0,00 0,00 98,51
12:23:49 4 0,00 0,00 0,00 1,01 0,00 0,00 0,00 0,00 98,99
12:23:49 5 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 100,00
12:23:49 6 22,11 0,00 4,52 0,00 0,00 0,00 0,00 0,00 73,37
12:23:49 7 13,93 0,00 2,49 0,00 0,00 0,00 0,00 0,00 83,58
12:23:49 CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
12:23:51 all 23,75 0,00 1,50 0,00 0,00 0,00 0,00 0,00 74,75
12:23:51 0 100,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00
12:23:51 1 1,49 0,00 1,00 0,00 0,00 0,00 0,00 0,00 97,51
12:23:51 2 27,00 0,00 4,50 0,00 0,00 0,00 0,00 0,00 68,50
12:23:51 3 18,09 0,00 1,51 0,00 0,00 0,00 0,00 0,00 80,40
12:23:51 4 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 100,00
12:23:51 5 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 100,00
12:23:51 6 31,66 0,00 3,02 0,00 0,00 0,00 0,00 0,00 65,33
12:23:51 7 12,06 0,00 2,01 0,00 0,00 0,00 0,00 0,00 85,93
Media: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
Media: all 23,36 0,00 1,31 0,19 0,00 0,00 0,00 0,00 75,14
Media: 0 100,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00
Media: 1 10,47 0,00 0,75 0,00 0,00 0,00 0,00 0,00 88,78
Media: 2 27,25 0,00 2,75 0,75 0,00 0,00 0,00 0,00 69,25
Media: 3 9,50 0,00 1,00 0,00 0,00 0,00 0,00 0,00 89,50
Media: 4 0,00 0,00 0,00 0,50 0,00 0,00 0,00 0,00 99,50
Media: 5 0,00 0,00 0,00 0,00 0,00 0,00 0,00 0,00 100,00
Media: 6 26,88 0,00 3,77 0,00 0,00 0,00 0,00 0,00 69,35
Media: 7 13,00 0,00 2,25 0,00 0,00 0,00 0,00 0,00 84,75
top - 12:23:52 up 31 days, 17:33, 1 user, load average: 1.58, 1.34, 1.43
Tasks: 206 total, 3 running, 202 sleeping, 0 stopped, 1 zombie
Cpu(s): 18.5%us, 1.5%sy, 0.1%ni, 79.5%id, 0.3%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 24737784k total, 21714080k used, 3023704k free, 286232k buffers
Swap: 29694972k total, 83504k used, 29611468k free, 19668712k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
9593 foroxd 20 0 363m 36m 9364 R 99.1 0.2 0:05.59 php
9716 foroxd 20 0 364m 36m 9356 R 47.5 0.2 0:00.24 php
9719 foroxd 20 0 356m 31m 9280 S 23.8 0.1 0:00.12 php
3272 mysql 20 0 4449m 134m 6932 S 15.8 0.6 12231:14 mysqld
9712 foroxd 20 0 0 0 0 Z 13.9 0.0 0:00.25 php
29237 root 20 0 0 0 0 S 2.0 0.0 0:00.96 kworker/4:1
1 root 20 0 19276 1140 976 S 0.0 0.0 0:09.02 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.09 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 4:37.59 ksoftirqd/0
5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
7 root RT 0 0 0 0 S 0.0 0.0 0:08.12 migration/0
8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
9 root 20 0 0 0 0 S 0.0 0.0 61:33.20 rcu_sched
10 root RT 0 0 0 0 S 0.0 0.0 0:08.95 migration/1
11 root 20 0 0 0 0 S 0.0 0.0 2:10.05 ksoftirqd/1
13 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1:0H
14 root RT 0 0 0 0 S 0.0 0.0 0:19.38 migration/2
15 root 20 0 0 0 0 S 0.0 0.0 1:41.62 ksoftirqd/2
17 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/2:0H
18 root RT 0 0 0 0 S 0.0 0.0 0:09.11 migration/3
19 root 20 0 0 0 0 S 0.0 0.0 3:59.54 ksoftirqd/3
21 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/3:0H
22 root RT 0 0 0 0 S 0.0 0.0 0:02.53 migration/4
23 root 20 0 0 0 0 S 0.0 0.0 0:38.75 ksoftirqd/4
25 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/4:0H
26 root RT 0 0 0 0 S 0.0 0.0 0:22.38 migration/5
27 root 20 0 0 0 0 S 0.0 0.0 0:52.44 ksoftirqd/5
29 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/5:0H
30 root RT 0 0 0 0 S 0.0 0.0 0:08.82 migration/6
31 root 20 0 0 0 0 S 0.0 0.0 0:40.09 ksoftirqd/6
33 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/6:0H
34 root RT 0 0 0 0 S 0.0 0.0 0:05.32 migration/7
35 root 20 0 0 0 0 S 0.0 0.0 0:30.41 ksoftirqd/7
37 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/7:0H
38 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 khelper
39 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs
40 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns
514 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 writeback
516 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrityd
517 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
519 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kblockd
658 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ata_sff
668 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khubd
678 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 md
681 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 edac-poller
713 root 20 0 0 0 0 S 0.0 0.0 0:29.15 kworker/5:1
715 root 20 0 0 0 0 S 0.0 0.0 0:27.44 kworker/7:1
790 root 20 0 49000 7544 1752 S 0.0 0.0 7:25.63 tailwatchd
813 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 rpciod
814 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kvm-irqfd-clean
869 root 20 0 0 0 0 S 0.0 0.0 0:15.90 kswapd0
870 root 25 5 0 0 0 S 0.0 0.0 0:00.00 ksmd
873 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/7:0
996 root 20 0 0 0 0 S 0.0 0.0 0:00.32 fsnotify_mark
1036 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 nfsiod
1049 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 cifsiod
1070 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsIO
1071 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
1072 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
1073 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
1074 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
1075 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
1076 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
1077 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
1078 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
1079 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsSync
1093 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 xfsalloc
1095 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 xfs_mru_cache
1098 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 xfslogd
1105 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ocfs2_wq
1108 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 user_dlm
1123 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
1133 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 glock_workqueue
1134 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 delete_workqueu
1142 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 gfs_recovery
1147 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 crypto
1179 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kthrotld
1852 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
1853 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 drbd-reissue
1885 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 iscsi_eh
1930 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
1935 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
1938 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_2
1941 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_3
1944 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_4
1947 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_5
1970 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bond0
2029 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 mlx4
2047 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 vfio-irqfd-clea
2101 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
2128 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 dm_bufio_cache
2131 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdelayd
2134 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kmpathd
2135 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kmpath_handlerd
2220 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 deferwq
2223 root 20 0 0 0 0 S 0.0 0.0 2:42.64 jbd2/sda3-8
2224 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-dio-unwrit
2281 root 16 -4 10716 756 408 S 0.0 0.0 0:02.82 udevd
2486 root 0 -20 0 0 0 S 0.0 0.0 0:40.08 kworker/0:1H
2652 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jbd2/sda2-8
2653 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-dio-unwrit
2797 root 0 -20 0 0 0 S 0.0 0.0 1:23.21 loop0
2803 root 20 0 0 0 0 S 0.0 0.0 0:14.45 kjournald
3024 root 20 0 238m 5272 916 S 0.0 0.0 3:45.85 rsyslogd
3038 named 20 0 658m 28m 2420 S 0.0 0.1 24:52.37 named
3151 root 20 0 11476 1172 1172 S 0.0 0.0 0:00.01 mysqld_safe
3685 root 0 -20 0 0 0 S 0.0 0.0 0:00.06 kworker/1:1H
3991 root 20 0 135m 1376 1240 S 0.0 0.0 0:05.39 pure-ftpd
3993 root 20 0 133m 1264 1220 S 0.0 0.0 0:05.92 pure-authd
4003 root 20 0 114m 1128 680 S 0.0 0.0 0:19.43 crond
4023 root 20 0 21540 456 376 S 0.0 0.0 0:00.02 atd
4057 root 20 0 0 0 0 S 0.0 0.0 0:15.39 kworker/2:1
4113 root 0 -20 0 0 0 S 0.0 0.0 0:00.04 kworker/2:1H
4406 root 0 -20 0 0 0 S 0.0 0.0 0:00.03 kworker/3:1H
5088 root 20 0 4104 440 436 S 0.0 0.0 0:00.00 mingetty
5090 root 20 0 4108 436 432 S 0.0 0.0 0:00.00 mingetty
5092 root 20 0 4108 436 432 S 0.0 0.0 0:00.00 mingetty
5095 root 20 0 4104 440 436 S 0.0 0.0 0:00.00 mingetty
5097 root 20 0 4104 440 436 S 0.0 0.0 0:00.00 mingetty
5099 root 20 0 4104 440 436 S 0.0 0.0 0:00.00 mingetty
5853 root 0 -20 0 0 0 S 0.0 0.0 0:00.01 kworker/6:1H
5883 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/7:1H
6324 nobody 20 0 67644 4276 1784 S 0.0 0.0 0:00.02 httpd
7033 nobody 20 0 67500 4104 1772 S 0.0 0.0 0:00.04 httpd
7064 nobody 20 0 67596 4228 1772 S 0.0 0.0 0:00.10 httpd
7884 root 0 -20 0 0 0 S 0.0 0.0 0:00.01 kworker/4:1H
8151 root 20 0 97.7m 3684 2772 S 0.0 0.0 0:00.01 sshd
8157 nobody 20 0 67644 4276 1772 S 0.0 0.0 0:00.02 httpd
8161 root 20 0 57396 2196 1580 S 0.0 0.0 0:00.00 sftp-server
8277 root 20 0 97.7m 3780 2868 S 0.0 0.0 0:00.00 sshd
8288 root 20 0 105m 1880 1512 S 0.0 0.0 0:00.01 bash
8431 nobody 20 0 67552 4196 1784 S 0.0 0.0 0:00.07 httpd
8432 nobody 20 0 67324 3892 1720 S 0.0 0.0 0:00.00 httpd
8454 nobody 20 0 67504 4136 1784 S 0.0 0.0 0:00.03 httpd
8513 nobody 20 0 67324 2776 756 S 0.0 0.0 0:00.00 httpd
8532 nobody 20 0 67516 4160 1784 S 0.0 0.0 0:00.03 httpd
8651 root 20 0 33876 4176 1812 S 0.0 0.0 0:02.37 authProg
8682 nobody 20 0 67644 4252 1772 S 0.0 0.0 0:00.01 httpd
8701 nobody 20 0 67476 4036 1784 S 0.0 0.0 0:00.01 httpd
8704 nobody 20 0 67496 4104 1788 S 0.0 0.0 0:00.02 httpd
8725 nobody 20 0 67596 4136 1772 S 0.0 0.0 0:00.02 httpd
8727 nobody 20 0 67644 4272 1772 S 0.0 0.0 0:00.02 httpd
8728 nobody 20 0 67492 4092 1784 S 0.0 0.0 0:00.01 httpd
8735 nobody 20 0 67484 4120 1784 S 0.0 0.0 0:00.02 httpd
8738 nobody 20 0 67596 4220 1772 S 0.0 0.0 0:00.02 httpd
8941 nobody 20 0 67492 4032 1784 S 0.0 0.0 0:00.02 httpd
8972 nobody 20 0 67644 4248 1772 S 0.0 0.0 0:00.01 httpd
8977 nobody 20 0 67644 4264 1772 S 0.0 0.0 0:00.02 httpd
8992 nobody 20 0 67644 4200 1772 S 0.0 0.0 0:00.00 httpd
9027 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/5:0
9240 nobody 20 0 67492 4104 1772 S 0.0 0.0 0:00.00 httpd
9335 nobody 20 0 67644 4192 1772 S 0.0 0.0 0:00.02 httpd
9342 nobody 20 0 67468 4124 1872 S 0.0 0.0 0:00.00 httpd
9351 nobody 20 0 67596 4136 1772 S 0.0 0.0 0:00.01 httpd
9352 nobody 20 0 67496 4064 1772 S 0.0 0.0 0:00.00 httpd
9353 nobody 20 0 67492 4084 1768 S 0.0 0.0 0:00.00 httpd
9493 root 20 0 104m 1944 1228 S 0.0 0.0 0:00.01 mysqlmymonlite.
9715 root 20 0 15068 1272 884 R 0.0 0.0 0:00.00 top
9738 root 20 0 157m 51m 2784 S 0.0 0.2 0:10.51 spamd child
9909 root 20 0 0 0 0 S 0.0 0.0 0:21.15 kworker/0:1
10607 root 20 0 33880 4180 1812 S 0.0 0.0 0:02.42 authProg
10655 root 20 0 33876 4172 1812 S 0.0 0.0 0:02.38 authProg
11486 root 0 -20 0 0 0 S 0.0 0.0 0:00.01 kworker/5:1H
12410 root 20 0 23552 2264 1496 S 0.0 0.0 0:03.35 cpsrvd-dormant
12585 root 20 0 33876 4176 1812 S 0.0 0.0 0:02.41 authProg
13552 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/4:0
13590 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1:1
14029 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/2:2
14248 root 20 0 67188 4456 2460 S 0.0 0.0 2:05.62 httpd
14252 root 20 0 33876 4176 1812 S 0.0 0.0 0:02.42 authProg
18278 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/6:0
18338 root 20 0 0 0 0 S 0.0 0.0 0:00.29 kworker/u32:0
18517 root 20 0 50620 8672 2296 S 0.0 0.0 0:00.06 leechprotect
20018 root 20 0 91548 4332 1840 S 0.0 0.0 1:18.16 miniserv.pl
20928 root 20 0 34572 3036 1488 S 0.0 0.0 1:00.28 queueprocd - wa
20957 root 20 0 106m 3160 1304 S 0.0 0.0 0:25.93 dnsadmin - serv
20990 root 20 0 23456 2180 1484 S 0.0 0.0 1:05.65 cpdavd-dormant
20995 root 38 18 27112 1792 1212 S 0.0 0.0 0:03.40 cpanellogd - sl
21246 root 20 0 66300 1208 516 S 0.0 0.0 0:00.01 sshd
25292 root 20 0 151m 13m 1408 S 0.0 0.1 0:33.44 lfd - sleeping
26362 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/3:1
27298 root 20 0 0 0 0 S 0.0 0.0 0:06.21 kworker/1:0
27543 root 20 0 0 0 0 S 0.0 0.0 0:00.05 kworker/u32:2
28666 root 20 0 0 0 0 S 0.0 0.0 0:05.27 kworker/6:2
29942 root 18 -2 10712 704 352 S 0.0 0.0 0:00.16 udevd
30441 root 20 0 407m 222m 5368 S 0.0 0.9 3:06.20 clamd
30451 mailnull 20 0 69436 3132 2376 S 0.0 0.0 0:25.17 exim
30485 root 20 0 153m 48m 3092 S 0.0 0.2 4:53.80 /usr/local/cpan
31077 root 20 0 0 0 0 S 0.0 0.0 0:15.98 kworker/3:2
31186 root 20 0 4108 452 356 S 0.0 0.0 0:00.00 courierlogger
31187 root 20 0 19240 724 580 S 0.0 0.0 0:00.26 authdaemond
31188 root 20 0 19240 360 196 S 0.0 0.0 0:01.37 authdaemond
31189 root 20 0 19240 364 200 S 0.0 0.0 0:01.38 authdaemond
31190 root 20 0 19240 360 196 S 0.0 0.0 0:01.38 authdaemond
31191 root 20 0 19240 360 196 S 0.0 0.0 0:01.34 authdaemond
31193 root 20 0 19240 364 200 S 0.0 0.0 0:01.35 authdaemond
31200 root 20 0 4108 452 356 S 0.0 0.0 0:01.57 courierlogger
31201 root 20 0 8320 656 556 S 0.0 0.0 0:01.91 couriertcpd
31206 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/0:2
31207 root 20 0 4108 320 240 S 0.0 0.0 0:00.00 courierlogger
31208 root 20 0 8320 628 532 S 0.0 0.0 0:00.00 couriertcpd
31213 root 20 0 4108 448 356 S 0.0 0.0 0:00.94 courierlogger
31214 root 20 0 8320 656 556 S 0.0 0.0 0:01.64 couriertcpd
31219 root 20 0 4108 320 240 S 0.0 0.0 0:00.00 courierlogger
31220 root 20 0 8320 628 532 S 0.0 0.0 0:00.00 couriertcpd
32759 root 20 0 155m 49m 2548 S 0.0 0.2 0:11.60 spamd child
total used free shared buffers cached
Mem: 24157 21205 2952 0 279 19207
Low: 24157 21205 2952
High: 0 0 0
-/+ buffers/cache: 1717 22440
Swap: 28998 81 28917
MemTotal: 24737784 kB
MemFree: 3023704 kB
Buffers: 286232 kB
Cached: 19668712 kB
SwapCached: 41424 kB
Active: 16928900 kB
Inactive: 3693360 kB
Active(anon): 375920 kB
Inactive(anon): 291528 kB
Active(file): 16552980 kB
Inactive(file): 3401832 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 29694972 kB
SwapFree: 29611468 kB
Dirty: 556 kB
Writeback: 0 kB
AnonPages: 626132 kB
Mapped: 33024 kB
Shmem: 124 kB
Slab: 837328 kB
SReclaimable: 762772 kB
SUnreclaim: 74556 kB
KernelStack: 2088 kB
PageTables: 12152 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 42063864 kB
Committed_AS: 1155024 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 335612 kB
VmallocChunk: 34359293956 kB
HardwareCorrupted: 0 kB
DirectMap4k: 5632 kB
DirectMap2M: 25151488 kB
Private + Shared = RAM used Program
80.0 KiB + 376.0 KiB = 456.0 KiB atd
24.0 KiB + 436.0 KiB = 460.0 KiB mingetty (6)
444.0 KiB + 356.0 KiB = 800.0 KiB courierlogger (5)
392.0 KiB + 556.0 KiB = 948.0 KiB couriertcpd (4)
700.0 KiB + 408.0 KiB = 1.1 MiB udevd (2)
448.0 KiB + 680.0 KiB = 1.1 MiB crond
164.0 KiB + 976.0 KiB = 1.1 MiB init
0.0 KiB + 1.1 MiB = 1.1 MiB mysqld_safe
44.0 KiB + 1.2 MiB = 1.2 MiB pure-authd
136.0 KiB + 1.2 MiB = 1.3 MiB pure-ftpd
964.0 KiB + 580.0 KiB = 1.5 MiB authdaemond (6)
580.0 KiB + 1.2 MiB = 1.8 MiB cpanellogd - sl
368.0 KiB + 1.5 MiB = 1.8 MiB bash
716.0 KiB + 1.2 MiB = 1.9 MiB mysqlmymonlite.
696.0 KiB + 1.4 MiB = 2.1 MiB cpdavd-dormant
616.0 KiB + 1.5 MiB = 2.1 MiB sftp-server
768.0 KiB + 1.5 MiB = 2.2 MiB cpsrvd-dormant
1.5 MiB + 1.5 MiB = 3.0 MiB queueprocd - wa
756.0 KiB + 2.3 MiB = 3.1 MiB exim
1.8 MiB + 1.3 MiB = 3.1 MiB dnsadmin - serv
2.4 MiB + 1.8 MiB = 4.2 MiB miniserv.pl
4.3 MiB + 916.0 KiB = 5.1 MiB rsyslogd
2.5 MiB + 2.8 MiB = 5.3 MiB sshd (3)
5.7 MiB + 1.7 MiB = 7.4 MiB tailwatchd
6.2 MiB + 2.2 MiB = 8.5 MiB leechprotect
11.5 MiB + 1.8 MiB = 13.3 MiB authProg (5)
12.6 MiB + 1.4 MiB = 14.0 MiB lfd - sleeping
25.7 MiB + 2.4 MiB = 28.0 MiB named
45.0 MiB + 3.0 MiB = 48.1 MiB /usr/local/cpan
66.3 MiB + 2.4 MiB = 68.7 MiB httpd (29)
95.4 MiB + 2.7 MiB = 98.1 MiB spamd child (2)
114.2 MiB + 9.2 MiB = 123.4 MiB php (4)
127.5 MiB + 6.8 MiB = 134.2 MiB mysqld
217.0 MiB + 5.2 MiB = 222.2 MiB clamd
Private + Shared = RAM used Program
----------------------------
Server Disk Usage
----------------------------
S.ficheros Tipo Size Used Avail Use% Montado en
rootfs rootfs 1,7T 33G 1,6T 2% /
/dev/root ext4 1,7T 33G 1,6T 2% /
devtmpfs devtmpfs 12G 344K 12G 1% /dev
/dev/sda2 ext4 99G 110M 94G 1% /boot
tmpfs tmpfs 12G 0 12G 0% /dev/shm
/dev/loop0 ext3 4,0G 139M 3,7G 4% /tmp
/dev/loop0 ext3 4,0G 139M 3,7G 4% /var/tmp
----------------------------
MySQL datadir disk usage
----------------------------
/var/lib/mysql/ uses 3764228 kilobytes of disk space
----------------------------
ulimit -aH
----------------------------
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 192740
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
----------------------------------------------------------
tail -15 /etc/security/limits.conf
----------------------------------------------------------
# - nice - max nice priority allowed to raise to values: [-20, 19]
# - rtprio - max realtime priority
#
#
#
#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
# End of file
----------------------------------------------------------
mysqld process limits:
cat /proc/3272/limits
----------------------------------------------------------
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size 0 0 bytes
Max resident set unlimited unlimited bytes
Max processes 192740 192740 processes
Max open files 2422 2422 files
Max locked memory 65536 65536 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 192740 192740 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
----------------------------------
CPANEL WEB SERVER & PHP Info:
----------------------------------
WHM / Cpanel version: 11.38.2.7
WHM's PHP Handler config:
/usr/local/cpanel/bin/rebuild_phpconf --current
Available handlers: suphp dso cgi none
DEFAULT PHP: 5
PHP4 SAPI: none
PHP5 SAPI: suphp
SUEXEC: enabled
RUID2: not installed
PHP 5.3.27 (cli) (built: Oct 5 2013 17:55:13)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2013 Zend Technologies
with XCache v3.0.3, Copyright (c) 2005-2013, by mOo
with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd.
with XCache Cacher v3.0.3, Copyright (c) 2005-2013, by mOo
with Suhosin v0.9.33, Copyright (c) 2007-2012, by SektionEins GmbH
System => Linux yourserverhostname 3.10.9-xxxx-grs-ipv6-64 #1 SMP Wed Aug 21 11:51:59 CEST 2013 x86_64
Build Date => Oct 5 2013 17:54:26
Configure Command => './configure' '--disable-fileinfo' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-intl' '--enable-libxml' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-ucd-snmp-hack' '--enable-wddx' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-bz2' '--with-config-file-path=/usr/local/lib' '--with-config-file-scan-dir=/usr/local/lib/php.ini.d' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-enchant=/usr' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-icu-dir=/usr' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libexpat-dir=/usr' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-snmp' '--with-sqlite=shared' '--with-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr'
Configure Command | './configure' '--disable-fileinfo' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-intl' '--enable-libxml' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-ucd-snmp-hack' '--enable-wddx' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-bz2' '--with-config-file-path=/usr/local/lib' '--with-config-file-scan-dir=/usr/local/lib/php.ini.d' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-enchant=/usr' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-icu-dir=/usr' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libexpat-dir=/usr' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-snmp' '--with-sqlite=shared' '--with-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr'
Server API | Command Line Interface
Configuration File (php.ini) Path | /usr/local/lib
Loaded Configuration File | /usr/local/lib/php.ini
Scan this dir for additional .ini files | /usr/local/lib/php.ini.d
PHP API | 20090626
Zend Extension Build | API220090626,NTS
PHP Extension Build | API20090626,NTS
DOM/XML API Version | 20031129
Client API version | 5.5.32
Client API library version | 5.5.32
Client API header version | 5.5.32
Client API version | 5.5.32
Phar API version | 1.1.1
display_errors | Off | Off
error_log | ErroresNHRN | ErroresNHRN
extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20090626 | /usr/local/lib/php/extensions/no-debug-non-zts-20090626
file_uploads | On | On
log_errors | On | On
log_errors_max_len | 1 | 1
magic_quotes_gpc | Off | Off
magic_quotes_sybase | Off | Off
max_execution_time | 0 | 0
max_file_uploads | 20 | 20
memory_limit | 128M | 128M
open_basedir | no value | no value
post_max_size | 64M | 64M
realpath_cache_size | 16K | 16K
realpath_cache_ttl | 120 | 120
safe_mode | Off | Off
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
sql.safe_mode | Off | Off
upload_max_filesize | 100M | 100M
upload_tmp_dir | no value | no value
sqlite3.extension_dir | no value | no value
safe_mode_allowed_env_vars | PHP_ | PHP_
safe_mode_protected_env_vars | LD_LIBRARY_PATH | LD_LIBRARY_PATH
suhosin.disable.display_errors | Off | Off
suhosin.memory_limit | 0 | 0
cURL support | enabled
cURL Information | 7.24.0
ZLib Version | 1.2.3
GD Support | enabled
GD Version | bundled (2.1.0 compatible)
FreeType Support | enabled
FreeType Linkage | with freetype
FreeType Version | 2.3.11
GIF Read Support | enabled
GIF Create Support | enabled
JPEG Support | enabled
libJPEG Version | 6b
PNG Support | enabled
libPNG Version | 1.2.49
WBMP Support | enabled
libXML support | active
libXML Compiled Version | 2.9.0
libXML Loaded Version | 20900
libXML streams | enabled
PCRE (Perl Compatible Regular Expressions) Support | enabled
PCRE Library Version | 8.21 2011-12-12
Soap Client | enabled
Soap Server | enabled
ZLib Support | enabled
suhosin.apc_bug_workaround | Off | Off
xcache.coredump_directory | no value | no value
xcache.disable_on_crash | Off | Off
xcache.experimental | Off | Off
xcache.test | Off | Off
xcache.admin.enable_auth | Off | Off
xcache.allocator | bestfit | bestfit
xcache.cacher | On | On
xcache.count | 1 | 1
xcache.gc_interval | 0 | 0
xcache.mmap_path | /dev/zero | /dev/zero
xcache.readonly_protection | Off | Off
xcache.shm_scheme | mmap | mmap
xcache.size | 32 | 32
xcache.slots | 8K | 8K
xcache.stat | On | On
xcache.ttl | 7200 | 7200
xcache.var_allocator | bestfit | bestfit
xcache.var_count | 1 | 1
xcache.var_gc_interval | 300 | 300
xcache.var_maxttl | 0 | 0
xcache.var_namespace | no value | no value
xcache.var_namespace_mode | 0 | 0
xcache.var_size | 32 | 32
xcache.var_slots | 8K | 8K
xcache.var_ttl | 7200 | 7200
suhosin.cookie.encrypt | Off | Off
suhosin.executor.disable_eval | Off | Off
suhosin.get.max_value_length | 512 | 512
suhosin.get.max_vars | 100 | 100
suhosin.memory_limit | 0 | 0
suhosin.post.max_value_length | 1000000 | 1000000
suhosin.post.max_vars | 1000 | 1000
suhosin.request.max_value_length | 1000000 | 1000000
suhosin.request.max_vars | 1000 | 1000
suhosin.upload.disallow_binary | 0 | 0
suhosin.upload.disallow_elf | 1 | 1
suhosin.upload.max_uploads | 25 | 25
suhosin.upload.remove_binary | 0 | 0
suhosin.upload.verification_script | no value | no value
Server Version: Apache/2.2.25 (Unix) mod_ssl/2.2.25 OpenSSL/1.0.0-fips
Server Built: Oct 5 2013 17:52:05
Current Time: Wednesday, 06-Nov-2013 12:23:46 CET
Restart Time: Friday, 01-Nov-2013 20:56:22 CET
Parent Server Generation: 222
Total accesses: 5195675 - Total Traffic: 6.8 GB
CPU Usage: u1.27 s.32 cu137.89 cs0 - .0348% CPU load
12.9 requests/sec - 17.7 kB/second - 1397 B/request
12 requests currently being processed, 18 idle workers
Server version: Apache/2.2.25 (Unix)
Server built: Oct 5 2013 17:52:05
Cpanel::Easy::Apache v3.22.14 rev9999
Server's Module Magic Number: 20051115:33
Server loaded: APR 1.4.8, APR-Util 1.5.2
Compiled using: APR 1.4.8, APR-Util 1.5.2
Architecture: 64-bit
Server MPM: Prefork
threaded: no
forked: yes (variable process count)
Server compiled with....
-D APACHE_MPM_DIR="server/mpm/prefork"
-D APR_HAS_SENDFILE
-D APR_HAS_MMAP
-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
-D APR_USE_SYSVSEM_SERIALIZE
-D APR_USE_PTHREAD_SERIALIZE
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D APR_HAS_OTHER_CHILD
-D AP_HAVE_RELIABLE_PIPED_LOGS
-D DYNAMIC_MODULE_LIMIT=128
-D HTTPD_ROOT="/usr/local/apache"
-D SUEXEC_BIN="/usr/local/apache/bin/suexec"
-D DEFAULT_PIDLOG="logs/httpd.pid"
-D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
-D DEFAULT_LOCKFILE="logs/accept.lock"
-D DEFAULT_ERRORLOG="logs/error_log"
-D AP_TYPES_CONFIG_FILE="conf/mime.types"
-D SERVER_CONFIG_FILE="conf/httpd.conf"
Loaded Modules:
core_module (static)
authn_file_module (static)
authz_host_module (static)
authz_groupfile_module (static)
authz_user_module (static)
authz_default_module (static)
auth_basic_module (static)
auth_digest_module (static)
cache_module (static)
disk_cache_module (static)
dbd_module (static)
echo_module (static)
include_module (static)
filter_module (static)
charset_lite_module (static)
deflate_module (static)
log_config_module (static)
logio_module (static)
expires_module (static)
headers_module (static)
unique_id_module (static)
setenvif_module (static)
proxy_module (static)
proxy_connect_module (static)
proxy_ftp_module (static)
proxy_http_module (static)
proxy_scgi_module (static)
proxy_ajp_module (static)
proxy_balancer_module (static)
ssl_module (static)
mpm_prefork_module (static)
http_module (static)
mime_module (static)
status_module (static)
autoindex_module (static)
info_module (static)
suexec_module (static)
cgi_module (static)
negotiation_module (static)
dir_module (static)
imagemap_module (static)
actions_module (static)
speling_module (static)
userdir_module (static)
alias_module (static)
rewrite_module (static)
so_module (static)
bwlimited_module (shared)
suphp_module (shared)
Compiled in modules:
core.c
mod_authn_file.c
mod_authz_host.c
mod_authz_groupfile.c
mod_authz_user.c
mod_authz_default.c
mod_auth_basic.c
mod_auth_digest.c
mod_cache.c
mod_disk_cache.c
mod_dbd.c
mod_echo.c
mod_include.c
mod_filter.c
mod_charset_lite.c
mod_deflate.c
mod_log_config.c
mod_logio.c
mod_expires.c
mod_headers.c
mod_unique_id.c
mod_setenvif.c
mod_proxy.c
mod_proxy_connect.c
mod_proxy_ftp.c
mod_proxy_http.c
mod_proxy_scgi.c
mod_proxy_ajp.c
mod_proxy_balancer.c
mod_ssl.c
prefork.c
http_core.c
mod_mime.c
mod_status.c
mod_autoindex.c
mod_info.c
mod_suexec.c
mod_cgi.c
mod_negotiation.c
mod_dir.c
mod_imagemap.c
mod_actions.c
mod_speling.c
mod_userdir.c
mod_alias.c
mod_rewrite.c
mod_so.c
-------------------------------
From /usr/local/apache/conf/httpd.conf
-------------------------------
Timeout 150
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 3
StartServers 3
MinSpareServers 5
MaxSpareServers 10
ServerLimit 256
MaxClients 150
MaxRequestsPerChild 10000
----------------------------
mysqlreport output
----------------------------
MySQL 5.5.32-cll uptime 31 2:45:11 Wed Nov 6 12:23:54 2013
__ Key _________________________________________________________________
Buffer used 6.54M of 8.00M %Used: 81.76
Current 8.00M %Usage: 100.00
Write hit 44.59%
Read hit 96.42%
__ Questions ___________________________________________________________
Total 146.93M 54.7/s
DMS 111.20M 41.4/s %Total: 75.68
Com_ 26.95M 10.0/s 18.34
COM_QUIT 8.85M 3.3/s 6.02
-Unknown 62.97k 0.0/s 0.04
Slow 10 s 65 0.0/s 0.00 %DMS: 0.00 Log: OFF
DMS 111.20M 41.4/s 75.68
SELECT 99.20M 36.9/s 67.51 89.21
UPDATE 9.80M 3.6/s 6.67 8.81
INSERT 1.44M 0.5/s 0.98 1.30
DELETE 503.62k 0.2/s 0.34 0.45
REPLACE 256.18k 0.1/s 0.17 0.23
Com_ 26.95M 10.0/s 18.34
set_option 15.80M 5.9/s 10.75
change_db 10.87M 4.0/s 7.40
show_fields 68.53k 0.0/s 0.05
__ Rows ________________________________________________________________
Rows 1.60T 596.9k/s
Using idx 8.31G 3.1k/s %Index: 0.52
Rows/question 10.92k
__ SELECT and Sort _____________________________________________________
Scan 10.91M 4.1/s %SELECT: 11.00
Range 38.19M 14.2/s 38.49
Full join 113.50k 0.0/s 0.11
Range check 0 0/s 0.00
Full rng join 2.64k 0.0/s 0.00
Sort scan 8.03M 3.0/s
Sort range 9.12M 3.4/s
Sort mrg pass 1.80k 0.0/s
__ Table Locks _________________________________________________________
Waited 782.09k 0.3/s %Total: 0.41
Immediate 190.20M 70.7/s
__ Tables ______________________________________________________________
Open 400 of 400 %Cache: 100.00
Opened 107.43k 0.0/s
__ Connections _________________________________________________________
Max used 152 of 151 %Max: 100.66
Total 8.86M 3.3/s
__ Created Temp ________________________________________________________
Disk table 330.87k 0.1/s %Disk: 12.34
Table 2.68M 1.0/s Size: 16.0M
File 4.76k 0.0/s
__ Threads _____________________________________________________________
Running 2 of 5
Created 8.85M 3.3/s
Slow 0 0/s
Cached 0 of 0 %Hit: 0.08
__ Aborted _____________________________________________________________
Clients 7.41k 0.0/s
Connects 381 0.0/s
__ Bytes _______________________________________________________________
Sent 7.09T 2.6M/s
Received 43.11G 16.0k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 21.84M of 127.98M %Usage: 17.07
Read hit 99.97%
Pages
Free 6.79k %Total: 82.93
Data 1.40k 17.06 %Drty: 0.00
Misc 1 0.01
Latched 0 0.00
Reads 2.82M 1.0/s
From disk 742 0.0/s %Disk: 0.03
Ahead Rnd 0 0/s
Writes 32.99k 0.0/s
Wait Free 0 0/s %Wait: 0.00
Flushes 3.50k 0.0/s
__ InnoDB Lock _________________________________________________________
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 811 0.0/s
Writes 5.56k 0.0/s
fsync 2.57k 0.0/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 656 0.0/s
Read 741 0.0/s
Written 3.50k 0.0/s
Rows
Deleted 0 0/s
Inserted 2.74k 0.0/s
Read 685.00k 0.3/s
Updated 0 0/s
----------------------------
Total Server MyISAM and InnoDB Size
----------------------------
*************************** 1. row ***************************
innodb_tablespace_utilization_perc: 100
total_size_gb: 3.554803087376058
index_size_gb: 0.9043547064065933
data_size_gb: 2.650448380969465
innodb_total_size_gb: 0.0028076171875
innodb_data_size_gb: 0.0009002685546875
innodb_index_size_gb: 0.0019073486328125
myisam_total_size_gb: 3.5488528003916144
myisam_data_size_gb: 2.6469267597422004
myisam_index_size_gb: 0.9019260406494141
perc_index: 25.440360100
perc_data: 74.559639800
innodb_perc_index: 67.934782600
innodb_perc_data: 32.065217300
myisam_perc_index: 25.414580100
myisam_perc_data: 74.585419800
innodb_perc_total_index: 0.210907100
innodb_perc_total_data: 0.033966600
myisam_perc_total_index: 99.731447600
myisam_perc_total_data: 99.867131100
----------------------------
MySQL settings
----------------------------
[mysqld]
innodb_file_per_table=1
open_files_limit=2422
---
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr |
| big_tables | OFF |
| binlog_cache_size | 32768 |
| binlog_direct_non_transactional_updates | OFF |
| binlog_format | STATEMENT |
| binlog_stmt_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | NO_CHAIN |
| concurrent_insert | AUTO |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_storage_engine | InnoDB |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| engine_condition_pushdown | ON |
| event_scheduler | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| foreign_key_checks | ON |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| general_log | OFF |
| general_log_file | /var/lib/mysql/xd.log |
| group_concat_max_len | 1024 |
| have_compress | YES |
| have_crypt | YES |
| have_csv | YES |
| have_dynamic_loading | YES |
| have_geometry | YES |
| have_innodb | YES |
| have_ndbcluster | NO |
| have_openssl | DISABLED |
| have_partitioning | YES |
| have_profiling | YES |
| have_query_cache | YES |
| have_rtree_keys | YES |
| have_ssl | DISABLED |
| have_symlink | YES |
| hostname | yourserverhostname |
| ignore_builtin_innodb | OFF |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_adaptive_flushing | ON |
| innodb_adaptive_hash_index | ON |
| innodb_additional_mem_pool_size | 8388608 |
| innodb_autoextend_increment | 8 |
| innodb_autoinc_lock_mode | 1 |
| innodb_buffer_pool_instances | 1 |
| innodb_buffer_pool_size | 134217728 |
| innodb_change_buffering | all |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| innodb_file_format | Antelope |
| innodb_file_format_check | ON |
| innodb_file_format_max | Antelope |
| innodb_file_per_table | ON |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_load_corrupted | OFF |
| innodb_force_recovery | 0 |
| innodb_io_capacity | 200 |
| innodb_large_prefix | OFF |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_buffer_size | 8388608 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 75 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_old_blocks_pct | 37 |
| innodb_old_blocks_time | 0 |
| innodb_open_files | 300 |
| innodb_print_all_deadlocks | OFF |
| innodb_purge_batch_size | 20 |
| innodb_purge_threads | 0 |
| innodb_random_read_ahead | OFF |
| innodb_read_ahead_threshold | 56 |
| innodb_read_io_threads | 4 |
| innodb_replication_delay | 0 |
| innodb_rollback_on_timeout | OFF |
| innodb_rollback_segments | 128 |
| innodb_spin_wait_delay | 6 |
| innodb_stats_method | nulls_equal |
| innodb_stats_on_metadata | ON |
| innodb_stats_sample_pages | 8 |
| innodb_strict_mode | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 30 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 0 |
| innodb_thread_sleep_delay | 10000 |
| innodb_use_native_aio | ON |
| innodb_use_sys_malloc | ON |
| innodb_version | 5.5.32 |
| innodb_write_io_threads | 4 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| keep_files_on_create | OFF |
| key_buffer_size | 8388608 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| lc_messages | en_US |
| lc_messages_dir | /usr/share/mysql/ |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| lock_wait_timeout | 31536000 |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | /var/lib/mysql/yourserverhostname.err |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| long_query_time | 10.000000 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 1073741824 |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| max_connect_errors | 10 |
| max_connections | 151 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_long_data_size | 1048576 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 18446744073709551615 |
| metadata_locks_cache_size | 1024 |
| min_examined_row_limit | 0 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 9223372036853727232 |
| myisam_mmap_size | 18446744073709551615 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| myisam_stats_method | nulls_unequal |
| myisam_use_mmap | OFF |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old | OFF |
| old_alter_table | OFF |
| old_passwords | OFF |
| open_files_limit | 2422 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on |
| performance_schema | OFF |
| performance_schema_events_waits_history_long_size | 10000 |
| performance_schema_events_waits_history_size | 10 |
| performance_schema_max_cond_classes | 80 |
| performance_schema_max_cond_instances | 1000 |
| performance_schema_max_file_classes | 50 |
| performance_schema_max_file_handles | 32768 |
| performance_schema_max_file_instances | 10000 |
| performance_schema_max_mutex_classes | 200 |
| performance_schema_max_mutex_instances | 1000000 |
| performance_schema_max_rwlock_classes | 30 |
| performance_schema_max_rwlock_instances | 1000000 |
| performance_schema_max_table_handles | 100000 |
| performance_schema_max_table_instances | 50000 |
| performance_schema_max_thread_classes | 50 |
| performance_schema_max_thread_instances | 1000 |
| pid_file | /var/lib/mysql/yourserverhostname.pid |
| plugin_dir | /usr/lib64/mysql/plugin/ |
| port | 3306 |
| preload_buffer_size | 32768 |
| profiling | OFF |
| profiling_history_size | 15 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 4096 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log | |
| relay_log_index | |
| relay_log_info_file | relay-log.info |
| relay_log_purge | ON |
| relay_log_recovery | OFF |
| relay_log_space_limit | 0 |
| report_host | |
| report_password | |
| report_port | 3306 |
| report_user | |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| secure_file_priv | |
| server_id | 0 |
| skip_external_locking | ON |
| skip_name_resolve | OFF |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_compressed_protocol | OFF |
| slave_exec_mode | STRICT |
| slave_load_tmpdir | /tmp |
| slave_max_allowed_packet | 1073741824 |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slave_type_conversions | |
| slow_launch_time | 2 |
| slow_query_log | OFF |
| slow_query_log_file | /var/lib/mysql/xd-slow.log |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097152 |
| sql_auto_is_null | OFF |
| sql_big_selects | ON |
| sql_big_tables | OFF |
| sql_buffer_result | OFF |
| sql_log_bin | ON |
| sql_log_off | OFF |
| sql_low_priority_updates | OFF |
| sql_max_join_size | 18446744073709551615 |
| sql_mode | |
| sql_notes | ON |
| sql_quote_show_create | ON |
| sql_safe_updates | OFF |
| sql_select_limit | 18446744073709551615 |
| sql_slave_skip_counter | 0 |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | InnoDB |
| stored_program_cache | 256 |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_master_info | 0 |
| sync_relay_log | 0 |
| sync_relay_log_info | 0 |
| system_time_zone | CEST |
| table_definition_cache | 400 |
| table_open_cache | 400 |
| thread_cache_size | 0 |
| thread_concurrency | 10 |
| thread_handling | one-thread-per-connection |
| thread_stack | 262144 |
| thread_statistics | OFF |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 16777216 |
| tmpdir | /tmp |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| unique_checks | ON |
| updatable_views_with_limit | YES |
| userstat | OFF |
| version | 5.5.32-cll |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| wait_timeout | 28800 |
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
+------------------------------------------+---------------+
| Variable_name | Value |
+------------------------------------------+---------------+
| Aborted_clients | 7407 |
| Aborted_connects | 381 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 43113298458 |
| Bytes_sent | 7091922303949 |
| Com_admin_commands | 52993 |
| Com_assign_to_keycache | 0 |
| Com_alter_db | 0 |
| Com_alter_db_upgrade | 0 |
| Com_alter_event | 0 |
| Com_alter_function | 0 |
| Com_alter_procedure | 0 |
| Com_alter_server | 0 |
| Com_alter_table | 1300 |
| Com_alter_tablespace | 0 |
| Com_analyze | 0 |
| Com_begin | 0 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 10867796 |
| Com_change_master | 0 |
| Com_check | 25042 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 2 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_procedure | 0 |
| Com_create_server | 0 |
| Com_create_table | 753 |
| Com_create_trigger | 0 |
| Com_create_udf | 0 |
| Com_create_user | 0 |
| Com_create_view | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 499958 |
| Com_delete_multi | 3660 |
| Com_do | 0 |
| Com_drop_db | 1 |
| Com_drop_event | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_procedure | 0 |
| Com_drop_server | 0 |
| Com_drop_table | 752 |
| Com_drop_trigger | 0 |
| Com_drop_user | 0 |
| Com_drop_view | 0 |
| Com_empty_query | 0 |
| Com_execute_sql | 0 |
| Com_flush | 2 |
| Com_grant | 1 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 1440285 |
| Com_insert_select | 1349 |
| Com_install_plugin | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_lock_tables | 8083 |
| Com_optimize | 25133 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_release_savepoint | 0 |
| Com_rename_table | 0 |
| Com_rename_user | 0 |
| Com_repair | 0 |
| Com_replace | 256180 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_resignal | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_rollback_to_savepoint | 0 |
| Com_savepoint | 0 |
| Com_select | 99198400 |
| Com_set_option | 15799312 |
| Com_signal | 0 |
| Com_show_authors | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 14 |
| Com_show_client_statistics | 0 |
| Com_show_collations | 0 |
| Com_show_contributors | 0 |
| Com_show_create_db | 155 |
| Com_show_create_event | 0 |
| Com_show_create_func | 0 |
| Com_show_create_proc | 0 |
| Com_show_create_table | 15585 |
| Com_show_create_trigger | 0 |
| Com_show_databases | 86 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 |
| Com_show_engine_status | 0 |
| Com_show_events | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 68525 |
| Com_show_function_status | 1687 |
| Com_show_grants | 1643 |
| Com_show_index_statistics | 0 |
| Com_show_keys | 39 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_plugins | 0 |
| Com_show_privileges | 0 |
| Com_show_procedure_status | 1687 |
| Com_show_processlist | 8965 |
| Com_show_profile | 0 |
| Com_show_profiles | 0 |
| Com_show_relaylog_events | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 26 |
| Com_show_storage_engines | 399 |
| Com_show_table_statistics | 0 |
| Com_show_table_status | 27401 |
| Com_show_tables | 2049 |
| Com_show_thread_statistics | 0 |
| Com_show_triggers | 26571 |
| Com_show_user_statistics | 0 |
| Com_show_variables | 1246 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reprepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 785 |
| Com_uninstall_plugin | 0 |
| Com_unlock_tables | 8069 |
| Com_update | 9785972 |
| Com_update_multi | 10778 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 8855979 |
| Created_tmp_disk_tables | 330878 |
| Created_tmp_files | 4764 |
| Created_tmp_tables | 2681319 |
| Delayed_errors | 1322 |
| Delayed_insert_threads | 3 |
| Delayed_writes | 131303 |
| Flush_commands | 1 |
| Handler_commit | 42524 |
| Handler_delete | 1414338 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 17325152 |
| Handler_read_key | 2310230256 |
| Handler_read_last | 83768 |
| Handler_read_next | 5370899522 |
| Handler_read_prev | 613626383 |
| Handler_read_rnd | 65566859 |
| Handler_read_rnd_next | 1595627407106 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 28557986 |
| Handler_write | 81074156 |
| Innodb_buffer_pool_pages_data | 1397 |
| Innodb_buffer_pool_bytes_data | 22888448 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 3498 |
| Innodb_buffer_pool_pages_free | 6793 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 8191 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 0 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 2823381 |
| Innodb_buffer_pool_reads | 742 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 32994 |
| Innodb_data_fsyncs | 2571 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 14340096 |
| Innodb_data_reads | 811 |
| Innodb_data_writes | 5561 |
| Innodb_data_written | 116703232 |
| Innodb_dblwr_pages_written | 3498 |
| Innodb_dblwr_writes | 381 |
| Innodb_have_atomic_builtins | ON |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 3049 |
| Innodb_log_writes | 895 |
| Innodb_os_log_fsyncs | 1169 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 1940480 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 656 |
| Innodb_pages_read | 741 |
| Innodb_pages_written | 3498 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 2744 |
| Innodb_rows_read | 684999 |
| Innodb_rows_updated | 0 |
| Innodb_truncated_status_writes | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 25 |
| Key_blocks_used | 6698 |
| Key_read_requests | 8016346295 |
| Key_reads | 286787162 |
| Key_write_requests | 23508110 |
| Key_writes | 13025350 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 152 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 639 |
| Open_streams | 0 |
| Open_table_definitions | 400 |
| Open_tables | 400 |
| Opened_files | 1511723 |
| Opened_table_definitions | 30593 |
| Opened_tables | 107698 |
| Performance_schema_cond_classes_lost | 0 |
| Performance_schema_cond_instances_lost | 0 |
| Performance_schema_file_classes_lost | 0 |
| Performance_schema_file_handles_lost | 0 |
| Performance_schema_file_instances_lost | 0 |
| Performance_schema_locker_lost | 0 |
| Performance_schema_mutex_classes_lost | 0 |
| Performance_schema_mutex_instances_lost | 0 |
| Performance_schema_rwlock_classes_lost | 0 |
| Performance_schema_rwlock_instances_lost | 0 |
| Performance_schema_table_handles_lost | 0 |
| Performance_schema_table_instances_lost | 0 |
| Performance_schema_thread_classes_lost | 0 |
| Performance_schema_thread_instances_lost | 0 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Queries | 146931988 |
| Questions | 146931988 |
| Rpl_status | AUTH_MASTER |
| Select_full_join | 113501 |
| Select_full_range_join | 2640 |
| Select_range | 38185507 |
| Select_range_check | 0 |
| Select_scan | 10908867 |
| Slave_heartbeat_period | 0.000 |
| Slave_open_temp_tables | 0 |
| Slave_received_heartbeats | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 65 |
| Sort_merge_passes | 1797 |
| Sort_range | 9115615 |
| Sort_rows | 546215229 |
| Sort_scan | 8030002 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 190197652 |
| Table_locks_waited | 782093 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 4 |
| Threads_created | 8848878 |
| Threads_running | 1 |
| Uptime | 2688311 |
| Uptime_since_flush_status | 2688311 |
+------------------------------------------+---------------+
+---------+-----------------+-----------+-----------------+----------------+------+--------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+-----------------+-----------+-----------------+----------------+------+--------------------+------------------+
| 1 | eximstats | localhost | eximstats | Sleep | 131 | | |
| 8849045 | leechprotect | localhost | leechprotect | Sleep | 2238 | | |
| 8854936 | DELAYED | localhost | eximstats | Delayed insert | 204 | Waiting for INSERT | |
| 8855519 | DELAYED | localhost | eximstats | Delayed insert | 131 | Waiting for INSERT | |
| 8855520 | DELAYED | localhost | eximstats | Delayed insert | 131 | Waiting for INSERT | |
| 8855954 | foroxd_foroxdco | localhost | foroxd_foroxdco | Sleep | 7 | | |
| 8855978 | root | localhost | | Query | 0 | | show processlist |
+---------+-----------------+-----------+-----------------+----------------+------+--------------------+------------------+
------------------------------------
INNODB Buffer Pool Stats
------------------------------------
*************************** 1. row ***************************
POOL_ID: 0
POOL_SIZE: 8191
FREE_BUFFERS: 6793
DATABASE_PAGES: 1397
OLD_DATABASE_PAGES: 495
MODIFIED_DATABASE_PAGES: 0
PENDING_DECOMPRESS: 0
PENDING_READS: 0
PENDING_FLUSH_LRU: 0
PENDING_FLUSH_LIST: 0
PAGES_MADE_YOUNG: 0
PAGES_NOT_MADE_YOUNG: 0
PAGES_MADE_YOUNG_RATE: 0
PAGES_MADE_NOT_YOUNG_RATE: 0
NUMBER_PAGES_READ: 741
NUMBER_PAGES_CREATED: 656
NUMBER_PAGES_WRITTEN: 3498
PAGES_READ_RATE: 0
PAGES_CREATE_RATE: 0
PAGES_WRITTEN_RATE: 0
NUMBER_PAGES_GET: 2823381
HIT_RATE: 1000
YOUNG_MAKE_PER_THOUSAND_GETS: 0
NOT_YOUNG_MAKE_PER_THOUSAND_GETS: 0
NUMBER_PAGES_READ_AHEAD: 0
NUMBER_READ_AHEAD_EVICTED: 0
READ_AHEAD_RATE: 0
READ_AHEAD_EVICTED_RATE: 0
LRU_IO_TOTAL: 0
LRU_IO_CURRENT: 0
UNCOMPRESS_TOTAL: 0
UNCOMPRESS_CURRENT: 0
----------------------------
INNODB Status
----------------------------
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
131106 12:23:54 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 22 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 118169 1_second, 118165 sleeps, 9654 10_second, 21674 background, 21674 flush
srv_master_thread log flush and writes: 118211
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 405, signal count 404
Mutex spin waits 479, rounds 6221, OS waits 127
RW-shared spins 274, rounds 8220, OS waits 274
RW-excl spins 0, rounds 0, OS waits 0
Spin rounds per wait: 12.99 mutex, 30.00 RW-shared, 0.00 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 1578F
Purge done for trx's n:o < 155C3 undo n:o < 0
History list length 715
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 8855980, OS thread handle 0x2ae75ef4700, query id 146931995 localhost root
show engine innodb status
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0], aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
811 OS file reads, 5561 OS file writes, 2571 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276671, node heap has 1 buffer(s)
1.73 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 5226739
Log flushed up to 5226739
Last checkpoint at 5226739
0 pending log writes, 0 pending chkp writes
1174 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137363456; in additional pool allocated 0
Dictionary memory allocated 535494
Buffer pool size 8191
Free buffers 6793
Database pages 1397
Old database pages 495
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 741, created 656, written 3498
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1397, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 3272, id 2948382086912, state: sleeping
Number of rows inserted 2744, updated 0, deleted 0, read 684999
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1.64 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
----------------------------
MySQL Error Log
----------------------------
131006 10:38:43 InnoDB: The InnoDB memory heap is disabled
131006 10:38:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131006 10:38:43 InnoDB: Compressed tables use zlib 1.2.3
131006 10:38:43 InnoDB: Using Linux native AIO
131006 10:38:43 InnoDB: Initializing buffer pool, size = 128.0M
131006 10:38:43 InnoDB: Completed initialization of buffer pool
131006 10:38:43 InnoDB: highest supported file format is Barracuda.
131006 10:38:44 InnoDB: Waiting for the background threads to start
131006 10:38:45 InnoDB: 5.5.32 started; log sequence number 3744622
131006 10:38:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131006 10:38:45 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131006 10:38:45 [Note] Server socket created on IP: '0.0.0.0'.
131006 10:38:45 [Note] Event Scheduler: Loaded 0 events
131006 10:38:45 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.32-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
Report Complete:
mi"" nov 6 12:23:54 CET 2013
----------------------------
thanks
-
Copy your current my.cnf, exact server spec, what kind of scripts you got on the server (custom or some CMS), and mysqltuner.pl result 0 -
my.cnf [mysqld] back_log = 100 #skip-innodb #innodb=OFF max_connections = 400 key_buffer_size = 256M myisam_sort_buffer_size = 256M myisam_max_sort_file_size = 3072M join_buffer_size = 256K read_buffer_size = 256K sort_buffer_size = 256K table_definition_cache = 10000 table_open_cache = 10000 thread_cache_size = 384 wait_timeout = 120 interactive_timeout = 60 connect_timeout = 10 tmp_table_size = 384M max_heap_table_size = 384M max_allowed_packet = 64M max_seeks_for_key = 1000 group_concat_max_len = 1024 max_length_for_sort_data = 1024 net_buffer_length = 16384 max_connect_errors = 100000 concurrent_insert = 2 read_rnd_buffer_size = 256K bulk_insert_buffer_size = 8M query_cache_limit = 1536K query_cache_size = 64M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 range_alloc_block_size = 4096 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM max_write_lock_count = 16 lock_wait_timeout=100 # mysql 5.5 specific innodb_buffer_pool_instances=8 innodb_flush_method = O_DIRECT innodb_file_per_table = 1 innodb_open_files = 1000 innodb_data_file_path= ibdata1:10M:autoextend innodb_buffer_pool_size = 8000M innodb_log_files_in_group = 2 innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 2 innodb_thread_concurrency = 16 innodb_lock_wait_timeout=50 innodb_io_capacity = 200 innodb_read_io_threads = 2 innodb_write_io_threads = 2 long_query_time=1 slow_query_log=0 slow_query_log_file=/var/log/mysql/slowq.log [mysqld_safe] nice = -5 open-files-limit = 8192 [mysqldump] quick quote-names max_allowed_packet = 64M [myisamchk] key_buffer_size = 1024M sort_buffer_size = 1M read_buffer_size = 1M write_buffer_size = 1M [mysqlhotcopy] interactive-timeout
1 vbulletin and 2 wordpress. Thanks and regards0 -
still mysqltuner results missing and what hdd you have it provides most of the improtant information in one place 0 -
Hello mysqltuner -------- General Statistics -------------------------------------------------- [[0;34m--[0m] Skipped version check for MySQLTuner script [[0;32mOK[0m] Currently running supported MySQL version 5.5.32-cll [[0;32mOK[0m] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [[0;34m--[0m] Status: [0;32m+Archive [0m[0;31m-BDB [0m[0;31m-Federated [0m[0;32m+InnoDB [0m[0;31m-ISAM [0m[0;31m-NDBCluster [0m [[0;34m--[0m] Data in MyISAM tables: 2G (Tables: 328) [[0;34m--[0m] Data in InnoDB tables: 944K (Tables: 59) [[0;34m--[0m] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [[0;34m--[0m] Data in MEMORY tables: 2M (Tables: 2) [[0;31m!![0m] Total fragmented tables: 40 -------- Security Recommendations ------------------------------------------- [[0;32mOK[0m] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [[0;34m--[0m] Up for: 23h 40m 48s (4M q [51.349 qps], 232K conn, TX: 200B, RX: 1B) [[0;34m--[0m] Reads / Writes: 80% / 20% [[0;34m--[0m] Total buffers: 8.5G global + 1.2M per thread (400 max threads) [[0;32mOK[0m] Maximum possible memory usage: 9.0G (38% of installed RAM) [[0;32mOK[0m] Slow queries: 0% (312/4M) [[0;32mOK[0m] Highest usage of available connections: 19% (78/400) [[0;32mOK[0m] Key buffer size / total MyISAM indexes: 256.0M/925.3M [[0;32mOK[0m] Key buffer hit rate: 97.1% (184M cached / 5M reads) [[0;32mOK[0m] Query cache efficiency: 52.3% (1M cached / 3M selects) [[0;31m!![0m] Query cache prunes per day: 49051 [[0;32mOK[0m] Sorts requiring temporary tables: 0% (171 temp sorts / 441K sorts) [[0;31m!![0m] Joins performed without indexes: 1299 [[0;32mOK[0m] Temporary tables created on disk: 6% (4K on disk / 71K total) [[0;32mOK[0m] Thread cache hit rate: 99% (78 created / 232K connections) [[0;32mOK[0m] Table cache hit rate: 23% (622 open / 2K opened) [[0;32mOK[0m] Open file limit used: 4% (842/20K) [[0;32mOK[0m] Table locks acquired immediately: 99% (3M immediate / 3M locks) [[0;32mOK[0m] InnoDB data size / buffer pool: 944.0K/7.8G -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries Adjust your join queries to always utilize indexes Variables to adjust: query_cache_size (> 64M) join_buffer_size (> 256.0K, or always use indexes with joins)
ssd 1,77 TB thanks0 -
[mysqld] back_log = 100 #skip-innodb max_connections = 400 wait_timeout = 120 interactive_timeout = 60 connect_timeout = 2 key_buffer_size = 1500M myisam_sort_buffer_size = 256M myisam_max_sort_file_size = 3072M join_buffer_size = 1M read_buffer_size = 256K sort_buffer_size = 128K read_rnd_buffer_size = 2M table_definition_cache = 1000 table_open_cache = 2500 thread_cache_size = 32 tmp_table_size = 50M max_heap_table_size = 50M max_allowed_packet = 64M concurrent_insert = 2 bulk_insert_buffer_size = 16M query_cache_type = 1 query_cache_size = 64M query_cache_limit = 1M default-storage-engine = MyISAM max_write_lock_count = 10 # mysql 5.5 specific innodb_buffer_pool_instances=8 innodb_flush_method = O_DIRECT innodb_file_per_table = 1 innodb_open_files = 3000 innodb_data_file_path= ibdata1:10M:autoextend innodb_buffer_pool_size = 1000M innodb_log_files_in_group = 2 innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 2 #innodb_thread_concurrency = 16 #innodb_lock_wait_timeout=50 #innodb_io_capacity = 200 #innodb_read_io_threads = 2 #innodb_write_io_threads = 2 slow_query_log=1 slow_query_log_file=mysql-slow.log long_query_time=0.1 [mysqld_safe] nice = -5 open-files-limit = 8192 [mysqldump] quick quote-names max_allowed_packet = 64M [myisamchk] key_buffer_size = 1024M sort_buffer_size = 1M read_buffer_size = 1M write_buffer_size = 1M [mysqlhotcopy] interactive-timeout I've removed and commented out some of the settings, do you even understand them why there were there ? innodb settings optimizations doesnt really make sense much in case of your config since, you got very little content in innodb tables if you plan to put in innodb more contents increase innodb_log_file_size to at least 50M (before restart you need to remove old ib_logfile* files ) you can restart the server with new my.cnf settings above "ssd 1,77 TB" you really have 1,77 TB SSD in this setup ? 0 -
Sorry, it 1Tb hdd 0 -
Feel free to update us after implementing the optimizations and let us know if you notice improved performance. Thank you. 0 -
Sorry, I was out the holidays. It goes very well but sometimes load up a bit. Thanks and regards 0
Please sign in to leave a comment.
Comments
8 comments