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.
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'.
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.
Gracias!
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.
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.
Thanks.
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.
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?
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?
I explain in first message about the size (check it, is in spanish but can understand):
"wpm8_icl_translate and wpm8_postmeta combined have almost 2 million rows, which is a lot. The queries use a lot of resources, the IOPS usage skyrockets, and the website results in a 504 error (or website critical error)."
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.
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.
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
Marcel
This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.
