PHP profiler

[vladimir.d]

Could someone suggest a PHP profiler working well with EspoCRM?

maybe XHProf?

https://github.com/longxinH/xhprof

[vladimir.d]

Well, I've made some research and installed XHProf on EspoCRM host.
It draws some useful diagrams so it's now possible to see where is a bottleneck.
uploading couple of pictures for the reference.

Probably I'll go further and try `liveprof`profiler to monitor CRM performance.

[esforim]

Wow finally some "stress" test information.

[AgentT]

vladimir.d Does the XHProf work with ESPO v7? If yes, how did you set it up? Do you install it with composer or how do you go about doing it?

[yuri]

Unless you have large numbers of users working simultaneously, PHP won't take effect on performance. Database will be always a bottleneck.

[AgentT]

yuri Yes we are having issues with the database itself. Especially the job table. Simple queries which uses indexes takes 5-10 seconds to be executed. Seems like some query is locking the table which blocks all the other queries. Sometimes even the lock table query takes long to be executed.

Any pointers on how to find the actual problem and fix the slowness? I am on MySQL 8, PHP 8, ESPO v7.1.9.

[yuri]

Do these queries execute fast when you running them manually?

[AgentT]

Yes. And they seem to use the right indexes too.