By going through these few steps a websites performance can changes from being sluggish - to being snappy and fast.
We run very updated and recent versions of MariaDB (Open Source successor of MySQL). The following steps will ensure that you make use of the latest performance improvements and optimisations.
Convert any MyISAM tables to InnoDB
MyISAM is an outdated storage engine that underperforms in all aspects, and InnoDB is now a feature complete alternative. InnoDB has many other advantages as well.
When you have a mysqldump file, use sed to fix the table types before importing by running:
sed -i 's/MyISAM/INNODB/g' filename.sql
Optimise tables on a regular basis
In PhpMyAdmin in the table overview, select all tables and choose "Optimise" from the dropdown menu. Optimise recalculates statistics for the tables, that are used to optimise performance when reading and writing data.
Check for unnecessary storage of data
Are you storing data you might as well throw away? We have come across sites where several years of data are stored in the logs - where the need usually is a week. Make sure logs rotate and that maintenance tasks run, so that old logs and support tables are cleaned up by your web application.
There are many bad default .htaccess rules, or big .htaccess files out there. The .htaccess should primarily be used for rewrites.
By default our servers are properly set up to gzip content, correct expiry headers and cache lifetime. Setting these values in .htaccess may slow down your site.
Get rid of slow plugins
Test all plugins for performance. If they make your page load slower, find an alternative plugin!
Other performance improving actions
Use SSL (https://)
SSL provides secure end-to-end communication and better performance. Our servers make use of the latest and best in internet technology, and SSL increases the performance of your website due to protocols like HTTP/2.0 and SPDY.
Published on: 02 / 01 / 2018