High Database Load INSERT IGNORE INTO `civicrm_tmp_e_gccache_
I thought I'd bring this to attention of the Civi Mail team as it's causing high load. This has happened on more than 1 occasion, running many of these queries for about 3 hours.
I get notified of it by an AWS Cloudwatch alarm on RDS.
The database was not running a mailing at the time. Contacts approx 100,000 so quite large. However database load is usually very low, even when running a mailing.
I haven't been able to identify what this process is - if anyone knows, then is there something that can be done to address the load? The database joins in the query make is a large query - is there another way to do this? e.g. break the query up into temp tables, fewer joins, use indexes etc
Thanks