Skip Navigation

Home › Support › English Support › [Closed] Remove old rows wp_icl_translate table

[Closed] Remove old rows wp_icl_translate table

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.

Sun Mon Tue Wed Thu Fri Sat
- 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 -
- 12:00 – 16:00 12:00 – 16:00 12:00 – 16:00 12:00 – 16:00 12:00 – 16:00 -

Supporter timezone: Europe/Zagreb (GMT+02:00)

This topic contains 6 replies, has 2 voices.

Last updated by Dražen 1 year, 2 months ago.

Assisted by: Dražen.

Author Posts
January 25, 2024 at 9:35 am #15225215

matthiasR-28

Hi, we have at the moment a huge wp_icl_translate table and this causes a lot of slow querries.

We think it has to do with uploading previously multiples times thousands of products and removing them later because of some issues.

Now in our table wp_icl_translate we have 4.686.628,00 rows. But i am pretty sure most of them we dont need anymore. How can we clean this?
January 25, 2024 at 10:30 am #15225495

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

can you please try to follow the workaround from the next errata:

- https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/

File: hidden link

Regards,
Drazen
January 25, 2024 at 10:09 pm #15228386

matthiasR-28

Hi, i did this but didnt do much. We have 5.000.000 + rows in our `wp_icl_translate` table what is a disaster for the speed. How can we reduce? We only have about 3k products for now
January 26, 2024 at 7:57 am #15228907

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

I am not sure would need to check further to know if this is needed or not, if you have many translations and posts that could be expected.

Please share access to your staging site, with wp-admin access and FTP, so we can check.

Thanks,
Drazen
January 26, 2024 at 8:56 am #15229126

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

thanks, I checked and I am further trying to check DB via phpmyAdmin, but seems your hosting blocks it.

1) Can you please check or let us know how can we check DB data? (hidden link)

2) Also can you please confirm this is a staging site, and we are free to do checkups and changes?

Thanks,
Drazen
January 26, 2024 at 8:59 am #15229130

matthiasR-28

Hi, its a live site but we have backups
January 26, 2024 at 9:01 am #15229165

Dražen
Supporter

Languages: English (English )

Timezone: Europe/Zagreb (GMT+02:00)

Hello,

we can not safely check on a production website.

Please provide access to the staging site and steps on how to check DB or unblock phpmyAdmin plugin on staging site.

Thanks,
Drazen

The topic ‘[Closed] Remove old rows wp_icl_translate table’ is closed to new replies.