marjaK-2

Problem:
The client is trying to optimize their database, which has grown significantly due to numerous entries in the posts_meta table. They reported that WPML Delete Jobs did not effectively reduce the database size.
Solution:
We analyzed the database and found that the _postsmeta table was indeed the largest. We also discovered a large number of attachment entries that might be bloating the database. We recommend creating a staging version of the website and running the following SQL queries to clean up unnecessary entries:

SELECT p.ID FROM `93lzr5_posts` p LEFT JOIN `93lzr5_icl_translations` t ON p.ID = t.element_id WHERE p.post_type = 'attachment' AND t.element_id IS NULL;

DELETE pm FROM `93lzr5_postmeta` pm WHERE pm.post_id IN (SELECT p.ID FROM `93lzr5_posts` p LEFT JOIN `93lzr5_icl_translations` t ON p.ID = t.element_id WHERE p.post_type = 'attachment' AND t.element_id IS NULL);

DELETE p FROM `93lzr5_posts` p LEFT JOIN `93lzr5_icl_translations` t ON p.ID = t.element_id WHERE p.post_type = 'attachment' AND t.element_id IS NULL;

Please ensure to perform these actions on a staging site and not on the live site. If this solution does not apply or is outdated, we recommend checking related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If further assistance is needed, please open a new support ticket.