Cogito ergo sum

How to reduce the size of wp_icl_strings table in my wordpress database

Just like a lot of WordPress users, I use for a client WPML to make the website multilingual. The plugin is a magical plugin that enables you to translate everything on your website. To make the translation process much easier for the user, WPML just tracks down every single added string to the database, which is not always necessary. This tracking leads to huge database usage and an exponential growth of the size of the WPML-tables.
One example of this problem is the size of the table wp_icl_strings. Because WMPL keeps track of everything, there are a lot of ghost entries, rather untranslated string, stored in the database.

Run the following query to reduce the size of the table:

DELETE FROM `wp_icl_strings` WHERE status = 0;

The query will remove untranslated strings (status = 0) from the database.

REMEMBER: BACKUP YOUR DATABASE FIRST BEFORE EXECUTING ANY QUERY ON YOUR DATABASE   

About the author

Peshmerge Morad

A IT-student and a programmer based in the Netherlands whose interests span multiple fields.

Add comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

By Peshmerge Morad
Cogito ergo sum