• Hi,
    I installed Mailpoet 3 (and MailPoet 3 Premium) on a website I’m currently working on (hosted on Siteground), and I’m experiencing cpu usage spikes so high that Siteground disabled my website.
    I’ve seen other posts like mine, and yes, I’ve already selected the option “Visitors to your website”.

    How can I tackle the problem?

    Thanks for the attention

    Ivan

Viewing 3 replies - 1 through 3 (of 3 total)
  • Jack K

    (@jack-kitterhing)

    Hey Ivan,

    If you’re experiencing CPU usage spikes, you might also want to edit the “Send With” options to limit the amount of emails being sent per hour. This should bring your CPU usage down.

    Thanks!

    Plugin Author MailPoet

    (@wysija)

    @ivanbigazzi thanks for reporting. Can you please contact us through the form found in the help icon at the bottom right of all your MailPoet pages?

    @miclovin we’ll be happy to help too. Either contact us like we instructed above or open a separate forum topic.

    • This reply was modified 1 year, 4 months ago by  MailPoet.

    @wysija sadly the CPU spike situation got so bad that this morning Siteground locked my website.
    I’ll have to pay for a more powerful server solution.
    In the meantime, I opended a ticket with the siteground support team, and they answered blameing these queries that, accoirding to them, are too “heavy”:

    === TOP 10 of 1351 (total) Slow Queries for the past 24 hours ==========
    1. Executed 7h 12m 50s ago for 63.735756 sec on Database –> [MYWEBSITE]_wp
    Date: 2018-03-14 01:49:06 Query_time: 63.735756 Rows_examined: 99: Rows_sent 0 Lock_time: 0.094002
    # Schema: [MYWEBSITE]_wp Last_errno: 1160 Killed: 0 SELECT * FROM wp_mailpoet_sending_queues WHERE status = ‘scheduled’ AND scheduled_at [MYWEBSITE]_wp
    Date: 2018-03-14 01:48:55 Query_time: 37.247336 Rows_examined: 99: Rows_sent 0 Lock_time: 0.000126
    # Schema: [MYWEBSITE]_wp Last_errno: 0 Killed: 0 SELECT * FROM wp_mailpoet_sending_queues WHERE status = ‘scheduled’ AND scheduled_at [MYWEBSITE]_wp
    Date: 2018-03-14 01:48:40 Query_time: 37.197481 Rows_examined: 99: Rows_sent 0 Lock_time: 0.132639
    # Schema: [MYWEBSITE]_wp Last_errno: 0 Killed: 0 SELECT * FROM wp_mailpoet_sending_queues WHERE status = ‘scheduled’ AND scheduled_at [MYWEBSITE]_wp
    Date: 2018-03-14 01:48:21 Query_time: 24.897370 Rows_examined: 99: Rows_sent 0 Lock_time: 0.000149
    # Schema: [MYWEBSITE]_wp Last_errno: 0 Killed: 0 SELECT * FROM wp_mailpoet_sending_queues WHERE status = ‘scheduled’ AND scheduled_at [MYWEBSITE]_wp
    Date: 2018-03-14 01:48:48 Query_time: 22.616400 Rows_examined: 33: Rows_sent 0 Lock_time: 0.000153
    # Schema: [MYWEBSITE]_wp Last_errno: 0 Killed: 0 SELECT * FROM wp_mailpoet_scheduled_tasks WHERE type = ‘bounce’ AND scheduled_at > ‘2018-03-14 01:48:25’ AND deleted_at IS NULL AND status = ‘scheduled’;
    ————————————————————————————————–
    6. Executed 1m 11s ago for 22.589694 sec on Database –> [MYWEBSITE]_wp
    Date: 2018-03-14 09:00:45 Query_time: 22.589694 Rows_examined: 33: Rows_sent 0 Lock_time: 0.000083
    # Schema: [MYWEBSITE]_wp Last_errno: 0 Killed: 0 SELECT * FROM wp_mailpoet_scheduled_tasks WHERE type = ‘premium_key_check’ AND scheduled_at [MYWEBSITE]_wp
    Date: 2018-03-14 09:01:16 Query_time: 22.071418 Rows_examined: 33: Rows_sent 1 Lock_time: 0.000103
    # Schema: [MYWEBSITE]_wp Last_errno: 0 Killed: 0 SELECT * FROM wp_mailpoet_scheduled_tasks WHERE type = ‘bounce’ AND scheduled_at [MYWEBSITE]_wp
    Date: 2018-03-14 09:01:00 Query_time: 21.344939 Rows_examined: 33: Rows_sent 0 Lock_time: 0.000093
    # Schema: [MYWEBSITE]_wp Last_errno: 1160 Killed: 0 SELECT * FROM wp_mailpoet_scheduled_tasks WHERE type = ‘premium_key_check’ AND scheduled_at [MYWEBSITE]_wp
    Date: 2018-03-14 01:48:46 Query_time: 21.126695 Rows_examined: 33: Rows_sent 1 Lock_time: 0.000144
    # Schema: [MYWEBSITE]_wp Last_errno: 0 Killed: 0 SELECT * FROM wp_mailpoet_scheduled_tasks WHERE type = ‘sending_service_key_check’ AND scheduled_at [MYWEBSITE]_wp
    Date: 2018-03-13 22:01:12 Query_time: 20.891125 Rows_examined: 1: Rows_sent 1 Lock_time: 0.110097
    # Schema: [MYWEBSITE]_wp Last_errno: 0 Killed: 0 SELECT * FROM wp_mailpoet_settings WHERE name = ‘db_version’ LIMIT 1;

    How can I contact you?

    Best regards

    Ivan

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