vBulletin + MySQL + cPanel / WHM dedicated server optimization request

forofutbolistas

• March 24, 2014 08:02

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 :) ------------------------------------------------------------- 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
---------------------------- 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
---------------------------- 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
---------------------------- 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 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 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
---------------------------- 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
---------------------------- MySQL datadir disk usage ---------------------------- /var/lib/mysql/ uses 1804872 kilobytes of disk space
---------------------------- ulimit -aH ---------------------------- core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 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
---------------------------------------------------------- tail -15 /etc/security/limits.conf ---------------------------------------------------------- # # #* 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
---------------------------------------------------------- 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
---------------------------------- 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
------------------------------- From /usr/local/apache/conf/httpd.conf ------------------------------- Timeout 300 KeepAlive On MaxKeepAliveRequests 100 KeepAliveTimeout 5 StartServers 15 MinSpareServers 15 MaxSpareServers 20 MinSpareServers 15 MaxSpareServers 20 ServerLimit 384
---------------------------- 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
---------------------------- 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=, MASTER_PORT=, # MASTER_USER=, MASTER_PASSWORD= ; # # where you replace , , by quoted strings and # 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 = # # The username the slave will use for authentication when connecting # to the master - required #master-user = # # The password the slave will authenticate with when connecting to # the master - required #master-password = # # The port the master is listening on. # optional - defaults to 3306 #master-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 | +--------+-----------------+-----------+----+---------+------+-------+------------------+
------------------------------------ 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 ----------------------------

• 

  thinkbot

  • March 25, 2014 11:23

  can you run mysqltuner.pl ?

  0
• 

  forofutbolistas

  • March 25, 2014 13:45

  [quote="thinkbot, post: 1604362">can you run mysqltuner.pl ?
  Yes, of course :) >> MySQLTuner 1.2.0_1 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.36-cll [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 1G (Tables: 225) [--] Data in InnoDB tables: 928K (Tables: 58) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [--] Data in MEMORY tables: 2M (Tables: 2) [!!] Total fragmented tables: 19 -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 12h 43m 14s (10M q [81.262 qps], 710K conn, TX: 149B, RX: 3B) [--] Reads / Writes: 71% / 29% [--] Total buffers: 1.8G global + 12.3M per thread (1000 max threads) [!!] Allocating > 2GB RAM on 32-bit systems can cause system instability [!!] Maximum possible memory usage: 13.8G (348% of installed RAM) [OK] Slow queries: 0% (5K/10M) [OK] Highest usage of available connections: 12% (121/1000) [OK] Key buffer size / total MyISAM indexes: 1.5G/718.8M [OK] Key buffer hit rate: 100.0% (474M cached / 234K reads) [OK] Query cache efficiency: 45.9% (3M cached / 7M selects) [!!] Query cache prunes per day: 14468 [OK] Sorts requiring temporary tables: 0% (386 temp sorts / 1M sorts) [OK] Temporary tables created on disk: 11% (4K on disk / 42K total) [OK] Thread cache hit rate: 96% (26K created / 710K connections) [OK] Table cache hit rate: 88% (1K open / 1K opened) [OK] Open file limit used: 2% (1K/61K) [OK] Table locks acquired immediately: 99% (11M immediate / 11M locks) [OK] InnoDB data size / buffer pool: 928.0K/128.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Enable the slow query log to troubleshoot bad queries Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** query_cache_size (> 128M)
  I have optimized tables and the only use for the server is vBulletin + MySQL so I guess there should be no problems with high memory usage.

  0
• 

  thinkbot

  • March 25, 2014 14:20

  Hey, Your settings are way too high [--] Total buffers: 1.8G global + 12.3M per thread (1000 max threads) [!!] Allocating > 2GB RAM on 32-bit systems can cause system instability [!!] Maximum possible memory usage: 13.8G (348% of installed RAM) you seem to have 4GB server, but have only 32-bit mysql installed, anyways update the config to: [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-external-locking skip-name-resolve tmpdir=/dev/shm key_buffer_size = 1200M max_allowed_packet = 1M table_open_cache = 1000 sort_buffer_size = 256K read_buffer_size = 128K read_rnd_buffer_size = 256K myisam_sort_buffer_size = 128M thread_cache_size = 16 query_cache_size = 75M open_files_limit = 32768 max_connections = 150 innodb_buffer_pool_size = 20M #skip-networking server-id = 1 [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
  and apache ------------------------------- From /usr/local/apache/conf/httpd.conf ------------------------------- Timeout 300 KeepAlive On MaxKeepAliveRequests 100 KeepAliveTimeout 1 StartServers 10 MinSpareServers 5 MaxSpareServers 10 MinSpareServers 5 MaxSpareServers 10 ServerLimit 200
  and make sure you have php opcode installed like eaccelerator or APC

  0
• 

  forofutbolistas

  • March 25, 2014 19:37

  [quote="thinkbot, post: 1604541">Hey, Your settings are way too high [--] Total buffers: 1.8G global + 12.3M per thread (1000 max threads) [!!] Allocating > 2GB RAM on 32-bit systems can cause system instability [!!] Maximum possible memory usage: 13.8G (348% of installed RAM) you seem to have 4GB server, but have only 32-bit mysql installed, and make sure you have php opcode installed like eaccelerator or APC
  Thanks a lot for the advice. I have just updated my.cnf and httpd.conf, and restarted MySQL / Apache. mysqltuner.pl is showing some improvements :) >> MySQLTuner 1.2.0_1 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.36-cll [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 1G (Tables: 225) [--] Data in InnoDB tables: 928K (Tables: 58) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [--] Data in MEMORY tables: 633K (Tables: 2) [!!] Total fragmented tables: 20 -------- Performance Metrics ------------------------------------------------- [--] Up for: 4h 2m 30s (1M q [83.784 qps], 84K conn, TX: 18B, RX: 404M) [--] Reads / Writes: 72% / 28% [--] Total buffers: 1.3G global + 960.0K per thread (150 max threads) [OK] Maximum possible memory usage: 1.4G (36% of installed RAM) [OK] Slow queries: 0% (415/1M) [OK] Highest usage of available connections: 28% (43/150) [OK] Key buffer size / total MyISAM indexes: 1.2G/721.8M [OK] Key buffer hit rate: 99.8% (60M cached / 109K reads) [OK] Query cache efficiency: 47.4% (380K cached / 802K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (263 temp sorts / 192K sorts) [OK] Temporary tables created on disk: 8% (468 on disk / 5K total) [OK] Thread cache hit rate: 99% (458 created / 84K connections) [OK] Table cache hit rate: 98% (568 open / 575 opened) [OK] Open file limit used: 2% (716/32K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) [OK] InnoDB data size / buffer pool: 928.0K/20.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries
  I am using Xcache 3.0.3 as compiled with EasyApache, I have found it easier to implent than APC or eaccelerator. I'll wait 24 hours in order to check if it shows improvement on the forum's busiest hours. Thanks again :)

  0
• 

  cPanelMichael

  • March 31, 2014 12:56

  [quote="forofutbolistas, post: 1604802">I'll wait 24 hours in order to check if it shows improvement on the forum's busiest hours.
  I am happy to see the community here was able to provide you with some advice. Did you notice any improvement during those busy hours? Thank you.

  0
• 

  forofutbolistas

  • April 02, 2014 08:35

  [quote="cPanelMichael, post: 1608482">I am happy to see the community here was able to provide you with some advice. Did you notice any improvement during those busy hours? Thank you.
  Yes, one week after the new values in my.cnf and httpd.conf were applied the server is working much more lag-free during the nightly busiest hours. It bothers me a bit that it's only using around 25% of the 4 GB of RAM installed but I guess it may be due to CentOS 5.10 being a 32bit OS in my server. I'm very thankful for the help so promptly and profesionally offered. :)

  0
• 

  forofutbolistas

  • April 07, 2014 09:51

  Hello again :o Yesterday night the same problems arose and high server load appeared just like before applying the optimization advice: root@server [~]# nice top -c top - 15:35:56 up 41 days, 29 min, 1 user, load average: 31.00, 31.29, 31.52 Tasks: 247 total, 2 running, 244 sleeping, 0 stopped, 1 zombie Cpu(s): 59.0%us, 2.8%sy, 0.1%ni, 37.3%id, 0.2%wa, 0.0%hi, 0.5%si, 0.0%st Mem: 4151412k total, 3821052k used, 330360k free, 108980k buffers Swap: 4192956k total, 80k used, 4192876k free, 2286540k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 29631 mysql 15 0 1596m 657m 5540 S 163.9 16.2 22534:30 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql - 16387 nobody 15 0 73268 16m 7852 S 9.1 0.4 0:02.27 /usr/local/apache/bin/httpd -k start -DSSL 16155 nobody 15 0 72560 15m 7740 S 5.5 0.4 0:02.97 /usr/local/apache/bin/httpd -k start -DSSL 16367 nobody 15 0 72196 14m 7240 S 5.5 0.4 0:02.67 /usr/local/apache/bin/httpd -k start -DSSL 18969 nobody 15 0 72872 14m 6496 S 5.5 0.4 0:00.40 /usr/local/apache/bin/httpd -k start -DSSL 15813 nobody 15 0 73164 16m 7844 S 4.9 0.4 0:06.52 /usr/local/apache/bin/httpd -k start -DSSL 8249 nobody 15 0 73728 17m 8792 S 4.2 0.4 0:12.16 /usr/local/apache/bin/httpd -k start -DSSL 18925 nobody 15 0 74280 16m 6676 S 3.9 0.4 0:01.37 /usr/local/apache/bin/httpd -k start -DSSL 18932 nobody 15 0 73292 17m 8664 S 3.9 0.4 0:01.09 /usr/local/apache/bin/httpd -k start -DSSL 16241 nobody 15 0 72844 15m 6932 S 3.6 0.4 0:01.85 /usr/local/apache/bin/httpd -k start -DSSL 19162 nobody 15 0 71472 15m 6296 S 3.6 0.4 0:00.18 /usr/local/apache/bin/httpd -k start -DSSL 18775 nobody 15 0 73108 15m 6952 S 1.8 0.4 0:01.54 /usr/local/apache/bin/httpd -k start -DSSL 15730 nobody 16 0 74208 16m 7076 S 1.5 0.4 0:02.05 /usr/local/apache/bin/httpd -k start -DSSL 18982 nobody 16 0 74100 15m 6884 S 1.2 0.4 0:00.48 /usr/local/apache/bin/httpd -k start -DSSL 18781 nobody 16 0 73116 15m 7360 S 0.9 0.4 0:01.50 /usr/local/apache/bin/httpd -k start -DSSL 18918 nobody 15 0 73680 15m 6652 S 0.9 0.4 0:01.01 /usr/local/apache/bin/httpd -k start -DSSL 19101 root 26 10 2556 1224 832 R 0.9 0.0 0:00.21 top -c 9647 nobody 15 0 73996 17m 8140 S 0.6 0.4 0:13.26 /usr/local/apache/bin/httpd -k start -DSSL 16277 nobody 15 0 72784 17m 9332 S 0.6 0.4 0:02.61 /usr/local/apache/bin/httpd -k start -DSSL 19027 nobody 15 0 73436 15m 6980 S 0.6 0.4 0:00.51 /usr/local/apache/bin/httpd -k start -DSSL 15694 nobody 15 0 72836 17m 9152 S 0.3 0.4 0:04.31 /usr/local/apache/bin/httpd -k start -DSSL 15698 nobody 15 0 72548 15m 7704 S 0.3 0.4 0:03.30 /usr/local/apache/bin/httpd -k start -DSSL 15787 nobody 15 0 72844 15m 7432 S 0.3 0.4 0:03.84 /usr/local/apache/bin/httpd -k start -DSSL 15788 nobody 15 0 73144 15m 7288 S 0.3 0.4 0:06.77 /usr/local/apache/bin/httpd -k start -DSSL 15805 nobody 15 0 72588 17m 9212 S 0.3 0.4 0:04.58 /usr/local/apache/bin/httpd -k start -DSSL 16165 nobody 15 0 72180 14m 7092 S 0.3 0.4 0:04.59 /usr/local/apache/bin/httpd -k start -DSSL 16176 nobody 15 0 0 0 0 Z 0.3 0.0 0:04.59 [httpd] 16349 nobody 15 0 73452 16m 8212 S 0.3 0.4 0:05.13 /usr/local/apache/bin/httpd -k start -DSSL 16390 nobody 15 0 73276 15m 7232 S 0.3 0.4 0:02.78 /usr/local/apache/bin/httpd -k start -DSSL 16392 nobody 15 0 73052 18m 9.8m S 0.3 0.5 0:02.72 /usr/local/apache/bin/httpd -k start -DSSL 18608 nobody 15 0 72896 15m 7496 S 0.3 0.4 0:02.25 /usr/local/apache/bin/httpd -k start -DSSL 18686 nobody 15 0 72940 15m 7068 S 0.3 0.4 0:01.85 /usr/local/apache/bin/httpd -k start -DSSL 18916 nobody 15 0 73116 15m 7248 S 0.3 0.4 0:01.19 /usr/local/apache/bin/httpd -k start -DSSL 1 root 15 0 2176 640 556 S 0.0 0.0 0:14.23 init [3] 2 root RT -5 0 0 0 S 0.0 0.0 0:09.94 [migration/0] 3 root 34 19 0 0 0 S 0.0 0.0 0:00.19 [ksoftirqd/0] 4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 [watchdog/0] root@server [~]# mysqladmin processlist +---------+-----------------+-----------+-----------------+---------+------+--------------+-------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------+-----------------+---------+------+--------------+-------------------------------------------------------------------------------------+ | 5260187 | forum_user1 | localhost | forum_database1 | Query | 0 | Sending data | SELECT COUNT(*) AS total FROM post_thanks WHERE userid = 8263 AND date > 1396737364 | | 5260195 | forum_user1 | localhost | forum_database1 | Sleep | 0 | | | | 5260196 | root | localhost | | Query | 0 | | show processlist | +---------+-----------------+-----------+-----------------+---------+------+--------------+-------------------------------------------------------------------------------------+
>> MySQLTuner 1.2.0_1 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.36-cll [!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 1G (Tables: 225) [--] Data in InnoDB tables: 928K (Tables: 58) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [--] Data in MEMORY tables: 760K (Tables: 2) [!!] Total fragmented tables: 23 -------- Performance Metrics ------------------------------------------------- [--] Up for: 9h 43m 57s (2M q [84.865 qps], 200K conn, TX: 43B, RX: 946M) [--] Reads / Writes: 74% / 26% [--] Total buffers: 1.3G global + 960.0K per thread (150 max threads) [OK] Maximum possible memory usage: 1.5G (36% of installed RAM) [OK] Slow queries: 0% (1K/2M) [OK] Highest usage of available connections: 57% (86/150) [OK] Key buffer size / total MyISAM indexes: 1.2G/756.1M [OK] Key buffer hit rate: 99.9% (135M cached / 145K reads) [OK] Query cache efficiency: 45.7% (917K cached / 2M selects) [!!] Query cache prunes per day: 33944 [OK] Sorts requiring temporary tables: 0% (2K temp sorts / 456K sorts) [OK] Temporary tables created on disk: 9% (984 on disk / 10K total) [OK] Thread cache hit rate: 99% (1K created / 200K connections) [OK] Table cache hit rate: 94% (783 open / 828 opened) [OK] Open file limit used: 2% (886/32K) [OK] Table locks acquired immediately: 99% (3M immediate / 3M locks) [OK] InnoDB data size / buffer pool: 928.0K/20.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries Variables to adjust: query_cache_size (> 100M)
  Is there any other optimization I may apply in order to improve those high server loads? :(

  0
• 

  thinkbot

  • April 07, 2014 15:42

  track slow queries in your mysql my.cnf slow_query_log=1 slow_query_log_file=mysql-slow.log long_query_time=0.1 let it run for some time then review them cd /root/ wget

  0

Please sign in to leave a comment.