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?
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...
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.
