CiviCRM Community Forums (archive)

I've noticed the (abridged) entries in my mysql-slow log shown below.

The fact that it's fairly consistently every 12 minutes, suggests it's some kind of cron, but my 2 crons for this account are one an hour (the drupal one), and every 10 minutes (to send mail). The details of the query that is slow is also weird - it's a mongo select, seems to be wanting to export everything in the database.

I've checked the web server logs and don't see any corresponding url that's triggering it (though I might just not be seeing it).

Anyone have any ideas?

My one thought is that it's related to the soap interaction with UAS, which they are using.


# Time: 101125  9:56:41
# User@Host: lllc[lllc] @ localhost []
# Query_time: 735  Lock_time: 0  Rows_sent: 100  Rows_examined: 848628133
--
# Time: 101125 10:08:40
# User@Host: lllc[lllc] @ localhost []
# Query_time: 718  Lock_time: 0  Rows_sent: 100  Rows_examined: 848629690
--
# Time: 101125 10:20:21
# User@Host: lllc[lllc] @ localhost []
# Query_time: 700  Lock_time: 0  Rows_sent: 100  Rows_examined: 848631384
--
# Time: 101125 10:31:55
# User@Host: lllc[lllc] @ localhost []
# Query_time: 692  Lock_time: 0  Rows_sent: 100  Rows_examined: 848633057