How to reduce the size of the wordpress wp_options table
Posted: Fri Nov 29, 2013 9:40 pm
If you have noticed an abnormal increase of wp_options tables, it is probably due to a plugin that keep on adding transient entries. The first thing you need to do is to find the plugin and then disable it. It is not easy to find the plugin, so you may disable all plugins (probably using database by adjusting 'active_plugins' record) and then enable one by one. It is also good if you can login to mysql server and execute SHOW PROCESSLIST; to see the ongoing process list of Mysql server.
Later on you may execute the following SQL string to delete the invalid entries.
Hope that helps!
Later on you may execute the following SQL string to delete the invalid entries.
Code: Select all
DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');