Support (offered by community volunteers) > Using CiviCRM

MySQL maxing

(1/3) > >>

Matt2000:
MySQL is maxing my CPU at 99%+.

By 'show processlist;' it appears the problem query is

SELECT count(DISTINCT contact_a.id) FROM civicrm_contact contact_a LEFT JOIN...

I'm running CiviCRM 1.9.

Any ideas?

Donald Lobo:

how big is the db etc, how many locations / emails / address / contacts etc. how long does it get max out the cpu for

the 2.0 schema has been significanly changed to reduce the number of left joins. there has also been some optimizations for search when displayed in a page (i.e. a limited number of contacts being displayed)

lobo

Matt2000:
9541 rows in civicrm_contacts table. Can't check on much else, as I'm also getting constant "Could not find valid Key" errors.

Once that query runs, it gets stuck, and cpu stays max'd until I kill the query.

I can't upgrade to 2.0 because of the problems with the Dojo HTML editor in CiviMail.

Matt2000:
FYI, this problem, which was occurring nearly everyday, has not occurred again since downgrading to CiviCRM 1.9.11960 a few days ago.

Matt2000:
Never mind. It happened again at least once yesterday, and I just killed 4 queries for today. :-(

Navigation

[0] Message Index

[#] Next page