It’s always hard. Notes from my SDUG Tuning Sugar Databases talk
19 Mar, 2008Posted By: Travis Swicegood
Man, giving a talk remote is always hard. Is my mic too soft? Can they hear me? Did some poor guy with a hearing aid just have it blown out ’cause I had my mic too loud? Am I pacing ok? What about handling questions?
Well, thanks to the expert help of Susie and Clint, I didn’t have to worry about any of this while giving my talk on Tuning Sugar Databases to SDUG. Everything functioned smoothly and the only thing I had to worry about was pacing myself, which seemed to work out good. Hopefully those who attended picked up a few new tricks. For those who didn’t get to attend live, we’ll have a recording of the webinar online soon. I’ll update when we do.
I promised some links during the presentation, so here you go. Our wiki is online @ http://www.sugarcrm.com/wiki/. There’s excellent info throughout the wiki, but the settings I touched on specifically are all outlined in Performance Tweaks for Large Systems, except one. Someone mentioned that there was no reference to $calculate_response_time on the wiki, that is correct and will be fixed. In meantime, here’s a quick intro to it. Adding the following line to your config.php:
"calculate_response_time" = true,
Will get you output like:
The other links I mentioned where, in no particular order:
Also, for anyone who’s interested, the MySQL AB tool for automating many of the processes I outlined is MySQL Enterprise. If you’re short on people or expertise, outsourcing your DBA duties to the company that created MySQL is a great option.
Hope that helps get you started on tuning your SugarCRM installs on MySQL. If you have any questions that we didn’t get covered in the presentation or Q & A, post them here and we’ll get you answers.
Tags: mysql, performance, sdug webinars
March 20th, 2008 at 4:42 am
Please, please comply with Sugar’s overriding mechanism when you implement this feature. Like so:
$sugar_config["calculate_response_time"] = true;
in *config_override.php* in Sugar’s root. Create this file if it’s not there already.
March 20th, 2008 at 4:43 am
NEVER edit config.php directly.
March 20th, 2008 at 4:53 am
However, addin this line won’t give you the resource usage summary. calculate_response_time will only give you the response time..
Read here how to get the resource usage summary shown above:
http://www.sugardev.net/Show_page_resources_for_performance_assessment
March 20th, 2008 at 5:38 am
@SugarDev.net - thanks for the reminder. As a developer I wipe my installation so many times in a week, I forget that people need to worry about upgrading!