[Eek. Help, please!] Would someone like to help me with my limited server?

[Tripp★]

Hello again;

Okay I got some data (Just over 24 hours later);

Top

top - 06:28:22 up 1 day, 3:06, 0 users, load average: 0.00, 0.00, 0.00 Tasks: 41 total, 1 running, 40 sleeping, 0 stopped, 0 zombie Cpu(s): 1.3%us, 0.1%sy, 0.0%ni, 96.1%id, 2.5%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 2097152k total, 1154560k used, 942592k free, 0k buffers Swap: 2097152k total, 520904k used, 1576248k free, 339116k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 18047 SITE 20 0 292m 30m 9888 S 4.3 1.5 0:14.86 php 2575 mysql 20 0 2134m 404m 6372 S 0.3 19.8 1:55.51 mysqld 11927 nobody 20 0 2298m 84m 17m S 0.3 4.1 0:23.28 httpd 11984 nobody 20 0 2372m 87m 18m S 0.3 4.3 0:22.23 httpd 1 root 20 0 19236 1032 864 S 0.0 0.0 0:00.04 init 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd/169 3 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khelper/169 164 root 16 -4 10644 256 252 S 0.0 0.0 0:00.00 udevd 602 root 20 0 179m 1160 804 S 0.0 0.1 0:00.26 rsyslogd 615 named 20 0 384m 4244 1912 S 0.0 0.2 0:00.58 named 649 root 20 0 66620 352 348 S 0.0 0.0 0:00.00 sshd 861 root 20 0 19612 984 840 S 0.0 0.0 0:00.11 dovecot 871 mailnull 20 0 70108 944 724 S 0.0 0.0 0:00.03 exim 875 dovenull 20 0 42496 2948 2516 S 0.0 0.1 0:00.00 pop3-login 876 dovenull 20 0 42360 2628 2448 S 0.0 0.1 0:00.00 imap-login 877 dovecot 20 0 13316 1032 936 S 0.0 0.0 0:00.02 anvil 878 root 20 0 13448 1124 972 S 0.0 0.1 0:00.06 log 880 dovenull 20 0 42356 2440 2384 S 0.0 0.1 0:00.00 pop3-login 881 dovenull 20 0 42360 2664 2448 S 0.0 0.1 0:00.15 imap-login 882 root 20 0 16412 1816 1108 S 0.0 0.1 0:00.12 config 883 dovecot 20 0 29452 1504 1320 S 0.0 0.1 0:00.22 auth 899 root 20 0 139m 27m 25m S 0.0 1.3 0:03.53 httpd 905 root 20 0 135m 1396 1324 S 0.0 0.1 0:00.08 pure-ftpd 907 root 20 0 133m 1384 1340 S 0.0 0.1 0:00.05 pure-authd 914 root 20 0 114m 744 648 S 0.0 0.0 0:00.64 crond 924 root 20 0 21544 464 372 S 0.0 0.0 0:00.00 atd 1009 root 20 0 34940 1748 1388 S 0.0 0.1 0:00.11 cPhulkd - proce 1020 root 20 0 111m 5152 2044 S 0.0 0.2 0:01.99 cpsrvd-ssl 1168 root 20 0 103m 776 504 S 0.0 0.0 0:00.09 cpdavd - accept 1180 root 20 0 38848 2420 1448 S 0.0 0.1 0:02.35 queueprocd - wa 1239 root 20 0 83728 6160 1612 S 0.0 0.3 0:12.30 tailwatchd 1250 root 38 18 31024 1256 764 S 0.0 0.1 0:00.15 cpanellogd - sl 2349 root 20 0 11308 1224 1220 S 0.0 0.1 0:00.00 mysqld_safe 11925 root 20 0 79720 9.9m 2900 S 0.0 0.5 0:00.05 leechprotect 11926 nobody 20 0 91540 3156 752 S 0.0 0.2 0:00.33 httpd 11928 nobody 20 0 2372m 89m 16m S 0.0 4.4 0:22.09 httpd 11985 nobody 20 0 2298m 81m 17m S 0.0 4.0 0:21.61 httpd 16611 root 20 0 19420 1540 1192 S 0.0 0.1 0:00.00 ssl-params 18260 root 20 0 27504 580 376 S 0.0 0.0 0:00.00 vzctl 18261 root 20 0 105m 1848 1500 S 0.0 0.1 0:00.00 bash 18285 root 20 0 14900 1240 988 R 0.0 0.1 0:00.00 top

root@server [/]# top

MySQL Tuner

>> MySQLTuner 1.3.0 - Major Hayden >> Bug reports, feature requests, and downloads at >> Run with '--help' for additional options and output filtering [OK] Currently running supported MySQL version 5.6.17 [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM [--] Data in MyISAM tables: 541M (Tables: 2031) [--] Data in InnoDB tables: 13M (Tables: 178) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52) [!!] Total fragmented tables: 55 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 3h 4m 30s (390K q [4.010 qps], 38K conn, TX: 25B, RX: 71M) [--] Reads / Writes: 63% / 37% [--] Total buffers: 248.0M global + 4.9M per thread (151 max threads) [OK] Maximum possible memory usage: 984.1M (48% of installed RAM) [OK] Slow queries: 0% (0/390K) [OK] Highest usage of available connections: 3% (6/151) [OK] Key buffer size / total MyISAM indexes: 8.0M/134.4M [OK] Key buffer hit rate: 98.5% (1M cached / 24K reads) [OK] Query cache efficiency: 71.1% (146K cached / 206K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 3K sorts) [!!] Joins performed without indexes: 626 [OK] Temporary tables created on disk: 13% (580 on disk / 4K total) [OK] Thread cache hit rate: 99% (6 created / 38K connections) [!!] Table cache hit rate: 7% (2K open / 26K opened) [OK] Open file limit used: 7% (3K/50K) [OK] Table locks acquired immediately: 99% (139K immediate / 139K locks) [OK] InnoDB buffer pool / data size: 128.0M/13.3M [OK] InnoDB log waits: 0 -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Adjust your join queries to always utilize indexes Increase table_open_cache gradually to avoid file descriptor limits Read this before increasing table_open_cache over 64: Variables to adjust: join_buffer_size (> 4.0M, or always use indexes with joins) table_open_cache (> 2000)

root@server [/]# perl mysqltuner.pl

http://mysqltuner.com/







































http://bit.ly/1mi7c4C

Response Time (Although I need to look for a better site to get detailed reports)

[ASTRAPI]

4.9M per thread <---- This is very high

join_buffer_size = 4.0M <---- This is very high try with 768k as the script will always recommend to raise it up but it will make the things worst.....

table_open_cache = 2000 <---- Try with 1000

Restart sql and check... Keep in mind that sql will need at least 2 days to get proper info from it :)

Which tables are using InnoDB ? Is there any special reason for this as i think you don't get any locked tables or huge traffic and looking for better performance....

[Tripp★]

InnoDB - Most likely ArrowChat.

[ASTRAPI]

Ok just try the above and let us know :)

Re post mysqltuner again .....

[Tripp★]

Would running InnoDB and MyISAM in one database cause any performance problems? Because it's in the same Database - which is why I am asking. :)

[RevengeFNF]

Would running InnoDB and MyISAM in one database cause any performance problems? Because it's in the same Database - which is why I am asking.

No.

[ASTRAPI]

Yes InnoDB will use more ram than MyISAM....but in your case i think that you have more issues to check before that....

[Grumpy]

Something doesn't seem right... You can tweak mysql more, but we need to find the big change, not the small changes. 900ms for single page load is too high. And it's not something minor mysql tweaking is going to solve. Your last top had no real issues, but your top right now is showing higher %wa than %user which is alarming. That means your processor waits around for io more than it actually works even though it has stuff to do. I'm pondering if it's a out-of-the-norm result, or the opposite.

We may also want to make sure what you're measuring as response time is accurate first. Removing the network involved. Fancy load tester aside, try running

time wget http://yoursite.com/forum/directory/index -O /dev/null

Run that like 10 times. Space them apart as well. Just post the real time stats, don't need to know the wget details.

[Tripp★]

I did them in a space of 15 minutes. Is this "Spaced out" appropriately or would it be better of the period of an hour or something?

2014-10-13 13:01:26 (7.65 MB/s) - “/dev/null” saved [269570] real 0m0.509suser 0m0.012ssys 0m0.003s2014-10-13 13:04:11 (7.75 MB/s) - “/dev/null” saved [269570] real 0m0.468suser 0m0.014ssys 0m0.002s2014-10-13 13:05:29 (7.83 MB/s) - “/dev/null” saved [258133] real 0m0.415suser 0m0.014ssys 0m0.000s2014-10-13 13:06:12 (7.85 MB/s) - “/dev/null” saved [269666] real 0m0.360suser 0m0.014ssys 0m0.000s2014-10-13 13:06:58 (7.86 MB/s) - “/dev/null” saved [258230] real 0m0.359suser 0m0.011ssys 0m0.003s2014-10-13 13:07:19 (7.93 MB/s) - “/dev/null” saved [269667] real 0m0.400suser 0m0.012ssys 0m0.005s2014-10-13 13:08:06 (7.89 MB/s) - “/dev/null” saved [258230] real 0m0.372suser 0m0.013ssys 0m0.001s2014-10-13 13:11:12 (7.90 MB/s) - “/dev/null” saved [269665] real 0m0.377suser 0m0.014ssys 0m0.000s2014-10-13 13:13:45 (5.07 MB/s) - “/dev/null” saved [258230] real 0m0.394suser 0m0.012ssys 0m0.003s2014-10-13 13:15:34 (7.93 MB/s) - “/dev/null” saved [269667] real 0m0.380suser 0m0.016ssys 0m0.007s

I didn't make further changes to the MySQL config - I was going to, today but I'm guessing it's not the MySQL that's the problem (At least this much of a problem)?

[Grumpy]

Well... you can simply choose to live with 400ms. It's not that bad. Unless it feels really slow to browse. Which may mean it's not your forum processing issue, but some other elements within the page. 500~600ms being added by network is a significant one. I'm not sure where you are hosted and where the previous 1s was being measured from. But if you want to reduce network delay, you'll basically have to move out of current provider since I'm guessing there's no premium bandwidth option for you, quite rare for a vps.

Since network is being a big difference, I'd suggest adding gzip compression (or checking that it is enabled). Also, make sure browser based caching is set for images/js/css. That sort of stuff so that further browsing will help a lot. They should make the greatest difference for you given majority of the delay is caused by the connection.

With fancy setup, down to like 50ms is possible. That'll be a question of how much more effort you want to invest in it. General optimization of opcache, user cache is highly recommended.

Since you have 5.5, only supported opcache option is zend opcache. Which... I may be wrong, but still unsupported by cpanel. If so, you have to manually install zend opcache and stop using easy apache.

For user cache, to simplify, I recommend using memcache. You'll need to install memcache, the php module, from easyapache (or manually) into your php. And then you'll need to install memcached, the service, from yum. Make sure you don't confuse memcache vs memcached. Afterwards, configure it in your IPB. Config info for memcached with IPB is found here:

http://community.invisionpower.com/resources/documentation/index.html/_/tutorials/large-communities/using-alternate-cache-storage-r169

You also should configure memcached (the service). If you installed via yum, it should be in /etc/sysconfig/memcached though default may be good enough.

[ASTRAPI]

Since you have 5.5, only supported opcache option is zend opcache. Which... I may be wrong

APC 3.1.15-dev trunk works on 5.5 :smile:

Xcache 3.2.0 also works on 5.5 :smile:

The problem seems to be the vps (network and low ram) running Cpanel and services: Apache, Mysql, opcache and using also HTTPS without SPDY.... :sad:

[Grumpy]

APC 3.1.15-dev trunk works on 5.5 :smile:

Xcache 3.2.0 also works on 5.5 :smile:

Bit of a gap between works and supported. But It does seem xcache had updates recently to add 5.5/5.6 support. Even php 5.4 is still tagged as beta for apc. I wouldn't use it... APC dev is dead.

[ASTRAPI]

I just say that it works :)

Zend opcache is very fast but you will need also something for data caching like Memcache...

[Tripp★]

Sorry for the late reply... Been busy again with a lot of things.

I installed zend opcache, I had some improvements although something is a little "off" because sometimes it can take 42 seconds to load - which definitely isn't good. But TTFB is improved - drastically.

Before opcache:

After opcache:

I'm hoping it's "Settling Pains" and that it just needs to run for a little while. Once it's done so I'll do some more tests and look at (if still recommended) installing memcache.

Opcache GUI:

[ASTRAPI]

sometimes it can take 42 seconds to load

With 42 seconds the problem for sure is deeper than installing memcache....