Background of the issue:
I am trying to optimize my database for the site hidden link. I have contacted my hosting service, and they explained that WPML has created thousands of rows in my tables, bloating my database from 2GB to over 4GB, most of this in posts_meta (3.7GB).
Symptoms:
WPML Delete Jobs did basically nothing to reduce the database size.
Questions:
How can I effectively reduce the size of my database?
Is there a more effective way to clean up the posts_meta table?
Are there any other WPML tools or methods to optimize the database?
Thank you for sharing the results. So, in this case, we can work it around. Please download your DB file from your hosting, upload it to Google Drive, Dropbox, or another cloud service from your choice. Please share the link, so I can download it. If possible, please also download and share the website files, so I can create a manual copy, locally.
With that information, I can analyze the DB. Let me know how it goes.
I think the only way I can share anything this big is by using OneDrive, but to be able to share the link there I need private message option since it is not something I can share in public forum and if I have understood right I need an invite to the private message to be able to give one?
Google Drive, WeTransfer can handle the file just fine, as well. Just pointing that out.
I've activated a private field, you will likely find it under the message box. It's a field to share the Duplicator package, but you can use it to insert any link you want. Let me know if it shows up. This field will only allow you and me the see the link.
Apparently. I couldn't import the files you shared, due to errors. Nonetheless, I've forwarded the information we currently have to our devs, to get a second opinion. I'll get back once I hear from them. Thank you for your patience and cooperation.
