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,

You need help with an application? hostlantern is specialized in hosting and supporting more than 200 scripts. Sign up for our web hosting services and let us help you with your application, 24/7!

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

“fail” error when adding dashlets in SugarCRM

If you add chart dashlets to your SugarCRM home page, but they are empty and you get a pop up...

How to set up separate outgoing email accounts in SugarCRM

With the latest version of SugarCRM you can allow your users to set their own Outgoing Email...

How to set up the HiveMail Email Gateway to use the PIPE method with cPanel

Configuring the PIPE Email Gateway method is probably the hardest part of a HiveMail setup, so in...

How to set an e-mail account for the EGroupware application?

In order to send/receive mails through EGroupware, the mail settings for the user should be...

How to change the administrator password in Omeka?

In order to change the password for your Omeka application you need to login to your cPanel ->...