This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.


This topic contains 1 reply, has 2 voices.

Last updated by Raja Mohammed 12 months ago.

Assigned support staff: Raja Mohammed.

Author Posts
June 11, 2019 at 7:39 pm #3998311


Hi there

The Database table icl_string_pages keeps growing VERY BIG. We believe this is a caching table so emptied it to solve the problem, but I have now read that this issue just reoccurs - how can I make sure it does not happen again?


June 12, 2019 at 4:47 am #4000203

Raja Mohammed

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hi Rachael,

I will help you with your issue,

As you have mentioned icl_string_pages holds cache data, Do you see any improvement after emptying the table? The tables entries will repopulate however the number of rows will not be the same as before, Kindly share with us any observation that you have made before and after truncating the table.

You might also need to repopulate the icl_strings_url tables, Please use the below MySql query to empty both the tables, We highly recommend securing a backup of your database before proceeding.

TRUNCATE TABLE wp_icl_string_pages;
TRUNCATE TABLE  wp_icl_string_urls;

Please note the performance will go down until the table data is repopulated.

Please let me know the observations.

Kind regards