ssossossossosso

Forums

This topic contains 8 replies, has 4 voices, and was last updated by  Tom Holland 6 months, 2 weeks ago.

  • Creator
    Topic
  • #24434

    brentwpeterson
    Participant

    Is this normal that the email body table would already be 2gb?

    +——————————–+————+
    | Tables | Size in MB |
    +——————————–+————+
    | oro_email_body | 2094.63 |
    | oro_email_attachment_content | 532.61 |
    | jms_jobs | 117.59 |
    | akeneo_batch_job_instance | 62.16 |
    | oro_search_index_text | 45.31 |
    | oro_email | 43.17 |
    | oro_integration_channel_status | 32.09 |


    Brent W Peterson
    Magento Evangelist

Viewing 8 replies - 1 through 8 (of 8 total)
  • Author
    Replies
  • #24435

    Dima Soroka
    Keymaster

    It depends on your inbox and IMAP sync configuration in user profile. If you decided to sync entire inbox(es) without limitation (you can keep only certain folders in sync), the table size will match inbox size.

    Could you please provide more details on your mailbox size and IMAP sync settings?

    #24436

    brentwpeterson
    Participant

    I have reconfigured what folders it looks at. Will the size of the table get reduced automatically?


    Brent W Peterson
    Magento Evangelist

    #24437

    Dima Soroka
    Keymaster

    yes, it should as emails that are not matching sync configuration will be deleted

    #24438

    brentwpeterson
    Participant

    We updated our email boxes to only include the inbox and sent mail (From ALL)

    The values for total size remain the same.


    Brent W Peterson
    Magento Evangelist

    #24439

    Alex Rudenko
    Moderator

    Brentwpeterson,

    Could you please specify which of commands you are using to get the table size.

    #24440

    Dima Soroka
    Keymaster

    “Inbox” folder filter typically (in case with gmail) includes all sub folders so if you select it in user profile configuration you’ll have all incoming emails from your mailbox. Could you please clarify if table size correlates with mailbox size?

    #24441

    brentwpeterson
    Participant

    Ok thanks, I am going to remove it for now.


    Brent W Peterson
    Magento Evangelist

    #24442

    Tom Holland
    Participant

    Hello Dima,

    I have the same issue with email related tables growing in size to over 9GB and it is causing my backups to fail due to memory usage.

    We had been syncing the entire INBOX for 4 users, but after reading this post, I set all of our accounts to sync only one empty folder and not the INBOX and over 2 hours later, I have not seen any reduction in database size. The email-sync job is running every minute. It does not appear that unselecting the inbox for sync removed anything from the database.

    If the email-sync job does not clean up after itself is there another option?

Viewing 8 replies - 1 through 8 (of 8 total)

You must be logged in to reply to this topic.