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: Bug
This topic contains 11 replies, has 3 voices.
Last updated by Marcel 1 year, 6 months ago.
Assisted by: Marcel.
Author | Posts |
---|---|
October 17, 2022 at 4:24 pm #12255697 | |
felixA-6 |
Según mi hosting tengo problemas y lentitud extrema debido a que las tablas wpm8_icl_translate y wpm8_postmeta combinadas, tienen casi 2 millones de filas, lo que es mucho. Las consultas usan muchos recursos, el uso de IOPS se dispara y el sitio web da como resultado el error 504 (o bien errór crítico en el sitio web). No tengo la menor idea, pero desde el hosting me dicen que es lo que está causando un error 504 en el admin de mi tienda woocommerce. Esto: |
October 19, 2022 at 7:53 am #12266793 | |
Alejandro Supporter
Languages: English (English ) Spanish (Español ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00) |
Ciao! Puoi provare ad accedere al database ed ottimizzare tutte le tabelle per liberare un po' di spazio. Quello che menzioni comunque è "normale". la tabella wp_postmeta crea tantissime entrate e di conseguenza anche noi dobbiamo crearle perché dobbiamo assicurarci che tutti i metadata siano traducibili. Più pagine ne hai o più plugin ne hai e pipu cresceranno queste tabelle. I nostri sviluppatori stanno lavorando per cercare di migliorare il processo dalla nostra parte e con la versione successiva di WordPress ( 6.1 che cerca di migliorare i processi del database) dovresti notare dei miglioramenti già sin da subito. noi aspettiamo poter rilasciare i nostri miglioramenti per la versione 4.6 ma non è ancora 100% sicuro visto che è ancora in processo di testing. Per ora ti consiglio di provare a pulire la tabella wp_postmeta e di ottimizzare le tabelle successivamente perché anche le nostre si puliscano un po'. Saluti. |
October 19, 2022 at 8:03 am #12266849 | |
felixA-6 |
Gracias, pero ya se han optimizado todas las tablas y aún así seguimos con el problema, como me escribe en italiano no se si quiere decir algo más que "optimizar" las tablas, pero eso ya se ha hecho. Es una tienda online con muchos productos, nada más. No es asumible ni razonable que su plugin cause estos problemas. No estamos para esperar a posibles futuras actualizaciones. |
October 21, 2022 at 10:31 am #12286305 | |
Marcel Supporter
Languages: English (English ) German (Deutsch ) Timezone: Europe/Madrid (GMT+02:00) |
Hi, as you created your ticket in the English forum, I will reply to you in English. I hope that's OK for you. Otherwise, please let me know, and I will try to find a Spanish supporter to handle your case. Currently, there is no proper solution for your case. I asked our development team is there is something we could do right now. I will let you know once I receive feedback from them. Best Regards |
October 21, 2022 at 10:47 am #12286581 | |
felixA-6 |
No problem with language, but i need solution, we cannot have a paid service (is not free) to recieve answer like "there is no solution" when cause is in your pluging! So besides need to wait day after day i need a solution as you can understand, for that we pay the plugin. |
October 21, 2022 at 1:49 pm #12287855 | |
Marcel Supporter
Languages: English (English ) German (Deutsch ) Timezone: Europe/Madrid (GMT+02:00) |
Hi, please ignore my message you received via mail, it was a reply for another ticket. Our devs are working on a permanent fix. Please check this Erratum: If you wish, there is an experimental plugin we build I can share with you, but keep in mind that this is not an official way, so we cannot guarantee the results. Do you want to try it? I recommend you test it first on a dev environment. Please let me know. Best Regards |
October 21, 2022 at 2:07 pm #12287999 | |
felixA-6 |
No, i don´t want to have a risk of delete products description in my store (take long time to create), this is an store and my content are products, cannot delete, your experimental plugin comes to say that delete translation jobs, no, what i have are products and the tarnslation to one language, if i delete that what will happen, will lost translation? |
October 21, 2022 at 3:22 pm #12288683 | |
Marcel Supporter
Languages: English (English ) German (Deutsch ) Timezone: Europe/Madrid (GMT+02:00) |
Hi, let me explain that in detail. The tables are big because there are many translations for your products saved. What the plugin is doing is removing these jobs, so the DB size reduces. This will influence the total performance of loading pages/posts & also your products. This means you will not lose translation. It will only delete the translation jobs for that translation in the database itself. Can you please check how big these tables are currently? icl_translate Thank You Best Regards |
October 21, 2022 at 3:32 pm #12288773 | |
felixA-6 |
I explain in first message about the size (check it, is in spanish but can understand): I have in website spanish and english language, so products are in spanish and translated to english, i make translation myself. If you say that won´t make me lost the english or spanish version of product page (product description...), ok, but if will lost is a big big problem. |
October 21, 2022 at 3:57 pm #12288905 | |
Marcel Supporter
Languages: English (English ) German (Deutsch ) Timezone: Europe/Madrid (GMT+02:00) |
Hi, I asked about size in MB, because I can only compare the data from other clients based on sizes in MB, not per amount of rows the hold. The intention was to see how much got improved for clients with a pretty identical table size to esitmate how much this will help in your case. The plugin I mentioned will only remove old jobs data, not the translation itself. I recommend you test this first on a staging version to see if you can help to improve the size of that tables. You can find a download link here: https://wpml.org/forums/topic/need-db-cleanup-plugin/#post-12276543. Again, please test this first only on a staging environment and make a full backup if you decide later to run the same steps on your live environment. Best Regards |
October 28, 2022 at 8:39 am #12329995 | |
felixA-6 |
That is a patch, not a solution, anything ne is thinking in offer real solution to that which, even in best hosting, cause problems? |
October 28, 2022 at 9:57 am #12331095 | |
Marcel Supporter
Languages: English (English ) German (Deutsch ) Timezone: Europe/Madrid (GMT+02:00) |
Hi, as I mentioned, there is currently no solution for it. If you can provide us with a duplicator copy, we can check if we can optimize something in your specific case, but a constant fix is not available. That's not something we can easily fix with a simple workaround. Best Regards |