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