Knowledge Base Article

How to enable slow query logging in SugarCRM?

SugarCRM executes a lot of MySQL queries which, with time, may become slow and thus increase the loading speed of your SugarCRM application.

 

Enabling slow query logging will show you the slow queries executed by your SugarCRM. This, in turn, will help you debug your application and optimize it for better performance.

 

You can enable slow query logging by logging in to your SugarCRM as admin and going to Admin > System Settings. Once there, check the box next to Log slow queries.

 

Alternatively, you can enable slow query logging directly from SugarCRM's config.php file by changing this line:

 

'dump_slow_queries' => false,

  

to

 

'dump_slow_queries' => true,



Rating

Please indicate if this article was helpful for you.

rating :  4.5 from 5
views :  1107
votes :  6

Haven't found what you are looking for? Suggest an article HERE.

powered by

Valid XHTML 1.0 Strict Valid CSS!