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.
Increase WordPress’ memory limit WP_MEMORY_LIMIT properly in wp-config.php
The WordPress memory limit can be increased by the WP_MEMORY_LIMIT variable in wp-config.php
. However, 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 a correct way of setting WordPress WP_MEMORY_LIMIT and PHP memory_limit settings.
How to optimize your WordPress hosting β 9+ practical tips
Isnβt it true that, when you (start to) develop WordPress websites for clients, and you host them yourself, you find yourself in a situation where you need to know a lot about βstuffβ other than WordPress development? In this optimizing WordPress hosting post, I provide 9+ practical tips for you, to improve WordPress hosting performance. Especially useful if you plan to develop and host WordPress websites yourself.
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
and increasing read/write I/O threads. Dividing the InnoDB buffer pool into multiple instances can improve Disk I/O. By doing so, you run your database more efficiently and faster. Here is a little help for you.
Optimize WordPress MySQL tables through Cron, behind the scenes
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.
How to optimize PHP OPcache configuration
Now that you’ve optimized PHP realpath_cache_size, it’s time to fine-tune PHP OPcache. With just a few tweaks you can tune OPcache to make it perform much better, and here is how! …
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.”. Therefore, setting a correct value for PHP realpath_cache_size can greatly improve PHP performance and optimize WordPress – and other CMS’s – websites.
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!
MySQL database optimization with indices
Why MySQL indices are so important? Here at Vevida, we like to help our customers as much as possible. Even with optimizing a MySQL database when they don’t ask for it, or when a customer doesn’t know performance can be improved. For example by adding an index because we spotted a slow query in our slow-query log.
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 this tutorial on how to convert from MyISAM to InnoDB.
WordPress wp_options table autoload micro-optimization
Learn how to add an index and 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, if available, or all options. The default option is to autoload, and over time when the wp_options
table grows, this degrades performance.
Check, repair and optimize MySQL tables with mysqlcheck
The mysqlcheck client is a command line table maintenance program for MySQL. Mysqlcheck checks, repairs, optimizes, or analyzes MySQL tables. In this post I’ll show you how to use mysqlcheck
to optimize all MySQL tables using a cronjob.
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.
Optimize all MySQL tables with PHP/MySQLi multi_query
The PHP MySQLi extension supports multiple queries, which are concatenated by a semicolon, with mysqli->multi_query
. We use this to optimize all MySQL tables, in a single multi-query statement. Neat! Optimizing MySQL tables is important to keep tables small and fast. This boosts MySQL, PHP and website performance and we all love that, don’t we? :)