ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

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

  • Creator
    Topic
  • #18033

    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
  • #18044
    Dima Soroka
    Dima Soroka
    Oro Core

    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?

    #18064

    brentwpeterson
    Participant

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


    Brent W Peterson
    Magento Evangelist

    #18065
    Dima Soroka
    Dima Soroka
    Oro Core

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

    #18084

    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

    #18086
    Alex Rudenko
    Alex Rudenko
    Oro Core

    Brentwpeterson,

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

    #18087
    Dima Soroka
    Dima Soroka
    Oro Core

    “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?

    #18088

    brentwpeterson
    Participant

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


    Brent W Peterson
    Magento Evangelist

    #35360

    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.