Announcement

Collapse
No announcement yet.

MySQL table partitioning

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL table partitioning

    It may be useful on tables that become big over time like emails

  • #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
      yuri commented
      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.

  • #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.

    Comment


    • esforim
      esforim commented
      Editing a comment
      Sad to see that version 8 still have this issue, it be quite a few years before the next version.

  • #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
      yuri commented
      Editing a comment
      What exactly performs slow? When you search in contents or the list view w/o filters?

  • #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

    Working...
    X