wp_mailpoet_subscriber_segment

  • Resolved Dani?l

    (@danielbareman)


    2 years, 10 months ago

    Hello!

    I’m Dani?l, a 3rd-line technical support representative of the Dutch webhosting company mijndomein.nl

    I’m getting in contact from my employers perspective, being a Webhosting company, providing shared-hosting.

    We are experiencing issues with customers using the MailPoet plugin, which is excessively using resources of database servers doing the following query:

    INSERT IGNORE INTO wp_mailpoet_subscriber_segment(subscriber_id, segment_id, created_at)
      SELECT mps.id, "1", CURRENT_TIMESTAMP() FROM wp_mailpoet_subscribers mps
        WHERE mps.wp_user_id > 0

    Which comes from:

    mailpoet/lib/Segments/WooCommerce.php:372:private function insertUsersToSegment(): void {
mailpoet/lib/Segments/WP.php:302:private function insertUsersToSegment() {

    We see that the following versions:

    COUNT    | PERCENTAGE | LINE
-----------------------------------------------------
      12 | 80.00 %    | 3.75.1
       1 | 6.67 %     | 3.74.3
       1 | 6.67 %     | 3.75.0
       1 | 6.67 %     | 3.76.0
-----------------------------------------------------
      15 | TOTAL LINES

    Run this query multiple times a minute, which seems rather much.

    Has anyone experienced this, and can you help diagnose the root-cause of this problem to help resolve the resource intensive usage of MailPoet on our database servers?

    Could this be a bug on / in MailPoet, or is it caused / triggered elsewhere?

    Kind regards, Dani?l

    • This topic was modified 2 years, 10 months ago by Dani?l.
    • This topic was modified 2 years, 10 months ago by Dani?l.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Dani?l

    (@danielbareman)

    I’m seeing the 3.76.0 – 2022-01-13 release, with:
    Fixed: cron issues with excessive number of queries in WooCommerce subsriber sync;

    Could this be what is causing the above?

    Plugin Support Gui A. a11n

    (@guicmazeredo)

    Hi there @danielbareman,

    Thank you for reaching out to report this issue you are experiencing.

    I asked our developers to have a look, and they are aware of this issue. They are working on a fix that might become available in the next release (scheduled for Tuesday, 18) or on the release after the next one at the latest (Tuesday 25).

    I’m really sorry for any inconvenience this issue may possibly have caused you and I appreciate your patience.

    Plugin Support Ojoma a11n

    (@geraltrivia)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Have a great day!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wp_mailpoet_subscriber_segment’ is closed to new replies.