-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.2 mysqlmymon.com
compiled by George Liu (eva2000) vbtechsupport.com
-------------------------------------------------------------
Report Generated:
Sat May 24 21:51:25 EDT 2014
----------------------------
MySQL Uptime:
----------------------------
MySQL server was started 2014-05-24 13:59:19
Uptime: 7 hours 52 min 6 sec
Uptime 28326
Uptime_since_flush_status 28326
Max Used Connections: 30/151 (19.87%)
Key Buffer Used: 6.54M/8.00M (81.76%)
Current Key Buffer Usage: 4.65M (58.18%)
InnoDB Buffer Pool: 128.00M/128.00M (100.00%)
Query Cache: 24.65M/32.00M (77.03%)
Table Locks Waited: 2.35k Rate: 0.1/s (0.40%)
--------------------
Query Cache Limit (bytes): 1048576
Query Cache Min Unit (bytes): 4096
Query Cache Size (bytes): 33554432
Query Cache Free Mem (bytes): 7707184
Query Cache Used Mem (bytes): 25847248
Queries in Query Cache: 1
Query Cache Avg Size (bytes): 25847248
----------------------------
Hardware Info:
----------------------------
Processors physical = 1, cores = 4, virtual = 8, hyperthreading = yes
8 2800.005
8 Intel(R) Core(TM) i7 CPU 960 @ 3.20GHz
8 8192 KB
----------------------------
TOP stats
----------------------------
Linux 3.2.58-68.art.x86_64 ((yourserverhostname)) 05/24/2014 _x86_64_ (8 CPU)
09:51:26 PM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
09:51:28 PM all 5.90 0.00 0.82 0.00 0.00 0.06 0.00 0.00 93.22
09:51:28 PM 0 3.09 0.00 0.52 0.00 0.00 0.00 0.00 0.00 96.39
09:51:28 PM 1 0.00 0.00 0.50 0.00 0.00 0.00 0.00 0.00 99.50
09:51:28 PM 2 36.00 0.00 3.50 0.00 0.00 0.00 0.00 0.00 60.50
09:51:28 PM 3 7.00 0.00 0.50 0.00 0.00 0.00 0.00 0.00 92.50
09:51:28 PM 4 0.50 0.00 0.50 0.00 0.00 0.00 0.00 0.00 99.00
09:51:28 PM 5 0.50 0.00 0.50 0.00 0.00 0.00 0.00 0.00 98.99
09:51:28 PM 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00
09:51:28 PM 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00
09:51:28 PM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
09:51:30 PM all 6.47 0.00 1.95 6.28 0.00 0.69 0.00 0.00 84.61
09:51:30 PM 0 10.77 0.00 1.54 48.72 0.00 1.03 0.00 0.00 37.95
09:51:30 PM 1 4.04 0.00 2.02 1.01 0.00 1.01 0.00 0.00 91.92
09:51:30 PM 2 22.61 0.00 2.01 0.00 0.00 0.50 0.00 0.00 74.87
09:51:30 PM 3 7.50 0.00 4.50 1.00 0.00 1.50 0.00 0.00 85.50
09:51:30 PM 4 0.00 0.00 1.51 0.00 0.00 0.00 0.00 0.00 98.49
09:51:30 PM 5 3.50 0.00 0.50 0.00 0.00 0.00 0.00 0.00 96.00
09:51:30 PM 6 2.51 0.00 2.51 0.00 0.00 1.51 0.00 0.00 93.47
09:51:30 PM 7 0.50 0.00 1.00 0.00 0.00 0.00 0.00 0.00 98.51
Average: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
Average: all 6.18 0.00 1.38 3.14 0.00 0.38 0.00 0.00 88.92
Average: 0 6.94 0.00 1.03 24.42 0.00 0.51 0.00 0.00 67.10
Average: 1 2.02 0.00 1.26 0.50 0.00 0.50 0.00 0.00 95.72
Average: 2 29.32 0.00 2.76 0.00 0.00 0.25 0.00 0.00 67.67
Average: 3 7.25 0.00 2.50 0.50 0.00 0.75 0.00 0.00 89.00
Average: 4 0.25 0.00 1.00 0.00 0.00 0.00 0.00 0.00 98.75
Average: 5 2.01 0.00 0.50 0.00 0.00 0.00 0.00 0.00 97.49
Average: 6 1.25 0.00 1.25 0.00 0.00 0.75 0.00 0.00 96.74
Average: 7 0.25 0.00 0.50 0.00 0.00 0.00 0.00 0.00 99.25
top - 21:51:31 up 7:55, 1 user, load average: 0.73, 0.56, 0.47
Tasks: 246 total, 1 running, 245 sleeping, 0 stopped, 0 zombie
Cpu(s): 3.7%us, 1.5%sy, 0.4%ni, 92.3%id, 1.8%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 24611332k total, 14951924k used, 9659408k free, 1012032k buffers
Swap: 61849596k total, 0k used, 61849596k free, 8976252k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25248 useruser 20 0 289m 37m 9416 S 15.7 0.2 0:01.99 php
23349 nobody 20 0 160m 84m 3976 S 5.9 0.4 0:06.25 httpd
4573 mysql 20 0 2727m 463m 7224 S 2.0 1.9 98:20.06 mysqld
11370 root 20 0 104m 2376 2136 S 2.0 0.0 0:01.10 whmsonicsrv
23336 prosexvi 20 0 269m 15m 9560 S 2.0 0.1 0:01.86 php
1 root 20 0 19280 1536 1264 S 0.0 0.0 0:01.31 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd
3 root 20 0 0 0 0 S 0.0 0.0 0:00.73 ksoftirqd/0
6 root RT 0 0 0 0 S 0.0 0.0 0:00.13 migration/0
7 root RT 0 0 0 0 S 0.0 0.0 0:02.09 watchdog/0
8 root RT 0 0 0 0 S 0.0 0.0 0:00.03 migration/1
9 root 20 0 0 0 0 S 0.0 0.0 0:00.78 kworker/1:0
10 root 20 0 0 0 0 S 0.0 0.0 0:00.37 ksoftirqd/1
12 root RT 0 0 0 0 S 0.0 0.0 0:00.12 watchdog/1
13 root RT 0 0 0 0 S 0.0 0.0 0:00.03 migration/2
15 root 20 0 0 0 0 S 0.0 0.0 0:00.30 ksoftirqd/2
16 root RT 0 0 0 0 S 0.0 0.0 0:00.11 watchdog/2
17 root RT 0 0 0 0 S 0.0 0.0 0:00.04 migration/3
19 root 20 0 0 0 0 S 0.0 0.0 0:00.26 ksoftirqd/3
20 root RT 0 0 0 0 S 0.0 0.0 0:00.10 watchdog/3
21 root RT 0 0 0 0 S 0.0 0.0 0:00.19 migration/4
23 root 20 0 0 0 0 S 0.0 0.0 0:00.39 ksoftirqd/4
24 root RT 0 0 0 0 S 0.0 0.0 0:00.10 watchdog/4
25 root RT 0 0 0 0 S 0.0 0.0 0:00.24 migration/5
27 root 20 0 0 0 0 S 0.0 0.0 0:00.31 ksoftirqd/5
28 root RT 0 0 0 0 S 0.0 0.0 0:00.10 watchdog/5
29 root RT 0 0 0 0 S 0.0 0.0 0:00.24 migration/6
30 root 20 0 0 0 0 S 0.0 0.0 0:00.17 kworker/6:0
31 root 20 0 0 0 0 S 0.0 0.0 0:00.30 ksoftirqd/6
32 root RT 0 0 0 0 S 0.0 0.0 0:00.09 watchdog/6
33 root RT 0 0 0 0 S 0.0 0.0 0:00.31 migration/7
34 root 20 0 0 0 0 S 0.0 0.0 0:00.02 kworker/7:0
35 root 20 0 0 0 0 S 0.0 0.0 0:00.31 ksoftirqd/7
36 root RT 0 0 0 0 S 0.0 0.0 0:00.11 watchdog/7
37 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 cpuset
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
41 root 20 0 0 0 0 S 0.0 0.0 0:00.07 sync_supers
42 root 20 0 0 0 0 S 0.0 0.0 0:00.00 bdi-default
43 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrityd
44 root 0 -20 0 0 0 S 0.0 0.0 0:00.35 kblockd
45 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ata_sff
46 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khubd
47 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 md
49 root 20 0 0 0 0 S 0.0 0.0 0:00.67 kworker/2:1
50 root 20 0 0 0 0 S 0.0 0.0 0:00.35 kworker/3:1
51 root 20 0 0 0 0 S 0.0 0.0 0:00.17 kworker/4:1
52 root 20 0 0 0 0 S 0.0 0.0 0:00.11 kworker/5:1
53 root 20 0 0 0 0 S 0.0 0.0 0:00.33 kworker/6:1
54 root 20 0 0 0 0 S 0.0 0.0 0:00.60 kworker/7:1
55 root 20 0 0 0 0 S 0.0 0.0 0:00.01 khungtaskd
56 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kswapd0
57 root 25 5 0 0 0 S 0.0 0.0 0:00.00 ksmd
58 root 39 19 0 0 0 S 0.0 0.0 0:05.83 khugepaged
59 root 20 0 0 0 0 S 0.0 0.0 0:00.00 fsnotify_mark
60 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 crypto
67 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kthrotld
69 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
127 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ttm_swap
185 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
186 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
187 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_2
188 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_3
189 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_4
190 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_5
191 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_6
192 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_7
196 root 20 0 0 0 0 S 0.0 0.0 0:00.25 kworker/u:5
197 root 20 0 0 0 0 S 0.0 0.0 0:00.59 kworker/u:6
201 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_8
202 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_9
215 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_10
216 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_11
217 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_12
218 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_13
288 root 20 0 0 0 0 S 0.0 0.0 0:00.40 kworker/3:2
321 root 20 0 0 0 0 S 0.0 0.0 0:00.26 kworker/5:2
335 root 20 0 0 0 0 S 0.0 0.0 0:00.59 kworker/1:2
337 root 20 0 0 0 0 S 0.0 0.0 0:00.28 kworker/4:2
346 root 20 0 0 0 0 S 0.0 0.0 0:00.84 kworker/2:2
416 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush
418 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush
434 root 20 0 0 0 0 S 0.0 0.0 0:06.53 jbd2/dm-0-8
435 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-dio-unwrit
520 root 16 -4 10684 736 320 S 0.0 0.0 0:00.85 udevd
575 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 edac-poller
848 allnjdea 20 0 288m 36m 9300 S 0.0 0.2 0:00.66 php
856 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush
866 root 20 0 0 0 0 S 0.0 0.0 0:02.61 flush-253:0
876 root 20 0 0 0 0 S 0.0 0.0 0:00.44 flush-253:2
906 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jbd2/sdf1-8
907 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-dio-unwrit
908 root 20 0 0 0 0 S 0.0 0.0 0:00.85 jbd2/dm-2-8
909 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-dio-unwrit
1051 root 20 0 0 0 0 S 0.0 0.0 0:00.22 kauditd
1122 topsexpl 20 0 382m 34m 9596 S 0.0 0.1 0:00.44 php
1126 valueddi 20 0 296m 43m 9m S 0.0 0.2 0:00.41 php
1134 valueddi 20 0 286m 34m 9352 S 0.0 0.1 0:00.50 php
1172 tortix 20 0 409m 84m 7832 S 0.0 0.4 0:33.02 tortixd
1444 root 16 -4 91200 772 580 S 0.0 0.0 0:01.30 auditd
1485 mommagti 20 0 297m 45m 9416 S 0.0 0.2 0:00.61 php
1502 root 20 0 237m 1592 980 S 0.0 0.0 0:03.03 rsyslogd
1516 named 20 0 668m 31m 2428 S 0.0 0.1 0:13.40 named
1565 root 20 0 66656 1204 480 S 0.0 0.0 0:00.00 sshd
1573 root 20 0 654m 449m 5748 S 0.0 1.9 0:18.98 clamd
1596 root 20 0 105m 1700 1364 S 0.0 0.0 0:00.01 mysqld_safe
1638 mommagsh 20 0 269m 17m 9168 S 0.0 0.1 0:00.08 php
1831 root 20 0 0 0 0 S 0.0 0.0 0:07.05 kworker/0:1
1838 tortix 20 0 409m 83m 6556 S 0.0 0.3 1:18.27 tortixd
1859 tortix 20 0 405m 74m 2120 S 0.0 0.3 0:00.43 tortixd
1951 root 20 0 19656 1128 828 S 0.0 0.0 0:00.04 dovecot
1974 dovenull 20 0 42400 3372 2592 S 0.0 0.0 0:00.10 pop3-login
1975 dovenull 20 0 42272 3120 2412 S 0.0 0.0 0:00.16 imap-login
1976 dovecot 20 0 13356 1076 900 S 0.0 0.0 0:00.01 anvil
1977 root 20 0 13484 1264 940 S 0.0 0.0 0:00.02 log
1979 dovenull 20 0 42268 3116 2412 S 0.0 0.0 0:00.00 pop3-login
1980 dovenull 20 0 42272 3116 2412 S 0.0 0.0 0:00.02 imap-login
1981 root 20 0 16468 2036 1096 S 0.0 0.0 0:00.05 config
2009 mailnull 20 0 71540 2984 704 S 0.0 0.0 0:00.07 exim
2027 root 20 0 161m 49m 3288 S 0.0 0.2 0:04.68 /usr/local/cpan
2062 root 20 0 161m 47m 1120 S 0.0 0.2 0:00.01 spamd child
2063 root 20 0 161m 47m 1120 S 0.0 0.2 0:00.01 spamd child
2071 root 20 0 159m 84m 5372 S 0.0 0.4 0:05.02 httpd
2079 root 20 0 135m 2012 1340 S 0.0 0.0 0:00.02 pure-ftpd
2082 root 20 0 133m 488 0 S 0.0 0.0 0:00.00 pure-uploadscri
2084 root 20 0 133m 1828 1344 S 0.0 0.0 0:00.03 pure-authd
2110 root 20 0 404m 84m 11m S 0.0 0.3 0:01.27 tortixd
2122 root 20 0 114m 1360 644 S 0.0 0.0 0:00.99 crond
2140 root 20 0 142m 8584 1772 S 0.0 0.0 0:01.50 /usr/local/cpan
2155 root 20 0 21588 400 220 S 0.0 0.0 0:00.00 atd
2386 root 20 0 71704 8036 2584 S 0.0 0.0 0:01.57 cPhulkd - proce
2621 root 20 0 99124 14m 1884 S 0.0 0.1 0:04.28 cpsrvd-ssl
2658 root 20 0 38376 6564 1436 S 0.0 0.0 0:00.78 queueprocd - wa
2666 root 20 0 110m 16m 344 S 0.0 0.1 0:00.03 cpdavd - accept
2719 allnjsto 20 0 292m 38m 9m S 0.0 0.2 0:00.29 php
2725 nobody 20 0 160m 84m 3872 S 0.0 0.4 0:02.78 httpd
2745 allnjsto 20 0 286m 32m 9352 S 0.0 0.1 0:00.51 php
2754 usgeodir 20 0 300m 47m 9612 S 0.0 0.2 0:01.78 php
2764 usgeodir 20 0 306m 51m 9m S 0.0 0.2 0:00.38 php
2817 root 20 0 79344 12m 1376 S 0.0 0.1 0:01.71 tailwatchd
2873 root 38 18 27164 3060 768 S 0.0 0.0 0:00.03 cpanellogd - sl
3111 root 20 0 219m 7084 2452 S 0.0 0.0 0:00.03 watchmysql
3140 buyandse 20 0 277m 20m 9180 S 0.0 0.1 0:00.21 php
3144 buyandse 20 0 277m 22m 9180 S 0.0 0.1 0:00.13 php
3297 cupidspl 20 0 275m 20m 9272 S 0.0 0.1 0:01.74 php
3706 emogurlz 20 0 295m 42m 9852 S 0.0 0.2 0:01.71 php
4876 ossecm 20 0 61384 9.8m 1064 S 0.0 0.0 0:17.97 ossec-dbd
4881 ossecm 20 0 8820 664 308 S 0.0 0.0 0:00.19 ossec-maild
4911 root 20 0 15624 1088 752 S 0.0 0.0 0:00.25 ossec-execd
4919 ossec 20 0 17668 9768 616 S 0.0 0.0 4:07.36 ossec-analysisd
4925 root 20 0 6540 512 312 S 0.0 0.0 0:01.20 ossec-logcollec
4973 root 20 0 18380 12m 516 S 0.0 0.1 0:56.70 ossec-syscheckd
4977 ossec 20 0 8700 420 236 S 0.0 0.0 0:00.01 ossec-monitord
5107 root 20 0 4112 552 468 S 0.0 0.0 0:00.00 mingetty
5109 root 20 0 4108 556 476 S 0.0 0.0 0:00.00 mingetty
5111 root 20 0 4108 552 472 S 0.0 0.0 0:00.00 mingetty
5113 root 20 0 4112 556 476 S 0.0 0.0 0:00.00 mingetty
5115 root 20 0 4108 552 472 S 0.0 0.0 0:00.00 mingetty
5117 root 18 -2 10680 740 324 S 0.0 0.0 0:00.70 udevd
5118 root 18 -2 10680 704 288 S 0.0 0.0 0:00.00 udevd
5284 allnjart 20 0 269m 14m 8764 S 0.0 0.1 0:01.34 php
5608 allnjdin 20 0 285m 33m 9236 S 0.0 0.1 0:02.03 php
5799 nobody 20 0 160m 84m 3940 S 0.0 0.4 0:01.90 httpd
6427 root 20 0 4108 552 468 S 0.0 0.0 0:00.00 mingetty
6836 allnjadv 20 0 292m 38m 9m S 0.0 0.2 0:00.33 php
6932 allnjadv 20 0 286m 34m 9352 S 0.0 0.1 0:00.49 php
7532 dumbestc 20 0 268m 16m 8192 S 0.0 0.1 0:00.02 php
8125 root 20 0 0 0 0 S 0.0 0.0 0:03.28 kworker/0:3
8126 allnjcha 20 0 292m 36m 9m S 0.0 0.2 0:00.30 php
8168 allnjcha 20 0 286m 34m 9352 S 0.0 0.1 0:00.50 php
8293 root 20 0 147m 8992 1196 S 0.0 0.0 0:00.35 psmon
8889 nobody 20 0 160m 83m 3060 S 0.0 0.3 0:00.89 httpd
10582 allnjsoc 20 0 296m 44m 9372 S 0.0 0.2 0:00.57 php
10650 thatsoci 20 0 271m 20m 8980 S 0.0 0.1 0:00.09 php
10665 cutename 20 0 268m 14m 8168 S 0.0 0.1 0:00.02 php
10710 root 20 0 102m 4208 3196 S 0.0 0.0 0:00.12 sshd
10755 root 20 0 105m 1936 1516 S 0.0 0.0 0:00.02 bash
10798 nobody 20 0 159m 83m 2924 S 0.0 0.3 0:00.39 httpd
11059 allnjart 20 0 269m 16m 8764 S 0.0 0.1 0:00.17 php
11198 nobody 20 0 159m 83m 3056 S 0.0 0.3 0:00.23 httpd
12267 coolvipg 20 0 298m 44m 9.9m S 0.0 0.2 0:01.39 php
12291 nobody 20 0 159m 82m 2812 S 0.0 0.3 0:00.06 httpd
12318 nobody 20 0 159m 83m 3028 S 0.0 0.3 0:00.06 httpd
12594 root 20 0 104m 1980 1236 S 0.0 0.0 0:00.01 mysqlmymonlite.
12807 root 20 0 15080 1316 884 R 0.0 0.0 0:00.00 top
14980 tortix 20 0 408m 82m 6460 S 0.0 0.3 0:47.01 tortixd
15047 root 20 0 0 0 0 S 0.0 0.0 0:16.56 kworker/0:0
23328 root 20 0 80056 10m 2872 S 0.0 0.0 0:00.09 leechprotect
23329 nobody 20 0 159m 80m 792 S 0.0 0.3 0:00.26 httpd
23330 nobody 20 0 160m 83m 3180 S 0.0 0.3 0:05.39 httpd
23377 cupidspl 20 0 269m 19m 9272 S 0.0 0.1 0:09.73 php
23383 carmarke 20 0 298m 44m 9616 S 0.0 0.2 0:01.10 php
23394 sextubee 20 0 269m 16m 8852 S 0.0 0.1 0:00.05 php
23397 triplexf 20 0 283m 29m 9276 S 0.0 0.1 0:00.70 php
23447 googlia 20 0 275m 21m 9412 S 0.0 0.1 0:02.05 php
23529 allnjauc 20 0 275m 24m 9048 S 0.0 0.1 0:01.61 php
23571 buyandse 20 0 277m 23m 9180 S 0.0 0.1 0:01.03 php
23716 spectroa 20 0 269m 18m 8996 S 0.0 0.1 0:00.05 php
23746 allussho 20 0 294m 42m 9308 S 0.0 0.2 0:02.30 php
23751 adultsxx 20 0 282m 30m 9428 S 0.0 0.1 0:00.85 php
23781 colonyvi 20 0 285m 31m 9196 S 0.0 0.1 0:00.78 php
23816 studcart 20 0 306m 53m 9704 S 0.0 0.2 0:03.21 php
23819 spectroy 20 0 276m 23m 9848 S 0.0 0.1 0:06.10 php
23868 allnjwex 20 0 292m 38m 10m S 0.0 0.2 0:18.91 php
23991 nobody 20 0 166m 89m 3220 S 0.0 0.4 0:07.28 httpd
23999 mommagga 20 0 301m 50m 9m S 0.0 0.2 0:01.87 php
24003 nobody 20 0 160m 84m 3940 S 0.0 0.4 0:06.24 httpd
24013 showertw 20 0 286m 32m 9476 S 0.0 0.1 0:01.77 php
24141 gaytubeg 20 0 283m 28m 9192 S 0.0 0.1 0:00.70 php
24342 allnjads 20 0 270m 15m 8940 S 0.0 0.1 0:00.08 php
24506 noteboar 20 0 281m 28m 9288 S 0.0 0.1 0:00.85 php
25108 allnjspp 20 0 372m 118m 9908 S 0.0 0.5 0:08.37 php
25114 allnjspp 20 0 365m 112m 9920 S 0.0 0.5 0:14.19 php
25127 fashionm 20 0 296m 45m 10m S 0.0 0.2 0:01.01 php
25131 fashionm 20 0 298m 42m 9616 S 0.0 0.2 0:00.81 php
25166 mommagti 20 0 300m 48m 9528 S 0.0 0.2 0:01.21 php
25174 naughtya 20 0 288m 36m 9208 S 0.0 0.2 0:00.49 php
25243 spectrov 20 0 271m 17m 9592 S 0.0 0.1 0:01.03 php
25251 oldbridg 20 0 288m 33m 9260 S 0.0 0.1 0:00.68 php
25360 emogurlz 20 0 295m 44m 9840 S 0.0 0.2 0:03.74 php
25417 stankhol 20 0 286m 35m 9.9m S 0.0 0.1 0:02.03 php
25437 stankhol 20 0 291m 37m 9.8m S 0.0 0.2 0:02.58 php
25452 spectrot 20 0 303m 51m 9320 S 0.0 0.2 0:01.51 php
25457 spectrop 20 0 285m 31m 9528 S 0.0 0.1 0:00.80 php
25460 allnjeve 20 0 297m 44m 10m S 0.0 0.2 0:01.81 php
25513 allnjwex 20 0 286m 32m 9352 S 0.0 0.1 0:00.49 php
25680 chaven 20 0 298m 44m 9712 S 0.0 0.2 0:04.67 php
26023 spicypor 20 0 308m 55m 9.8m S 0.0 0.2 0:02.19 php
26029 spicypor 20 0 309m 55m 9824 S 0.0 0.2 0:01.86 php
26096 njdiscou 20 0 297m 42m 9m S 0.0 0.2 0:00.41 php
26105 njdiscou 20 0 290m 38m 9360 S 0.0 0.2 0:00.51 php
26821 triplexx 20 0 271m 18m 9016 S 0.0 0.1 0:00.06 php
26927 allpasho 20 0 298m 46m 9444 S 0.0 0.2 0:00.59 php
28214 hughelli 20 0 303m 49m 9396 S 0.0 0.2 0:01.46 php
29464 galaxyof 20 0 269m 14m 8852 S 0.0 0.1 0:00.10 php
29593 allnjinf 20 0 283m 33m 9424 S 0.0 0.1 0:01.17 php
29689 ultimate 20 0 293m 39m 9664 S 0.0 0.2 0:00.54 php
29903 allnjgif 20 0 270m 16m 9252 S 0.0 0.1 0:00.31 php
31127 studcart 20 0 288m 34m 9612 S 0.0 0.1 0:01.15 php
31305 chavenb 20 0 288m 34m 9184 S 0.0 0.1 0:00.67 php
31335 allnjcla 20 0 323m 71m 9604 S 0.0 0.3 0:00.56 php
31341 allnjcla 20 0 331m 77m 9676 S 0.0 0.3 0:01.77 php
31381 mommagco 20 0 299m 47m 9768 S 0.0 0.2 0:00.93 php
31389 mommagco 20 0 296m 45m 9.9m S 0.0 0.2 0:00.99 php
32100 dietblas 20 0 268m 14m 8168 S 0.0 0.1 0:00.02 php
total used free shared buffers cached
Mem: 24034 14601 9433 0 988 8765
Low: 24034 14601 9433
High: 0 0 0
-/+ buffers/cache: 4846 19187
Swap: 60399 0 60399
MemTotal: 24611332 kB
MemFree: 9660128 kB
Buffers: 1012032 kB
Cached: 8976252 kB
SwapCached: 0 kB
Active: 8670012 kB
Inactive: 5014208 kB
Active(anon): 3696972 kB
Inactive(anon): 1468 kB
Active(file): 4973040 kB
Inactive(file): 5012740 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 61849596 kB
SwapFree: 61849596 kB
Dirty: 1144 kB
Writeback: 12 kB
AnonPages: 3695864 kB
Mapped: 54792 kB
Shmem: 2512 kB
Slab: 848408 kB
SReclaimable: 795152 kB
SUnreclaim: 53256 kB
KernelStack: 2408 kB
PageTables: 53156 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 74155260 kB
Committed_AS: 6260012 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 256968 kB
VmallocChunk: 34359288200 kB
HardwareCorrupted: 0 kB
AnonHugePages: 2332672 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 8192 kB
DirectMap2M: 25149440 kB
Private + Shared = RAM used Program
180.0 KiB + 220.0 KiB = 400.0 KiB atd
184.0 KiB + 236.0 KiB = 420.0 KiB ossec-monitord
488.0 KiB + 0.0 KiB = 488.0 KiB pure-uploadscript
200.0 KiB + 312.0 KiB = 512.0 KiB ossec-logcollector
356.0 KiB + 308.0 KiB = 664.0 KiB ossec-maild
192.0 KiB + 580.0 KiB = 772.0 KiB auditd
488.0 KiB + 476.0 KiB = 964.0 KiB mingetty (6)
176.0 KiB + 900.0 KiB = 1.1 MiB anvil
336.0 KiB + 752.0 KiB = 1.1 MiB ossec-execd
300.0 KiB + 828.0 KiB = 1.1 MiB dovecot
324.0 KiB + 940.0 KiB = 1.2 MiB log
716.0 KiB + 644.0 KiB = 1.3 MiB crond
272.0 KiB + 1.2 MiB = 1.5 MiB init
1.2 MiB + 324.0 KiB = 1.5 MiB udevd (3)
612.0 KiB + 980.0 KiB = 1.6 MiB rsyslogd
336.0 KiB + 1.3 MiB = 1.7 MiB mysqld_safe
484.0 KiB + 1.3 MiB = 1.8 MiB pure-authd
420.0 KiB + 1.5 MiB = 1.9 MiB bash
744.0 KiB + 1.2 MiB = 1.9 MiB mysqlmymonlite.
672.0 KiB + 1.3 MiB = 2.0 MiB pure-ftpd
940.0 KiB + 1.1 MiB = 2.0 MiB config
240.0 KiB + 2.1 MiB = 2.3 MiB whmsonicsrv
2.2 MiB + 704.0 KiB = 2.9 MiB exim
2.2 MiB + 768.0 KiB = 3.0 MiB cpanellogd - sl
1.4 MiB + 2.4 MiB = 3.7 MiB imap-login (2)
1.4 MiB + 2.5 MiB = 4.0 MiB pop3-login (2)
1.7 MiB + 3.1 MiB = 4.8 MiB sshd (2)
5.0 MiB + 1.4 MiB = 6.4 MiB queueprocd - wa
4.5 MiB + 2.4 MiB = 6.9 MiB watchmysql
5.3 MiB + 2.5 MiB = 7.8 MiB cPhulkd - proce
7.6 MiB + 1.2 MiB = 8.8 MiB psmon
8.9 MiB + 616.0 KiB = 9.5 MiB ossec-analysisd
8.7 MiB + 1.0 MiB = 9.8 MiB ossec-dbd
7.4 MiB + 2.8 MiB = 10.2 MiB leechprotect
10.8 MiB + 1.3 MiB = 12.2 MiB tailwatchd
11.9 MiB + 516.0 KiB = 12.4 MiB ossec-syscheckd
13.2 MiB + 1.8 MiB = 15.0 MiB cpsrvd-ssl
16.2 MiB + 344.0 KiB = 16.5 MiB cpdavd - accept
29.5 MiB + 2.4 MiB = 31.9 MiB named
53.0 MiB + 3.2 MiB = 56.2 MiB /usr/local/cpan (2)
92.6 MiB + 1.1 MiB = 93.7 MiB spamd child (2)
375.3 MiB + 11.7 MiB = 387.0 MiB tortixd (5)
443.9 MiB + 5.6 MiB = 449.5 MiB clamd
456.3 MiB + 7.1 MiB = 463.3 MiB mysqld
1.0 GiB + 5.2 MiB = 1.0 GiB httpd (13)
2.2 GiB + 10.3 MiB = 2.2 GiB php (81)
Private + Shared = RAM used Program
----------------------------
Server Disk Usage
----------------------------
Filesystem Type Size Used Avail Use% Mounted on
/dev/mapper/vg_server1-lv_root
ext4 247G 57G 178G 25% /
tmpfs tmpfs 12G 0 12G 0% /dev/shm
/dev/sdf1 ext4 485M 114M 346M 25% /boot
/dev/mapper/vg_server1-lv_home
ext4 13T 110G 12T 1% /home
----------------------------
MySQL datadir disk usage
----------------------------
/var/lib/mysql/ uses 36667792 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) 192158
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
----------------------------------------------------------
tail -15 /etc/security/limits.conf
----------------------------------------------------------
# - nice - max nice priority allowed to raise to values: [-20, 19]
# - rtprio - max realtime priority
#
#<domain> <type> <item> <value>
#
#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
# End of file
----------------------------------------------------------
mysqld process limits:
cat /proc/4573/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 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 192158 192158 processes
Max open files 31936 31936 files
Max locked memory 65536 65536 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 192158 192158 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
----------------------------------
WEB SERVER & PHP Info:
----------------------------------
PHP 5.3.28 (cli) (built: May 23 2014 21:29:22)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2013 Zend Technologies
with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd.
System => Linux yourserverhostname 3.2.58-68.art.x86_64 #1 SMP Thu May 15 13:40:36 EDT 2014 x86_64
Build Date => May 23 2014 21:28:32
Configure Command => './configure' '--disable-fileinfo' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-magic-quotes' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-wddx' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-curl=/opt/curlssl/' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--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-sqlite=shared' '--with-tidy=/opt/tidy/' '--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 | 20090626
Zend Extension Build | API220090626,NTS
PHP Extension Build | API20090626,NTS
DOM/XML API Version | 20031129
Client API version | 5.5.36
Client API library version | 5.5.36
Client API header version | 5.5.36
Client API version | 5.5.36
Phar API version | 1.1.1
display_errors | STDOUT | STDOUT
error_log | error_log | error_log
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 | 1024 | 1024
magic_quotes_gpc | Off | Off
magic_quotes_sybase | Off | Off
max_execution_time | 0 | 0
max_file_uploads | 20 | 20
memory_limit | 256M | 256M
open_basedir | no value | no value
post_max_size | 4096M | 4096M
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 | 4096M | 4096M
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
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, sqlite2, mysql
PDO Driver for MySQL => enabled
Client API version => 5.5.36
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: 21d763042eb5769ae0a09dc1118df2b5aae6fb33 $
Phar-based phar archives => enabled
Tar-based phar archives => enabled
ZIP-based phar archives => enabled
gzip compression => enabled
bzip2 compression => disabled (install pecl/bz2)
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.27 (Unix) mod_ssl/2.2.27 OpenSSL/1.0.1e-fips
Server Built: May 23 2014 21:25:55
Current Time: Saturday, 24-May-2014 21:51:25 EDT
Restart Time: Saturday, 24-May-2014 13:57:59 EDT
Parent Server Generation: 5
Total accesses: 70508 - Total Traffic: 616.0 MB
CPU Usage: u37.67 s9.88 cu7.27 cs0 - .193% CPU load
2.48 requests/sec - 22.2 kB/second - 8.9 kB/request
2 requests currently being processed, 9 idle workers
Server version: Apache/2.2.27 (Unix)
Server built: May 23 2014 21:25:55
Cpanel::Easy::Apache v3.24.18 rev9999
Server's Module Magic Number: 20051115:33
Server loaded: APR 1.5.0, APR-Util 1.5.3
Compiled using: APR 1.5.0, APR-Util 1.5.3
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_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_default_module (static)
auth_basic_module (static)
auth_digest_module (static)
file_cache_module (static)
cache_module (static)
disk_cache_module (static)
mem_cache_module (static)
include_module (static)
filter_module (static)
deflate_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)
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)
dav_module (static)
status_module (static)
autoindex_module (static)
asis_module (static)
info_module (static)
suexec_module (static)
cgi_module (static)
dav_fs_module (static)
dav_lock_module (static)
negotiation_module (static)
dir_module (static)
actions_module (static)
speling_module (static)
userdir_module (static)
alias_module (static)
rewrite_module (static)
so_module (static)
sed_module (shared)
security2_module (shared)
evasive20_module (shared)
bwlimited_module (shared)
cloudflare_module (shared)
fastinclude_module (shared)
fcgid_module (shared)
Compiled in modules:
core.c
mod_authn_file.c
mod_authn_dbm.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_default.c
mod_auth_basic.c
mod_auth_digest.c
mod_file_cache.c
mod_cache.c
mod_disk_cache.c
mod_mem_cache.c
mod_include.c
mod_filter.c
mod_deflate.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_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_dav.c
mod_status.c
mod_autoindex.c
mod_asis.c
mod_info.c
mod_suexec.c
mod_cgi.c
mod_dav_fs.c
mod_dav_lock.c
mod_negotiation.c
mod_dir.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 300
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
</IfModule>
StartServers 5
<IfModule prefork.c>
MinSpareServers 5
MaxSpareServers 10
</IfModule>
MinSpareServers 5
MaxSpareServers 10
</IfModule>
ServerLimit 2048
MaxClients 150
MaxRequestsPerChild 10000
</IfModule>
----------------------------
mysqlreport output
----------------------------
MySQL 5.5.36-cll uptime 0 7:52:45 Sat May 24 21:52:04 2014
__ Key _________________________________________________________________
Buffer used 6.54M of 8.00M %Used: 81.76
Current 4.73M %Usage: 59.12
Write hit 99.04%
Read hit 99.94%
__ Questions ___________________________________________________________
Total 1.78M 62.7/s
QC Hits 1.13M 40.0/s %Total: 63.70
DMS 541.95k 19.1/s 30.46
Com_ 223.61k 7.9/s 12.57
-Unknown 157.84k 5.6/s 8.87
COM_QUIT 38.20k 1.3/s 2.15
Slow 10 s 4 0.0/s 0.00 %DMS: 0.00 Log: OFF
DMS 541.95k 19.1/s 30.46
INSERT 272.48k 9.6/s 15.31 50.28
SELECT 224.72k 7.9/s 12.63 41.47
DELETE 16.05k 0.6/s 0.90 2.96
REPLACE 15.53k 0.5/s 0.87 2.86
UPDATE 13.17k 0.5/s 0.74 2.43
Com_ 223.61k 7.9/s 12.57
set_option 52.85k 1.9/s 2.97
change_db 33.20k 1.2/s 1.87
stmt_close 30.93k 1.1/s 1.74
__ Rows ________________________________________________________________
Rows 2.17G 76.3k/s
Using idx 651.58M 23.0k/s %Index: 30.09
Rows/question 1.22k
__ SELECT and Sort _____________________________________________________
Scan 44.98k 1.6/s %SELECT: 20.02
Range 30.60k 1.1/s 13.62
Full join 305 0.0/s 0.14
Range check 2 0.0/s 0.00
Full rng join 16 0.0/s 0.01
Sort scan 53.37k 1.9/s
Sort range 15.12k 0.5/s
Sort mrg pass 38 0.0/s
__ Query Cache _________________________________________________________
Memory usage 24.57M of 32.00M %Usage: 76.78
Block Fragmnt 6.91%
Hits 1.13M 40.0/s
Inserts 184.82k 6.5/s
Insrt:Prune 2.47:1 3.9/s
Hit:Insert 6.13:1
__ Table Locks _________________________________________________________
Waited 2.35k 0.1/s %Total: 0.40
Immediate 585.43k 20.6/s
__ Tables ______________________________________________________________
Open 400 of 400 %Cache: 100.00
Opened 1.15M 40.5/s
__ Connections _________________________________________________________
Max used 30 of 151 %Max: 19.87
Total 38.88k 1.4/s
__ Created Temp ________________________________________________________
Disk table 19.75k 0.7/s %Disk: 37.83
Table 52.21k 1.8/s Size: 16.0M
File 46 0.0/s
__ Threads _____________________________________________________________
Running 1 of 6
Created 38.82k 1.4/s
Slow 0 0/s
Cached 0 of 0 %Hit: 0.16
__ Aborted _____________________________________________________________
Clients 1.35k 0.0/s
Connects 11 0.0/s
__ Bytes _______________________________________________________________
Sent 2.32G 81.7k/s
Received 226.99M 8.0k/s
__ InnoDB Buffer Pool __________________________________________________
Usage 128.00M of 128.00M %Usage: 100.00
Read hit 99.80%
Pages
Free 0 %Total: 0.00
Data 8.05k 98.32 %Drty: 0.00
Misc 138 1.68
Latched 0 0.00
Reads 548.34M 19.3k/s
From disk 1.09M 38.5/s %Disk: 0.20
Ahead Rnd 0 0/s
Writes 482.12k 17.0/s
Wait Free 0 0/s %Wait: 0.00
Flushes 97.56k 3.4/s
__ InnoDB Lock _________________________________________________________
Waits 2 0.0/s
Current 0
Time acquiring
Total 44 ms
Average 22 ms
Max 43 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 1.12M 39.5/s
Writes 123.09k 4.3/s
fsync 38.09k 1.3/s
Pending
Reads 0
Writes 0
fsync 1
Pages
Created 8.42k 0.3/s
Read 1.12M 39.4/s
Written 97.57k 3.4/s
Rows
Deleted 1.70k 0.1/s
Inserted 21.61k 0.8/s
Read 289.57M 10.2k/s
Updated 31.72k 1.1/s
----------------------------
Total Server MyISAM and InnoDB Size
----------------------------
*************************** 1. row ***************************
innodb_tablespace_utilization_perc: 100
total_size_gb: 34.510652558878064
index_size_gb: 1.8998483717441559
data_size_gb: 32.61080418713391
innodb_total_size_gb: 0.404937744140625
innodb_data_size_gb: 0.246978759765625
innodb_index_size_gb: 0.157958984375
myisam_total_size_gb: 34.104802990332246
myisam_data_size_gb: 32.36334981955588
myisam_index_size_gb: 1.7414531707763672
perc_index: 5.505107000
perc_data: 94.494892900
innodb_perc_index: 39.008214600
innodb_perc_data: 60.991785300
myisam_perc_index: 5.106181500
myisam_perc_data: 94.893818400
innodb_perc_total_index: 8.314294200
innodb_perc_total_data: 0.757352500
myisam_perc_total_index: 91.662745100
myisam_perc_total_data: 99.241189000
----------------------------
MySQL settings
----------------------------
[mysqld]
local-infile=0
log-warnings=2
symbolic-links=0
query_cache_size=32m
innodb_file_per_table=1
open_files_limit=31936
[mysqld_safe]
log-error=/var/log/mysqld.log
---
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
| 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/server1.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 | DISABLED |
| 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.36 |
| 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 | OFF |
| lock_wait_timeout | 31536000 |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | /var/log/mysqld.log |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 2 |
| 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 | 31936 |
| 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 | 33554432 |
| 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/server1-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 | EDT |
| 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.36-cll |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| wait_timeout | 28800 |
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
+------------------------------------------+-------------+
| Variable_name | Value |
+------------------------------------------+-------------+
| Aborted_clients | 1355 |
| Aborted_connects | 11 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 227016539 |
| Bytes_sent | 2318370272 |
| Com_admin_commands | 3004 |
| 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_analyze | 0 |
| Com_begin | 70 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 33203 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 71 |
| 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 | 43 |
| Com_create_trigger | 0 |
| Com_create_udf | 0 |
| Com_create_user | 0 |
| Com_create_view | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 15996 |
| Com_delete_multi | 61 |
| 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 | 2 |
| Com_drop_trigger | 0 |
| Com_drop_user | 0 |
| Com_drop_view | 0 |
| Com_empty_query | 0 |
| Com_execute_sql | 0 |
| Com_flush | 1 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 271983 |
| Com_insert_select | 502 |
| Com_install_plugin | 0 |
| Com_kill | 1349 |
| Com_load | 0 |
| Com_lock_tables | 596 |
| Com_optimize | 17 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_release_savepoint | 0 |
| Com_rename_table | 1 |
| Com_rename_user | 0 |
| Com_repair | 0 |
| Com_replace | 15525 |
| 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 | 224742 |
| Com_set_option | 52855 |
| Com_signal | 0 |
| Com_show_authors | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_client_statistics | 0 |
| Com_show_collations | 0 |
| Com_show_contributors | 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 | 449 |
| Com_show_create_trigger | 0 |
| Com_show_databases | 6 |
| 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 | 2421 |
| Com_show_function_status | 0 |
| Com_show_grants | 0 |
| Com_show_index_statistics | 0 |
| Com_show_keys | 70 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_plugins | 0 |
| Com_show_privileges | 0 |
| Com_show_procedure_status | 0 |
| Com_show_processlist | 129 |
| 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 | 390 |
| Com_show_storage_engines | 0 |
| Com_show_table_statistics | 0 |
| Com_show_table_status | 219 |
| Com_show_tables | 1509 |
| Com_show_thread_statistics | 0 |
| Com_show_triggers | 1544 |
| Com_show_user_statistics | 0 |
| Com_show_variables | 22 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 30932 |
| Com_stmt_execute | 30932 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 30932 |
| Com_stmt_reprepare | 0 |
| Com_stmt_reset | 30932 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 1337 |
| Com_uninstall_plugin | 0 |
| Com_unlock_tables | 596 |
| Com_update | 11885 |
| Com_update_multi | 1288 |
| 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 | 38887 |
| Created_tmp_disk_tables | 19762 |
| Created_tmp_files | 46 |
| Created_tmp_tables | 52273 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 1 |
| Delayed_writes | 678 |
| Flush_commands | 1 |
| Handler_commit | 127823 |
| Handler_delete | 3564 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 49209 |
| Handler_read_key | 225607554 |
| Handler_read_last | 1422 |
| Handler_read_next | 402555782 |
| Handler_read_prev | 23604027 |
| Handler_read_rnd | 1339261 |
| Handler_read_rnd_next | 1506848416 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 97846458 |
| Handler_write | 124906324 |
| Innodb_buffer_pool_pages_data | 8074 |
| Innodb_buffer_pool_bytes_data | 132284416 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 97569 |
| Innodb_buffer_pool_pages_free | 0 |
| Innodb_buffer_pool_pages_misc | 118 |
| Innodb_buffer_pool_pages_total | 8192 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 17721 |
| Innodb_buffer_pool_read_ahead_evicted | 6858 |
| Innodb_buffer_pool_read_requests | 548751230 |
| Innodb_buffer_pool_reads | 1103518 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 482124 |
| Innodb_data_fsyncs | 38091 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 18487676928 |
| Innodb_data_reads | 1131609 |
| Innodb_data_writes | 123091 |
| Innodb_data_written | 3251286528 |
| Innodb_dblwr_pages_written | 97569 |
| Innodb_dblwr_writes | 3625 |
| Innodb_have_atomic_builtins | ON |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 102668 |
| Innodb_log_writes | 13875 |
| Innodb_os_log_fsyncs | 15984 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 53076992 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 8419 |
| Innodb_pages_read | 1128136 |
| Innodb_pages_written | 97569 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 44 |
| Innodb_row_lock_time_avg | 22 |
| Innodb_row_lock_time_max | 43 |
| Innodb_row_lock_waits | 2 |
| Innodb_rows_deleted | 1697 |
| Innodb_rows_inserted | 21608 |
| Innodb_rows_read | 289694146 |
| Innodb_rows_updated | 31722 |
| Innodb_truncated_status_writes | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 4331 |
| Key_blocks_used | 6698 |
| Key_read_requests | 725100457 |
| Key_reads | 403034 |
| Key_write_requests | 82486923 |
| Key_writes | 795903 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 30 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 796 |
| Open_streams | 0 |
| Open_table_definitions | 400 |
| Open_tables | 400 |
| Opened_files | 2041056 |
| Opened_table_definitions | 1115785 |
| Opened_tables | 1153904 |
| 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 | 2174 |
| Qcache_free_memory | 7788344 |
| Qcache_hits | 1133734 |
| Qcache_inserts | 184819 |
| Qcache_lowmem_prunes | 74895 |
| Qcache_not_cached | 38855 |
| Qcache_queries_in_cache | 14026 |
| Qcache_total_blocks | 31517 |
| Queries | 1921600 |
| Questions | 1779698 |
| Rpl_status | AUTH_MASTER |
| Select_full_join | 305 |
| Select_full_range_join | 16 |
| Select_range | 30613 |
| Select_range_check | 2 |
| Select_scan | 44995 |
| 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 | 4 |
| Sort_merge_passes | 38 |
| Sort_range | 15118 |
| Sort_rows | 6338444 |
| Sort_scan | 53376 |
| 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 | 585459 |
| Table_locks_waited | 2354 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 7 |
| Threads_created | 38825 |
| Threads_running | 2 |
| Uptime | 28367 |
| Uptime_since_flush_status | 28367 |
+------------------------------------------+-------------+
+-------+---------------+-----------------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+---------------+-----------------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 3 | eximstats | localhost | eximstats | Sleep | 54 | | |
| 4 | tortix | localhost:60205 | tortix | Sleep | 49 | | |
| 1144 | root | localhost | | Sleep | 481 | | |
| 34788 | leechprotect | localhost | leechprotect | Sleep | 2722 | | |
| 34868 | DELAYED | localhost | eximstats | Delayed insert | 54 | Waiting for INSERT | |
| 38490 | thatsoci_cg11 | localhost | thatsoci_ssg | Sleep | 256 | | |
| 38883 | tortix | localhost:39664 | tortix | Query | 0 | Writing to net | SELECT rule_id,SUM(total) AS rcount FROM aslw_stat_ip WHERE rule_id BETWEEN 300000 AND 399999 AND dt |
| 38886 | root | localhost | | Query | 0 | | show processlist |
+-------+---------------+-----------------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
------------------------------------
INNODB Buffer Pool Stats
------------------------------------
*************************** 1. row ***************************
POOL_ID: 0
POOL_SIZE: 8192
FREE_BUFFERS: 0
DATABASE_PAGES: 8074
OLD_DATABASE_PAGES: 2960
MODIFIED_DATABASE_PAGES: 0
PENDING_DECOMPRESS: 0
PENDING_READS: 0
PENDING_FLUSH_LRU: 0
PENDING_FLUSH_LIST: 0
PAGES_MADE_YOUNG: 1119698
PAGES_NOT_MADE_YOUNG: 0
PAGES_MADE_YOUNG_RATE: 183.390436222357
PAGES_MADE_NOT_YOUNG_RATE: 0
NUMBER_PAGES_READ: 1128137
NUMBER_PAGES_CREATED: 8419
NUMBER_PAGES_WRITTEN: 97569
PAGES_READ_RATE: 183.96419730824087
PAGES_CREATE_RATE: 0.34425665153030277
PAGES_WRITTEN_RATE: 4.770413599777053
NUMBER_PAGES_GET: 548751235
HIT_RATE: 995
YOUNG_MAKE_PER_THOUSAND_GETS: 5
NOT_YOUNG_MAKE_PER_THOUSAND_GETS: 0
NUMBER_PAGES_READ_AHEAD: 17721
NUMBER_READ_AHEAD_EVICTED: 6858
READ_AHEAD_RATE: 3.131096211537516
READ_AHEAD_EVICTED_RATE: 1.9180013442402584
LRU_IO_TOTAL: 11268
LRU_IO_CURRENT: 1
UNCOMPRESS_TOTAL: 0
UNCOMPRESS_CURRENT: 0
----------------------------
INNODB Status
----------------------------
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
140524 21:52:06 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 61 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 21809 1_second, 21807 sleeps, 2016 10_second, 1863 background, 1863 flush
srv_master_thread log flush and writes: 22506
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 3458, signal count 5602
Mutex spin waits 13567, rounds 53921, OS waits 433
RW-shared spins 4854, rounds 110065, OS waits 2480
RW-excl spins 1059, rounds 32025, OS waits 303
Spin rounds per wait: 3.97 mutex, 22.68 RW-shared, 30.24 RW-excl
------------
TRANSACTIONS
------------
Trx id counter AD2195
Purge done for trx's n:o < AD2180 undo n:o < 0
History list length 1351
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 38888, OS thread handle 0x2f833e19700, query id 1921611 localhost root
show engine innodb status
---TRANSACTION AD1C09, not started
MySQL thread id 38490, OS thread handle 0x2f894a1c700, query id 1908191 localhost thatsoci_cg11
---TRANSACTION AD204E, not started
MySQL thread id 4, OS thread handle 0x2f8a452c700, query id 1918576 localhost 127.0.0.1 tortix
---TRANSACTION AD2194, ACTIVE 0 sec
mysql tables in use 1, locked 0
MySQL thread id 38883, OS thread handle 0x2f833cf4700, query id 1921606 localhost 127.0.0.1 tortix Copying to tmp table
SELECT code,SUM(total) AS tcount FROM aslw_stat_geo WHERE dt>=DATE_SUB(NOW(),INTERVAL 1 MONTH) GROUP BY code ORDER BY tcount DESC LIMIT 5
Trx read view will not see trx with id >= AD2195, sees < AD2195
--------
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
1131625 OS file reads, 123091 OS file writes, 38091 OS fsyncs
184.21 reads/s, 16384 avg bytes/read, 6.03 writes/s, 1.69 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 365, seg size 367, 7071 merges
merged operations:
insert 12566, delete mark 31, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 122 buffer(s)
10583.53 hash searches/s, 165.57 non-hash searches/s
---
LOG
---
Log sequence number 4102504119
Log flushed up to 4102504119
Last checkpoint at 4102504119
0 pending log writes, 0 pending chkp writes
15967 log i/o's done, 0.79 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 137363456; in additional pool allocated 0
Dictionary memory allocated 12677171
Buffer pool size 8192
Free buffers 0
Database pages 8070
Old database pages 2958
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1119713, not young 0
15000.00 youngs/s, 0.00 non-youngs/s
Pages read 1128152, created 8419, written 97569
15000.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8070, unzip_LRU len: 0
I/O sum[11268]:cur[16], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Main thread process no. 4573, id 3266629908224, state: sleeping
Number of rows inserted 21608, updated 31722, deleted 1697, read 289696676
0.31 inserts/s, 0.15 updates/s, 0.23 deletes/s, 11752.63 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
----------------------------
MySQL Error Log
----------------------------
140524 21:18:47 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:22:05 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:23:11 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:24:30 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:31:54 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:33:15 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:33:19 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:33:19 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:34:40 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:35:06 [Warning] Access denied for user 'spiry'@'localhost' (using password: YES)
140524 21:38:08 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:39:36 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:41:50 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:44:16 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
140524 21:44:58 [ERROR] Got error 127 when reading table './cupidspl_dating/skadate_blog_post'
Report Complete:
Sat May 24 21:52:06 EDT 2014
----------------------------
