Skip to content

Instantly share code, notes, and snippets.

Created December 31, 2021 07:52
What would you like to do?
Optimize postmeta table for big data on WordPress
ALTER TABLE wp_postmeta ADD key(post_id, meta_key(100), meta_value(191));
ALTER TABLE wp_postmeta ADD key(meta_key(100), meta_value(191));
-- change wp_postmeta to your table with prefix
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment