Posted inWordPress

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.
28/05/2020Posted inWordPress
Increase WordPress’ memory limit WP_MEMORY_LIMIT properly in wp-config.php
Posted inWordPress

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

How to increase the memory limit for your WordPress website, the right way. 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.
26/02/2018Posted inWordPress
Your WordPress hosting at Warp Speed - img. credits: Christian Daryanto Limas @ flickr
Posted inWordPress

Optimized WordPress hosting (9+ practical tips)

WordPress optimized hosting is a subject on which a lot is written about. And therefore, this post is not about where to host your WordPress blog, or who offers the best WordPress hosting. This post is for you developers, what you can do to optimize your WordPress hosting. This post is not about setting up high-availability, fail-over, clustering, IIS versus Nginx versus Apache, RAID 1, 5, 6, 10, different types of storage, and so on. It’s about solving performance issues.
31/08/2016Posted inWordPress
High Performance MySQL
Posted inMySQL

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

Are you running into MySQL load problems? Learn how to optimize MySQL InnoDB Buffer Pool 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.
10/06/2016Posted inMySQL
get current PHP realpath_cache_size value
Posted inCode base

How to set a good PHP realpath_cache_size

Learn how to set a good PHP realpath_cache_size and optimize your PHP performance. . 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 other CMS's - websites.
23/10/2014Posted inCode base
High Performance MySQL
Posted inMySQL

Convert MySQL MyISAM tables to InnoDB

Convert MyISAM to InnoDB for better database performance. 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.
19/06/2014Posted inMySQL
Posted inWordPress

WordPress wp_options table autoload micro-optimization

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. 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.
02/05/2014Posted inWordPress
Umbraco Project Belle
Posted inUmbraco

Configure SQLServer sessionState for Umbraco

Prepare your Umbraco website for high performance web garden or web farm and load balancing environments: Store your sessions out-of-process (OutProc). As opposed to the default in-process (inProc) sessions, where sessions are saved in the worker process. Create a high performing, fast loading Umbraco website.
23/04/2014Posted inUmbraco
Posted inCode base

Optimize all MySQL tables with PHP/MySQLi multi_query

PHP script to make your MySQL database smaller, leaner and faster! 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?
23/04/2014Posted inCode base