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.

Tagged: 

This topic contains 1 reply, has 2 voices.

Last updated by Raja Mohammed 4 months ago.

Assigned support staff: Raja Mohammed.

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

rachaelE

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?

Thanks
Rachael

June 12, 2019 at 4:47 am #4000203

Raja Mohammed
Supporter

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
Raja