Performance Issue

  • Resolved scottm1967

    (@scottm1967)


    3 years, 4 months ago

    We are having periodic spikes in load on the server. It seems like the query to update the API last access time for CC is one of the big offenders. It looks like this query is executed multiple times in rapid succession causing locking issues with mysql. I can see in the logs that it is executed just seconds apart. The query is:

    UPDATE woocommerce_api_keys SET last_access = ‘2021-11-04 00:06:36’ WHERE key_id = 19;

    The entry for 19 is Constant Contact.

    Please research and fix.

Viewing 1 replies (of 1 total)
  • Plugin Author Constant Contact

    (@constantcontact)

    Hi @scottm1967

    Do you have any other Constant Contact based plugins installed or plugins that have their own Constant Contact integrations?

    Asking because I’ve checked the plugin’s code and I’m finding a place where potentially remove a woocommerce_api_keys value, and where we select found keys from the database, but none where we’re updating anything around last_access. It’s possible that that part is coming from WooCommerce, and it just happens to be causing some slowdown when managing the key(s) for our plugin.

Viewing 1 replies (of 1 total)
  • The topic ‘Performance Issue’ is closed to new replies.