I haven’t written a dev diary update for quite a while – Over the past few months I’ve been preparing a lot of back-end stuff to make my life easier. The main issue was whenever I ran promotions, I’d get inundated with private questions which then I had to answer privately and this would really […]
UPDATE: It’s been a long time since I wrote this Products on Sale shortcode plugin – since then I’ve integrated way better functionality into my Faster Woo Widgets plugin so you can have /sale/dog-toys/black/ as your permalinks and have your products-on-sale filterable, paginated and optionally indexable by google. If you get Faster Woo Widgets, please […]
If you’ve used tools like Pingdom, Google Page Speed Insights or GT Metrix, you’ll have seen that they can help figure out why ‘front-end’ performance of your site is slow. Front-end performance includes all the stuff that happens on the users browser. It doesn’t include things like PHP execution time or MySQL query time – […]
In the video below, I show an example of performance analysis of a WordPress plugin. Performance optimisation is firstly performance analysis – you need to find out where your performance bottlenecks are. Performance bottlenecks in WordPress are most commonly found in the database, so a plugin tool like Query Monitor can help a great deal. If […]
There are a multitude of profilers available for WordPress but they all fail in some way to provide the real results you need. Query Monitor, for example, is fantastic for profiling database queries, which is normally where performance problems come from, but it lets you down a little when it comes to finding out which […]
Edit your /etc/mysql/my.cnf file – the default file comes with a bug for setting up this slow query log, but find the line which starts log_slow_queries (it’ll be commented out probably). Don’t uncomment it, instead use something like these values: slow-query-log = 1slow-query-log-file = /var/log/mysql/slow.loglong_query_time = 1log-queries-not-using-indexes long_query_time can be a decimal if you wish – […]