Skip Navigation

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: 

This topic contains 2 replies, has 2 voices.

Last updated by Marcel 2 months, 1 week ago.

Assigned support staff: Marcel.

Author Posts
April 7, 2021 at 7:40 pm #8485863

amyL-11

Hello,

URGENT. We see multiple queries that are potentially causing spikes in our sites:

UPDATE `wp_4_icl_mo_files_domains` SET `domain` = 'acf', `status` = 'not_imported', `num_of_strings` = 0, `last_modified` = 1617757319 WHERE `file_path_md5` = '26e1b0cdad7a7e7cee0926bc54f266ca';

UPDATE `wp_4_icl_mo_files_domains` SET `domain` = 'wpml-string-translation', `status` = 'not_imported', `num_of_strings` = 0, `last_modified` = 1617757319 WHERE `file_path_md5` = '9ac768c6db2e30dc875c1047274b674c';

UPDATE `wp_4_icl_mo_files_domains` SET `domain` = 'wpml-media', `status` = 'not_imported', `num_of_strings` = 0, `last_modified` = 1617757319 WHERE `file_path_md5` = '6cc1659b5e62d80610ca7cdb3cbb7b48';
offset: 121851

What may be causing this?

Thanks,

Eddie

April 7, 2021 at 7:42 pm #8485873

amyL-11

IS `status` = 'not_imported' an issue?

April 8, 2021 at 1:30 pm #8492921

Marcel
Supporter

Languages: English (English ) German (Deutsch )

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

Hi Eddie,

no 'not_imported' is not an issue. This is the only status for the row if WPML imports the .MO file.

WPML string translations are saved in mo.files. Path to the .mo files that are kept in wp-content/languages/wpml are stored in the table wp_icl_mo_files_domains. Can you please add me some detailed information about the queries using Debug Objects plugin? You can find a tutorial here: https://wpml.org/faq/how-to-debug-performance-problems/#install-and-activate-the-debug-objects-plugin

Then, please add me a screenshot from WPML -> Themes & plugins localization window.

Thanks

Best Regards
Marcel

The topic ‘[Closed] Query generating spike’ is closed to new replies.