performance Archives - Sysadmins of the North

28 May 202025 June 2020

How to Fix Yoast SEO for WordPress DeleteDuplicateIndexables MySQL error

In recent days, there are a number of reports about broken Yoast SEO database operations, related to the DeleteDuplicateIndexables function. The PHP function is located in the file wordpress-seo\src\config\migrations\20200507054848_DeleteDuplicateIndexables.php, and in this post I’ll provide you with a possible fix for this statement. Read on. Jan ReilinkMy name is Jan. I am not a hacker,…

Continue reading How to Fix Yoast SEO for WordPress DeleteDuplicateIndexables MySQL error

23 September 201927 September 2019

Reduce Wordfence CPU usage, disable Wordfence “Live Traffic View”

Whenever WordPress is using a lot of CPU and you have Wordfence Security plugin enabled, it is recommended to double check some settings. Unfortunately the Wordfence “Live Traffic Options” (“Traffic logging mode”) feature can cause high CPU usage and load issues for WordPress websites. Therefore, I recommend you disable this feature to improve the performance…

Continue reading Reduce Wordfence CPU usage, disable Wordfence “Live Traffic View”

15 August 20198 May 2020

Use -SearchBase with Get-ADComputer for faster results

This might be specific to my Windows Server environment and PoSH scripting, but using -SeachBase with PowerShell’s Get-ADComputer gives me faster results. You can use this for your own advantage, here is a little example to speed up AD DS queries. Jan ReilinkMy name is Jan. I am not a hacker, coder, developer or guru.…

Continue reading Use -SearchBase with Get-ADComputer for faster results

26 February 20183 April 2020

Increase WordPress’ memory limit WP_MEMORY_LIMIT properly in wp-config.php

Here is how to increase WordPress’ memory limit (WP_MEMORY_LIMIT) properly. I see this done wrong over and over again in WordPress plugins and themes. In a worst case scenario this may even decrease the available amount of memory for WordPress! So be careful with the advice you follow. In this post I show you one…

Continue reading Increase WordPress’ memory limit WP_MEMORY_LIMIT properly in wp-config.php

3 May 201620 January 2020

Get current number of FTP client connections (NonAnonymous) with PowerShell and Get-Counter

Ever wanted to know the current number of active FTP client connections on your Windows Server FTP Service? You can get this statistic using PowerShell, the Get-Counter cmdlet and the Microsoft FTP Service Current NonAnonymous Users performance counter. Jan ReilinkMy name is Jan. I am not a hacker, coder, developer or guru. I am merely…

Continue reading Get current number of FTP client connections (NonAnonymous) with PowerShell and Get-Counter

29 December 201525 March 2019

Install Varnish Cache on CentOS 6.7

In this article I’ll show you how to install Varnish Cache on CentOS, version 6.7 in this case. Varnish is a web application accelerator also known as a caching HTTP reverse proxy. You install it in front of any server that speaks HTTP and configure it to cache the contents. Because Varnish Cache is really,…

Continue reading Install Varnish Cache on CentOS 6.7

25 July 20141 April 2020

Magento maintenance script for IIS

Important Magento maintenance, now for IIS too: optimize the speed and performance of your Magento ecommerce webshop by carrying out important maintenance. Remove old MySQL database log files and Magento cache data on a regular basis. Jan ReilinkMy name is Jan. I am not a hacker, coder, developer or guru. I am merely a systems…

Continue reading Magento maintenance script for IIS

29 June 201426 June 2020

8 Tips to improve Joomla performance

How to speed-up Joomla performance on Windows Server IIS: 8 important, but simple, tips to improve & speed up Joomla Add caching, gzip compression, set your sessions & optimize MySQL database functions… Provide your visitors with a blazing fast Joomla website! Jan ReilinkMy name is Jan. I am not a hacker, coder, developer or guru.…

Continue reading 8 Tips to improve Joomla performance

18 May 201418 March 2020

Minify JavaScript, CSS and compress images

Fire-and-forget JavaScript and CSS minification and PNG image optimization on the Linux-, Mac OS X and Windows command-line interface. Using OptiPNG and YUI Compressor Optimize PNG images and minify JavaScript and CSS files, the easy and fast way? With YUI Compressor and OptiPNG on the Windows-, Linux- and macOS command line of course! Compacting HTML,…

Continue reading Minify JavaScript, CSS and compress images

19 March 201312 June 2020

Boost Drupal performance with Boost

Boost Drupal performance on Windows Server IIS. Besides WinCache on IIS, you can improve Drupal’s performance by installing the Drupal BOOST module. For this module to work you need to disable Drupal’s own caching mechanism, and you need access to the server variable CONTENT_TYPE in URL Rewrite. Here is how… Jan ReilinkMy name is Jan.…

Continue reading Boost Drupal performance with Boost

17 February 201318 July 2019

Create your own PHP based Origin Pull CDN

The advantage of having your website content hosted on a Content Delivery Network (CDN) is having your content distributed and stored across the Globe. Utilizing the network of the Content Delivery Network provider. Hosting your WordPress website on a Content Delivery Network is an important WordPress optimization tip. Here is how to create your own…

Continue reading Create your own PHP based Origin Pull CDN

14 February 20134 February 2020

Cache MySQL query results with PHP WinCache

In November 2011, I wrote a post about MySQL query caching with PHP/Zend_Cache, and I recently stumbled upon a blog post caching MySQL query results in memcached by “KutuKupret”. This made me wonder if the same would be easily done with the Windows Cache Extension for PHP. Jan ReilinkMy name is Jan. I am not a hacker,…

Continue reading Cache MySQL query results with PHP WinCache

14 November 201115 January 2020

MySQL query caching using PHP/Zend_Cache

By using the Cache.php PHP class of the Zend Framework, you can relatively easy cache MySQL query results to disk. This ensures faster consecutive results and speeds up execution. In this context, caching means: execute a MySQL query once and save the result in a temporary file. For every time that same query is executed,…

Continue reading MySQL query caching using PHP/Zend_Cache

Hi there!