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

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

MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

Are you running into MySQL load problems? Learn how to tune MySQL servers for a heavy InnoDB workload, by configuring innodb_buffer_pool_instances. Dividing the InnoDB buffer pool into multiple instances improves Disk I/O. By doing so, you run your database and website more efficiently and faster. Here is a little help for you. Jan ReilinkMy name…

Continue reading MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

Optimize WordPress MySQL tables through Cron, behind the scenes

Schedule WordPress database optimization with WP-Cron To regularly optimize my WordPress database tables, I created a small plugin that utilizes the WordPress Cron feature. This comes in handy to perform database optimization for WordPress on a regular basis, without forgetting about it. Just activate and enjoy. And here is the plugin code … Jan ReilinkMy…

Continue reading Optimize WordPress MySQL tables through Cron, behind the scenes

Minify WP-Super-Cache HTML cache files: WPSCMin a WP-Super-Cache plugin

The WordPress WP-Super-Cache cache plugin doesn’t minify HTML cache files, which I find a disadvantage. Knowing minify libraries, I went looking for an existing solution (why reinvent the wheel?), and found one: WPSCMin. Read on … Jan ReilinkMy name is Jan. I am not a hacker, coder, developer or guru. I am merely a systems…

Continue reading Minify WP-Super-Cache HTML cache files: WPSCMin a WP-Super-Cache plugin

Vevida Optimizer WordPress plugin

Installing WordPress is one thing, keeping it up to date is something else. Each week brings new bugs or potential attack scenarios that will make a WordPress website vulnerable to hacks. Enabling automatic updates for all or at least most parts of WordPress solves a large number of problems with irregularly maintained WordPress websites. Jan…

Continue reading Vevida Optimizer WordPress plugin

How to set a good PHP realpath_cache_size

The PHP directive realpath_cache_size sets the size of the realpath cache to be used by PHP. Increasing realpath_cache_size might greatly improve PHP performance, as PHP states: “this value should be increased on systems where PHP opens many files.” Setting a correct value for PHP realpath_cache_size can greatly improve PHP performance and optimize WordPress – and…

Continue reading How to set a good PHP realpath_cache_size

Joomla ACL decision flow-chart

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

Convert MySQL MyISAM tables to InnoDB

In the earlier days of MySQL, the default storage engine for your database tables was “MyISAM”. InnoDB is the engine to use now, and MyISAM is no longer actively developed. Therefore all MySQL optimizations are for InnoDB, and it’s recommended to switch from MyISAM to this InnoDB storage engine for your MySQL database tables. Follow…

Continue reading Convert MySQL MyISAM tables to InnoDB

WordPress wp_options table autoload micro-optimization

Learn how to optimize WordPress’ wp_options table for faster database results. This probably isn’t a big issue, but today I noticed a slow MySQL query coming from a WordPress database (WordPress wp_options table). This made me investigate and to optimize the WordPress wp_options table “autoload” feature. The autoload feature loads and caches all autoloaded options,…

Continue reading WordPress wp_options table autoload micro-optimization

Umbraco Project Belle

Configure SQLServer sessionState for Umbraco

Configure Umbraco for SQLServer sessionState storage, for your sessions. This post explains how to prepare your Umbraco website for a high performance web garden or web farm, and load balancing environments: Store your ASP.NET / Umbraco sessions out-of-process (OutProc). As opposed to the default in-process (inProc) sessions, where sessions are saved in the worker process.…

Continue reading Configure SQLServer sessionState for Umbraco