Excessive amount of database queries

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.

This topic contains 1 replies, has 1 voice.

Author	Posts
June 11, 2025 at 12:54 pm #17125917
Rasha Kanjarawi	Background of the issue: I am trying to understand why there is an excessive amount of database traffic on my website, which is not heavily visited. I see more traffic from crawlers than humans. I briefly activated the MariaDB general query log for about 10 to 15 seconds and got a log file of 12 MB. The queries with a high volume of data seem to be all from WPML. I need help to check if something unusual is happening. Link to a page where the issue can be seen: hidden link. Get the log here: hidden link. Symptoms: Excessive database queries resulting in high traffic, with an average ithroughput of 20 to 80 GiB per hour, and a 12 MB log file generated in 10 to 15 seconds. Questions: Can you check if some untoward things are happening with the database queries from WPML?
June 12, 2025 at 10:35 am #17129582
Rasha Kanjarawi	I've been looking at the PHP-FPM Status Page for the website, and it's showing huge request durations (often > 70 seconds) for everything which is not delivered directly by W3 Total Cache, i.e. first accesses to normal pages and any searches. I really don't know what is going on...
June 13, 2025 at 8:36 am #17132162
Rasha Kanjarawi	I found out that during a migration of the vserver to another host machine the database got corrupted. I was abkle to fall back to a database backup from before the migration.