MySQL table partitioning

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • tothewine
    Active Community Member
    • Jan 2018
    • 373
    #1

    MySQL table partitioning

    It may be useful on tables that become big over time like emails
    Tags: None
    • Marco
      Junior Member
      • Sep 2017
      • 5
      #2
      I agree, I've 16GB of email table and all the procedure related to email are blocked. How to solve the problem?

        Comment

        • yuri
          #2.1
          yuri commented
          06-17-2021, 05:21 PM
          Editing a comment
          16 GB is not that much. I think you can improve performance by configuring MySQL or allocating more resourses.

          Full-Text search can be slow though. MySQL is very bad with full-text search when order is applied. I hope they improve it someday.
        • yuri
          Member
          • Mar 2014
          • 8440
          #3
          I think you can try to setup partitioning by yourself. It's not necceserelly must be done by application (Espo).

          Full-text indexes are not supported for partition tables. https://dev.mysql.com/doc/refman/8.0...mitations.html. Full-text is enabled for emails by default.
          Last edited by yuri; 06-17-2021, 05:22 PM.
          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

            Comment

            • esforim
              #3.1
              esforim commented
              06-18-2021, 02:02 AM
              Editing a comment
              Sad to see that version 8 still have this issue, it be quite a few years before the next version.
            • Marco
              Junior Member
              • Sep 2017
              • 5
              #4
              Thank a lot I'll try to partition and I'll let you know. I agree with you 16GB is not so much but they're only 1 year of email data. The data obviously are increasing and function email to case takes very long time to execute

                Comment

                • yuri
                  #4.1
                  yuri commented
                  06-18-2021, 05:43 PM
                  Editing a comment
                  What exactly performs slow? When you search in contents or the list view w/o filters?
                • Marco
                  Junior Member
                  • Sep 2017
                  • 5
                  #5
                  The performace slow is on email list show on the URL https://serveresponame/#Email is not possible to show the email list for user
                  Already trying in partitioning, I've to take more time

                    Comment

                    Previous template Next
                    Working...