Fix Site Speed

[krschmidt]

• [x] Enable APC/opcache
• [x] Aggregate css/js
• [x] caching for anonymous users
• [x] disable theme debugging

[krschmidt]

@jerrac could you handle APC?

[jerrac]

I didn't install apc, but opcache is now installed. Feel free to tweak settings. I believe you can use the MultiPHP INI Editor Editor Mode screen on cpanel to add/adjust the opcache php settings.

[krschmidt]

I'm getting a cold cache load of less than 1 second now, so that's a definite improvement. Unfortunately, administrative pages are crawling. ~4-5 minute for a module enable.

[krschmidt]

I upped the innodb_buffer_pool_size, since 128M is a little tiny for a shared host, but it was already larger than we'd need for the size of the sites that were present.

@andersonpr was thinking that the /home directories being on nfs might be part of the problem. any thoughts?

[krschmidt]

Enabled panels caching

[krschmidt]

Though there's a long way to go, things are feeling fast enough that I'm going to close this issue since we're good enough for launch. See also #14, which would provide up to a ~10% improvement on some of the cached, anonymous pages.

[krschmidt]

reopening, because administrative functions, like update.php, still take several minutes.

[krschmidt]

8 seconds to load some pages. @jerrac i've removed more modules than I should. The biggest part of that is 1.3 seconds to get the initial page from drupal. Can you look into speeding things up at all?

[krschmidt]

Ran mysqltuner, it suggested some changes. Doubled the values on all these (to these values):

sort_buffer_size=512K
read_rnd_buffer_size=512K
tmp_table_size=32M
max_heap_table_size=32M

It had other suggestions as well, but it felt safest to start with these. I'll restart the service late tonight or tomorrow.

[krschmidt]

mysqld restarted ~20 minutes ago.

[krschmidt]

Turns out that it isn't just that opcache needs configuring, but it has small defaults, and since the config was commented out, it may not have been running. Will be increasing the size of the opcache, and also making these changes to mysql:

sort_buffer_size=1M
read_rnd_buffer_size=1M
tmp_table_size=64M
max_heap_table_size=64M

[krschmidt]

PHP 5.6 opcache settings changed to suggested defaults - global PHP settings changed to those same defaults. Other configs not touched. Database updates made.

Things still feel slow, but faster than they were. Initial loads of some pages are still crawling, with /admin/structure/appearance taking ~8.7 seconds just to fetch the Drupal page before it was cached.

[krschmidt]

Ideally we'd actually run under php7, but civicrm doesn't do that yet