It's always hard. Notes from my SDUG Tuning Sugar Databases talk

bsoremsugar —  March 19, 2008 — 9 Comments

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:

Screenshot of status info

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.

9 responses to It's always hard. Notes from my SDUG Tuning Sugar Databases talk

  1. 

    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.

  2. 

    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.

  3. 

    NEVER edit config.php directly.

  4. 

    NEVER edit config.php directly.

  5. 

    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

  6. 

    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

  7. 
    Travis Swicegood March 20, 2008 at 1:38 pm

    @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! :-)

  8. 
    Travis Swicegood March 20, 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! :-)

Trackbacks and Pingbacks:

  1. Custom Car ECU Remapping and Chip Tuning experts. Offering a mobile service across Northern England and Southern Scotland. - November 28, 2011

    Custom Car ECU Remapping and Chip Tuning experts. Offering a mobile service across Northern England and Southern Scotland….

    [...]SugarCRM Developer Blog » Blog Archive » It’s always hard. Notes from my SDUG Tuning Sugar Databases talk[...]…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s