Serving static files via web server¶

See Serving Static Files for Better Performance for a description and the benefits.

Using cron to perform background jobs¶

See Defining Background Jobs for a description and the benefits.

Enable JavaScript and CSS Asset Management¶

See JavaScript and CSS Asset Management for a description and the benefits.

PHP safe mode¶

PHP safe mode has to be turned off. It is deprecated and has been removed in newer PHP versions. Verify its status in phpinfo_, and look for safe_mode on/off. If it is on, then add this line to php.ini to turn it off:

safe_mode = Off

Enable the SPDY protocol¶

Your webserver can be configured to use the SPDY protocol which could improve the overall performance of ownCloud. Please have a look at the documentation of your webservers module for more information:

• mod-spdy for Apache
• ngx_http_spdy_module for nginx

Maximum number of Apache processes¶

An Apache process uses around 12MB of RAM. Apache should be configured so that the maximum number of HTTPD processes times 12MB is lower than the amount of RAM. Otherwise the system begins to swap and the performance goes down.

KeepAlive should be configured with sensible defaults¶

KeepAlive On
KeepAliveTimeout 2
MaxKeepAliveRequests 10

mod_gzip¶

mod_gzip should be used because it speeds up the transfer of data and helps to free server memory, and HTTP connections are closed faster.

MPM¶

Apache prefork has to be used. Don’t use threaded mpm with mod_php because PHP is currently not thread safe.

Hostname Lookups¶

# cat /etc/httpd/conf/httpd.conf
...
HostnameLookups off

Log files¶

Log files should be switched off for maximum performance.

Comment out the CustomLog directive. Keep ErrorLog to be able to track down errors.

MaxKeepAliveRequests 4096¶

<IfModule prefork.c>
        StartServers 100
        MinSpareServers 100
        MaxSpareServers 2000
        ServerLimit 6000
        MaxClients 6000
        MaxRequestsPerChild 4000
</IfModule>

<Directory "/var/www/html">
        Options Indexes SymLinksIfOwnerMatch AllowOverride All
</Directory>

Nginx module check¶

As a first step, it is necessary to check if your Nginx installation has the nginx cache purge module compiled in:

nginx -V 2>&1 | grep ngx_cache_purge -o

If your output contains ngx_cache_purge, you can continue with the configuration, otherwise you need to manually compile Nginx with the module needed.

Compile Nginx with the nginx-cache-purge module¶

1. Preparation:

cd /opt
wget http://nginx.org/keys/nginx_signing.key
sudo apt-key add nginx_signing.key
sudo vi /etc/apt/sources.list.d/nginx.list

Add the following lines (if different, replace {trusty} by your distribution name):

deb http://nginx.org/packages/mainline/ubuntu/ trusty nginx
deb -src http://nginx.org/packages/mainline/ubuntu/ trusty nginx

Then run sudo apt-get update

2. Download the Nginx source from the ppa repository

cd /opt
sudo apt-get build-dep nginx
sudo apt-get source nginx

3. Download module(s) to be compiled in and configure compiler arguments

ls -la

Please replace {release} with the release downloaded:

cd /opt/nginx-{release}/debian

If folder “modules” is not present, do:

sudo mkdir modules
cd modules
sudo git clone https://github.com/FRiCKLE/ngx_cache_purge.git
sudo vi /opt/nginx-{release}/debian/rules

If not present, add the following line at the top under:

#export DH_VERBOSE=1:
MODULESDIR = $(CURDIR)/debian/modules

And at the end of every configure command add:

--add-module=$(MODULESDIR)/ngx_cache_purge

Don’t forget to escape preceeding lines with a backslash \. The parameters may now look like:

$(WITH_SPDY) \
--with-cc-opt="$(CFLAGS)" \
--with-ld-opt="$(LDFLAGS)" \
--with-ipv6 \
--add-module=$(MODULESDIR)/ngx_cache_purge

4. Compile and install Nginx

cd /opt/nginx-{release}
sudo dpkg-buildpackage -uc -b
ls -la /opt
sudo dpkg --install /opt/nginx_{release}~{distribution}_amd64.deb

5. Check if the compilation and installation of the ngx_cache_purge module was successful

nginx -V 2>&1 | grep ngx_cache_purge -o

It should now show: ngx_cache_purge

Show Nginx version including all features compiled and installed:

nginx -V 2>&1 | sed s/" --"/"\n\t--"/g

6. Mark Nginx to be blocked from further updates via apt-get

sudo dpkg --get-selections | grep nginx

For every nginx component listed run sudo apt-mark hold <component>

7. Regular checks for nginx updates

Do a regular visit on the Nginx news page and proceed in case of updates with items 2 to 5.

Configure Nginx with the nginx-cache-purge module¶

1. Preparation Create a directory where Nginx will save the cached thumbnails. Use any path that fits to your environment. Replace {path} in this example with your file path:

sudo mkdir -p /usr/local/tmp/cache

2. Configuration

sudo vi /etc/nginx/sites-enabled/{your-ownCloud-nginx-config-file}

Add at the beginning, but outside the server{} block:

fastcgi_cache_path {path} levels=1:2 keys_zone=OWNCLOUD:100m inactive=60m;

Add inside the server{} block, as an example of a configuration:

set $skip_cache 1;

# POST requests and urls with a query string should always go to PHP

if ($request_uri ~* "thumbnail.php")
{ set $skip_cache 0;
}

fastcgi_cache_key "$scheme$request_method$host$request_uri";
fastcgi_cache_use_stale error timeout invalid_header http_500;
fastcgi_ignore_headers Cache-Control Expires Set-Cookie;

location ~ \.php(?:$/) {
      fastcgi_split_path_info ^(.+\.php)(/.+)$;

      include fastcgi_params;
      fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
      fastcgi_param PATH_INFO $fastcgi_path_info;
      fastcgi_param HTTPS on;
      fastcgi_pass php-handler;

      fastcgi_cache_bypass $skip_cache;
      fastcgi_no_cache $skip_cache;
      fastcgi_cache OWNCLOUD;
      fastcgi_cache_valid  60m;
      }

3. Test the configuration

sudo service nginx restart

• Open your browser and clear your cache.
• Logon to your ownCloud instance, open the gallery app, move thru your folders and watch while the thumbnails are generated for the first time.
• You may also watch with eg. htop your system load while the thumbnails are processed.
• Go to another app or logout and relogon.
• Open the gallery app again and browse to the folders you accessed before. Your thumbnails should appear more or less immediately.
• htop will not show up additional load while processing, compared to the high load before.

Using MariaDB/MySQL instead of SQLite¶

MySQL or MariaDB are preferred because of the performance limitations of SQLite with highly concurrent applications, like ownCloud.

On large instances you could consider running MySQLTuner to optimize the database.

See the section Database Configuration for how to configure ownCloud for MySQL or MariaDB. If your installation is already running on SQLite then it is possible to convert to MySQL or MariaDB using the steps provided in Converting Database Type.

Improve slow performance with MySQL on Windows¶

On Windows hosts running MySQL on the same system changing the parameter dbhost in your config/config.php from localhost to 127.0.0.1 could improve the page loading time.

See also this forum thread.

Other performance improvements¶

Mysql: compare https://tools.percona.com/wizard to your current settings MariaDB: https://mariadb.com/kb/en/optimization-and-tuning/

Postgresql¶

Alternative to MariaDB/MySQL. Used in production by a few core developers.

Requires at least Postgresql 9.0

Oracle Database¶

Usage scenario: Existing enterprise installations. Only core apps are supported and tested. Not recommended because it involves compiling the oci8