Email problem when searching

[Ellen]

Hi.
We have problem with email in espo CRM system.
Since we have around 15 sales and they using email in CRM system.
But recent day when they search email in system it's always hanging.
As I check server increase 200% CPU
So could you please help to give us solution for this case.
Thank you.

[yuri]

Hi,

Do users have read access set to 'team' in Role?

[yuri]

If you mostly need to search only by a Subject you can remove Body field from the text filter (Administration > Entity Manager > Email > Edit). It should increase a performance.

[Ellen]

Hi Yuri,
Do users have read access set to 'team' in Role?-> yes
If you mostly need to search only by a Subject you can remove Body field from the text filter (Administration > Entity Manager > Email > Edit). It should increase a performance.-> Let me check and feedback soon.
Thank you

[Ellen]

Dear Yuri,
One more thing.
In case , the email storage increase day by day.What is the suitable solution then it not affect to speed performance of system

[yuri]

How much time does it take to load email list view w/o text filter with 'teams' access?

[Ellen]

Hi,
It's take around 5-10 minutes or longer to load, and sometimes it's time out and hanging system.
Thank you.
Ellen

[yuri]

Did you mean seconds? How much of records do you have in email table?

How much time it takes to load emails with access level = all ?

[Ellen]

Dear Yuri,
Recently it's 96630 record.
Not second, it's minutes.
How much time it takes to load emails with access level = all ?-->it's too long and almost time out.

[yuri]

Hi Ellen,

Is it w/o any filter? Just loading the list view? Or it loads so long only when searching?

Very weird. With an access level "all" (like admin has) it should take less than second to load a list (w/o searching).

[Ellen]

Hi Yuri,
Once they click on email it start loading very slow.I also don't know.
And at that time, CPU of server increase over 100% even 200%.May it's caused of slow loading.
But I mean, how we can mange this issue.Because it really effected to CRM system.
Thank you.
Ellen

[yuri]

What MySQL version do you have?

[yuri]

Recommendations:

1. Use MySQL 8.0
2. Upgrade EspoCRM to 5.7.0
3. Make sure your server have enough RAM (> 4Gb would be fine)
4. Set MySQL param innodb_buffer_pool_chunk_size to the value equal to ~70% of total RAM, see https://dev.mysql.com/doc/refman/5.7...ol-resize.html

[Ellen]

Ok Yuri,
Let me check again our server.
Thank you