Using uncss or similar with WordPress?

It is unlikely to ever work in a dynamic enviroment like wordpress, where css rules might be applied based on changes in the content. For example addition of a widget, aligning an image, etc. (that said, I wish wordpress themes would stop cramming 1M of CSS rules into one file instead of breaking it up … Read more

wordpress with 1.5 million posts

1 GB on virtual private server (VPS) should be enough, if you don’t have a high traffic. WP Cache could cause problems when number of posts is more than 30,000 due to limitations on file descriptors. Main rules of tuning nginx, php and MySQL are the same as for high traffic site. You can read … Read more

I’m designing a plugin to create database indexes. Suggestions?

This plugin, Index WP MySQL for Speed, is released. GPLed source code is here. Anecdotal experience shows speedups on some big WP and WooCommerce sites. Here’s the data definition language it runs to create useful compound indexes. ALTER TABLE wp_postmeta ADD UNIQUE KEY meta_id (meta_id); ALTER TABLE wp_postmeta DROP PRIMARY KEY; ALTER TABLE wp_postmeta ADD … Read more

WP Optimization: Removing Orphaned wp_options (especially the autoload ones)

Do you have access to a SQL client program like phpmyadmin or something similar? If so give this query SELECT option_id, option_name, LENGTH(option_value) FROM wp_options WHERE autoload = ‘yes’ AND option_name NOT LIKE ‘_transient%’ ORDER BY 3 DESC LIMIT 20; You’ll see the top twenty auto loaded options in descending order of length. Eyeball the … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)