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 5 replies, has 2 voices.

Last updated by joachimB-4 2 years, 10 months ago.

Assigned support staff: Denise.

Author Posts
August 29, 2016 at 5:08 am #1026559

joachimB-4

Hi,
even with the latest versions of your plugins gets the table icl_string_pages very big (about 400 MB, 5.300.000 rows). It makes automatic DB backups very slow. Is it possible to truncate this table on a regulary basis (cron job)?

August 29, 2016 at 7:33 am #1026849

joachimB-4

May be you can provide a SQL query to find out what causes the size (e.g. plugins)?

August 29, 2016 at 12:07 pm #1027684

Denise

Hi Joachim,

I'll help you with this. Thanks for the debug info.

The problem with the large size of the icl_string_pages table is resolved now by updating our plugin to the latest versions. I see that you have already updated so this will not re-occur in the future. After this table is brought down to a normal size, it will not need to be truncated.

I see that you have WPML String Translations 2.4.1.1
* Did you recently update this plugin?
* Please deactivate/activate String Translations and check the size of the table.

If you are still having this issue, please use the instructions here. https://wpml.org/errata/big-icl_string_pages-table-wpml-3-5-0-causes-performance-issues/

Thanks,
Denise

August 29, 2016 at 12:37 pm #1027819

joachimB-4

Hi,
I did so as adviced (deactivate/activate), the table is now 0 rows, I will look at it and come back in one or two days - lets see how the table growth!
Regards

August 29, 2016 at 1:27 pm #1027979

Denise

OK Joachim,

Thanks for letting me know. This table should increase to a natural size as you scan strings and continue to use WPML. Please let me know if you continue to have any performance issues related to this.

Thanks,
Denise

August 30, 2016 at 12:03 pm #1036936

joachimB-4

Hi,
problem solved, table is now about 12 MB and not growing!
Thanks
joachim