Hello,
I recently upgraded my dedicated server to Apache/2.4.7 (Unix) PHP/5.3.28 MySQL 5.5.36-cll
The server is only running a vBulletin forum (3.7 branch with all patches) that gets around 15,000 daily visits with around 800 visitors in the busiest hours.
During those hours, the forum works very slow, so I was looking for some help optimizing the server.
I have installed mysqlmymonlite.sh for CentOS / WHM to get all the info need, if someone may help me I would be very grateful
I recently upgraded my dedicated server to Apache/2.4.7 (Unix) PHP/5.3.28 MySQL 5.5.36-cll
The server is only running a vBulletin forum (3.7 branch with all patches) that gets around 15,000 daily visits with around 800 visitors in the busiest hours.
During those hours, the forum works very slow, so I was looking for some help optimizing the server.
I have installed mysqlmymonlite.sh for CentOS / WHM to get all the info need, if someone may help me I would be very grateful
Code:
-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.2 WHM mysqlmymon.com
compiled by George Liu (eva2000) vbtechsupport.com
-------------------------------------------------------------
Report Generated:
Mon Mar 24 05:28:47 PDT 2014
Code:
----------------------------
MySQL Uptime:
----------------------------
MySQL server was started 2014-03-23 17:57:44
Uptime: 11 hours 31 min 2 sec
Uptime 41462
Uptime_since_flush_status 41462
--------------------
Query Cache Limit (bytes): 1048576
Query Cache Min Unit (bytes): 4096
Query Cache Size (bytes): 134217728
Query Cache Free Mem (bytes): 120641184
Query Cache Used Mem (bytes): 13576544
Queries in Query Cache: 1
Query Cache Avg Size (bytes): 13576544
Code:
----------------------------
Hardware Info:
----------------------------
Processors physical = 2, cores = 2, virtual = 4, hyperthreading = yes
4 2800.304
4 Intel(R) Xeon(TM) CPU 2.80GHz
4 2048 KB
Code:
----------------------------
TOP stats
----------------------------
Linux 2.6.18-274.3.1.el5PAE ((yourserverhostname)) 03/24/2014
05:28:47 AM CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s
05:28:49 AM all 48.06 0.00 3.12 0.25 0.00 0.12 0.00 48.44 1156.00
05:28:49 AM 0 60.00 0.00 4.00 1.00 0.00 0.00 0.00 35.00 1001.50
05:28:49 AM 1 41.29 0.00 2.49 0.00 0.50 0.50 0.00 55.22 154.50
05:28:49 AM 2 66.83 0.00 4.02 0.00 0.00 0.00 0.00 29.15 0.00
05:28:49 AM 3 24.38 0.00 1.49 0.00 0.00 0.00 0.00 74.13 0.00
05:28:49 AM CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s
05:28:51 AM all 13.72 0.00 1.12 0.25 0.12 0.12 0.00 84.66 1129.50
05:28:51 AM 0 3.50 0.00 0.50 0.00 0.00 0.00 0.00 96.00 1001.00
05:28:51 AM 1 16.50 0.00 1.50 0.50 0.00 0.50 0.00 81.00 128.50
05:28:51 AM 2 4.98 0.00 1.00 0.00 0.00 0.00 0.00 94.03 0.00
05:28:51 AM 3 30.50 0.00 2.00 0.00 0.00 0.00 0.00 67.50 0.00
Average: CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s
Average: all 30.88 0.00 2.12 0.25 0.06 0.12 0.00 66.56 1142.75
Average: 0 31.75 0.00 2.25 0.50 0.00 0.00 0.00 65.50 1001.25
Average: 1 28.93 0.00 2.00 0.25 0.25 0.50 0.00 68.08 141.50
Average: 2 35.75 0.00 2.50 0.00 0.00 0.00 0.00 61.75 0.00
Average: 3 27.43 0.00 1.75 0.00 0.00 0.00 0.00 70.82 0.00
top - 05:28:51 up 27 days, 14:22, 1 user, load average: 2.27, 2.15, 2.06
Tasks: 222 total, 1 running, 219 sleeping, 0 stopped, 2 zombie
Cpu(s): 47.2%us, 3.5%sy, 0.1%ni, 48.3%id, 0.5%wa, 0.0%hi, 0.4%si, 0.0%st
Mem: 4151412k total, 3603144k used, 548268k free, 160700k buffers
Swap: 4192956k total, 80k used, 4192876k free, 2312324k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
30737 nobody 15 0 73268 15m 6756 S 15.6 0.4 0:00.18 httpd
29871 nobody 15 0 73144 15m 7408 S 1.9 0.4 0:02.62 httpd
30034 nobody 22 0 0 0 0 Z 1.9 0.0 0:01.15 httpd <defunct>
30792 nobody 15 0 72868 15m 6984 S 1.9 0.4 0:00.47 httpd
1 root 15 0 2176 640 556 S 0.0 0.0 0:10.16 init
2 root RT -5 0 0 0 S 0.0 0.0 0:06.71 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.14 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:05.36 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.16 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:06.67 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.13 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:05.87 migration/3
12 root 34 19 0 0 0 S 0.0 0.0 0:00.11 ksoftirqd/3
13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.10 events/0
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.10 events/1
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.10 events/2
17 root 10 -5 0 0 0 S 0.0 0.0 0:00.12 events/3
18 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
19 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kthread
25 root 10 -5 0 0 0 S 0.0 0.0 0:01.30 kblockd/0
26 root 10 -5 0 0 0 S 0.0 0.0 0:03.10 kblockd/1
27 root 10 -5 0 0 0 S 0.0 0.0 0:01.37 kblockd/2
28 root 10 -5 0 0 0 S 0.0 0.0 0:04.32 kblockd/3
29 root 19 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
117 root 19 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/0
118 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/1
119 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/2
120 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/3
123 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
125 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
198 root 15 0 0 0 0 S 0.0 0.0 0:00.17 khungtaskd
201 root 10 -5 0 0 0 S 0.0 0.0 1:36.07 kswapd0
202 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
203 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
204 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 aio/2
205 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 aio/3
361 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
405 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
406 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/1
407 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 ata/2
408 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 ata/3
409 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 ata_aux
415 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
416 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
417 root 10 -5 0 0 0 S 0.0 0.0 5:02.18 kjournald
442 root 10 -5 0 0 0 S 0.0 0.0 0:01.87 kauditd
475 root 21 -4 2404 636 392 S 0.0 0.0 0:00.45 udevd
950 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kedac
1367 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kstriped
1386 root 12 -5 0 0 0 S 0.0 0.0 0:00.00 kmpathd/0
1388 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 kmpathd/1
1389 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 kmpathd/2
1390 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 kmpathd/3
1391 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 kmpath_handlerd
1511 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kjournald
1513 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kjournald
1678 root 0 -20 0 0 0 S 0.0 0.0 0:16.55 loop0
1679 root 10 -5 0 0 0 S 0.0 0.0 0:01.35 kjournald
1767 root 18 -5 0 0 0 S 0.0 0.0 0:00.00 iscsi_eh
1831 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cnic_wq
1854 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 ib_addr
1873 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 ib_mcast
1874 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 ib_inform
1875 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 local_sa
1881 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 iw_cm_wq
1889 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 ib_cm/0
1890 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 ib_cm/1
1891 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 ib_cm/2
1892 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 ib_cm/3
1897 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 rdma_cm
1917 root 10 -10 22524 21m 1736 S 0.0 0.5 0:00.03 iscsiuio
1921 root 18 0 2372 420 348 S 0.0 0.0 0:04.12 iscsid
1922 root 5 -10 2836 2832 1904 S 0.0 0.1 0:00.04 iscsid
3739 root 15 0 0 0 0 S 0.0 0.0 0:00.32 pdflush
3994 root 15 0 0 0 0 S 0.0 0.0 0:05.79 pdflush
5918 root 15 0 8988 2868 2300 S 0.0 0.1 0:00.05 sshd
5919 sshd 15 0 8700 1332 868 S 0.0 0.0 0:00.03 sshd
6781 root 19 -4 13696 876 560 S 0.0 0.0 0:43.21 auditd
6783 root 7 -8 13216 932 584 S 0.0 0.0 0:09.08 audispd
6928 root 18 0 1832 584 488 S 0.0 0.0 0:19.30 syslogd
6931 root 15 0 1780 408 336 S 0.0 0.0 0:00.00 klogd
6945 root 15 0 2580 380 272 S 0.0 0.0 0:34.73 irqbalance
7017 dbus 16 0 2868 936 728 S 0.0 0.0 0:02.92 dbus-daemon
7060 root 25 0 12848 1296 556 S 0.0 0.0 1:08.16 pcscd
7074 root 21 0 1776 532 452 S 0.0 0.0 0:00.00 acpid
7087 haldaemo 19 0 6116 4084 1608 S 0.0 0.1 0:03.32 hald
7088 root 20 0 3284 984 840 S 0.0 0.0 0:00.00 hald-runner
7096 haldaemo 25 0 2124 804 716 S 0.0 0.0 0:00.00 hald-addon-acpi
7153 root 20 0 30464 1408 1084 S 0.0 0.0 0:02.41 automount
10949 root 15 0 7332 1060 644 S 0.0 0.0 0:04.47 sshd
11128 root 17 0 2892 1052 820 S 0.0 0.0 0:00.64 dovecot
11139 dovenull 18 0 7420 3692 1932 S 0.0 0.1 0:04.07 pop3-login
11140 dovenull 15 0 6112 2184 1796 S 0.0 0.1 0:00.30 imap-login
11141 dovecot 16 0 2772 852 724 S 0.0 0.0 0:03.53 anvil
11142 root 18 0 2904 1088 764 S 0.0 0.0 0:03.09 log
11144 dovenull 18 0 12832 9256 2096 S 0.0 0.2 0:15.08 pop3-login
11145 dovenull 18 0 6112 2524 2100 S 0.0 0.1 0:00.23 imap-login
11147 root 15 0 3576 1668 928 S 0.0 0.0 0:00.35 config
11164 root 15 0 7484 1520 1156 S 0.0 0.0 0:03.68 pure-ftpd
11166 root 16 0 8028 1232 980 S 0.0 0.0 0:00.85 pure-authd
11180 root 18 0 6260 1116 568 S 0.0 0.0 0:04.24 crond
11233 root 18 0 2376 476 360 S 0.0 0.0 0:00.03 atd
11611 root 15 0 17116 12m 4900 S 0.0 0.3 0:11.83 cpsrvd-ssl
11618 named 25 0 74012 7556 2112 S 0.0 0.2 8:29.76 named
11777 root 15 0 8988 2860 2300 S 0.0 0.1 0:00.02 sshd
11778 sshd 15 0 8700 1332 868 S 0.0 0.0 0:00.01 sshd
12821 avahi 18 0 2716 1300 1112 S 0.0 0.0 0:01.10 avahi-daemon
12822 avahi 22 0 2716 328 192 S 0.0 0.0 0:00.00 avahi-daemon
12829 root 15 0 8988 2852 2300 S 0.0 0.1 0:00.03 sshd
12830 sshd 15 0 8700 1328 876 S 0.0 0.0 0:00.00 sshd
12951 root 16 0 3792 720 356 S 0.0 0.0 0:00.43 smartd
12955 root 15 0 1764 444 384 S 0.0 0.0 0:00.00 mingetty
12956 root 15 0 1764 440 384 S 0.0 0.0 0:00.00 mingetty
12957 root 15 0 1764 440 384 S 0.0 0.0 0:00.00 mingetty
12958 root 20 0 1764 440 384 S 0.0 0.0 0:00.00 mingetty
12959 root 20 0 1764 440 384 S 0.0 0.0 0:00.00 mingetty
12960 root 21 0 1764 440 384 S 0.0 0.0 0:00.00 mingetty
13387 root 34 19 27336 10m 2228 S 0.0 0.3 0:03.56 yum-updatesd
13390 root 34 19 2676 1164 952 S 0.0 0.0 0:09.84 gam_server
14864 mailnull 18 0 10556 3844 2556 S 0.0 0.1 0:01.84 exim
14878 root 15 0 31576 27m 2360 S 0.0 0.7 0:08.82 /usr/local/cpan
15378 root 15 0 31576 26m 1176 S 0.0 0.7 0:00.08 spamd child
15410 root 15 0 31576 26m 1176 S 0.0 0.7 0:00.05 spamd child
16608 root 15 0 8988 2852 2300 S 0.0 0.1 0:00.03 sshd
16611 sshd 15 0 8700 1324 876 S 0.0 0.0 0:00.01 sshd
17679 root 15 0 9796 5188 2196 S 0.0 0.1 0:10.76 cPhulkd - proce
18534 root 21 0 5464 1244 1060 S 0.0 0.0 0:00.05 mysqld_safe
18826 mysql 15 0 2030m 543m 5464 S 0.0 13.4 962:19.83 mysqld
19421 root 15 0 8988 2860 2300 S 0.0 0.1 0:00.03 sshd
19424 sshd 15 0 8700 1332 876 S 0.0 0.0 0:00.00 sshd
20060 root 15 0 8988 2856 2300 S 0.0 0.1 0:00.04 sshd
20083 sshd 15 0 8700 1328 868 S 0.0 0.0 0:00.03 sshd
23259 root 18 0 6332 4380 1392 S 0.0 0.1 0:00.62 queueprocd - wa
23305 root 33 18 4584 2104 744 S 0.0 0.1 0:00.54 cpanellogd - sl
24119 root 15 0 8988 2848 2304 S 0.0 0.1 0:00.04 sshd
24120 sshd 15 0 8700 1344 892 S 0.0 0.0 0:00.01 sshd
24893 root 19 0 4128 844 712 S 0.0 0.0 0:00.00 ssl-params
27089 root 18 0 11192 6616 2396 S 0.0 0.2 0:00.24 leechprotect
28222 root 15 0 10336 3044 2440 S 0.0 0.1 0:00.12 sshd
28227 root 15 0 6780 1632 1216 S 0.0 0.0 0:00.01 sftp-server
28261 root 15 0 10204 3040 2456 S 0.0 0.1 0:00.16 sshd
28271 root 15 0 5644 1464 1192 S 0.0 0.0 0:00.05 bash
29789 nobody 15 0 72992 16m 8632 S 0.0 0.4 0:02.35 httpd
29794 nobody 15 0 72616 15m 7352 S 0.0 0.4 0:01.92 httpd
29843 nobody 16 0 72580 14m 7000 S 0.0 0.4 0:01.21 httpd
29858 nobody 16 0 72880 15m 7164 S 0.0 0.4 0:01.63 httpd
29875 nobody 15 0 73588 16m 7468 S 0.0 0.4 0:02.12 httpd
30025 nobody 15 0 73132 15m 6788 S 0.0 0.4 0:00.81 httpd
30032 nobody 15 0 73212 15m 6968 S 0.0 0.4 0:01.41 httpd
30046 nobody 15 0 73276 17m 8716 S 0.0 0.4 0:02.00 httpd
30071 nobody 15 0 72656 16m 8300 S 0.0 0.4 0:01.54 httpd
30238 nobody 15 0 73228 15m 7284 S 0.0 0.4 0:02.96 httpd
30283 nagios 18 0 1920 596 496 S 0.0 0.0 0:08.16 nrpe
30407 nobody 15 0 73208 15m 6772 S 0.0 0.4 0:01.22 httpd
30408 nobody 15 0 72676 15m 7088 S 0.0 0.4 0:01.20 httpd
30409 root 17 0 0 0 0 Z 0.0 0.0 0:00.00 cpsrvd-ss <defunct>
30413 nobody 15 0 73164 15m 7500 S 0.0 0.4 0:02.92 httpd
30574 nobody 15 0 73208 15m 7268 S 0.0 0.4 0:01.35 httpd
30577 nobody 15 0 72896 15m 7072 S 0.0 0.4 0:00.91 httpd
30578 nobody 15 0 72220 14m 6764 S 0.0 0.4 0:00.61 httpd
30582 nobody 15 0 72200 14m 6852 S 0.0 0.4 0:00.88 httpd
30584 nobody 15 0 73736 15m 6768 S 0.0 0.4 0:01.08 httpd
30595 nobody 15 0 72216 16m 9236 S 0.0 0.4 0:02.24 httpd
30597 nobody 15 0 73280 15m 7248 S 0.0 0.4 0:01.02 httpd
30599 nobody 15 0 72888 14m 6856 S 0.0 0.4 0:00.57 httpd
30601 nobody 15 0 72556 14m 6720 S 0.0 0.4 0:00.45 httpd
30604 nobody 15 0 73444 16m 8188 S 0.0 0.4 0:00.37 httpd
30606 nobody 15 0 72836 14m 6720 S 0.0 0.4 0:00.98 httpd
30609 nobody 15 0 73432 17m 8592 S 0.0 0.4 0:01.72 httpd
30612 nobody 15 0 72608 14m 6556 S 0.0 0.4 0:00.79 httpd
30613 nobody 15 0 72616 14m 6612 S 0.0 0.4 0:00.88 httpd
30617 nobody 15 0 72924 14m 6392 S 0.0 0.4 0:00.22 httpd
30618 nobody 15 0 72180 15m 7504 S 0.0 0.4 0:00.53 httpd
30619 nobody 16 0 73160 15m 7216 S 0.0 0.4 0:00.93 httpd
30620 nobody 15 0 72880 14m 6760 S 0.0 0.4 0:00.54 httpd
30623 nobody 16 0 72548 13m 5508 S 0.0 0.3 0:00.25 httpd
30730 nobody 15 0 72588 14m 6628 S 0.0 0.4 0:00.46 httpd
30732 nobody 15 0 73256 16m 7568 S 0.0 0.4 0:00.32 httpd
30733 nobody 15 0 72844 13m 5464 S 0.0 0.3 0:00.29 httpd
30734 nobody 15 0 73208 15m 6848 S 0.0 0.4 0:00.42 httpd
30735 nobody 15 0 72308 13m 5952 S 0.0 0.3 0:00.17 httpd
30738 nobody 15 0 73204 15m 6744 S 0.0 0.4 0:00.21 httpd
30739 nobody 15 0 73292 15m 6752 S 0.0 0.4 0:00.31 httpd
30767 nobody 15 0 72672 14m 6552 S 0.0 0.4 0:00.13 httpd
30768 nobody 15 0 72572 14m 6776 S 0.0 0.4 0:00.82 httpd
30773 nobody 15 0 73584 15m 6340 S 0.0 0.4 0:00.19 httpd
30778 nobody 15 0 72664 13m 6084 S 0.0 0.3 0:00.16 httpd
30781 nobody 15 0 72968 14m 6376 S 0.0 0.4 0:00.58 httpd
30782 nobody 15 0 73204 14m 6280 S 0.0 0.4 0:00.25 httpd
30783 nobody 15 0 72756 14m 6460 S 0.0 0.4 0:00.18 httpd
30784 nobody 15 0 72212 12m 5204 S 0.0 0.3 0:00.09 httpd
30785 nobody 15 0 72220 12m 5204 S 0.0 0.3 0:00.14 httpd
30786 nobody 15 0 72832 14m 6292 S 0.0 0.4 0:00.27 httpd
30788 nobody 16 0 73152 15m 7136 S 0.0 0.4 0:00.62 httpd
30791 nobody 15 0 68916 9212 2824 S 0.0 0.2 0:00.03 httpd
30793 nobody 16 0 72928 14m 6616 S 0.0 0.4 0:00.22 httpd
30794 nobody 15 0 68916 9248 2820 S 0.0 0.2 0:00.04 httpd
30796 nobody 15 0 72964 13m 5500 S 0.0 0.3 0:00.26 httpd
30798 nobody 15 0 72884 14m 5908 S 0.0 0.3 0:00.26 httpd
30803 nobody 15 0 70872 15m 6880 S 0.0 0.4 0:00.20 httpd
30804 nobody 15 0 73644 15m 6468 S 0.0 0.4 0:00.26 httpd
30806 nobody 15 0 72660 14m 6560 S 0.0 0.4 0:00.27 httpd
30808 nobody 15 0 73052 16m 7836 S 0.0 0.4 0:00.32 httpd
30812 nobody 15 0 73252 15m 6524 S 0.0 0.4 0:00.59 httpd
30813 nobody 15 0 71716 12m 5464 S 0.0 0.3 0:00.16 httpd
30815 nobody 15 0 72964 14m 6344 S 0.0 0.4 0:00.48 httpd
30816 nobody 15 0 72564 14m 6148 S 0.0 0.3 0:00.42 httpd
30817 nobody 19 0 72600 15m 7432 S 0.0 0.4 0:01.18 httpd
30818 nobody 15 0 72840 14m 6676 S 0.0 0.4 0:00.31 httpd
30819 nobody 15 0 68924 9252 2820 S 0.0 0.2 0:00.02 httpd
30822 nobody 15 0 72652 13m 6072 S 0.0 0.3 0:00.14 httpd
30824 nobody 15 0 68548 9060 2820 S 0.0 0.2 0:00.04 httpd
30825 nobody 15 0 73144 14m 6508 S 0.0 0.4 0:00.54 httpd
30826 nobody 15 0 71732 12m 5456 S 0.0 0.3 0:00.06 httpd
30829 nobody 15 0 69652 12m 5404 S 0.0 0.3 0:00.05 httpd
30838 root 18 0 5720 1408 960 S 0.0 0.0 0:00.02 mysqlmymonlite.
30980 root 18 0 68400 11m 5264 S 0.0 0.3 0:01.48 httpd
31013 root 15 0 2440 988 708 R 0.0 0.0 0:00.01 top
total used free shared buffers cached
Mem: 4054 3518 535 0 156 2258
Low: 854 629 224
High: 3199 2888 311
-/+ buffers/cache: 1103 2950
Swap: 4094 0 4094
MemTotal: 4151412 kB
MemFree: 548516 kB
Buffers: 160700 kB
Cached: 2312324 kB
SwapCached: 0 kB
Active: 2203488 kB
Inactive: 1207492 kB
HighTotal: 3276544 kB
HighFree: 318588 kB
LowTotal: 874868 kB
LowFree: 229928 kB
SwapTotal: 4192956 kB
SwapFree: 4192876 kB
Dirty: 968 kB
Writeback: 0 kB
AnonPages: 937880 kB
Mapped: 34572 kB
Slab: 155180 kB
PageTables: 13156 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
CommitLimit: 6268660 kB
Committed_AS: 4029748 kB
VmallocTotal: 116728 kB
VmallocUsed: 17804 kB
VmallocChunk: 98344 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
Hugepagesize: 2048 kB
Private + Shared = RAM used Program
88.0 KiB + 9.5 KiB = 97.5 KiB klogd
96.0 KiB + 25.0 KiB = 121.0 KiB acpid
116.0 KiB + 14.0 KiB = 130.0 KiB nrpe
116.0 KiB + 15.5 KiB = 131.5 KiB init
128.0 KiB + 12.5 KiB = 140.5 KiB syslogd
128.0 KiB + 15.5 KiB = 143.5 KiB irqbalance
136.0 KiB + 20.5 KiB = 156.5 KiB atd
128.0 KiB + 51.5 KiB = 179.5 KiB hald-addon-acpi
144.0 KiB + 44.5 KiB = 188.5 KiB anvil
144.0 KiB + 51.0 KiB = 195.0 KiB ssl-params
164.0 KiB + 120.5 KiB = 284.5 KiB hald-runner
280.0 KiB + 15.5 KiB = 295.5 KiB udevd
264.0 KiB + 56.0 KiB = 320.0 KiB pure-authd
304.0 KiB + 55.0 KiB = 359.0 KiB dovecot
340.0 KiB + 47.5 KiB = 387.5 KiB log
300.0 KiB + 98.0 KiB = 398.0 KiB gam_server
388.0 KiB + 16.0 KiB = 404.0 KiB audispd
248.0 KiB + 161.0 KiB = 409.0 KiB mysqld_safe
340.0 KiB + 72.0 KiB = 412.0 KiB mingetty (6)
416.0 KiB + 20.5 KiB = 436.5 KiB auditd
460.0 KiB + 21.0 KiB = 481.0 KiB dbus-daemon
484.0 KiB + 16.5 KiB = 500.5 KiB smartd
440.0 KiB + 79.0 KiB = 519.0 KiB pure-ftpd
460.0 KiB + 68.5 KiB = 528.5 KiB sftp-server
380.0 KiB + 162.5 KiB = 542.5 KiB bash
452.0 KiB + 152.0 KiB = 604.0 KiB mysqlmymonlite.
592.0 KiB + 23.0 KiB = 615.0 KiB crond
468.0 KiB + 184.0 KiB = 652.0 KiB avahi-daemon (2)
760.0 KiB + 43.5 KiB = 803.5 KiB automount
832.0 KiB + 59.0 KiB = 891.0 KiB config
892.0 KiB + 22.5 KiB = 914.5 KiB pcscd
824.0 KiB + 392.0 KiB = 1.2 MiB imap-login (2)
1.3 MiB + 81.0 KiB = 1.4 MiB cpanellogd - sl
1.3 MiB + 395.0 KiB = 1.7 MiB iscsid (2)
1.7 MiB + 239.0 KiB = 2.0 MiB exim
2.9 MiB + 161.5 KiB = 3.0 MiB hald
3.0 MiB + 157.0 KiB = 3.2 MiB queueprocd - wa
2.9 MiB + 328.0 KiB = 3.2 MiB cPhulkd - proce
4.2 MiB + 378.0 KiB = 4.6 MiB leechprotect
6.7 MiB + 53.0 KiB = 6.8 MiB named
4.6 MiB + 4.0 MiB = 8.6 MiB sshd (17)
8.7 MiB + 390.0 KiB = 9.1 MiB pop3-login (2)
8.9 MiB + 503.5 KiB = 9.4 MiB yum-updatesd
2.8 MiB + 8.1 MiB = 10.9 MiB /usr/local/cpan
10.8 MiB + 111.5 KiB = 10.9 MiB cpsrvd-ssl
4.5 MiB + 16.0 MiB = 20.4 MiB spamd child (2)
20.5 MiB + 348.0 KiB = 20.8 MiB iscsiuio
261.6 MiB + 19.2 MiB = 280.8 MiB httpd (74)
546.5 MiB + 190.5 KiB = 546.7 MiB mysqld
---------------------------------
956.6 MiB
=================================
Private + Shared = RAM used Program
smem -uk
User Count Swap USS PSS RSS
nagios 1 0 116.0K 119.0K 596.0K
dovecot 1 0 144.0K 174.0K 852.0K
dbus 1 0 460.0K 464.0K 936.0K
avahi 2 0 468.0K 616.0K 1.6M
mailnull 1 0 1.7M 1.9M 3.8M
sshd 7 0 1.1M 2.4M 9.1M
haldaemon 2 0 3.0M 3.2M 4.8M
named 1 0 6.7M 6.7M 7.4M
dovenull 4 0 9.5M 10.2M 17.2M
root 55 0 76.2M 105.8M 215.8M
nobody 71 0 256.0M 270.3M 1.0G
mysql 1 0 544.5M 544.5M 545.4M
smem -t -p
PID User Command Swap USS PSS RSS
12956 root /sbin/mingetty tty2 0.00% 0.00% 0.00% 0.01%
12957 root /sbin/mingetty tty3 0.00% 0.00% 0.00% 0.01%
12958 root /sbin/mingetty tty4 0.00% 0.00% 0.00% 0.01%
12959 root /sbin/mingetty tty5 0.00% 0.00% 0.00% 0.01%
12960 root /sbin/mingetty tty6 0.00% 0.00% 0.00% 0.01%
12955 root /sbin/mingetty tty1 0.00% 0.00% 0.00% 0.01%
6931 root klogd -x 0.00% 0.00% 0.00% 0.01%
1921 root iscsid 0.00% 0.00% 0.00% 0.01%
7074 root /usr/sbin/acpid 0.00% 0.00% 0.00% 0.01%
30283 nagios /usr/local/nagios/bin/nrpe 0.00% 0.00% 0.00% 0.01%
1 root init [3] 0.00% 0.00% 0.00% 0.02%
6928 root syslogd -m 0 0.00% 0.00% 0.00% 0.01%
6945 root irqbalance 0.00% 0.00% 0.00% 0.01%
12822 avahi avahi-daemon: chroot helpe 0.00% 0.00% 0.00% 0.01%
11233 root /usr/sbin/atd 0.00% 0.00% 0.00% 0.01%
7096 haldaemon hald-addon-acpi: listening 0.00% 0.00% 0.00% 0.02%
11141 dovecot dovecot/anvil 0.00% 0.00% 0.00% 0.02%
24893 root dovecot/ssl-params 0.00% 0.00% 0.00% 0.02%
7088 root hald-runner 0.00% 0.00% 0.01% 0.02%
475 root /sbin/udevd -d 0.00% 0.01% 0.01% 0.02%
11166 root /usr/sbin/pure-authd -s /va 0.00% 0.01% 0.01% 0.03%
16611 sshd sshd: root [net] 0.00% 0.00% 0.01% 0.03%
12830 sshd sshd: root [net] 0.00% 0.00% 0.01% 0.03%
11128 root /usr/sbin/dovecot 0.00% 0.01% 0.01% 0.03%
19424 sshd sshd: root [net] 0.00% 0.00% 0.01% 0.03%
20083 sshd sshd: root [net] 0.00% 0.00% 0.01% 0.03%
5919 sshd sshd: root [net] 0.00% 0.00% 0.01% 0.03%
11778 sshd sshd: root [net] 0.00% 0.00% 0.01% 0.03%
24120 sshd sshd: root [net] 0.00% 0.00% 0.01% 0.03%
11142 root dovecot/log 0.00% 0.01% 0.01% 0.03%
13390 root /usr/libexec/gam_server 0.00% 0.01% 0.01% 0.03%
6783 root /sbin/audispd 0.00% 0.01% 0.01% 0.02%
18534 root /bin/sh /usr/bin/mysqld_saf 0.00% 0.01% 0.01% 0.03%
6781 root auditd 0.00% 0.01% 0.01% 0.02%
10949 root /usr/sbin/sshd 0.00% 0.01% 0.01% 0.03%
7017 dbus dbus-daemon --system 0.00% 0.01% 0.01% 0.02%
12821 avahi avahi-daemon: running [serv 0.00% 0.01% 0.01% 0.03%
12951 root /usr/sbin/smartd -q never 0.00% 0.01% 0.01% 0.02%
28227 root /usr/libexec/openssh/sftp-s 0.00% 0.01% 0.01% 0.04%
11164 root pure-ftpd (SERVER) 0.00% 0.01% 0.01% 0.04%
24119 root sshd: root [priv] 0.00% 0.01% 0.01% 0.07%
12829 root sshd: root [priv] 0.00% 0.01% 0.01% 0.07%
16608 root sshd: root [priv] 0.00% 0.01% 0.01% 0.07%
20060 root sshd: root [priv] 0.00% 0.01% 0.01% 0.07%
11777 root sshd: root [priv] 0.00% 0.01% 0.01% 0.07%
19421 root sshd: root [priv] 0.00% 0.01% 0.01% 0.07%
5918 root sshd: root [priv] 0.00% 0.01% 0.01% 0.07%
28271 root -bash 0.00% 0.01% 0.01% 0.04%
11140 dovenull dovecot/imap-login 0.00% 0.01% 0.01% 0.05%
30838 root /bin/bash ./mysqlmymonlite. 0.00% 0.01% 0.01% 0.03%
11180 root crond 0.00% 0.01% 0.01% 0.03%
11145 dovenull dovecot/imap-login 0.00% 0.01% 0.01% 0.06%
28261 root sshd: root@pts/1 0.00% 0.01% 0.02% 0.07%
28222 root sshd: root@notty 0.00% 0.01% 0.02% 0.07%
7153 root automount --pid-file /var/r 0.00% 0.02% 0.02% 0.03%
30824 nobody /usr/local/apache/bin/httpd 0.00% 0.01% 0.02% 0.22%
11147 root dovecot/config 0.00% 0.02% 0.02% 0.04%
7060 root pcscd 0.00% 0.02% 0.02% 0.03%
30791 nobody /usr/local/apache/bin/httpd 0.00% 0.01% 0.02% 0.22%
23305 root cpanellogd - sleeping for l 0.00% 0.03% 0.03% 0.05%
1922 root iscsid 0.00% 0.03% 0.04% 0.07%
30980 root /usr/local/apache/bin/httpd 0.00% 0.03% 0.04% 0.27%
11139 dovenull dovecot/pop3-login 0.00% 0.04% 0.05% 0.09%
14864 mailnull /usr/sbin/exim -bd -q60m 0.00% 0.04% 0.05% 0.09%
30819 nobody /usr/local/apache/bin/httpd 0.00% 0.06% 0.06% 0.30%
30813 nobody /usr/local/apache/bin/httpd 0.00% 0.06% 0.06% 0.30%
30829 nobody /usr/local/apache/bin/httpd 0.00% 0.06% 0.06% 0.30%
30826 nobody /usr/local/apache/bin/httpd 0.00% 0.06% 0.06% 0.31%
31019 root python /usr/bin/smem -t -p 0.00% 0.06% 0.07% 0.09%
7087 haldaemon hald 0.00% 0.07% 0.07% 0.10%
23259 root queueprocd - wait to proces 0.00% 0.07% 0.08% 0.11%
17679 root cPhulkd - processo 0.00% 0.07% 0.08% 0.12%
30784 nobody /usr/local/apache/bin/httpd 0.00% 0.08% 0.08% 0.32%
30578 nobody /usr/local/apache/bin/httpd 0.00% 0.08% 0.08% 0.35%
30582 nobody /usr/local/apache/bin/httpd 0.00% 0.08% 0.08% 0.36%
30785 nobody /usr/local/apache/bin/httpd 0.00% 0.08% 0.08% 0.33%
30822 nobody /usr/local/apache/bin/httpd 0.00% 0.08% 0.09% 0.34%
30816 nobody /usr/local/apache/bin/httpd 0.00% 0.08% 0.09% 0.35%
30730 nobody /usr/local/apache/bin/httpd 0.00% 0.08% 0.09% 0.36%
30623 nobody /usr/local/apache/bin/httpd 0.00% 0.08% 0.09% 0.33%
29843 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.37%
30601 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.36%
30612 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.36%
30768 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.36%
30793 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.36%
30735 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.34%
30767 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.36%
30577 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.37%
29794 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.38%
30613 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.36%
30408 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.37%
30786 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.35%
30783 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.36%
30595 nobody /usr/local/apache/bin/httpd 0.00% 0.08% 0.09% 0.41%
30599 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.37%
30733 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.09% 0.34%
30798 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.35%
30606 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.37%
30620 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.37%
30796 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.34%
30792 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.37%
30617 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.36%
29858 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.38%
30618 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.37%
30817 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.38%
30815 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.36%
30574 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.38%
30788 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.38%
30025 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.38%
30825 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.37%
30738 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.38%
30619 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.39%
30597 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.39%
30407 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.38%
30808 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.10% 0.40%
30782 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.37%
30734 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.38%
30818 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.37%
29871 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.39%
30032 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.38%
30804 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.10% 0.37%
30812 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.11% 0.37%
30737 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.11% 0.38%
30413 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.11% 0.39%
30739 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.11% 0.38%
29789 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.11% 0.42%
30773 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.11% 0.37%
30238 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.11% 0.39%
30803 nobody /usr/local/apache/bin/httpd 0.00% 0.09% 0.11% 0.40%
30732 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.11% 0.40%
29875 nobody /usr/local/apache/bin/httpd 0.00% 0.11% 0.11% 0.40%
27089 root /usr/local/cpanel/3rdparty/ 0.00% 0.10% 0.11% 0.16%
30046 nobody /usr/local/apache/bin/httpd 0.00% 0.10% 0.11% 0.43%
30806 nobody /usr/local/apache/bin/httpd 0.00% 0.11% 0.12% 0.40%
30584 nobody /usr/local/apache/bin/httpd 0.00% 0.12% 0.12% 0.40%
30604 nobody /usr/local/apache/bin/httpd 0.00% 0.12% 0.13% 0.42%
11618 named /usr/sbin/named -u named -t 0.00% 0.17% 0.17% 0.18%
11144 dovenull dovecot/pop3-login 0.00% 0.17% 0.18% 0.22%
13387 root /usr/bin/python -tt /usr/sb 0.00% 0.22% 0.23% 0.26%
15410 root spamd chil 0.00% 0.05% 0.25% 0.66%
15378 root spamd chil 0.00% 0.06% 0.25% 0.66%
14878 root /usr/local/cpanel/3rdparty/ 0.00% 0.07% 0.27% 0.69%
11611 root cpsrvd (SSL) - waiting for 0.00% 0.27% 0.27% 0.30%
1917 root iscsiuio 0.00% 0.50% 0.51% 0.54%
18826 mysql /usr/sbin/mysqld --basedir= 0.00% 13.38% 13.38% 13.40%
-------------------------------------------------------------------------------
145 12 0.00% 21.98% 23.12% 44.96%
smem -wk
Code:
----------------------------
Server Disk Usage
----------------------------
Filesystem Type Size Used Avail Use% Mounted on
/dev/sda3 ext3 222G 79G 132G 38% /
/dev/sda1 ext3 251M 24M 215M 10% /boot
tmpfs tmpfs 2.0G 0 2.0G 0% /dev/shm
/dev/sdb1 ext3 230G 188M 218G 1% /newstorage
/usr/tmpDSK ext3 1.9G 35M 1.8G 2% /tmp
Code:
----------------------------
MySQL datadir disk usage
----------------------------
/var/lib/mysql/ uses 1804872 kilobytes of disk space
Code:
----------------------------
ulimit -aH
----------------------------
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 73728
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 10240
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 73728
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
Code:
----------------------------------------------------------
tail -15 /etc/security/limits.conf
----------------------------------------------------------
#<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
* hard nofile 10240
* soft nofile 10240
# End of file
Code:
----------------------------------------------------------
mysqld process limits:
cat /proc/18826/limits
----------------------------------------------------------
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 10485760 unlimited bytes
Max core file size 0 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 73728 73728 processes
Max open files 61010 61010 files
Max locked memory 32768 32768 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 73728 73728 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Code:
----------------------------------
CPANEL WEB SERVER & PHP Info:
----------------------------------
WHM / Cpanel version: 11.42.0.22
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: dso
SUEXEC: not installed
RUID2: not installed
PHP 5.3.28 (cli) (built: Feb 25 2014 02:58:29)
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 XCache Cacher v3.0.3, Copyright (c) 2005-2013, by mOo
System => Linux yourserverhostname 2.6.18-274.3.1.el5PAE #1 SMP Tue Sep 6 20:56:05 EDT 2011 i686
Build Date => Feb 25 2014 02:57:42
Configure Command => './configure' '--disable-fileinfo' '--disable-pdo' '--disable-phar' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-sockets' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-freetype-dir=/usr' '--with-gd' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libxml-dir=/opt/xml2/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-zlib' '--with-zlib-dir=/usr' '--without-sqlite3'
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
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 | On | On
magic_quotes_sybase | Off | Off
max_execution_time | 0 | 0
max_file_uploads | 20 | 20
memory_limit | 64M | 64M
open_basedir | no value | no value
post_max_size | 8M | 8M
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 | 2M | 2M
upload_tmp_dir | no value | no value
safe_mode_allowed_env_vars | PHP_ | PHP_
safe_mode_protected_env_vars | LD_LIBRARY_PATH | LD_LIBRARY_PATH
GD Support | enabled
GD Version | bundled (2.1.0 compatible)
FreeType Support | enabled
FreeType Linkage | with freetype
FreeType Version | 2.2.1
GIF Read Support | enabled
GIF Create Support | enabled
JPEG Support | enabled
libJPEG Version | 6b
PNG Support | enabled
libPNG Version | 1.2.10
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
ZLib Support | enabled
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 | On | On
xcache.allocator | bestfit | bestfit
xcache.cacher | On | On
xcache.count | 4 | 4
xcache.gc_interval | 900 | 900
xcache.mmap_path | /dev/zero | /dev/zero
xcache.readonly_protection | Off | Off
xcache.shm_scheme | mmap | mmap
xcache.size | 32M | 32M
xcache.slots | 8K | 8K
xcache.stat | On | On
xcache.ttl | 0 | 0
xcache.var_allocator | bestfit | bestfit
xcache.var_count | 4 | 4
xcache.var_gc_interval | 300 | 300
xcache.var_maxttl | 14400 | 14400
xcache.var_namespace | no value | no value
xcache.var_namespace_mode | 0 | 0
xcache.var_size | 2M | 2M
xcache.var_slots | 4K | 4K
xcache.var_ttl | 7200 | 7200
memcache support => enabled
Active persistent connections => 0
Version => 2.2.7
Revision => $Revision: 327750 $
Directive => Local Value => Master Value
memcache.allow_failover => 1 => 1
memcache.chunk_size => 8192 => 8192
memcache.default_port => 11211 => 11211
memcache.default_timeout_ms => 1000 => 1000
memcache.hash_function => crc32 => crc32
memcache.hash_strategy => standard => standard
memcache.max_failover_attempts => 20 => 20
mysql
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
Server Version: Apache/2.4.7 (Unix) OpenSSL/0.9.8e-fips-rhel5
Server Built: Feb 25 2014 02:54:19
Current Time: Monday, 24-Mar-2014 05:28:46 PDT
Restart Time: Monday, 24-Mar-2014 03:59:39 PDT
Total accesses: 77835 - Total Traffic: 567.7 MB
CPU Usage: u74.71 s6.1 cu0 cs0 - 1.51% CPU load
14.6 requests/sec - 108.7 kB/second - 7.5 kB/request
29 requests currently being processed, 52 idle workers
Server version: Apache/2.4.7 (Unix)
Server built: Feb 25 2014 02:54:19
Cpanel::Easy::Apache v3.24.11 rev9999
Server's Module Magic Number: 20120211:27
Server loaded: APR 1.5.0, APR-UTIL 1.5.3
Compiled using: APR 1.5.0, APR-UTIL 1.5.3
Architecture: 32-bit
Server MPM: prefork
threaded: no
forked: yes (variable process count)
Server compiled with....
-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=256
-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_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_core_module (static)
authz_host_module (static)
authz_groupfile_module (static)
authz_user_module (static)
authz_core_module (static)
access_compat_module (static)
auth_basic_module (static)
socache_shmcb_module (static)
socache_dbm_module (static)
so_module (static)
include_module (static)
filter_module (static)
deflate_module (static)
http_module (static)
mime_module (static)
log_config_module (static)
logio_module (static)
expires_module (static)
headers_module (static)
setenvif_module (static)
proxy_module (static)
proxy_connect_module (static)
proxy_http_module (static)
slotmem_shm_module (static)
ssl_module (static)
mpm_prefork_module (static)
unixd_module (static)
status_module (static)
autoindex_module (static)
info_module (static)
suexec_module (static)
cgi_module (static)
negotiation_module (static)
dir_module (static)
actions_module (static)
userdir_module (static)
alias_module (static)
rewrite_module (static)
bwlimited_module (shared)
disable_suexec_module (shared)
php5_module (shared)
Compiled in modules:
core.c
mod_authn_file.c
mod_authn_core.c
mod_authz_host.c
mod_authz_groupfile.c
mod_authz_user.c
mod_authz_core.c
mod_access_compat.c
mod_auth_basic.c
mod_socache_shmcb.c
mod_socache_dbm.c
mod_so.c
mod_include.c
mod_filter.c
mod_deflate.c
http_core.c
mod_mime.c
mod_log_config.c
mod_logio.c
mod_expires.c
mod_headers.c
mod_setenvif.c
mod_proxy.c
mod_proxy_connect.c
mod_proxy_http.c
mod_slotmem_shm.c
mod_ssl.c
prefork.c
mod_unixd.c
mod_status.c
mod_autoindex.c
mod_info.c
mod_suexec.c
mod_cgi.c
mod_negotiation.c
mod_dir.c
mod_actions.c
mod_userdir.c
mod_alias.c
mod_rewrite.c
Code:
-------------------------------
From /usr/local/apache/conf/httpd.conf
-------------------------------
Timeout 300
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 5
</IfModule>
<IfModule prefork.c>
</IfModule>
<IfModule worker.c>
</IfModule>
StartServers 15
<IfModule prefork.c>
MinSpareServers 15
MaxSpareServers 20
</IfModule>
MinSpareServers 15
MaxSpareServers 20
</IfModule>
ServerLimit 384
</IfModule>
Code:
----------------------------
mysqlreport output
----------------------------
----------------------------
Total Server MyISAM and InnoDB Size
----------------------------
*************************** 1. row ***************************
innodb_tablespace_utilization_perc: NULL
total_size_gb: 1.6771595953032374
index_size_gb: 0.695234127342701
data_size_gb: 0.9819254679605365
innodb_total_size_gb: 0
innodb_data_size_gb: 0
innodb_index_size_gb: 0
myisam_total_size_gb: 1.6740348553285003
myisam_data_size_gb: 0.9790675854310393
myisam_index_size_gb: 0.6949672698974609
perc_index: 41.453069100
perc_data: 58.546930800
innodb_perc_index: NULL
innodb_perc_data: NULL
myisam_perc_index: 41.514504100
myisam_perc_data: 58.485495800
innodb_perc_total_index: 0
innodb_perc_total_data: 0
myisam_perc_total_index: 99.961616100
myisam_perc_total_data: 99.708951100
Code:
----------------------------
MySQL settings
----------------------------
# Example MySQL config file for very large systems.
#
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 1536M
max_allowed_packet = 1M
table_open_cache = 30000
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 512M
thread_cache_size = 8
query_cache_size = 128M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
open_files_limit = 32768
max_connections = 1000
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
# log-bin=mysql-bin
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
# start replication for the first time (even unsuccessfully, for example
# if you mistyped the password in master-password and the slave fails to
# connect), the slave will create a master.info file, and any later
# change in this file to the variables' values below will be ignored and
# overridden by the content of the master.info file, unless you shutdown
# the slave server, delete master.info and restart the slaver server.
# For that reason, you may want to leave the lines below untouched
# (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
#
# binary logging format - mixed recommended
#binlog_format=mixed
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 384M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 100M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 384M
sort_buffer_size = 384M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
---
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
| 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/server.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 | OFF |
| 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 | 1610612736 |
| 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 | 1000 |
| 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 | 4294967295 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| metadata_locks_cache_size | 1024 |
| min_examined_row_limit | 0 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 2146435072 |
| myisam_mmap_size | 4294967295 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 536870912 |
| 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 | 61010 |
| 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/lib/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 | 134217728 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 4096 |
| read_buffer_size | 2097152 |
| read_only | OFF |
| read_rnd_buffer_size | 8388608 |
| 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 | 1 |
| 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/server-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 | PDT |
| table_definition_cache | 400 |
| table_open_cache | 30000 |
| thread_cache_size | 8 |
| thread_concurrency | 8 |
| thread_handling | one-thread-per-connection |
| thread_stack | 196608 |
| 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 | i686 |
| version_compile_os | Linux |
| wait_timeout | 28800 |
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
+------------------------------------------+-------------+
| Variable_name | Value |
+------------------------------------------+-------------+
| Aborted_clients | 27 |
| Aborted_connects | 4 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 1070593611 |
| Bytes_sent | 44099983735 |
| Com_admin_commands | 52 |
| 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 | 0 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 209265 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_procedure | 0 |
| Com_create_server | 0 |
| Com_create_table | 2 |
| Com_create_trigger | 0 |
| Com_create_udf | 0 |
| Com_create_user | 0 |
| Com_create_view | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 130737 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_event | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_procedure | 0 |
| Com_drop_server | 0 |
| Com_drop_table | 2 |
| Com_drop_trigger | 0 |
| Com_drop_user | 0 |
| Com_drop_view | 0 |
| Com_empty_query | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 114495 |
| Com_insert_select | 2 |
| Com_install_plugin | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_lock_tables | 776 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_release_savepoint | 0 |
| Com_rename_table | 0 |
| Com_rename_user | 0 |
| Com_repair | 0 |
| Com_replace | 49690 |
| 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 | 1330842 |
| Com_set_option | 209282 |
| 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 | 0 |
| Com_show_create_trigger | 0 |
| Com_show_databases | 9 |
| 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 | 140 |
| Com_show_function_status | 0 |
| Com_show_grants | 0 |
| Com_show_index_statistics | 0 |
| Com_show_keys | 0 |
| 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 | 142 |
| 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 | 10 |
| Com_show_storage_engines | 0 |
| Com_show_table_statistics | 0 |
| Com_show_table_status | 2 |
| Com_show_tables | 0 |
| Com_show_thread_statistics | 0 |
| Com_show_triggers | 0 |
| Com_show_user_statistics | 0 |
| Com_show_variables | 26 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 2451 |
| Com_stmt_execute | 2451 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 2451 |
| Com_stmt_reprepare | 0 |
| Com_stmt_reset | 2451 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 4 |
| Com_uninstall_plugin | 0 |
| Com_unlock_tables | 776 |
| Com_update | 248603 |
| Com_update_multi | 44 |
| 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 | 209838 |
| Created_tmp_disk_tables | 1793 |
| Created_tmp_files | 478 |
| Created_tmp_tables | 12054 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 41581 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 94597 |
| Handler_read_key | 33863260 |
| Handler_read_last | 142 |
| Handler_read_next | 190990967 |
| Handler_read_prev | 1819990 |
| Handler_read_rnd | 19918237 |
| Handler_read_rnd_next | 4079118847 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 283273 |
| Handler_write | 393171 |
| Innodb_buffer_pool_pages_data | 768 |
| Innodb_buffer_pool_bytes_data | 12582912 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 7423 |
| Innodb_buffer_pool_pages_misc | 0 |
| 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 | 11923 |
| Innodb_buffer_pool_reads | 769 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 3 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 14782464 |
| Innodb_data_reads | 837 |
| Innodb_data_writes | 3 |
| Innodb_data_written | 1536 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_have_atomic_builtins | OFF |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 1 |
| Innodb_os_log_fsyncs | 3 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 512 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 768 |
| Innodb_pages_written | 0 |
| 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 | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Innodb_truncated_status_writes | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 1248293 |
| Key_blocks_used | 159637 |
| Key_read_requests | 135923276 |
| Key_reads | 163037 |
| Key_write_requests | 440436 |
| Key_writes | 279244 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 84 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 905 |
| Open_streams | 0 |
| Open_table_definitions | 326 |
| Open_tables | 785 |
| Opened_files | 8991 |
| Opened_table_definitions | 338 |
| Opened_tables | 846 |
| 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 | 4341 |
| Qcache_free_memory | 120645144 |
| Qcache_hits | 976042 |
| Qcache_inserts | 1318609 |
| Qcache_lowmem_prunes | 22137 |
| Qcache_not_cached | 11139 |
| Qcache_queries_in_cache | 3332 |
| Qcache_total_blocks | 11461 |
| Queries | 3488044 |
| Questions | 3480691 |
| Rpl_status | AUTH_MASTER |
| Select_full_join | 4 |
| Select_full_range_join | 0 |
| Select_range | 326313 |
| Select_range_check | 0 |
| Select_scan | 156997 |
| Slave_heartbeat_period | 0.000 |
| Slave_open_temp_tables | 0 |
| Slave_received_heartbeats | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 16 |
| Slow_queries | 1622 |
| Sort_merge_passes | 236 |
| Sort_range | 501604 |
| Sort_rows | 110680824 |
| Sort_scan | 55964 |
| 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 | 3804890 |
| Table_locks_waited | 19511 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 7 |
| Threads_connected | 2 |
| Threads_created | 6451 |
| Threads_running | 1 |
| Uptime | 41475 |
| Uptime_since_flush_status | 41475 |
+------------------------------------------+-------------+
+--------+-----------------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-----------------+-----------+----+---------+------+-------+------------------+
| 209837 | forum_forum373 | localhost | | Query | 0 | | show processlist |
+--------+-----------------+-----------+----+---------+------+-------+------------------+
Code:
------------------------------------
INNODB Buffer Pool Stats
------------------------------------
----------------------------
INNODB Status
----------------------------
----------------------------
MySQL Error Log
----------------------------
140323 17:57:45 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140323 17:57:45 InnoDB: Compressed tables use zlib 1.2.3
140323 17:57:45 InnoDB: Using Linux native AIO
140323 17:57:45 InnoDB: Initializing buffer pool, size = 128.0M
140323 17:57:45 InnoDB: Completed initialization of buffer pool
140323 17:57:45 InnoDB: highest supported file format is Barracuda.
140323 17:57:45 InnoDB: Waiting for the background threads to start
140323 17:57:46 InnoDB: 5.5.36 started; log sequence number 2784394
140323 17:57:46 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140323 17:57:46 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140323 17:57:46 [Note] Server socket created on IP: '0.0.0.0'.
140323 17:57:46 [Note] Event Scheduler: Loaded 0 events
140323 17:57:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.36-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
140323 21:52:17 [Warning] IP address '218.9.29.90' could not be resolved: Name or service not known
Report Complete:
Mon Mar 24 05:28:59 PDT 2014
----------------------------