mailpoet_scheduled_task_subscribers table has very many rows

  • Resolved n1fdadmin

    (@n1fdadmin)


    2 years, 5 months ago

    Our paid mailpoet subscription has about 480 subscribers out of a limit of 1,000. I am receiving the following error when trying to backup our database –

    Table XXX_mailpoet_scheduled_task_subscribers has very many rows (185754)

    The excessive size of this table (185,000) records is causing our backups to be unreliable and unusable. I suspect that there are stranded records in this table as it seems unlikely that 480 subscribers would generate 185,000 records. Can you please help us to get this cleaned up?

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Gui A. a11n

    (@guicmazeredo)

    Hi there @n1fdadmin,

    The _mailpoet_scheduled_task_subscribers table holds information about which subscribers a task is supposed to be performed for.

    Currently, MailPoet will store and indefinitely keep a historical list of scheduled tasks and their related subscribers so it can get big.

    We have a task on our development backlog to automatically clean some types of information in this table periodically.

    I’m afraid we don’t have an ETA for releasing this adjustment though. You can manually clean it in the meantime and keep an eye on the new features and fixes that come with each weekly update to know when this will be implemented.

    I hope this helps!

    Thread Starter n1fdadmin

    (@n1fdadmin)

    OK, what strategy should we be using for manually cleaning up this table? Record age? Attributes? etc. How do we identify those records that need to be kept to avoid deleting information that is important for ongoing operation of MailPoet?

    Plugin Support Dani F. a11n

    (@danielinhou)

    Hi again @n1fdadmin ????,

    OK, what strategy should we be using for manually cleaning up this table? Record age?

    Yes, I think that cleaning it up by record age should work until the plugin does that automatically.

    I hope this helps.

    Cheers

    Thread Starter n1fdadmin

    (@n1fdadmin)

    Thanks Dani. I need a little more help. How does the information in this table correlate to active subscribers and email content? I want to be sure that I don’t get over aggressive and delete too many records and cause problems with subscriber attributes and/or email newsletters that we’ve sent in the past.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘mailpoet_scheduled_task_subscribers table has very many rows’ is closed to new replies.