Database Optimisation
R
Recyclart
You should really optimize how you save the email sending queue in the table _mailpoet_sending_queue.
On my websites, for the bigger one, this table is several Go and continues to increase with time... until the server crash.
Why are you saving each email in plain HTML in the database? You should save only one version of the global email and then optimize to call this email for each user... not save each email in the table, I have dozen of thousands of the same emails in my table...
Really, they're a lot of improvements to be done here! It's ok for small websites but for bigger ones it's not really possible.
M
MailPoet
Merged in a post:
reduce table of database mailpoet
Michel CHILAUD
Hello,
I see my table : wp_mailpoet_scheduled_task_subscribers has a 1 200 000 rows.
I delete this rows obsolete by mysql with help of Support. Can you put a "button" to delete this rows manually or automatic (for example every month)... I am clear ? if not see Dani F who help me. Thanks
I hope you understand my english (i am french)
edm73
Another upvote for this. So much bloat in a database makes it slow to backup, prone to timing out, takes an age to perform certain DB tasks. If I could find another plugin that could drag and drop posts from WP directly, I'd ditch Mailpoet like a hot brick. They don't seem interested in improving this.
Franz Neumeier
I know people who have switched to other newsletter sending providers for this very reason. And statistics are not that important for everyone, so there should at least be an option to delete older data.
Tautvidas
Hello Michel CHILAUD, thank you for your clear feedback!
To help us better understand your specific case, could you please share what motivated you to explore the number of rows in this table, and look to delete the obsolete rows?
Michel CHILAUD
Tautvidas: Hi, For the provider OVH i have a limit for the data base (200 M). I receive an alert at 160 Mo ! I delete a lot of old post, but the size is about the same. So i have a look by sql to see the size of alle the table... and i see the table wp_mailpoet_scheduled_task_subscribers with 1 200 000 rows.
I think, it is not a specific case, but an hide problem. I think there should be an option in mailpoet to clean the database from time to time... automatically or manually. Have a nice day
Tautvidas
Michel CHILAUD: Thank you so much for sharing, the additional context is very helpful!
I can definitely see how this can make managing your site more stressful, and it's definitely an area we should improve in.
Unfortunately, currently we're focusing on the Automations feature and don't have short-term plans to improve this, but this issue is on our radar, and we'll follow up when we have more to share.
Michel CHILAUD
Tautvidas: thanks.
Simon Whyatt
Michel CHILAUD: There is already a request for this open for some time. The database use of mailpoet is completely unacceptable. I hadn't realised until after I'd paid for a year subscription. Needless to say I won't be renewing if something isn't sorted beforehand. It's unnecessarily bloated and needs a built in cleaning option.
Martijn Joosse
I also need this, my sending_queues table is over 1 GB, and keeps growing, with over 22.000 subscribers. There should be some options to manage this, for example choosing to delete the old data, by year/month. The same for the statistics tables.
Ján Mikláš
Merged in a post:
House Keeping - reduce old database entries
S
Sebastian
MailPoet so far has no mechanism at all to clean old database entries.
Eg statistics and tasks.
With high volume newsletter sending this fills up the database and the server storage fast.
Our backup broke through too huge database tables. Other effects might be the need to upgrade DB and slow down speed.
Statistics could be compressed to end results.
Tasks should be just cleared from the DB after a short while.
L
Laurent Matignon
Upvoted. Should be the top priority.
On one of my websites the wp_mailpoet_scheduled_task_subscribers
table has ~7 352 370 lines!
It has a big impact on my website performance.
Major issue here.
Simon Whyatt
Yes, the database needs to be much leaner. Most of my WordPress sites have a total combined database of under 100MB, whereas the mailpoet sending queue table alone in a site with >5000 subscribers and only a handful of mails sent is already over 100MB! Even a database heavy WooCommerce site with 100s of products and users typically doesn't exceed 800MB in total. My hosting has a database limit of 1024MB per website. That's typically 10+ times larger than necessary but now looks like it might be insuficient for a site using MailPoet.
Luc NAROLLES (Surligneur de Talents !)
Hello
I strongly encourage you for this work, especially given the number of tables
Thanks
Alexander B Kerekes
Good idea! I've upvoted it. Would you mind taking a look at my feature request for a Campaign tab and consider upvoting it, as well?
Thanks!
Load More
→