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

How to load plugin after page is loaded – pagespeed issues

I’d reach out directly to that plugin developer to relate your concerns, and if they’re not responsive consider a different plugin. But in the meantime, you can use wp_dequeue_script() and wp_dequeue_style() and their counterparts wp_enqueue_script/style to remove the stuff that’s slowing down your site. This answer has more detail on how to move scripts from … 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

WordPress 3+ slow load times on Ubuntu 10.10

It looks like that wordpress can’t check for updates on the one server but can on the other. WordPress does not output much information if it can’t, it’s just an request which takes it’s time to time-out. Install the Disable WordPress Core Update (WordPress Plugin) and the Disable WordPress Plugin Updates (WordPress Plugin) to disable … Read more

Performance problem with first load

It’s a well-known problem among WordPress specialists that GoDaddy overloads their servers and you get tons of performance problems with it. If you are at GoDaddy because they are inexpensive let me recommend a host I’ve been using for years: A Small Orange. You can get a minimum account there for $US25/year, their Tiny plan. … Read more

cross-host benchmarking with wordpress

Afaik there’s no real performance test available (what exactly do you want to check?), but you can find a plugin that came out of the first Q below, that might help you doing some profilling. An interesting read might be… refactoring WP to improve memory performance generally a lot of Qs inside the performance tag … Read more

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